| Author |
Message
|
| RocknRambo |
 Posted: Thu Jan 19, 2006 1:51 pm Post subject: jDBC Adapter for Sql Server |
 |
|
Partisan
Joined: 24 Sep 2003
Posts: 355
|
I'm trying configure JDBC Adapter for Sql Server, and looking for the parameters to be provided in the "DatabaseDriver" in ODA,
I'm finding hard time to find the pdf, did anybody configure before?
and also do we have to provide any driverpath in oda.bat.. like for oracle, its classes12.zip ?
Thanks
-RR |
|
| Back to top |
|
 |
| sdng |
| Posted: Fri Jan 20, 2006 1:01 am Post subject: |
|
|
Acolyte
Joined: 23 Nov 2005
Posts: 53
|
|
| Back to top |
|
|
| RocknRambo |
| Posted: Fri Jan 20, 2006 7:15 am Post subject: |
|
|
Partisan
Joined: 24 Sep 2003
Posts: 355
|
Thank you for the DatabaseURL.
can I get help in the DatabaseDriver in ODA, I mean what shud I type in tht attribute, this is what I'm trying but not succcessful
DatabaseDriver: com.ibm.jdbc.sqlserver.SQLServerDriver
| Quote: |
[Time: 2006/01/20 09:57:48.430] [System: Object Discovery Agent] [SS: JDBCODA] [Type: Fatal] [Mesg: The specified Driver Class com.ibm.jdbc.sqlserver.SQLServerDriver could not be found.]
[Time: 2006/01/20 09:57:48.430] [System: Object Discovery Agent] [SS: JDBCODA] [Type: Error] [Mesg: init Failed! Reason Unable to establish connection to database. Reason The specified Driver Class com.ibm.jdbc.sqlserver.SQLServerDriver could not be found..] |
and in the oda.bat, what shud we set the DatabaseDriver = ?
thanks again
-RR |
|
| Back to top |
|
|
| RocknRambo |
| Posted: Fri Jan 20, 2006 7:17 am Post subject: |
|
|
Partisan
Joined: 24 Sep 2003
Posts: 355
|
sorry!. small correction,
in start_JDBCODA, what path shud we give for
as when I downloaded MS SQL server driver for JDBC, it was a setup file and it just got installed in background.
-RR |
|
| Back to top |
|
|
| vk |
| Posted: Fri Jan 20, 2006 3:47 pm Post subject: |
|
|
Partisan
Joined: 20 Sep 2005
Posts: 302
Location: Houston
|
Search for the following files - mssqlserver.jar, msbase.jar and msutil.jar
You have to add the path of all these 3 files in DRIVERLIB
Regards,
VK. |
|
| Back to top |
|
|
| sdng |
| Posted: Mon Jan 23, 2006 12:56 am Post subject: |
|
|
Acolyte
Joined: 23 Nov 2005
Posts: 53
|
if you will use Microsoft JDBC Driver for SQL than
set DatabaseDriver=com.microsoft.jdbc.sqlserver.SQLServerDriver
you can check it, if open mssqlserver.jar (with WinZip for example). this value sensitive to case (such as all in Java).
_________________
Are you gangsters? No, we are Russians! |
|
| Back to top |
|
|
|
|
