Oracle DBA to learn MS SQL: installed

Showing posts with label installed. Show all posts

Monday, March 19, 2012

Oracle XE

I haven't installed this yet but does anyone who has have any comments on
the pros and cons vs. SQL2005 Express?
Also, does it have any graphical management tools (analogous to Mgt. Studio
Express)?
Many thanks.
No one knows, huh?
"Andrew Chalk" <achalk@.magnacartasoftware.com> wrote in message
news:erEAtjYAGHA.3840@.TK2MSFTNGP15.phx.gbl...
>I haven't installed this yet but does anyone who has have any comments on
>the pros and cons vs. SQL2005 Express?
> Also, does it have any graphical management tools (analogous to Mgt.
> Studio Express)?
> Many thanks.
>

Oracle with Crystal: "Failed to Load Database Information"

I've already deployed the Crystal .msi and installed the Oracle Client on the server, and still getting this message:

Temp\temp_294ca6ef-60f1-4511-b5a5-c6986817b96d.rpt: Failed to load database information.

I gave permission to the ASP.NET user in all the folders it needs, Oracle, Ora92 and Ora92/bin, Temp...

In the development computer it runs OK, but in Production server its crashs!

Someone can help me? Any ideas will be quite welcome!

Thanks in advance!

Fernando Ruano.Does your server support crystal report?
you can try to load the crystal report in your server where from your application is running.|||Yes, my server support it because the deployment was already made.

And when I create an ODBC with Oracle it works fine.

Only when my app tries to call a .rtp Crystal Report from the server causes the failed load database.

How come?? O_o'|||See if you are able to find solution here
http://www.businessobjects.com/support/default.asp

Monday, March 12, 2012

Oracle report returning strange data

I have a RS report that is connecting to an Oracle Database (8.1.7), the
8.1.7 oracle client is installed on RS Sever, and the result set is returning
strange data. I'm using a simple view that was created in the Oracle
database, that returns a small record set about 100 records. I'm seeing ASCII
values in place of some data, in the Data tab and the Preview tab and the
Published report.
I have tried using both Oracle Drivers and the Microsoft ODBC drivers for
Oracle, and I get the same results.
Some of the data looks just fine but some of the characters get replaced by
ASCII values.
I have installed RS SP1.
Don't know what I am doing wrong...Hi Gary
We are running SQL Reporting Services (SP1) against an Oracle 9i database
without any problems. In our case 9.2.0.4 client is used to talk with
9.2.0.4 database.
I suspect the problem you are having is related to version of Oracle client
you are using. If you have access to a client 9.2.0.4 or higher you may want
to give that a try.
"garyc" wrote:
> I have a RS report that is connecting to an Oracle Database (8.1.7), the
> 8.1.7 oracle client is installed on RS Sever, and the result set is returning
> strange data. I'm using a simple view that was created in the Oracle
> database, that returns a small record set about 100 records. I'm seeing ASCII
> values in place of some data, in the Data tab and the Preview tab and the
> Published report.
> I have tried using both Oracle Drivers and the Microsoft ODBC drivers for
> Oracle, and I get the same results.
> Some of the data looks just fine but some of the characters get replaced by
> ASCII values.
> I have installed RS SP1.
> Don't know what I am doing wrong...

Friday, March 9, 2012

Oracle OLEDB in SSIS - problem with 64bit

I have a 64bit Windows 2003 Server with SQL 2005 (64bit) installed. I would want to fetch data from an Oracle database that resides on a different server and load it into SQL2005 through SSIS. This is part of migration from SQL2000.

I have tried to run Oracle client 10G (64bit) with no success, since SSIS is a 32bit application.

I uninstalled the 64bit Oracle client and installed the 32bit version and can create an Oracle OLEDB Provider as Connection Manager and preview the data from the Oracle source, but when I run the package it displays an error almost directly and the transfer stops.

[OLE DB Source [1]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "BOFLEV.bofinc" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.

I have tried to change the path for SSIS from Program Files (x86) to ProgramFilesx86 with no luck.

I have changed the Run64BitRunTime to false.

Is there anyone that has managed to resolve this, I really do not want to use a third party software for this!

SSIS has both 32-bit and 64-bit flavors. The dev environment (BIDS) only uses the 32-bit version, though.

Can you connect to Oracle through the 32-bit driver from any other application (like Access)? If not, it sounds lile the driver installation is corrupt.

|||

Yeah we managed to get this one sorted after much searching.

Be very careful with the version of oracle 10g you are using, if memory serves me right it needs to be 10.2..0.1.8 or higher, it is not sufficient to have only 10g 64 bit, it must be patched also.

We used the microsoft oracle driver for the 32bit development of the packages using BIDS, we used configurations for the connections thus allowing us to change the provider type from msdaora to oraoledb.oracle.1 for when we transfered and scheduled the package on the SSIS 64 bit. So far we have used this scenario for about 80 packages without fail.

Regards

John

Oracle odbc driver on windows 2003 64 bit, SQL Server 2005

God morning!
I 've just installed SQL Server 2005 on Windows 2003 Server 64 bit. One of my databases need to connect to seveal Oracle databases.
- I tried installing 64 bit Orcale 9 on this server. Got a strange message that the application (Oracle 64 bit) could not be installed on a 32 bit server! Strange!
- I installed Oracle 9 32 bit on the server, but I could not find ODBC driver in the Data sources! Neither the oledb under providers in MSS Manager Studio!
- Same result efter several desintall and installation. A college copied the .dll files och run a script to register the dll files. We could then se the Oracle driver in the Database sources, but we could not create any connection.
- We have even tried an 10G version of Oracle with the same result.

Is there anyone who succeeded installing Oracle on 64 bit Windows and could create odbc connection/linked server?

Regards

I am in the same situation. Have you been able to find a solution?

Thanks,
Derek|||

Unfortunetly not :(

I have posted this issue on several forums including Oracles site. We are going to leave that database which demand linked servers to Oracle on the 32 bit server. I am going to install SQL Server 2005 on that server later. But I am still hoping for some solution to this delicate problem.

|||On 64 bit Windows you have seperate 32 bit and 64 bit ODBC worlds. There is no thunking between 32 and 64 bit components as there was between 16 and 32 bit. To work with 32 bit drivers you need to run the 32 bit ODBC administrator C:\WINDOWS\SysWOW64\odbcad32.exe|||

Oh!

Was it that simpel! Thanks for your answer. I could set up my odbc links, but I could't find Oracle oledb provider under linked servers.

Do you have a tip on that?

|||

Please note that there is no 64bit version of the Microsoft Oracle OLEDB provider but there is a 32bit version on the box that can be used by 32bit applications.

To use linked servers on 64bit, you might want to consider installing/using the Oracle supplied OLEDB provider if any.

Regards,

Uwa.

|||

Hi!

I managed fixing thanks to tips from Ron (http://www.dbforums.com/showthread.php?p=6242791#post6242791) by downloading and installning "Oracle Database 10g Release 2 (10.2.0.1.0) for Microsoft Windows (x64)" from Oracle download page.

I could set up odbc links and linked servers in my x64 box.

Thanks, everyone who replied to my questions.

|||

Maybe I did this wrong, but what I tried (on WindXP 64-bit) was...

1. Load Oracle 10.2.0.1.0 64-bit Enterprise in OraHome and create a sample database.

2. Load Oracle 10.2.0.1.0 32-bit Client in OraClient, with base install and Windows extensions (ODBC, OLE, etc.)

However, when I open C:\Windows\SysWOW64\odbcad32.exe (the 32 Bit ODBC administrator, I saw the Oracle driver for OraClient, but could not create a DSN for the sample OraDB in the 64-bit OraHome.

Can someone point me in the right direction?

Thanks.

- Will

|||

When you say you couldn't set up a DSN, could you give a bit more detail about how you tried to do this and what happened (esp in terms of error messages). Thanks.

|||

Hi!

I hade a wrong version av Orcale installation at that time!

When I couldn't install the 64 version av Oracle. I got a meeage that said something like my Windows installation was not 64 bit!

Then I tried installong the 32 bit version. After that couldn't I see the odbc driver for Oracle in 64 bit odbc. At that time could I however fix my odbc source by running the 32 version av odbc! C:\Windows\SysWOW64\odbcad32.exe

But installing the 32 version av Orcale didn't help my fixing linked servers. There was no oledb driver avaible for 64 bit version of SQL server 2005!

I deinstalled Oracle 32 bit, downloaded x64 version av Oracle (after a tip from some one in the forum). The 64 bit version which I tried to install was for Itanium. I had AMD! I manage downloading X64 which is for AMD ("Oracle Database 10g Release 2 (10.2.0.1.0) for Microsoft Windows (x64)") from Oracle download page.

|||

Hi!

I hade a wrong version av Orcale installation at that time!

When I couldn't install the 64 version av Oracle. I got a meeage that said something like my Windows installation was not 64 bit!

But installing the 32 version av Orcale didn't help my fixing linked servers. There was no oledb driver avaible for 64 bit version of SQL server 2005!

I did not install the Oracle database however. I ran the custom installation together with our Oracle expert. We insatalled ODBC, Oledb, ... After that I could find both drivers under the 64 bit version of ODBC and under linked servers in SQL Server 2005.

Try that!

Good luck!

|||

This *IS* possible and have now done it with assist from Oracle tech support.

1. Install 64-bit 10.2.0.1 Database into OraDb_home.
2. Install 32-bit 10.2.0.1 Client (needs Windows ODBC extensions) into OraClient_home.
3. Apply patch 5500954 for 64-bit - this is a Critical Bug patch 8 for 64-bit.
4. Apply patch 5337014 for 32-bit - this is a patchset to upgrade the Client to 10.0.2.0.3.
5. Contrary to what Oracle note 334528.1 says (which is to patch the 64-bit Server), you must patch/upgrade the 32-bit client as well (otherwise, it still fails).

Also, DataDirect's Connect Ver 5.2 ODBC Oracle "wire-driver" (32-bit version) will work without installing the OraClient at all.

- Will

|||

Hi!

Thanks for your reply. I wonder why I should "Install 32-bit 10.2.0.1 Client (needs Windows ODBC extensions) into OraClient_home."?

|||

You need to install two Oracle homes and a database to access, like...

1. The 64-bit database into C:\Oracle\Database - and call the OracleHome instance OraDatabase.

2. The 32-bit client (a whole administrative install) into C:\Oracle\Client - and call the OracleHome instance OraClient.

3. The 64-bit Oracle database ORCL.

(Do NOT try to install into "C:\Program Files\Oracle"... or its "short" equivalent C:\Progra~1\Oracle as the OPatch utility will NOT parse either of these properly)

Take the sqlnet.ora, listener.ora, and tnsnames.ora files from C:\Oracle\Database\Network\Admin and copy them to C:\Oracle\Client\Network\Admin.

At a minimum, the following Services need to be operating from the database...

1. OracleOraDatabaseTNSListener

2. OracleServiceORCL

Lastly, the note above describing the use of the 32-bit 10.3.0.1 does NOT note that there has turned out to be a bug in the sqora32.dll ODBC driver (and two others). This can be fixed by patch 5699495 from MetaLink - metalink.oracle.com.

- Will

|||

Dear Sir,

I have ASP v3 installed on Windows Server 2003 x64 which is connected to Oracle9i Database server. As you know ASP works under 32 bit Tech. So i need to install 32bit oracle client on the server to let ASP connect to Oracle. I tried to install oracle9i client but it didnot work ( the ODBC test connection works but the ASP cannot connect). I Also tried ODBC 32-bit Driver & ODAC all-in-one for 64bit & InstantClient .... all of the failed.

i would like to ask you about your steps, if it works well with ASP. Also i need to know from where i can download "32-bit 10.2.0.1 Client and 5337014 for 32-bit patch.

thank you in advance.

Alaa

Oracle odbc driver on windows 2003 64 bit, SQL Server 2005

Is there anyone who succeeded installing Oracle on 64 bit Windows and could create odbc connection/linked server?

Regards

I am in the same situation. Have you been able to find a solution?

Thanks,
Derek|||

Unfortunetly not :(

Oh!

Was it that simpel! Thanks for your answer. I could set up my odbc links, but I could't find Oracle oledb provider under linked servers.

Do you have a tip on that?

|||

Please note that there is no 64bit version of the Microsoft Oracle OLEDB provider but there is a 32bit version on the box that can be used by 32bit applications.

To use linked servers on 64bit, you might want to consider installing/using the Oracle supplied OLEDB provider if any.

Regards,

Uwa.

|||

Hi!

I could set up odbc links and linked servers in my x64 box.

Thanks, everyone who replied to my questions.

|||

Maybe I did this wrong, but what I tried (on WindXP 64-bit) was...

1. Load Oracle 10.2.0.1.0 64-bit Enterprise in OraHome and create a sample database.

2. Load Oracle 10.2.0.1.0 32-bit Client in OraClient, with base install and Windows extensions (ODBC, OLE, etc.)

However, when I open C:\Windows\SysWOW64\odbcad32.exe (the 32 Bit ODBC administrator, I saw the Oracle driver for OraClient, but could not create a DSN for the sample OraDB in the 64-bit OraHome.

Can someone point me in the right direction?

Thanks.

- Will

|||

When you say you couldn't set up a DSN, could you give a bit more detail about how you tried to do this and what happened (esp in terms of error messages). Thanks.

|||

Hi!

I hade a wrong version av Orcale installation at that time!

When I couldn't install the 64 version av Oracle. I got a meeage that said something like my Windows installation was not 64 bit!

But installing the 32 version av Orcale didn't help my fixing linked servers. There was no oledb driver avaible for 64 bit version of SQL server 2005!

|||

Hi!

I hade a wrong version av Orcale installation at that time!

When I couldn't install the 64 version av Oracle. I got a meeage that said something like my Windows installation was not 64 bit!

But installing the 32 version av Orcale didn't help my fixing linked servers. There was no oledb driver avaible for 64 bit version of SQL server 2005!

Try that!

Good luck!

|||

This *IS* possible and have now done it with assist from Oracle tech support.

Also, DataDirect's Connect Ver 5.2 ODBC Oracle "wire-driver" (32-bit version) will work without installing the OraClient at all.

- Will

|||

Hi!

Thanks for your reply. I wonder why I should "Install 32-bit 10.2.0.1 Client (needs Windows ODBC extensions) into OraClient_home."?

|||

You need to install two Oracle homes and a database to access, like...

1. The 64-bit database into C:\Oracle\Database - and call the OracleHome instance OraDatabase.

2. The 32-bit client (a whole administrative install) into C:\Oracle\Client - and call the OracleHome instance OraClient.

3. The 64-bit Oracle database ORCL.

(Do NOT try to install into "C:\Program Files\Oracle"... or its "short" equivalent C:\Progra~1\Oracle as the OPatch utility will NOT parse either of these properly)

Take the sqlnet.ora, listener.ora, and tnsnames.ora files from C:\Oracle\Database\Network\Admin and copy them to C:\Oracle\Client\Network\Admin.

At a minimum, the following Services need to be operating from the database...

1. OracleOraDatabaseTNSListener

2. OracleServiceORCL

- Will

|||

Dear Sir,

i would like to ask you about your steps, if it works well with ASP. Also i need to know from where i can download "32-bit 10.2.0.1 Client and 5337014 for 32-bit patch.

thank you in advance.

Alaa

Oracle odbc driver on windows 2003 64 bit, SQL Server 2005

Is there anyone who succeeded installing Oracle on 64 bit Windows and could create odbc connection/linked server?

Regards

I am in the same situation. Have you been able to find a solution?

Thanks,
Derek|||

Unfortunetly not :(

Oh!

Was it that simpel! Thanks for your answer. I could set up my odbc links, but I could't find Oracle oledb provider under linked servers.

Do you have a tip on that?

|||

Please note that there is no 64bit version of the Microsoft Oracle OLEDB provider but there is a 32bit version on the box that can be used by 32bit applications.

To use linked servers on 64bit, you might want to consider installing/using the Oracle supplied OLEDB provider if any.

Regards,

Uwa.

|||

Hi!

I could set up odbc links and linked servers in my x64 box.

Thanks, everyone who replied to my questions.

|||

Maybe I did this wrong, but what I tried (on WindXP 64-bit) was...

1. Load Oracle 10.2.0.1.0 64-bit Enterprise in OraHome and create a sample database.

2. Load Oracle 10.2.0.1.0 32-bit Client in OraClient, with base install and Windows extensions (ODBC, OLE, etc.)

However, when I open C:\Windows\SysWOW64\odbcad32.exe (the 32 Bit ODBC administrator, I saw the Oracle driver for OraClient, but could not create a DSN for the sample OraDB in the 64-bit OraHome.

Can someone point me in the right direction?

Thanks.

- Will

|||

When you say you couldn't set up a DSN, could you give a bit more detail about how you tried to do this and what happened (esp in terms of error messages). Thanks.

|||

Hi!

I hade a wrong version av Orcale installation at that time!

When I couldn't install the 64 version av Oracle. I got a meeage that said something like my Windows installation was not 64 bit!

But installing the 32 version av Orcale didn't help my fixing linked servers. There was no oledb driver avaible for 64 bit version of SQL server 2005!

|||

Hi!

I hade a wrong version av Orcale installation at that time!

When I couldn't install the 64 version av Oracle. I got a meeage that said something like my Windows installation was not 64 bit!

But installing the 32 version av Orcale didn't help my fixing linked servers. There was no oledb driver avaible for 64 bit version of SQL server 2005!

Try that!

Good luck!

|||

This *IS* possible and have now done it with assist from Oracle tech support.

Also, DataDirect's Connect Ver 5.2 ODBC Oracle "wire-driver" (32-bit version) will work without installing the OraClient at all.

- Will

|||

Hi!

Thanks for your reply. I wonder why I should "Install 32-bit 10.2.0.1 Client (needs Windows ODBC extensions) into OraClient_home."?

|||

You need to install two Oracle homes and a database to access, like...

1. The 64-bit database into C:\Oracle\Database - and call the OracleHome instance OraDatabase.

2. The 32-bit client (a whole administrative install) into C:\Oracle\Client - and call the OracleHome instance OraClient.

3. The 64-bit Oracle database ORCL.

(Do NOT try to install into "C:\Program Files\Oracle"... or its "short" equivalent C:\Progra~1\Oracle as the OPatch utility will NOT parse either of these properly)

Take the sqlnet.ora, listener.ora, and tnsnames.ora files from C:\Oracle\Database\Network\Admin and copy them to C:\Oracle\Client\Network\Admin.

At a minimum, the following Services need to be operating from the database...

1. OracleOraDatabaseTNSListener

2. OracleServiceORCL

- Will

|||

Dear Sir,

i would like to ask you about your steps, if it works well with ASP. Also i need to know from where i can download "32-bit 10.2.0.1 Client and 5337014 for 32-bit patch.

thank you in advance.

Alaa

Oracle odbc driver on windows 2003 64 bit, SQL Server 2005

Is there anyone who succeeded installing Oracle on 64 bit Windows and could create odbc connection/linked server?

Regards

I am in the same situation. Have you been able to find a solution?

Thanks,
Derek

|||

Unfortunetly not :(

Oh!

Was it that simpel! Thanks for your answer. I could set up my odbc links, but I could't find Oracle oledb provider under linked servers.

Do you have a tip on that?

|||

Please note that there is no 64bit version of the Microsoft Oracle OLEDB provider but there is a 32bit version on the box that can be used by 32bit applications.

To use linked servers on 64bit, you might want to consider installing/using the Oracle supplied OLEDB provider if any.

Regards,

Uwa.

|||

Hi!

I could set up odbc links and linked servers in my x64 box.

Thanks, everyone who replied to my questions.

|||

Maybe I did this wrong, but what I tried (on WindXP 64-bit) was...

1. Load Oracle 10.2.0.1.0 64-bit Enterprise in OraHome and create a sample database.

2. Load Oracle 10.2.0.1.0 32-bit Client in OraClient, with base install and Windows extensions (ODBC, OLE, etc.)

However, when I open C:\Windows\SysWOW64\odbcad32.exe (the 32 Bit ODBC administrator, I saw the Oracle driver for OraClient, but could not create a DSN for the sample OraDB in the 64-bit OraHome.

Can someone point me in the right direction?

Thanks.

- Will

|||

When you say you couldn't set up a DSN, could you give a bit more detail about how you tried to do this and what happened (esp in terms of error messages). Thanks.

|||

Hi!

I hade a wrong version av Orcale installation at that time!

When I couldn't install the 64 version av Oracle. I got a meeage that said something like my Windows installation was not 64 bit!

But installing the 32 version av Orcale didn't help my fixing linked servers. There was no oledb driver avaible for 64 bit version of SQL server 2005!

|||

Hi!

I hade a wrong version av Orcale installation at that time!

When I couldn't install the 64 version av Oracle. I got a meeage that said something like my Windows installation was not 64 bit!

But installing the 32 version av Orcale didn't help my fixing linked servers. There was no oledb driver avaible for 64 bit version of SQL server 2005!

Try that!

Good luck!

|||

This *IS* possible and have now done it with assist from Oracle tech support.

Also, DataDirect's Connect Ver 5.2 ODBC Oracle "wire-driver" (32-bit version) will work without installing the OraClient at all.

- Will

|||

Hi!

Thanks for your reply. I wonder why I should "Install 32-bit 10.2.0.1 Client (needs Windows ODBC extensions) into OraClient_home."?

|||

You need to install two Oracle homes and a database to access, like...

1. The 64-bit database into C:\Oracle\Database - and call the OracleHome instance OraDatabase.

2. The 32-bit client (a whole administrative install) into C:\Oracle\Client - and call the OracleHome instance OraClient.

3. The 64-bit Oracle database ORCL.

(Do NOT try to install into "C:\Program Files\Oracle"... or its "short" equivalent C:\Progra~1\Oracle as the OPatch utility will NOT parse either of these properly)

Take the sqlnet.ora, listener.ora, and tnsnames.ora files from C:\Oracle\Database\Network\Admin and copy them to C:\Oracle\Client\Network\Admin.

At a minimum, the following Services need to be operating from the database...

1. OracleOraDatabaseTNSListener

2. OracleServiceORCL

- Will

|||

Dear Sir,

i would like to ask you about your steps, if it works well with ASP. Also i need to know from where i can download "32-bit 10.2.0.1 Client and 5337014 for 32-bit patch.

thank you in advance.

Alaa

Wednesday, March 7, 2012

Oracle odbc driver on windows 2003 64 bit, SQL Server 2005

Is there anyone who succeeded installing Oracle on 64 bit Windows and could create odbc connection/linked server?

Regards

I am in the same situation. Have you been able to find a solution?

Thanks,
Derek|||

Unfortunetly not :(

Oh!

Was it that simpel! Thanks for your answer. I could set up my odbc links, but I could't find Oracle oledb provider under linked servers.

Do you have a tip on that?

|||

Please note that there is no 64bit version of the Microsoft Oracle OLEDB provider but there is a 32bit version on the box that can be used by 32bit applications.

To use linked servers on 64bit, you might want to consider installing/using the Oracle supplied OLEDB provider if any.

Regards,

Uwa.

|||

Hi!

I could set up odbc links and linked servers in my x64 box.

Thanks, everyone who replied to my questions.

|||

Maybe I did this wrong, but what I tried (on WindXP 64-bit) was...

1. Load Oracle 10.2.0.1.0 64-bit Enterprise in OraHome and create a sample database.

2. Load Oracle 10.2.0.1.0 32-bit Client in OraClient, with base install and Windows extensions (ODBC, OLE, etc.)

However, when I open C:\Windows\SysWOW64\odbcad32.exe (the 32 Bit ODBC administrator, I saw the Oracle driver for OraClient, but could not create a DSN for the sample OraDB in the 64-bit OraHome.

Can someone point me in the right direction?

Thanks.

- Will

|||

When you say you couldn't set up a DSN, could you give a bit more detail about how you tried to do this and what happened (esp in terms of error messages). Thanks.

|||

Hi!

I hade a wrong version av Orcale installation at that time!

When I couldn't install the 64 version av Oracle. I got a meeage that said something like my Windows installation was not 64 bit!

But installing the 32 version av Orcale didn't help my fixing linked servers. There was no oledb driver avaible for 64 bit version of SQL server 2005!

|||

Hi!

I hade a wrong version av Orcale installation at that time!

When I couldn't install the 64 version av Oracle. I got a meeage that said something like my Windows installation was not 64 bit!

But installing the 32 version av Orcale didn't help my fixing linked servers. There was no oledb driver avaible for 64 bit version of SQL server 2005!

Try that!

Good luck!

|||

This *IS* possible and have now done it with assist from Oracle tech support.

Also, DataDirect's Connect Ver 5.2 ODBC Oracle "wire-driver" (32-bit version) will work without installing the OraClient at all.

- Will

|||

Hi!

Thanks for your reply. I wonder why I should "Install 32-bit 10.2.0.1 Client (needs Windows ODBC extensions) into OraClient_home."?

|||

You need to install two Oracle homes and a database to access, like...

1. The 64-bit database into C:\Oracle\Database - and call the OracleHome instance OraDatabase.

2. The 32-bit client (a whole administrative install) into C:\Oracle\Client - and call the OracleHome instance OraClient.

3. The 64-bit Oracle database ORCL.

(Do NOT try to install into "C:\Program Files\Oracle"... or its "short" equivalent C:\Progra~1\Oracle as the OPatch utility will NOT parse either of these properly)

Take the sqlnet.ora, listener.ora, and tnsnames.ora files from C:\Oracle\Database\Network\Admin and copy them to C:\Oracle\Client\Network\Admin.

At a minimum, the following Services need to be operating from the database...

1. OracleOraDatabaseTNSListener

2. OracleServiceORCL

- Will

|||

Dear Sir,

i would like to ask you about your steps, if it works well with ASP. Also i need to know from where i can download "32-bit 10.2.0.1 Client and 5337014 for 32-bit patch.

thank you in advance.

Alaa

Oracle odbc driver on windows 2003 64 bit, SQL Server 2005

Is there anyone who succeeded installing Oracle on 64 bit Windows and could create odbc connection/linked server?

Regards

I am in the same situation. Have you been able to find a solution?

Thanks,
Derek|||

Unfortunetly not :(

Oh!

Was it that simpel! Thanks for your answer. I could set up my odbc links, but I could't find Oracle oledb provider under linked servers.

Do you have a tip on that?

|||

Please note that there is no 64bit version of the Microsoft Oracle OLEDB provider but there is a 32bit version on the box that can be used by 32bit applications.

To use linked servers on 64bit, you might want to consider installing/using the Oracle supplied OLEDB provider if any.

Regards,

Uwa.

|||

Hi!

I could set up odbc links and linked servers in my x64 box.

Thanks, everyone who replied to my questions.

|||

Maybe I did this wrong, but what I tried (on WindXP 64-bit) was...

1. Load Oracle 10.2.0.1.0 64-bit Enterprise in OraHome and create a sample database.

2. Load Oracle 10.2.0.1.0 32-bit Client in OraClient, with base install and Windows extensions (ODBC, OLE, etc.)

However, when I open C:\Windows\SysWOW64\odbcad32.exe (the 32 Bit ODBC administrator, I saw the Oracle driver for OraClient, but could not create a DSN for the sample OraDB in the 64-bit OraHome.

Can someone point me in the right direction?

Thanks.

- Will

|||

When you say you couldn't set up a DSN, could you give a bit more detail about how you tried to do this and what happened (esp in terms of error messages). Thanks.

|||

Hi!

I hade a wrong version av Orcale installation at that time!

When I couldn't install the 64 version av Oracle. I got a meeage that said something like my Windows installation was not 64 bit!

But installing the 32 version av Orcale didn't help my fixing linked servers. There was no oledb driver avaible for 64 bit version of SQL server 2005!

|||

Hi!

I hade a wrong version av Orcale installation at that time!

When I couldn't install the 64 version av Oracle. I got a meeage that said something like my Windows installation was not 64 bit!

But installing the 32 version av Orcale didn't help my fixing linked servers. There was no oledb driver avaible for 64 bit version of SQL server 2005!

Try that!

Good luck!

|||

This *IS* possible and have now done it with assist from Oracle tech support.

Also, DataDirect's Connect Ver 5.2 ODBC Oracle "wire-driver" (32-bit version) will work without installing the OraClient at all.

- Will

|||

Hi!

Thanks for your reply. I wonder why I should "Install 32-bit 10.2.0.1 Client (needs Windows ODBC extensions) into OraClient_home."?

|||

You need to install two Oracle homes and a database to access, like...

1. The 64-bit database into C:\Oracle\Database - and call the OracleHome instance OraDatabase.

2. The 32-bit client (a whole administrative install) into C:\Oracle\Client - and call the OracleHome instance OraClient.

3. The 64-bit Oracle database ORCL.

(Do NOT try to install into "C:\Program Files\Oracle"... or its "short" equivalent C:\Progra~1\Oracle as the OPatch utility will NOT parse either of these properly)

Take the sqlnet.ora, listener.ora, and tnsnames.ora files from C:\Oracle\Database\Network\Admin and copy them to C:\Oracle\Client\Network\Admin.

At a minimum, the following Services need to be operating from the database...

1. OracleOraDatabaseTNSListener

2. OracleServiceORCL

- Will

|||

Dear Sir,

i would like to ask you about your steps, if it works well with ASP. Also i need to know from where i can download "32-bit 10.2.0.1 Client and 5337014 for 32-bit patch.

thank you in advance.

Alaa

Oracle not supported?

I installed de trial version of SQL Server 2005 Workgroup, then created a
small report using a Oracle Database.
In Visual Studio the report previews fine but after being deployed to SSRS
i't tells me that the data extension is not registered.
Is this a trial version issue or is the Oracle support for SSRS have to be
configured after instalation?
Juan Ignacio Herreralook at this page:
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
the workgroup edition support only data source against the same SQL Servre
installation only.
you can't directly access Oracle or any external source.
but... maybe you can create a linked server to your oracle database and
create your queries using the openquery SQL command.
the queries will come from your local server and not from your oracle
database.
"Juan Ignacio Herrera" <nacho(quitar)@.delta.com.gt> wrote in message
news:uQ8sNyvGGHA.3176@.TK2MSFTNGP12.phx.gbl...
>I installed de trial version of SQL Server 2005 Workgroup, then created a
> small report using a Oracle Database.
> In Visual Studio the report previews fine but after being deployed to SSRS
> i't tells me that the data extension is not registered.
> Is this a trial version issue or is the Oracle support for SSRS have to be
> configured after instalation?
> Juan Ignacio Herrera
>

Oracle Linked Server on Windows 2003

We have SQL 2000 SP3a installed on a Windows 2003 server.
We are trying to add an Oracle 8.1.7 linked server.
On W2003, the error message below appears when trying to view tables with th
e exact same connection parameters work on several servers that are running
SQL 2000 on Windows 2000.
Parameters are
Other Data Source: Microsoft OLE DB Provider for Oracle
Product name: Oracle
Data Source: <same as on working W2K server>
Data Source: <same as on working W2K server>
Server Options: Data Access, RPC, RPC Out, Use Remote Collation enabled
Be made in this security context: <same Username/PW that are working on W2K
server>
Error message:
Error 7399: OLE DB provider 'MSDAORA' reported an error.
OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize
returned 0x80004005: ].
How can we get SQL 2000 on W2003 to link to the Oracle server?Did you restart the server after installing the Oracle client?
The recommended steps are:
1. Install Oracle client
2. Reinstall MDAC
3. Reboot the server
Also you cannot use multiple Oracle homes, this is not supported from
the OLE DB provider.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!|||Hi,
I am having an issue while trying to install the Orcale Client 8.1.7 on a
Windows 2003 Server Standard Edition...Nothing happens and the install
doesn't complete? Is there a switch I need to check to allow the
installation?
Thanks,
Warren
"mt69clp" wrote:

> Did you restart the server after installing the Oracle client?
> The recommended steps are:
> 1. Install Oracle client
> 2. Reinstall MDAC
> 3. Reboot the server
> Also you cannot use multiple Oracle homes, this is not supported from
> the OLE DB provider.
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
>|||Why do you choose Client 8.1.7? Try installing the newest 9.X client. It
is backward compatible and you will have less trouble wit Windows 2003.
The 10.X should do it also but I think it is not tested by Microsoft
until now.
I use the 9.0.1.0 client to connect to a 8.1.7.4 database and it works
fine.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!|||Hi,
I tried to install the 9.x Client and still can't. I don't get an error, it
just says press next once the installation is complete and it just stops? I
s
there a setting in Windows 2003 server that I need to address to allow the
install?
Thanks,
Warren
"mt69clp" wrote:

> Why do you choose Client 8.1.7? Try installing the newest 9.X client. It
> is backward compatible and you will have less trouble wit Windows 2003.
> The 10.X should do it also but I think it is not tested by Microsoft
> until now.
> I use the 9.0.1.0 client to connect to a 8.1.7.4 database and it works
> fine.
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
>|||Hello, I was wondering if anyone was able to run the Oracle 8i v8.1.7 databa
se on the Windows 2003 Server? Also, do you know where i could find additio
nal information for other applications (such as Websphere 5.0.2 and the J2EE
Architecture) running on Windows 2003 Server? Any help is appreciated.
Thanks,
Jason

quote:
Originally posted by mt69clp
Why do you choose Client 8.1.7? Try installing the newest 9.X client. It
is backward compatible and you will have less trouble wit Windows 2003.
The 10.X should do it also but I think it is not tested by Microsoft
until now.
I use the 9.0.1.0 client to connect to a 8.1.7.4 database and it works
fine.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

|||I just opened a crit sit with MS with regards to this issue. Here is
how to fix it with Windows 2003, SQL 2000, and Oracle 9i:
This is discussed in Q193893 and according to this the registry key "
& #91;HKEY_LOCAL_MACHINE\SOFTWARE\Microsof
t\MSDTC\MTxOCI] " should have
following
entries.
"OracleXaLib"="oraclient9.dll"
"OracleSqlLib"="orasql9.dll"
"OracleOciLib"="oci.dll"
I hope this helps.
Carrie
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

Oracle Linked Server on SQL Server 2005 64-bit

Hello,
we are trying to migrate from SQL Server 2000 to SQL Server 2005.
On an 64 bit Windows 2003 SP1 Server we have installed an SQL Server 2000
Enterprise Edition and an SQL Server Enterprise Edition 2005 (64bit), both as
named instances.
On both SQL Servers we have configured Oracle Linked Servers. While
distributed queries on the SQL Server 2000 are running fine, we get the
following error message on the SQL Server 2005:
Msg 7403, Level 16, State 1, Procedure v_extendedcustomer2, Line 6
The OLE DB provider "MSDAORA" has not been registered.
What could be the problem?
Thanks in advance
Detlef Herchen
Hi Detlef,
Welcome to use MSDN Managed Newsgroup!
From your descriptions, I understood you could quer
1. Is your SQL Server 2000 also 64 bit version?
2. Does your Oracle OLE DB provider supports 64-bit? You must download the
latest provider that supports 64 bit for SQL Server 2005 x64
3. You may also try using 32bit ODBC Configuration in the Windows Pro X64
to configure Access ODBC driver for your application. Launch the Panel with
command C:\WINDOWS\SysWow64\odbcad32.exe and you will see the Configuration
Dialog. (Note that this will run on WOW)
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

Oracle Linked Server on SQL Server 2005 64-bit

Hello,
we are trying to migrate from SQL Server 2000 to SQL Server 2005.
On an 64 bit Windows 2003 SP1 Server we have installed an SQL Server 2000
Enterprise Edition and an SQL Server Enterprise Edition 2005 (64bit), both a
s
named instances.
On both SQL Servers we have configured Oracle Linked Servers. While
distributed queries on the SQL Server 2000 are running fine, we get the
following error message on the SQL Server 2005:
Msg 7403, Level 16, State 1, Procedure v_extendedcustomer2, Line 6
The OLE DB provider "MSDAORA" has not been registered.
What could be the problem?
Thanks in advance
Detlef HerchenHi Detlef,
Welcome to use MSDN Managed Newsgroup!
From your descriptions, I understood you could quer
1. Is your SQL Server 2000 also 64 bit version?
2. Does your Oracle OLE DB provider supports 64-bit? You must download the
latest provider that supports 64 bit for SQL Server 2005 x64
3. You may also try using 32bit ODBC Configuration in the Windows Pro X64
to configure Access ODBC driver for your application. Launch the Panel with
command C:\WINDOWS\SysWow64\odbcad32.exe and you will see the Configuration
Dialog. (Note that this will run on WOW)
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||Dear Michael Cheng,
I'm using SQL Server 2005 64 Bit and having a problem when I try to
connect to Oracle 10G 64 Bit (installed on the same server). I'm using
"Oracle Provider for OLE DB" to connect but from what I've read in
Books Online that the provider doesn't support for Oracle 64 Bit. Can
you please tell me how to fix it ? Maybe I should install another
provider such as "Microsoft OLE DB Provider for Oracle" ? If so, where
can I find or download that provider for SQL 2005 64 Bit. Thanks.
Regards,
Albert
4lb3rt
---
4lb3rt's Profile: http://www.dbtalk.net/m925
View this thread: http://www.dbtalk.net/t155721

Oracle linked server error

Hello,
sql server 2000 cluster patched to SP3 and NT5 patched to SP4.
Oracle 9i client installed.
We have set up a linked server to an Oracle instance using the 'Microsoft
OLE DB Provider for Oracle', this works for a while without any problems and
then for an unknown reason ceases to work.
The only error messages I have been able to get is by running the t-sql query
SELECT * FROM LINKSERV..SCHEMA.TABLE which returns
Server:Msg 7399, Level 16, State 1, Line 1
OLE DB Provider MSDAORA reported an error.
[OLE/DB provider returned message: Oracle error occured but error message
could not be retrieved from Oracle.}
OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize
returned 0x80004005:].
However using the Oracle client on the server I can still connect to any
Oracle instance but I have to stop and start the sql service to get the
linked server to work again, becuase I have to stop and start sql server I'm
presuming that the fault is with sql server.
Did you check out that article before ?
HOW TO: Set Up and Troubleshoot a Linked Server to Oracle in SQL Server
http://support.microsoft.com/dXefaul...en-us;Q280X106
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Chris@.CambridgeUK" <Chris@.CambridgeUK@.discussions.microsoft.com> schrieb im
Newsbeitrag news:0BE21B83-BA02-4C0D-AA57-573AD76C3FB5@.microsoft.com...
> Hello,
> sql server 2000 cluster patched to SP3 and NT5 patched to SP4.
> Oracle 9i client installed.
> We have set up a linked server to an Oracle instance using the 'Microsoft
> OLE DB Provider for Oracle', this works for a while without any problems
> and
> then for an unknown reason ceases to work.
> The only error messages I have been able to get is by running the t-sql
> query
> SELECT * FROM LINKSERV..SCHEMA.TABLE which returns
> Server:Msg 7399, Level 16, State 1, Line 1
> OLE DB Provider MSDAORA reported an error.
> [OLE/DB provider returned message: Oracle error occured but error message
> could not be retrieved from Oracle.}
> OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize
> returned 0x80004005:].
> However using the Oracle client on the server I can still connect to any
> Oracle instance but I have to stop and start the sql service to get the
> linked server to work again, becuase I have to stop and start sql server
> I'm
> presuming that the fault is with sql server.
>
>
|||Yes, I've seen this document and it has been of help to me before but not in
this case as the linked server works and then stops without notice
"Jens Sü?meyer" wrote:

> Did you check out that article before ?
> HOW TO: Set Up and Troubleshoot a Linked Server to Oracle in SQL Server
> http://support.microsoft.com/dXefau...n-us;Q280X106
>
>
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "Chris@.CambridgeUK" <Chris@.CambridgeUK@.discussions.microsoft.com> schrieb im
> Newsbeitrag news:0BE21B83-BA02-4C0D-AA57-573AD76C3FB5@.microsoft.com...
>
>

Oracle linked server error

Hello,
sql server 2000 cluster patched to SP3 and NT5 patched to SP4.
Oracle 9i client installed.
We have set up a linked server to an Oracle instance using the 'Microsoft
OLE DB Provider for Oracle', this works for a while without any problems and
then for an unknown reason ceases to work.
The only error messages I have been able to get is by running the t-sql quer
y
SELECT * FROM LINKSERV..SCHEMA.TABLE which returns
Server:Msg 7399, Level 16, State 1, Line 1
OLE DB Provider MSDAORA reported an error.
[OLE/DB provider returned message: Oracle error occured but error messag
e
could not be retrieved from Oracle.}
OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize
returned 0x80004005:].
However using the Oracle client on the server I can still connect to any
Oracle instance but I have to stop and start the sql service to get the
linked server to work again, becuase I have to stop and start sql server I'm
presuming that the fault is with sql server.Did you check out that article before ?
HOW TO: Set Up and Troubleshoot a Linked Server to Oracle in SQL Server
http://support.microsoft.com/d_efau...;en-us;Q280_106
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Chris@.CambridgeUK" <Chris@.CambridgeUK@.discussions.microsoft.com> schrieb im
Newsbeitrag news:0BE21B83-BA02-4C0D-AA57-573AD76C3FB5@.microsoft.com...
> Hello,
> sql server 2000 cluster patched to SP3 and NT5 patched to SP4.
> Oracle 9i client installed.
> We have set up a linked server to an Oracle instance using the 'Microsoft
> OLE DB Provider for Oracle', this works for a while without any problems
> and
> then for an unknown reason ceases to work.
> The only error messages I have been able to get is by running the t-sql
> query
> SELECT * FROM LINKSERV..SCHEMA.TABLE which returns
> Server:Msg 7399, Level 16, State 1, Line 1
> OLE DB Provider MSDAORA reported an error.
> [OLE/DB provider returned message: Oracle error occured but error mess
age
> could not be retrieved from Oracle.}
> OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initializ
e
> returned 0x80004005:].
> However using the Oracle client on the server I can still connect to any
> Oracle instance but I have to stop and start the sql service to get the
> linked server to work again, becuase I have to stop and start sql server
> I'm
> presuming that the fault is with sql server.
>
>|||Yes, I've seen this document and it has been of help to me before but not in
this case as the linked server works and then stops without notice
"Jens Sü?meyer" wrote:

> Did you check out that article before ?
> HOW TO: Set Up and Troubleshoot a Linked Server to Oracle in SQL Server
> http://support.microsoft.com/d_efa...en-us;Q280_106
>
>
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "Chris@.CambridgeUK" <Chris@.CambridgeUK@.discussions.microsoft.com> schrieb
im
> Newsbeitrag news:0BE21B83-BA02-4C0D-AA57-573AD76C3FB5@.microsoft.com...
>
>

Oracle linked server (64-bit)

We have an active-active cluster on two 64-bit servers, with an
instance of SQL Server running on each node.
We installed the 64-bit oracle client and it works just fine using
Oracle's "SQL Plus" app. But when we add it as a linked server in SQL
Server, it hangs when we try to access it, whether in the Enterprise
Manager or executing "sp_catalogs". It then kicks us off and the node
has to be rebooted for all the services and groups to come back online
properly.
we have a linked server to Oracle on another 64-bit Sql Server (not
clustered) which works just fine for us.
Has anyone seen this? Any helpful thoughts?
bryan
Make sure the provider is setup to execute in-process with SQL Server, by
default it is not since it is not a Microsoft provider, but the Oracle
provider does not work correctly out of process.
See http://support.microsoft.com/default...B;EN-US;280106
NOTE : If you use a third-party Oracle provider and it is incapable of
running outside of a SQL Server process, allow it to run in-process by
changing the provider options. To change the provider options, change the
value of the AllowInProcess (DWORD) entry in the following registry key,
which is located under the corresponding provider name, to 1:
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright SQLDev.Net 1991-2004 All rights reserved.
"bk" <r.bryan.kane@.gmail.com> wrote in message
news:1102633081.687411.319750@.f14g2000cwb.googlegr oups.com...
> We have an active-active cluster on two 64-bit servers, with an
> instance of SQL Server running on each node.
> We installed the 64-bit oracle client and it works just fine using
> Oracle's "SQL Plus" app. But when we add it as a linked server in SQL
> Server, it hangs when we try to access it, whether in the Enterprise
> Manager or executing "sp_catalogs". It then kicks us off and the node
> has to be rebooted for all the services and groups to come back online
> properly.
> we have a linked server to Oracle on another 64-bit Sql Server (not
> clustered) which works just fine for us.
> Has anyone seen this? Any helpful thoughts?
> bryan
>

Saturday, February 25, 2012

Oracle Linked Server

Hi,
I have an Oracle 9i client installed on SQL Server 2000, and I want to add a
linked Oracle server to SQL Server, I got an error says 'OLEDB error, OLEDB
error trace: initialize returned 0x80004005', and I can not view the tables
or views in the Oracle lin
ked server, can anybody help me on this?
HongHi
0x80004005 is usually a general error, have you checked the connection
string?
http://www.connectionstrings.com/
John
"Hong Wang" <anonymous@.discussions.microsoft.com> wrote in message
news:8AB9BCEB-F6C5-4AD6-ACA2-0A3C0A8890CC@.microsoft.com...
> Hi,
> I have an Oracle 9i client installed on SQL Server 2000, and I want to add
a linked Oracle server to SQL Server, I got an error says 'OLEDB error,
OLEDB error trace: initialize returned 0x80004005', and I can not view the
tables or views in the Oracle linked server, can anybody help me on this?
> Hong|||Try turning on trace flag 7300 on or use SQL Profiler to capture the
OLEDB Errors event. This should allow you to get more information
about the error.
For additional info, you may want to refer to the following:
HOW TO: Set Up and Troubleshoot a Linked Server to Oracle in SQL
Server
http://support.microsoft.com/?id=280106
-Sue
On Wed, 2 Jun 2004 13:01:08 -0700, Hong Wang
<anonymous@.discussions.microsoft.com> wrote:

>Hi,
>I have an Oracle 9i client installed on SQL Server 2000, and I want to add a linked
Oracle server to SQL Server, I got an error says 'OLEDB error, OLEDB error trace: i
nitialize returned 0x80004005', and I can not view the tables or views in the Oracle
li
nked server, can anybody help me on this?
>Hong

Oracle Datasource with sql express version

Hi,
do you know if it's possible to connect Reporting Services, installed
with the sql express version, to an oracle datasource.
The oracle server is on the same machine.
This work fine in dev environnement but the deployment failed with this
message: "provider is not registered on the local machine".
Thank'sI don't think so. I think the express version is for reporting against
express data.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<amfred@.gmail.com> wrote in message
news:1156321685.686065.70410@.m73g2000cwd.googlegroups.com...
> Hi,
> do you know if it's possible to connect Reporting Services, installed
> with the sql express version, to an oracle datasource.
> The oracle server is on the same machine.
> This work fine in dev environnement but the deployment failed with this
> message: "provider is not registered on the local machine".
> Thank's
>

Monday, February 20, 2012

Oracle 9i Client on SQL Server 2000 Ent.

I installed Oracle 9i client on a SQL Server 2000
Enterprise Edition server with Windows 2000 Advanced
Server operating system. Next, I opened the linked server
and lastly I tried to open the Microsoft OLE DB Provider
for SQL Server which caused the server to hang and had to
be rebooted.
Please help me with what could cause this problem?
Thank You,
MikeHonestly I don't know the answer, so I can just throw some
ideas:
I assume it was working fine before you installed the
Oracle 9i client. Just a crazy though, try to reboot your
server couple times and see if that fixes the problem.
If it still doesn't work then remove the Oracle 9i client
and see what happens.
hth.
>--Original Message--
>I installed Oracle 9i client on a SQL Server 2000
>Enterprise Edition server with Windows 2000 Advanced
>Server operating system. Next, I opened the linked
server
>and lastly I tried to open the Microsoft OLE DB Provider
>for SQL Server which caused the server to hang and had to
>be rebooted.
>Please help me with what could cause this problem?
>Thank You,
>Mike
>.
>

Monday, March 19, 2012

Oracle XE

Oracle with Crystal: "Failed to Load Database Information"

Monday, March 12, 2012

Oracle report returning strange data

Friday, March 9, 2012

Oracle OLEDB in SSIS - problem with 64bit

Oracle odbc driver on windows 2003 64 bit, SQL Server 2005

Oracle odbc driver on windows 2003 64 bit, SQL Server 2005

Oracle odbc driver on windows 2003 64 bit, SQL Server 2005

Oracle odbc driver on windows 2003 64 bit, SQL Server 2005

Wednesday, March 7, 2012

Oracle odbc driver on windows 2003 64 bit, SQL Server 2005

Oracle odbc driver on windows 2003 64 bit, SQL Server 2005

Oracle not supported?

Oracle Linked Server on Windows 2003

Oracle Linked Server on SQL Server 2005 64-bit

Oracle Linked Server on SQL Server 2005 64-bit

Oracle linked server error

Oracle linked server error

Oracle linked server (64-bit)

Saturday, February 25, 2012

Oracle Linked Server

Oracle Datasource with sql express version

Monday, February 20, 2012

Oracle 9i Client on SQL Server 2000 Ent.

Oracle DBA to learn MS SQL

Blog Archive

About Me