Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

3ae2c8b6-997f-48c2-a1bd-989a0aea434bFeb 8 2016 — edited Feb 8 2016

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

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 7 2016
Added on Feb 8 2016
2 comments
3,283 views