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 ... |
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"; ...
|
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 ... |
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 ... |
|
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 ... |
|
|
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. ... |
|
|
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 ... |
|
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 ... |
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 ... |
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 ... |
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 ... |
|
|
|
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) ... |
|
|