Error during database connection (JDBC)

[Former Member]

Hello!

When I try testing my connection to MSSQL (using sender JDBC channel) in communication channel monitoring (RWB)i can read that Error explanation:

Error during database connection to the database URL 'jdbc:microsoftsqlserver://<DB_IP_ADRESS>:1433;databaseName=XXXX' using the JDBC driver 'com.microsoft.jdbc.sqlserver.SQLServerDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Unable to locate a suitable JDBC driver to establish a connection to URL 'jdbc:microsoftsqlserver://<DB_IP_ADRESS>:1433;databaseName=XXXX''

Before I did the communication channel configuration I did the driver instalation and deploy like in document "HowTo_ConfigExtAdapters". In Adapter Monitor (RWB) i can see the JDBC adapter instaled and started (gray square).

Any idea what is wrong?

[MichalKrawczyk · Accepted solution]

hi,

try this:

jdbc:microsoft:sqlserver://

and not

jdbc:microsoftsqlserver

Regards,

michal

[Former Member]

Thanks. That was my foult in connection string but I have another problem:

SQLException:[Microsoft][SQLServer 2000 Driver for JDBC] Error establishing socket.

[Former Member]

Hi,

Check your database port and your firewall settings.

Regards,

Wojtek

[MichalKrawczyk]

hi,

this might mean that your XI server

cannot connect to mssql (connection problem)

can you check if there are any firewalls

between the servers (xi and mssql)?

Regards,

michal

[Former Member]

hello guys,

looks like a very old problem. Hope it has been fixed.

I am getting the same error message and would appreciate if someone can please let me know. My email address is rprasad AT cincom.com

[Former Member]

Hi,

Please check configuration of your CC. Maybe you made a typo.

Regards,

Wojciech

[MichalKrawczyk]

Hi,

he did - in the connection string

Regards,

michal

-

---

<a href="/people/michal.krawczyk2/blog/2005/06/28/xipi-faq-frequently-asked-questions"><b>XI / PI FAQ - Frequently Asked Questions</b></a>