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:.
Connection Properties:- Transaction Type ________LOCAL_TRANSACTION DataSource Class ________(I DONT KNOW WT IS SUITABLEFOR 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
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.
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]
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.