Cry of desperation... JDBC in Portal not working

[Former Member]

I am already puzzling a few days....

I defined a JDBC Connector in the Visual Administrator.

The definition there are ok, because I can connect perfectly using the test servlet at http://sapserver:50100/TestJDBC_Web/TestJDBCPage.jsp.

The next step was defining a system in my landscape. I followed the instructions in the document "How To... Configure a BI JDBC System for Visual Composer"

I am using these properties:

CodeLink = com.sap.portal.systems.bi.SAP_BI_JDBC

ConnectionFactoryClass = SDK_TESTDB

ConnectionUrl = jdbc:jtds:sqlserver://sapserver:1433;databaseName=TestDb

(this url is the same as in Vis. Administrator)

Driver Class Name = net.sourceforge.jtds.jdbc.Driver

Fixed Catalog = TestDb

Fixed Schema = dbo

System Type = SAP_BI_JDBC

User Mapping = admin, user

I am logged in as Administrator, so I added the login credentials at the User Mapping page of the Administrator user.

When I use Connection Test function from the portal I get the following messages:

Retrieval of default alias successful

Connection failed. Make sure user mapping is set correctly and all connection properties are correct.

What can I do to solve this problem?

I have already tried so many changes in the properties...

It is driving me on the wall !!

Where can find a logfile to see what is going wrong?

[former_member188977]

Hi Jan, make sure that the test servlet is OK and you are using the same values in the system.

after that, clean the credentials in user mapping area, delete the alias in the system and save the changes.

After that, create the alias again and compleate the user mapping section.

What version and SP are you using ?

Regards,

Ignacio.

[Former Member]

Done as you told me. No success....:-(

I am uing NW2004s SP7, the Sneak Preview version.

Any way to see why the connection is nto going wrong? Some log file or something?

[Former Member]

Finally it is working!

I removed the jtds drivers and installed the SqlServer JDBC drivers from Microsoft. Now it works perfectly.

It is a mystery after all. I have been using those jtds drivers a few monthes with the NW2004 Sneak Preview version. Not in the portal, but in the Javabeans and Dynpro applications.

Anyway, now I can use my database in the Visual Composer.