Re: Trouble connecting to Oracle from C#

Tech-Archive recommends: Speed Up your PC by fixing your registry

Why not use the OracleClient .NET native provider?

--
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest books:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) and
Hitchhiker's Guide to SQL Server 2005 Compact Edition

-----------------------------------------------------------------------------------------------------------------------
<kimtherkelsen@xxxxxxxxx> wrote in message
news:1183493696.488011.6020@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,
I use the System.Data.OleDb.OleDbConnection class to establish a
connection to a Oracle 10G database.
The dsn connection string I use look like this:

dsn=provider="MSDAORA.1";User ID=test;Data Source="172.30.0.25/
JBOS";Password=test;

This works fine in Windows XP and Windows server 2003 but I have a
customer that try to connect to the database from a Windows 2000
machine and gets the following error:

ORA-06401: NETCMN: Invalid driver designator

I have tried to reproduce the error on a VMWARE Windows 2000 sp4
machine (that does not have a Oracle server or client installed) but
there it works after installing MDAC version 2.8. I am not able to
reproduce the error...

Do you have any idea what is wrong?

I include the the following DLL files with the code:
oraociei10.dll, oci.dll, oraocci10.dll, ociw32.dll, orannzsbb10.dll

Best regards,
Kim Therkelsen



.

Relevant Pages

  • Re: How to Create Local Temporary Table
    ... I have worked with both Oracle and SQL Server for some time and have grown to appreciate how much more mature Oracle is than SQL Server. ... When most think of scripting in Windows, they think of DOS command line scripting. ...
    (comp.databases.oracle.server)
  • Re: Schnittstelle MS SQL -> Oracle auf Itaium
    ... Unter Windows? ... Microsoft SQL Server Management Studio ... wir kommen ja nicht auf die Oracle DB ...
    (microsoft.public.de.sqlserver)
  • Re: SQL Server to Oracel
    ... > I got a new Job where I have to handle Oracle databases on Linux. ... > previous experience is with Sql Server on Windows NT. ... > How different is Oracle on Linux then Oracle on windows. ...
    (microsoft.public.sqlserver.server)
  • Re: The best elegant solution to override 65k rows limit in a sheet
    ... I'm so sorry that you work for a stupid company; SQL Server is WINNING ... This is important because IBM essentially loses its value proposition ... The separate options approach is required by Oracle because it is so ... on Windows to stem the growth of Microsoft SQL Server. ...
    (microsoft.public.excel)
  • Re: Slow booting xp home.
    ... Changing the boot order to boot first from your hard disk might save you a half second, but you won't be able to boot from a CD until you change it back - and the time spent to do that will erase any previous time saved. ... 2- Consider what software you really want to start with Windows and also how you've configured your applications at startup ... Installing and Registering Visual Studio Express Editions Smart Device ...
    (microsoft.public.windowsxp.perform_maintain)