• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

JDBC and SQL Server 2000

 
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Ranch Hand
Posts: 35
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
And then the entire population worshiped me like unto a god. Well, me and this tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic