Configuring JDBC Driver for JDBC System

[former_member182294]

I have installed Enterprise Portal 6.0 with MS SQL Server 2000 as the backend database.As while Configuring a JDBC IView,SQL Server driver is required.

1. Is there any default driver that comes with portal

installation which i can use or do we have to

configure the driver seperately,If yes then where to

configure the driver.

2. Can i connect to any other database , other than the

default database which is used during the EP

installation which in my case is My SQL Server 2000.

If let us say i want to create an JDBC IView for a

Oracle database.Where should i copy my oracle driver

files or how should i configure my oracle drivers

(classes12.jar) which i can use while creating a JDBC

System.

Can anybody please help me on this Issue or any docs

available on this ?

[Former Member]

1. Default JDBC drivers come out-of-box may be found under YOUR_INSTANCE\cluster\server\additional-lib\com\sap\data_direct_driver_references

There are drivers for MSSQL, Oracle, DB2, Informix and Sybase. Pay attention that the name of the packages varies from the standard expected name - they all start from com.sap.*.

2. If you want to supply additional drivers then you have to follow a standard procedure of adding java libs to a node. Under YOURINSTANCE/docs there is a FAQ about J2EE and there ClassLoading -> "How to set a reference from an application to a library?" all info you'll find there.

Just don't forget that you have to do it on every node in the cluster (server most likely and not discpatchers).

Good luck!

[Former Member]

the driver is com.sap.portals.jdbc.oracle.OracleDriver but the connection URL??

for SQL server for example is dbc:sap:sqlserver://host:port;DatabaseName=pubs;SelectMethod=cursor.

[former_member182294]

Thank you very much of the information about the drivers,now i know where the driver jar files are located ,I could see in the in the log files, the driver jar getting loaded but iam still unable to connect to the database.When i select my system which is configured to connect to a oracle database, it hangs as 'Loading...' for ever while creating the JDBC IView and also does not show any errors in the log files.Iam unable to figure out the problem.I have given the permissions as it is mentioned in one of the demo, on sdn.sap.com for creating an JDBC IView.DO i have to configure some more things ?.

It would be great if you could give me your any contact no's and time when you are available,so i can talk to you more on this to get my problem solved.Iam working for a software firm in India.

Thanks in advance

[Former Member]

Where can I find the documentation for the connection URL for each different driver?

[Former Member]

for oracle :

jdbc:sap:oracle://<Oracle Server Machine>:<Port>;SID=<SID>

for sql:

jdbc:sap:sqlserver://<sql server>:1433;DatabaseName=<database name>;SelectMethod=cursor

[ArielPereyra]

Does anybody knows the URL for connecting to an Informix Database??

Thanks

[Former Member]

Does anybody knows the URL for connecting to a Sybase one?

[Former Member]

I can't find the folder for NetWeaver2004s sp09

[Former Member]

I have used the default jdbcodbc driver from sun to connect to MS SQL Server. Another developer here has used it to connect to oracle.