Service Desk Practitioners Forum
cancel

jdbc error: OVOW 7.5 to SD 5.1SP6 integration

Highlighted
Rahul Kumar Gup
Outstanding Contributor.

jdbc error: OVOW 7.5 to SD 5.1SP6 integration

Hi All,

I have ovow 7.5 and SD 5.1 on seperate servers with windows 2003 enterprise edition. database MSSQL 2005 WITH SP 2 is installed on both servers.


[CONNECTION]
TYPE=JDBC
[JDBC]
DRIVER=com.inet.tds.TdsDriver
URL=jdbc:inetdae://EMSOVO01.E4EAS.COM:1433?database=openview&instance=OVOPS
USR=sa
PWD=********

please see attached file and tell me what should i do to solve jdbc error. i am not a database guy.

Regds,
Rahul
3 REPLIES
Ben Snell
Super Contributor.

Re: jdbc error: OVOW 7.5 to SD 5.1SP6 integration

Hi

I've no experience of the particular error but I know a thing or two about databases! As a check list have you tried:
Checking that the account is valid and has rights to access the data (implies that you are using the SA account - check that this has not been restricted at the SQL level)
Check that you can ping the database
Check that the database is on port 1433 and has not been moved to another port
Check that the database name you want is "openview"
Check that the database instance that are trying to connect to is called "OVOPS" (this is the most likely cause)

Regards
Ben
Rahul Kumar Gup
Outstanding Contributor.

Re: jdbc error: OVOW 7.5 to SD 5.1SP6 integration

Hi ben,
Iam not a database administrator and not having good knowledge og jdbc and odbc, but i did some efforts and came to know that database mssql 2005 uses odbc not jdbc. I am not sure 100 percent, because when i did some changes in OvSdOvow.conf file

[CONNECTION]
TYPE=ODBC
[DSN]
NAME=openview
#DRIVER=com.inet.tds.TdsDriver
#URL=jdbc:inetdae:EMSOVO01.E4EAS.COM:1433?database=openview&instance=OVOPS
USR=sa
PWD=E4E@123

Then i didn't get any error. See attached screenshot what i got after finishing that process.

If u have experience of jdbc or odbc. Please confirm all details.

Regds,
Rahul
Rahul Kumar Gup
Outstanding Contributor.

Re: jdbc error: OVOW 7.5 to SD 5.1SP6 integration

Best solution

Rahul