Hi,
I am trying to connect to Oracle 9i database using below VB code:
strConnection = "Driver={Microsoft ODBC for Oracle};Server=SERVERNAME;Uid=USERID;Pwd=PASSWORD"
Connect = New ADODB.Connection
Connect.Open(strConnection)
The last line throws me below error:
[Microsoft][ODBC Driver Manager] Data Source Name not found and no default driver specified
The VB code is working fine and able to connect to dev database in dev server. The same script with UAT server name is not working in UAT server.
Both the servers are of Windows server 2008 - 32 bit.
When I checked the drivers tab in ODBC Data Source Administrator, dev server has below entry:
Microsoft ODBC For Oracle - 6.00.6001.18000 - Microsoft Corporation - MSORCL32.dll - Date
Whereas UAT server has below entry:
Microsoft ODBC For Oracle -
The driver Microsoft ODBC for oracle is listed in the drivers tab of UAT server but does not have the version & dll file details. Is this driver not installed properly? If yes, how to re install it? Please help to resolve this issue.
If this is not the right place to ask this question, please redirect me to the right group.
Thanks,
Tamil