473,842 Members | 1,598 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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.Oracl e" for linked server "ORACLETEST 2"
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.Oracl e" for linked server "ORACLETEST 2".

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 14381
da******@hotmai l.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.Oracl e" for linked server "ORACLETEST 2"
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.wash ington.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.wash ington.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.wash ington.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
4552
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 Express Edition v1.3.2 Win, IBM Tivoli System Automation v1.2.0 Linux, IBM Tivoli Workload Scheduler Virtualized Data Centers v8.2 , other IBM Tivoli CDs, WEBSPHERE EVERYPLACE MOBILE PORTAL v5.0 - ALTIUM , other IBM WebSphere Business CDs...
3
6716
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. System.Data.Odbc.OdbcException: ERROR '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. ERROR Driver's SQLSetConnectAttr failed ERROR '(unknown)' is not...
8
15713
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 and recreate it. Needless to say this is a pain. Is this by design or some kind of bug? Is there a workaround? Thanks
14
7049
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 sql server resides on is not reachable. The error is different depending on the connection string that I use. If I use the following connection string: "server=192.1.1.1; Initial Catalog=master; uid=The_User; password=The_Password; Connect...
0
2620
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: ------------------------------------------ Server Error in '/PersonalWebSiteStarter' Application. -------------------------------------------------------------------------------- An error has occurred while establishing a connection to the server. ...
5
4235
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 Server. But when I open SQL Server Management Studio, I can only connect to the SQL 2000 engine. In the Object explorer, it says v8.0.2039 (which I think is SQL 2000 Server, because I can see the existing SQL 2000 databases). How can I get SQL...
9
2626
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 don't receive the database list in the dropdown) "An error has occured while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that
3
2764
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 (Request.Form == null || Request.Form == "") { Session = "LocalHost"; }
7
5950
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
9872
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9715
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10945
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10612
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
7858
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7038
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5696
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5885
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
3
3145
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.