Problem connecting to SQL database

[Former Member]

Hi,

I am trying to connect to SQL database 2005 through Visual Administrator by creating a data source. I installed driver for SQL JDBC 1.1 driver. I created the driver with the jar file sqljdbc.jar. the datasource was created. But when I try to execute the query, I am getting the following error

java.rmi.RemoteException: com.sap.engine.services.dbpool.exceptions.BaseRemoteException: SQL statement(s) cannot be executed over DataSource "AmritaKediaDS". If you are using an Open SQL DataSource, you must register your tables using JDDI before you request them. Reason: com.sap.engine.services.dbpool.exceptions.BaseSQLException: ResourceException in method ConnectionFactoryImpl.getConnection(): com.sap.engine.services.dbpool.exceptions.BaseResourceException: SQLException thrown by the physical connection: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host has failed. java.net.ConnectException: Connection refused: connect [id = Unknown]

Please help me....Points will be given in plenty for right answers

Thanks

Amrita

[Former Member]

Hi,

Pl go through this blog and the thread its clearly explained the way to create the DS in VA.

/people/anilkumar.vippagunta2/blog/2007/02/20/reading-and-writing-images-from-sqlserver-in-webdynpro

Regards

Ayyapparaj

[Former Member]

hai Amrita,

try using system dsn if your using user dsn for now.

Thanks n Regards

Sharanya.R

[Former Member]

Hi Amrita,

I thimk the following [Unable to Get a Connection From a Data Source |http://help.sap.com/saphelp_nw70/helpdata/en/5c/2f2c4142aef623e10000000a155106/frameset.htm] can help.

Regards,

Alka.