473,242 Members | 2,161 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,242 software developers and data experts.

Can't connect to Oracle Dbase with SQL Server 2005 Express

Hi,

I'm attempting to connect to an Oracle database using SQL Server 2005
Express (OS is Windows XP Professional) and having absolutely no luck.
Here is the information SQL Plus
gives me about the database when I log in -

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production

As you can see I have no problem connecting with the Oracle specific
tools (SQL PLUS and PL/SQL Developer).

I've tried creating a linked server with both the Microsoft provided
OLE DB provider and the Oracle provider. With the Microsoft Provider I
get the following error when attempting a query in the query edit
window.

OLE DB provider "MSDAORA" for linked server "ORACLE" returned message
"Oracle client and networking components were not found. These
components are supplied by Oracle Corporation and are part of the
Oracle Version 7.3.3 or later client software installation.
Provider is unable to function until these components are installed.".
Msg 7303, Level 16, State 1, Line 2
Cannot initialize the data source object of OLE DB provider "MSDAORA"
for linked server "ORACLE".

When I try connecting withe Oracle provider I get the following -

OLE DB provider "OraOLEDB.Oracle" for linked server "ORACLETEST2"
returned message "ORA-01017: invalid username/password; logon denied".
Msg 7303, Level 16, State 1, Line 2
Cannot initialize the data source object of OLE DB provider
"OraOLEDB.Oracle" for linked server "ORACLETEST2".

I've set the password up as a local to remote login mapping using the
security page of the Linked Server property dialog. The username /
password are definitely correct -- I used them to log in using SQL PLUS
and PL/SQL Developer. I'm using an Oracle 9 client.

PLEASE HELP !!!!!

Thanks,

Signed Frustrated

Dec 15 '05 #1
8 14341
da******@hotmail.com wrote:
Hi,

I'm attempting to connect to an Oracle database using SQL Server 2005
Express (OS is Windows XP Professional) and having absolutely no luck.
Does the phrase "going from the sublime to the ridiculous" have any
meaning for you :-)
OLE DB provider "MSDAORA" for linked server "ORACLE" returned message
"Oracle client and networking components were not found. These
components are supplied by Oracle Corporation and are part of the
Oracle Version 7.3.3 or later client software installation.".
Is this on the same machine that Oracle is installed on ? Then it's
likely that you haven't installed the required client software. The
SQLPlus connections don't necessarily go through the network layer if
you are doing them on the same box.
When I try connecting withe Oracle provider I get the following -

OLE DB provider "OraOLEDB.Oracle" for linked server "ORACLETEST2"
returned message "ORA-01017: invalid username/password; logon denied".
Msg 7303, Level 16, State 1, Line 2
Cool - This shows that the Oracle provider is connecting to the Oracle
database - that error message comes from the database itself.
I've set the password up as a local to remote login mapping using the
security page of the Linked Server property dialog. The username /
password are definitely correct


Nope - the username/password being provided to the Oracle database are
definitely NOT correct. I have no idea what "local to remote mapping
using the security page of the Linked Server property dialog" actually
means, so can't help there, but I'm guessing that's the problem.

As an aside, why SQL Server Express ? If you download Oracle Database
Express Edition and use that to connect to the backend Oracle database,
you may find life a little easier, a lot less sublime, and definitely
not as ridiculous -
http://www.oracle.com/technology/pro.../xe/index.html
Dec 16 '05 #2
Hi Mark,

I figured mabye my problem could be solved by upgrading the version of
Oracle so I installed Oracle 10.1 on Friday and had success with the
Microsoft Oracle OLEDB provider -- not so with the Oracle provider, but
rather than wasting a bunch of time figuring out why I couldn't connect
with that I figured the MS Oracle DB provider would fill my needs.
However this morning I attempted to once again connect via SQL Server
Express figuring and had gotten over the hurdle and I got a new error
-- OLE DB provider "MSDAORA" for linked server "MSORACLE" returned
message "Oracle error occurred, but error message could not be
retrieved from Oracle.". And again I can connect to this database fine
using PL/SQL Developer. So once again I'm back to square one and
totally perplexed. Any idea how
to retrieve the Oracle messages?

As to why I'm using SQL Server Express -- I am doing an MS Excel
automation project, so I'm not quite sure that Oracle is an option on
the client side. Also the backend is not on my machine -- I actually
have no idea where it is, except that I know it's some huge (6
Terabyte) database server somewhere.

By "Local to remote mapping" I'm referring to the selection on SQL
Server Express' Security Property Page (right click on Properties for
the linked server, then click on the Security selection in left pane of
the dialog box that appears). It appears to allow you to enter a user
and password combination that will be used to attach to the linked
server.

Thanks again

Dec 19 '05 #3
Crazy Cat wrote:
Hi Mark,

I figured mabye my problem could be solved by upgrading the version of
Oracle so I installed Oracle 10.1 on Friday and had success with the
Microsoft Oracle OLEDB provider -- not so with the Oracle provider, but
rather than wasting a bunch of time figuring out why I couldn't connect
with that I figured the MS Oracle DB provider would fill my needs.
However this morning I attempted to once again connect via SQL Server
Express figuring and had gotten over the hurdle and I got a new error
-- OLE DB provider "MSDAORA" for linked server "MSORACLE" returned
message "Oracle error occurred, but error message could not be
retrieved from Oracle.". And again I can connect to this database fine
using PL/SQL Developer. So once again I'm back to square one and
totally perplexed. Any idea how
to retrieve the Oracle messages?

As to why I'm using SQL Server Express -- I am doing an MS Excel
automation project, so I'm not quite sure that Oracle is an option on
the client side. Also the backend is not on my machine -- I actually
have no idea where it is, except that I know it's some huge (6
Terabyte) database server somewhere.

By "Local to remote mapping" I'm referring to the selection on SQL
Server Express' Security Property Page (right click on Properties for
the linked server, then click on the Security selection in left pane of
the dialog box that appears). It appears to allow you to enter a user
and password combination that will be used to attach to the linked
server.

Thanks again


If you are in the United States you might want to take a good look at
the requirements of Sarbanes Oxley and your probable violation by
using MS Excel.

If you have something to do with Oracle data you might want to just
leave it in the Oracle database and create your reports directly from
that repository.
--
Daniel A. Morgan
http://www.psoug.org
da******@x.washington.edu
(replace x with u to respond)
Dec 19 '05 #4
Please elaborate on Sarbanes Oxley -- I looked it up but not sure how
it applies to me (software developer). Isn't that
targeted at accountants? My function and the project I'm working on
have nothing to do with accounting -- it's an engineering
function.

I found a solution to my problem with the Oracle OLE DB provider and am
providing a link to the solution for all interested

http://msdn2.microsoft.com/en-us/library/ms152516.aspx

Hope this helps any out there having similar problems.

Thanks

Dec 19 '05 #5
Crazy Cat wrote:
Please elaborate on Sarbanes Oxley -- I looked it up but not sure how
it applies to me (software developer). Isn't that
targeted at accountants? My function and the project I'm working on
have nothing to do with accounting -- it's an engineering
function.

I found a solution to my problem with the Oracle OLE DB provider and am
providing a link to the solution for all interested

http://msdn2.microsoft.com/en-us/library/ms152516.aspx

Hope this helps any out there having similar problems.

Thanks


If you are working in Excel then it stands to reason you are working
with numbers: Accounting related information.

If those numbers are not constrained so that each every alteration is
auditable and numbers are then used for financial decisions or financial
statements you are in potential violation.

You as a developer are not in violation. But the result of your work
likely will be.
--
Daniel A. Morgan
http://www.psoug.org
da******@x.washington.edu
(replace x with u to respond)
Dec 19 '05 #6
On Mon, 19 Dec 2005 09:35:08 -0800, Crazy Cat wrote:
Please elaborate on Sarbanes Oxley -- I looked it up but not sure how
it applies to me (software developer). Isn't that
targeted at accountants? My function and the project I'm working on
have nothing to do with accounting -- it's an engineering
function.


Sarb-Ox is a legal device for enforcing accountability, not accounting.

Basically it means that there must be a verifiable audit trail (just like
ISO-900x) for any operation that *may* impact the financial status of the
organization. This includes any data manipulation using any database
and/or programming tools.

(To counter Enron, everything must be verifiably unschreddable, or
verifiably have no impact on the org's financials.)

It also means that the CEO is personally on the hook for ensuring the
compliance, at risk of a jail term and huge fines. Since CEOs delegate
responsibility, that means that everyone down the corporate ladder may
directly or indirectly be in the path of the delegation.

The succeess of your project and the pay or consulting fees of the
team on your project are expected to have a long-term impact on the
corporate financials. Therefore Sarb Ox applies.

(Heck, in a small organization the refund from recycling pop (soda) cans
from the company-supplied Coke machine could be considered having an
impact - there is no end to how silly the interpretation can become.)

--
Hans Forbrich
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com
*** Top posting [replies] guarantees I won't respond. ***

Dec 19 '05 #7

am working in .net with oracle 10g

while am going to connect database am getting this error

please help me

Oracle client and networking components were not found. These components
are supplied by Oracle Corporation and are part of the Oracle Version
7.3.3 or later client software installation. Provider is unable to
function until these components are installed.

*** Sent via Developersdex http://www.developersdex.com ***
Aug 1 '06 #8
krishna mohan wrote:
am working in .net with oracle 10g

while am going to connect database am getting this error

please help me

Oracle client and networking components were not found. These components
are supplied by Oracle Corporation and are part of the Oracle Version
7.3.3 or later client software installation. Provider is unable to
function until these components are installed.

*** Sent via Developersdex http://www.developersdex.com ***
The above message is not an Oracle message. Use the Oracle
provided .NET components.
--
Daniel A. Morgan
University of Washington
da******@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Aug 1 '06 #9

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Zorba.GR | last post by:
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager...
3
by: Dave F. | last post by:
I am using ODBC to connect to dBase data on a remote server. The ASP.NET app will be running on Win 2k or 2003 server. I have tried to make it work but all I can get is an error. ...
8
by: Crazy Cat | last post by:
Hi, When I click on the properties of a linked server, all the General properties are read - only, which means that if I want to edit any general properties I have to delete the linked server...
14
by: Marcus | last post by:
I have a function that simply returns TRUE if it can connect to a particular Sql Server 2005 express, or FALSE if it cannot. I am getting some strange error codes returned when the computer that...
0
by: Larry Rebich | last post by:
I am trying to use the sample web template that is distributed with Visual Studio 2005 called 'Personal Web Site Starter Kit'. After running for awhile it fails with the following message: ...
5
by: Jack | last post by:
Hello, I had SQL2000 server running fine on the windows 2003 box. I then installed SQL 2005 Express. They both worked together fine. I then uninstalled SQL 2005 Express and installed SQL 2005...
9
by: Gabriel | last post by:
Hello, I installed SQL server 2005 SP1 on a Windows XP SP2 From Visual Studio, I'm trygin to create a connection to a database, but I receive this error but I'm creating the connection (I...
3
by: LamSoft | last post by:
I am not going to write a aspx to connect a SQL Server... but it tries to connect the SQL Server... Some of the Code.. protected void LoginButton_Click(object sender, EventArgs e) { if...
7
by: RN1 | last post by:
Is it possible to connect to my local SQL Server 2005 database from a remote web server? If yes, what ConnectionString do I use? Thanks, Ron
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.