Hi All, I'm having trouble setting JDBC with MS SQL Server 2000. I have downloaded the service pack for SQL Server that came with JDBC drivers. I ran the setup.exe file but i think all it did was set up a folder with these sub-folders in it. <mySQLSERVERJDBC> - books - Help - lib - SQLSERVER JTA msfixes readme
I have no trouble with MS Access. Would it be the same procedure for setting MS Access? Any insight would be helpful Thanks, Geoff
What did you setup for MS Sql Server 2000 ? With this procudure, you only installed a library that allow you to connect to MS SQL Server 2000. After that you have to configure "programmatically" the connection between your application and your MS SQL Server 2000 database. With an URL liek this one : jdbc:microsoft:sqlserver://127.0.0.1:1433;SelectMethod=cursor;DatabaseName=myDB
Do the next thing next. That’s a pretty good rule. Read the tiny ad, that’s a pretty good rule, too.