Microsoft SQL SERVER 2005 DB connectivity

OS …WINDOWS XP
DB…Microsoft SQL SERVER 2005

Plz help me in JDBC CONNECTIVITY with SQL SERVER 2005.Plz give me the info about important .jar files to copy in IS folder and how can i find those jar files ? :eek:.

MYJDBC:MYCON Details:-
Connection _____________JDBC Adapter Connection
Package________________NEWSQL

Connection Properties:-
Transaction Type ________LOCAL_TRANSACTION
DataSource Class ________(I DONT KNOW WT IS SUITABLE FOR SQL 2005)
serverName _____________localhost
user ___________________
password _______________
databaseName __________master
portNumber _____________1433
networkProtocol _________tcp
Other Properties _________

Connection Management Properties:-
Enable Connection Pooling __true
Minimum Pool Size ________0
Maximum Pool Size ________10
Pool Increment Size _______1
Block Timeout ____________1000
Expire Timeout ___________1000
Startup Retry Count _______0
Startup Backoff Timeout ____10

If Any idea plz send it to me on forum.:confused:

See this…

http://wmusers.com/forum/showthread.php?t=9315&highlight=sql+server+2005

OS…windows XP sp2

I have no specific jar file for sql Server 2005 so I am using jar files which is used in SQl server 2000 name are msbase.jar,mssqlserver.jar,msutil.jar
in the “C:\wMethods\IntegrationServer\lib\jars…”
If u have any idea to find this files related to MSSQL Server 2005 plz let me know.

MYJDBC:MYCON Details:-
Connection _____________JDBC Adapter Connection
Package________________SQLNEW

Connection Properties:-
Transaction Type ________LOCAL_TRANSACTION
DataSource Class ________ com.microsoft.sqlserver.jdbc.SQLServerDataSource
serverName _____________localhost
user ___________________SYSTEM
password _______________ ******
databaseName __________MYDB
portNumber _____________1433
networkProtocol _________TCP/IP
Other Properties _________selectMethod=cursor

Connection Management Properties:-
Enable Connection Pooling __true
Minimum Pool Size ________0
Maximum Pool Size ________10
Pool Increment Size _______1
Block Timeout ____________1000
Expire Timeout ___________1000
Startup Retry Count _______0
Startup Backoff Timeout ____10

Now i m getting----->

Error encountered

[COLOR=Red][ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource SQL:sqlconn.
[ART.118.5063] Adapter Runtime (Connection): Unable to start connection SQL:sqlconn: after 1 attempt(s).
[ADA.1.204] Cannot connect to the database with DataSource class “com.microsoft.sqlserver.jdbc.SQLServerDataSource”.
The TCP/IP connection to the host has failed. java.net.ConnectException: Connection refused: connect
[/color]

[B]How can i overcome on it ,Any assistance will be appreciable.
[/b]

Did you end up solving this?

I downloaded version 1.1 of the Microsoft drivers and then went to endable my connection and it froze saying “Pending Enable” on the JDBC configuration screen in IS Admin.

BTW the 7.1 documentation directs you to leave networkProtocol and OtherProperties blank for SQL 2005 LOCAL TRANSACTIONS.

Hi,
Have managed to find out what the problem was?

br,
Vlad