odbc « SQLserver « Java Database Q&A





1. Options to Replicate Microsoft SQL Server Database to MySQL/PostgreSQL on Linux    stackoverflow.com

I need to replicate data from Microsoft SQL Server to MySQL or PostgreSQL. The data includes images stored in BLOB columns. Could you please comment on your experiences with the following ...

2. java sql connectivity    stackoverflow.com

I have created a user dsn named "harshi"
To insert rows in a table getting data from Java code I want to insert in SQL table. The connection statement is:

String url = "jdbc:odbc:Harshi"; ...

3. Sun JDBC ODBC Driver or MSSQL JDBC Driver    stackoverflow.com

we have 2 approaches to connecting to our MSSQL databases, the one being the Sun JDBC ODBC bridge and the other being the MSSQL JDBC Driver. We're doing some reorganization and want ...

4. Connecting to SQL Server 2008 from a Mac    stackoverflow.com

Office for Mac 2011 has better support for Pivot Tables in Excel, including external data. I need an ODBC connection on a Mac to SQL Server 2008. Microsoft recommends ...

5. jdbc:odbc SQL2000 XML return?    coderanch.com

6. Facing Big Problem with Sql Server 2000 Odbc Driver    coderanch.com

Hai, I am facing a lot of problems with sql server 2000 odbc drivers. and the database when i try a awt database application in ms access it is working perceftly but is it not working in using sql server 2000 database and some times i am getting the exception with sql server java.sql.SQLException : [Microsoft] [ODBC SQL Server Driver] Connection ...

8. jdbc:odbc DSN less connection for SQL Server    coderanch.com

Thanks, Arun. At least now I know it's not my code. However the knowledgebase article references SQL 7 and Access 97. I'm trying to connect to an Access 2000 database so I'm not sure it applies. As of this writing I'm downloading the Jet4.0 Service pack for Windows 2000 to see if that rectifies the situation. Thanks again for the lead. ...





11. I am facing a lot of problems with sql server 2000 odbc drivers.    coderanch.com

It sounds like you are not properly closing your connections, statements, or something like that. We're using SQL Server 2000 and process over 100 million DB operations a month with no issues. One word of caution, eventhough many people say you do not have to close Statements, PreparedStatements, or CallabelStatements before closing Connections: do it. It does matter. Don't leave it ...

13. java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]Opti onal fature not implem    coderanch.com

No shailesh i respect those who listen to my problems.for Mr. C Lamont Gilbert i can give a one word answer and for Pauls response i need to work on it. Thank you Mr.Paul Sturrock your advice really helped me in my project. i tried using jTDS and it is working properly without giving any execptions. Thanks a lot regards susanth ...

14. [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt    coderanch.com

Hi, I am using MicroSoft SQL Server 2000 with Java. I am encountering one error: [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt I am using globally one connection, statement and resultset and I am closing the connection, resultset and statement properly (to my knowledge!!) What are the cases in which these type of errorw will come? How ...

15. [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt    coderanch.com

Hey guys, This would be my first time using JDBC within an application. The problem i am having now is the exception that is in the subject line. Don't get me wrong now, I understand what it means, but i'm not sure what i am doing wrong. So the database im querying is a little bit strange(at least i think i ...

16. ODBC versus SQLSERVER data retrieval issues, known ???    java-forums.org

I'm writing some JAVA code in a Windows XP/VISTA environment. I have text and audio WAV data in small SQL Server 2005 - 2008 databases [the following problem exists in both databases, i made 2 different dbs to see if it went away in v2008 but it didn't]. The audio data was inserted into the db using : * FROM OPENROWSET(BULK ...





20. Microsoft][ODBC SQL Server Driver]Optional feature not implemented    forums.oracle.com

here is the stack trace java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]Optional feature not implemented at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958) at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115) at sun.jdbc.odbc.JdbcOdbc.SQLBindInParameterBigint(JdbcOdbc.java:1225) at sun.jdbc.odbc.JdbcOdbcPreparedStatement.setLong(JdbcOdbcPreparedStatement.java:592) at desktopapplication2.db.get(db.java:47) at desktopapplication2.DesktopApplication2View.jButton1ActionPerformed(DesktopApplication2View.java:394) at desktopapplication2.DesktopApplication2View.access$800(DesktopApplication2View.java:22) at desktopapplication2.DesktopApplication2View$4.actionPerformed(DesktopApplication2View.java:183) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236) at java.awt.Component.processMouseEvent(Component.java:5517) at javax.swing.JComponent.processMouseEvent(JComponent.java:3135) at java.awt.Component.processEvent(Component.java:5282) at java.awt.Container.processEvent(Container.java:1966) at java.awt.Component.dispatchEventImpl(Component.java:3984) at java.awt.Container.dispatchEventImpl(Container.java:2024) at java.awt.Component.dispatchEvent(Component.java:3819) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822) at java.awt.Container.dispatchEventImpl(Container.java:2010) ...