OLEDB connection error with (win 64 bit server)

Hi

Im trying to connecting from SQL 2005 (win 64bit server) to a Oracle database via OLEDB but get the following message. The OraOLEDB.Oracle.1 provider is not registered on the local machine.

If we try ODBC we get the following message "error in initializing provider. Attemt to load Oracle client libraries threw BadImageFormatException.This problem will occur when running in 64bit mode whit the 32 bit Oracle Client components installed."

It should be the 64 bit client that is installed.

In the test environment (32 bit win) both works.

Pleas help

Rickard

One of the following two should work -

1) Get a Oracle client installed that is 64-bit compliant (http://www.oracle.com/technology/tech/windows/faq.html#x86-64)

2) Compile your application as "x32" instead of "anycpu" or "x64" and it will work

Useful link : http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=457875&SiteID=1

Let me know if you require more information

Best

Sriram

OLEDB connection error with (win 64 bit server)

Hi

Im trying to connecting from SQL 2005 (win 64bit server) to a Oracle database via OLEDB but get the following message. The OraOLEDB.Oracle.1 provider is not registered on the local machine.

If we try ODBC we get the following message "error in initializing provider. Attemt to load Oracle client libraries threw BadImageFormatException.This problem will occur when running in 64bit mode whit the 32 bit Oracle Client components installed."

It should be the 64 bit client that is installed.

In the test environment (32 bit win) both works.

Pleas help

Rickard

One of the following two should work -

1) Get a Oracle client installed that is 64-bit compliant (http://www.oracle.com/technology/tech/windows/faq.html#x86-64)

2) Compile your application as "x32" instead of "anycpu" or "x64" and it will work

Useful link : http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=457875&SiteID=1

Let me know if you require more information

Best

Sriram

OLE DB Provider for ODBC/Win XP

I have SQL Server Developer Edition which runs on Windows XP and it has been
running fine thus far. I am now trying to run Analysis Services on it and it
needs OLE DB Provider for ODBC. I downloaded MDAC 2.8 and installed it on my
Windows XP platform. The installation went without a hitch but when I go to
Data Sources (ODBC), I cannot see OLE DB Provider for ODBC listed. Does OLE
DB Provider for ODBC only run on Windows 2000 or Windows NT?
Thanks,
AlistairOops, that should be OLE DB Provider for OLAP.
Alistair
"lestersal" <lestersal@.cox.net> wrote in message
news:yLs3c.40660$1k.22567@.okepread01...
> I have SQL Server Developer Edition which runs on Windows XP and it has
been
> running fine thus far. I am now trying to run Analysis Services on it and
it
> needs OLE DB Provider for ODBC. I downloaded MDAC 2.8 and installed it on
my
> Windows XP platform. The installation went without a hitch but when I go
to
> Data Sources (ODBC), I cannot see OLE DB Provider for ODBC listed. Does
OLE
> DB Provider for ODBC only run on Windows 2000 or Windows NT?
> Thanks,
> Alistair
>|||The Data Sources (ODBC) control panel applet only deals with ODBC data
sources and drivers. You are referring to an OLE DB provider.
OLE DB has a similar data sources interface. Try creating a empty text
file, and save it with a .udl file extension. Then double-click that file
and you should get the OLE DB interface.
Brannon Jones
Developer - MDAC
This posting is provided "as is" with no warranties and confers no rights.
"lestersal" <lestersal@.cox.net> wrote in message
news:5oA3c.40902$1k.38183@.okepread01...
> Oops, that should be OLE DB Provider for OLAP.
> Alistair
> "lestersal" <lestersal@.cox.net> wrote in message
> news:yLs3c.40660$1k.22567@.okepread01...
> been
and
> it
on
> my
> to
> OLE
>

Ole db error

Hi frnds,
New problems evryday ..
we had migrated our intranet website(in asp) frm win 2k t
win 2k3 last week , for 2 days all went ok but then the
trouble(s) started ...
frm yest we are getting an error time in and again
"Microsoft Ole DB provider for ODBC Drivers
error '80040e31'"
I have no clue as 2 why it is happening ...
the backend is sql server 2000...
plz help
Regards
JulainThat's the error number for Timeout expired. If using ADO,
try increasing the command timeout property. You can find an
example of this at:
http://www.able-consulting.com/ADO_Faq.htm#Q14
You may also want to consider using the OLE DB provider for
SQL Server instead of the generic OLE DB provider for ODBC
drivers. Generally you will get better performance, more
functionality.
-Sue
On Mon, 17 May 2004 21:58:40 -0700, "Julian"
<anonymous@.discussions.microsoft.com> wrote:

>Hi frnds,
>New problems evryday ..
>we had migrated our intranet website(in asp) frm win 2k t
>win 2k3 last week , for 2 days all went ok but then the
>trouble(s) started ...
>frm yest we are getting an error time in and again
>"Microsoft Ole DB provider for ODBC Drivers
>error '80040e31'"
>I have no clue as 2 why it is happening ...
>the backend is sql server 2000...
>plz help
> Regards
>Julain

Ole db error

Hi frnds,
New problems evryday ..
we had migrated our intranet website(in asp) frm win 2k t
win 2k3 last week , for 2 days all went ok but then the
trouble(s) started ...
frm yest we are getting an error time in and again
"Microsoft Ole DB provider for ODBC Drivers
error '80040e31'"
I have no clue as 2 why it is happening ...
the backend is sql server 2000...
plz help
Regards
Julain
That's the error number for Timeout expired. If using ADO,
try increasing the command timeout property. You can find an
example of this at:
http://www.able-consulting.com/ADO_Faq.htm#Q14
You may also want to consider using the OLE DB provider for
SQL Server instead of the generic OLE DB provider for ODBC
drivers. Generally you will get better performance, more
functionality.
-Sue
On Mon, 17 May 2004 21:58:40 -0700, "Julian"
<anonymous@.discussions.microsoft.com> wrote:

>Hi frnds,
>New problems evryday ..
>we had migrated our intranet website(in asp) frm win 2k t
>win 2k3 last week , for 2 days all went ok but then the
>trouble(s) started ...
>frm yest we are getting an error time in and again
>"Microsoft Ole DB provider for ODBC Drivers
>error '80040e31'"
>I have no clue as 2 why it is happening ...
>the backend is sql server 2000...
>plz help
> Regards
>Julain