Re: 64bit Connection to Oracle
- From: "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
- Date: Wed, 5 Nov 2008 17:10:18 -0500
You cannot use a 32 bit ODBC driver from the 64 bit world. You'll have to
install a 64 bit ODBC driver for Oracle 9i.
I suppose that TNSPing and Oracle Sqlplus are working correctly with the 32
bit driver because they are 32 bit applications running under the emulation
mode (WOW64).
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)
"Robin9876" <robin9876@xxxxxxxxxxx> wrote in message
news:b0ef25ef-2260-4018-9244-a7e2c5d49771@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On a SQL Server 2005 Standard 64 bit on a Window 2003 R2 64 bit
standand server.
As after setting up 32 bit ODBC and then using the new ODBC connection
in SQL BI it lists the connection but then displays an error message
showing not resolving service name in TNSNames. Although TNSPing and
Oracle Sqlplus works fine.
When using the OLE from Microsoft it displays the error message
ORA-06413 connection not open and when using Oracle OLE is shows
unable to resolve service name.
How can you connection from 64 bit SIIS 2005 to Oracle 9i?
.
- References:
- 64bit Connection to Oracle
- From: Robin9876
- 64bit Connection to Oracle
- Prev by Date: 64bit Connection to Oracle
- Next by Date: Re: SSIS package Informix to SS 2005
- Previous by thread: 64bit Connection to Oracle
- Next by thread: Re: SSIS package Informix to SS 2005
- Index(es):
Relevant Pages
|
