This week's book giveaway is in the Agile and Other Processes forum.
We're giving away four copies of The Little Book of Impediments (e-book only) and have Tom Perry on-line!
See this thread for details.
Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC and SQL Server 2000

 
Geoffrey Lo
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Laurent Leonard
Ranch Hand
Posts: 35
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic