Re: 'Registering' ADO Dlls

"Steve Zimmelman" <skz@xxxxxxxxxxxxxxxxxx> wrote in message
news:46519a59@xxxxxxxxxxxxxxxxxxxxxxxxx
If the Installation didn't do that automatically, then you need to use
RegSvr32.exe to register the DLL's.

Run: RegSvr32.exe \somepath\some.dll

You should be able to build a connection string for the ADO connection if
you know what the provider is.

I haven't installed oracle drivers, but I have a "Microsoft OLE DB
Provider for Oracle" in my list. (I'm using D2006)

DON'T use the MS driver. It has been obsolete for many years. When you
install the Oracle client, choose the 'Custom' option and make sure you have
something like ""Oracle Windows Interfaces ..." checked. This is where the
OLEDB driver is. You'll get this automatically with an admin client install
but it's more than most people need. The "Runtime client" doesn't include
the OLEDB driver. All of this applies to 9i. I'm not sure how this might
have chaneged in 10g, if at all.

HTH,
- Arnie


.

Relevant Pages

  • Re: ORACLE CLIENT USERS BEWARE: Bug in Query Builder breaks SQL
    ... Comparing the Microsoft .NET Framework 1.1 Data Provider for Oracle ... When trying to use the Query Builder with Oracle, ...
    (microsoft.public.vsnet.general)
  • Re: Oracle Database Access via IIS 6.0 ASP Pages on Windows 2003 S
    ... >Oracle 10g Client is installed on the Windows Server. ... >This is my standard DSN Less connection. ... >Microsoft OLE DB Provider for ODBC Drivers error '80004005' ...
    (microsoft.public.inetserver.iis)
  • Re: Cant get Oracle OLE DB provider to work from SSIS on a 64-bit environment
    ... The project I'm trying to get running, consists of approx 25 seperate packages where 3-4 of them gets data from different Oracle sources, but I'm not even got to the point where I'm trying to run the whole lot. ... There are two issues in the topic that could be an issue, and that is to switch the whole project to 32-bit mode and then the part that says that the Designer only shows 32-bit versions of the provider. ... What I think I'll try now, it to install the 32-bit version of the Oracle ODAC to see if that makes any difference. ... uninstall ODAC and when I uninstall the regular Oracle Client with the ...
    (microsoft.public.sqlserver.dts)
  • Re: ORA-1866 The datetime class is invalid error...the saga continues!
    ... but you could try using a different data provider. ... Use the Microsoft ADO.NET Oracle Provider ... VB.NET to my employers and not being able to query data using a date field ... SQL statements I provided earlier will execute flawlessly in any enviornment ...
    (microsoft.public.dotnet.general)
  • Re: Data Provider for Oracle: MS version vs. Oracle?
    ... OK so this is how it works, you have a reader or any data object. ... provider will work also for Oracle (even if the native provider returns a ... As programming model you use the database abstraction layer data objects as ... and myCustomer is a Customer entity filled from Oracle using ODP.NET. ...
    (microsoft.public.dotnet.framework.adonet)