[Microsoft][ODBC Driver Manager] Data Source Name not found and no default driver specified

3ae2c8b6-997f-48c2-a1bd-989a0aea434b

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

top.gun

A better forum may be this one:

Sdhamoth-Oracle

You can try reinstalling MS ODBC driver. You need to install MDAC which includes MS ODBC driver for Oracle.

https://msdn.microsoft.com/en-us/library/ms810810.aspx

MS ODBC driver is based on OCI v7 APIs. Use Oracle ODBC driver for leveraging full potential of Oracle Database. You can run Oracle ODBC driver for Oracle using compact version of Oracle client called Oracle Instant Client.

Instant Client downloads for Windows

You have to download Oracle Instant Client Basic Lite package and ODBC package in the above link.