Re: ADO connection to Oracle

From: Ryszard Gawron [MS] (rysiekg_at_hotmail.com)
Date: 07/19/04 

Date: Mon, 19 Jul 2004 16:29:16 +0200

Hello Frank,
did you install mdac 2.7 on the machine?

best regards

Ryszard Gawron
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no
rights.

"Frank Maxey" <fdmaxey@yahoo.com> wrote in message
news:12e3e52d.0407190511.29a0b1ae@posting.google.com...
> I have encountered a serious problem trying to deploy an application
> in VB.net that accesses an Oracle database.
>
> When I run the application on any system that has the VS.Net
> development system, everything works fine. Whenever I try to deploy
> the runtime version, however, the program terminates with no error
> message.
>
> The program always stops at the connection to the database. The
> connection is made using generic OLE DB, not the Oracle data provider.
>
> The following method is used to deploy the runtime version:
>
> - Dotnetfx.exe is run to install the .NET framework.
>
> - Oracle Client 9.2 is installed to connect to the database
>
> - Oracle Provider for OLD DB is then installed.
>
> The deployment has been tried with two Win2000 machines, one with a
> previous version of Oracle Client, the other with no installation of
> Oracle.
>
> If I construct a UDL file and specify the target database, the
> connection is tested successfully. On the machine with SQL, a
> connection can also be made.
>
> The OleDB.OleDBConnection.Open call is made within a Try.Catch
> structure. The connection string points to the UDL file. As I said,
> the program terminates with no exception being thrown and no error
> message.
>
> At this point I don't have a clue. I've looked for some post that
> mentions this problem but have not found any.
>
> Should I just switch from the generic OleDB library to the Oracle data
> provider? I'll do this if I have to, but I would like to retain
> flexibility, as this software might be used for other databases.
>
> Right now I'm completely stopped.
>
> TIA.
>
> Frank Maxey
> fdmaxey@yahoo.com

Relevant Pages

  • RE: ADO.Net Connection Pooling Problem with Oracle
    ... the CLR is releasing the connection to your database. ... the number of database sessions in Oracle seem to ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Connecting to an Oracle Database
    ... You can also use FrontPage, ... Click Add to Catalog under "Database Connections" ... Put in your Oracle connection string in the custom connections dialog ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: AIX 4.3.3 , Oracle 7.3.4 coredumps at startup
    ... I cannot port the database to Oracle 8 or later since the app ... > the apps that are now reserved words in Oracle 8 and later. ... Put away your installation media and forget a new install for the moment. ...
    (comp.unix.aix)
  • Re: how to activate oracle text in 10g enterprise
    ... general purpose database, or if he wanted to study otext, and was ... 'Oracle Text' option from the DBCA screen. ... If you experienced oracle warnings and errors during the install ...
    (comp.databases.oracle.server)
  • RE: Query Oracle, show results (need help!!)
    ... After the DB connection, put this... ... I am trying to log into an Oracle database, ... Prepare the SQL statement for running and it'll be stored in Oracle buffer ...
    (perl.beginners)