Forum Stats

  • 3,784,355 Users
  • 2,254,928 Discussions
  • 7,880,790 Comments

Discussions

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

3ae2c8b6-997f-48c2-a1bd-989a0aea434b
edited Feb 8, 2016 12:45PM in ODBC

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

Answers

This discussion has been closed.