Connecting to Oracle Database within SQL Server 2005

FAQ

Profile

Connecting to Oracle Database within SQL Server 2005

Database Help (Home) -> Programming

Next: help for a complex query

Author

Message

Ky_fanatic

External

Since: Feb 03, 2008
Posts: 1

(Msg. 1) Posted: Sun Feb 03, 2008 6:31 am Post subject: Connecting to Oracle Database within SQL Server 2005 Archived from groups: microsoft>public>sqlserver>programming (more info?)

I have a Oracle Legacy 8.1.6 DB I am trying to connect to via SQL Server 2005. My SQL server is a 64 bit machine. I have successfully connected to the database via System DSN Connection using Oracle OLE connection. I have tried the following other drivers to connect to my Oracle db ORA92 Driver Microsoft OLE Driver for Oracle I either get an ora-06413 or ORA-12514 error. I believe my issue may be caused by SQL Server being installed in the Program Files (x86) folder. I have read many articles saying this causes issues. I have tried to implement all the suggestions but I have gotten no resolution. Does anyone have any ideas? Thanks >> Stay informed about: Connecting to Oracle Database within SQL Server 2005

Display posts from previous:

Related Topics:

Job hanging when connecting to Oracle - We have a job that has multiple DTS packages and the first 3 connect to Oracle via ODBC. The final 3 packages do their work strictly on SQL Servers. The packages that connect to Oracle are pulling data from Oracle into SQL Server using data pump tasks,...

Database Restore Problem SQL Server 2005 - Hi OS Windows server 2003 SP1 SQL Server 2005 Slandered Edition We try to restore the backup from the bak file and it is giving the following message System.Data.SqlClient.SqlError : Restore Detected an error on page (0:0) in database "Database...

Adding new row to SQL Server 2005 database - I am new to SQL Server 2005. I have a large database table, and I want to add new rows (records) to the table from within a C# program. The simplest method would seem to be using a T-SQL INSERT command, but T-SQL does not accept variables as input..

query for inventory of database information fom master on .. - HI, is it possible to write a query to get the following information for all user defined databases on a given instance of sql server 2005? db size, log / data files , recovery mode, coalition, compatibility level, number of log / data files. ....

problem connecting to SQL Server 2000 - Hi, I try through C# (.NET) to connect to a database. I registered earlier a server and then I deleted the registration. Then I registered another one and I am able to see in the SQL Server Enterprise Manager my tables. When in .NET I try to connect to...

	Database Help (Home) -> Programming	All times are: Pacific Time (US & Canada)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum