JDBC Channel

[Former Member]

hi all

Am doing a an HTTP JDBC scenario. I ve configured my JDBC channel correctly. But in adapter monitor the channel status shows :

" Receiver Adapter v2603 for Party '', Service 'JDBC_ALCON':

Configured at 2007-01-12 20:25:14 IST

History:

- 2007-01-12 20:25:16 IST: Error: Accessing database connection 'jdbc:microsoft:sqlserver://ISVDBD1:1788;DatabaseName=Misdata' failed: DriverManagerException: Cannot establish connection to URL 'jdbc:microsoft:sqlserver://ISVDBD1:1788;DatabaseName=Misdata': SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Login failed for user 'misuser'."

What all can be the possible reasons for this error. Because my connection url and user and password are correct. Please see to this

[Former Member · Accepted solution]

Hi,

Can you recheck the port number in the URL 'jdbc:microsoft:sqlserver://ISVDBD1:<b>1788</b>;DatabaseName=Misdata'

By default the port is 1433.

Also recheck the User Id and Pwd .

Regards,

Jai Shankar

[Former Member · Accepted solution]

thanks alot... now it worked. The problem was with port no

[Former Member]

Hi Sumayya,

Please Check the Connectivity with a stand alone Java program. Give the driver jars in classpath. There should be a problem in that only.

May be the user name may not have access to the specified database.

Regards,

P.Venkat

[Former Member]

Hi,

Did you deploy the drivers for sql server?

If yes make sure that you have given the right parameters for url, username and password.

Regards,

Sudheer.

[Former Member]

go to through the following URL. It helps you when you get that kind of error.

http://support.microsoft.com/kb/313100