on 04-03-2008 11:51 AM
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hai Amrita,
try using system dsn if your using user dsn for now.
Thanks n Regards
Sharanya.R
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
76 | |
9 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.