Unable to stablish a connection using JDBC Drivers and Datasources

[Former Member]

Hi all,

I am using SQL Server 2005,

I configured the driver(name:SQL2005) and added sqljdbc.jar

Also created a datasource with this information:

Application name: TEST

Name: TEST

Desc: TEST

I gave TEST as Alias.

I selected the driver I've created before(SQL2005), with JDBC Version 1.x(No AX Support)

As Driver Class I put com.microsoft.sqlserver.jdbc.SQLServerDriver

As DatabaseURL I put jdbc:sqlserver://<ServerName>:<port>;database=<dbName>

User: Admin, Password: pass

In SQL Engine I put "VENDOR SQL"

when I save it and try to Start Selected StandAlone Application I get this Error:

Error occurred while starting application 'sap.com/TEST'

these are the details:

Caused by: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

Found in negative cache

-

---

Loader Info -

---

ClassLoader name: [library:SQL2005]

Parent loader name: [Frame ClassLoader]

No references !

Resources:

C:\usr\sap\J2E\JC00\j2ee\cluster\server0\bin\ext\SQL2005\sqljdbc.jar

C:\usr\sap\J2E\JC00\j2ee\cluster\server0\bin\core_lib\opensqlport.jar

Loading model: {parent,local,references}

Can Anyone please help me?

Thanks in advance!

Guillermo

[Former Member · Accepted solution]

Hi,

Following document might shed some light in the configuration in Visual Admin

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/6209b52e-0401-0010-6a9f-d40ec3a0...

Regards

Ayyapparaj

[Former Member · Accepted solution]

Thank you very much, seeing that document it was much easier to solve the problem.

Now I am facing other problem:

When I try to execute a query(for example : select * from

) I get this error:

Error occurred while executing init statements

java.rmi.RemoteException: com.sap.engine.services.dbpool.exceptions.BaseRemoteException: SQL statement(s) cannot be executed over DataSource "TEST". 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: La conexión a la instancia con nombre ha fallado. Error: java.net.SocketTimeoutException: Receive timed out.

Do you have any idea how to solve this?

thanks again

Bye!