Skip to Content
0
Former Member
Feb 17, 2009 at 07:31 PM

Unable to stablish a connection using JDBC Drivers and Datasources

47 Views

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