Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

How to configure a .cfg file for sqljdbc.jar

  
   Database Help (Home) -> JDBC Driver RSS
Next:  Autocommit, Implicit Transactions, and Connection..  
Author Message
nabira

External


Since: Mar 09, 2008
Posts: 1



(Msg. 1) Posted: Sun Mar 09, 2008 9:15 am
Post subject: How to configure a .cfg file for sqljdbc.jar
Archived from groups: microsoft>public>sqlserver>jdbcdriver (more info?)
Hello,
I have an application that normally works with sybase, but it can
work with SQL Server. If I want to use SQL Server as DBMS I have to
configure a .cfg file, but I don't know how to say to my program that
it has to use the correct driver.
The standard .cfg file is:


ls.mappingclass=com.idsscheer.aris.server.dl.mapimpl.sqlsrv.AMapping
dl.mappingclass=com.idsscheer.aris.server.dl.mapimpl.sqlsrv.dl.AMapping
arisadm_user=aris70
arisadm_schema=aris70
url=jdbc:jtds:sqlserver://LAPTOP202:1433/ARIS7
startdb=yes
db.startup.maxwait=180000
driver=net.sourceforge.jtds.jdbc.Driver
pwderrcode=e;18456
dbmsname=SQL Server


But "net.sourceforge.jtds.jdbc.Driver" is not correct, I have to use
sqljdbc.jar!
Can anyone help me, please? I'm not expertise with JDBC drivers.

Nabira

 >> Stay informed about: How to configure a .cfg file for sqljdbc.jar 
Back to top
Login to vote
Adam Saxton [MSFT]

External


Since: Mar 04, 2008
Posts: 3



(Msg. 2) Posted: Tue Mar 18, 2008 7:47 pm
Post subject: RE: How to configure a .cfg file for sqljdbc.jar [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
For the SQL Server 2005 JDBC Driver, your driver will be:
com.microsoft.sqlserver.jdbc.SQLServerDriver instead of
net.sourceforge.jtds.jdbc.Driver.

Thanks,
Adam W. Saxton [MSFT]

 >> Stay informed about: How to configure a .cfg file for sqljdbc.jar 
Back to top
Login to vote
Adam Saxton [MSFT]

External


Since: Mar 04, 2008
Posts: 3



(Msg. 3) Posted: Tue Mar 18, 2008 7:47 pm
Post subject: RE: How to configure a .cfg file for sqljdbc.jar [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
For the SQL Server 2005 JDBC Driver, your driver will be:
com.microsoft.sqlserver.jdbc.SQLServerDriver instead of
net.sourceforge.jtds.jdbc.Driver.

Thanks,
Adam W. Saxton [MSFT]
 >> Stay informed about: How to configure a .cfg file for sqljdbc.jar 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
MDX and JDBC Driver - Hi all, Anybody know if it possible to connect to an as2000 database and run mdx queries using the microsoft jdbc drivers? thanks, Peter

java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]U.. - Folks, I was getting this exception occasionally and tracked in down to the application server C drive being full. Looks like the drivers are writing to logs (event ?) on this drive. Freeing up space removed the problem. Hope this helps someone. ..

JDBC driver doesn't close socket event after connection.cl.. - Hi I have a Java application (on Red Hat Enterprise) that <font color=purple> ; 1) connects every 10 seconds to an MS/SQL database</font> <font color=purple> ; 2) attempts to get the metadata for a specific table</fo...

Redistribution -

I can not connect to SQL Server 2000 on WinXP SP2 - Hi, I am using 'SQLServer 2000 Driver for JDBC' in my java application. My SQL Server is running in Windows XP pc. I dont had any problem before install WindowsXP Service Pack 2. But when i have installed WinXP SP2 my application can not connected to..
   Database Help (Home) -> JDBC Driver All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]