CODEWITHSUNDEEP
exceloracle-databaseodbc
herder
herder

Reputation: 412

Connect from Excel 2007 to Oracle via ODBC (Windows7 x64)

I have a Windows 7 64 bit and Excel 2007 32 bit. I need to connect with Oracle DB by ODBC.

How can i create the above connection?

I installed 32bit client: instantclient-basic-nt-12.1.0.2.0 and instantclient-odbc-nt-12.1.0.2.0,

I created necessary environment paths (PATH, ORACLE_HOME, TNS_ADMIN) and I add ORACLE_HOME to variable PATH in system path.

When I'm trying to create DSN in C:\Windows\SysWOW64\odbcad32.exe I'm getting an error nr 126: system can not find a file SQORAS32.dll in %ORACLE_HOME%...

Any ideas?

Upvotes: 0

Views: 915

Answers (1)

herder
herder

Reputation: 412

I created ODBC connection!

The problem with error nr 126 still appears when I'm trying to create connection using driver "Oracle in instalclient_12_1", but when I'm using driver "Microsoft ODBC for Oracle" it works ok.

Upvotes: 0

Related Questions