Re: .NET Application - Unhandled Exception

Sorry, I thought that would be all you needed to know. The application is written to syncronise the data between two databases, an Oracle server and a MS SQL server. The application connects to Oracle to check a table populated by triggers, the application then runs a query to get the data and updates the SQL server.

I believe the problem is with connecting to the database from the computer due to the error, so I would have thought what I wrote would have been enough to get the information I was after.

The Oracle server is 10g, but wouldn't the solution work for all versions? I'm new to Oracle and have learnt everything I know in the past month or two, I haven't had the thousands of pounds worth of training so I don't know.

sybrandb wrote:
> On Jan 22, 12:56 pm, a..._at_areasix.co.uk wrote:
> > Hey all,
> >
> > I'm having a bit of trouble with my .NET application - I have built an
> > application to read data from an Oracle database and then write to a MS
> > SQL database.
> >
> > The application runs fine on the development machine, but when I
> > release and try the application on the MS SQL Server machine (where the
> > syncronisation will take place), I get an Unhandled Exception
> > (System.TypeInitializationException) Error.
> >
> > When I debug it throws me back the following error:
> > The type initializer for "Oracle.DataAccess.Client.OracleConnection"
> > threw an exception.
> >
> > Does anyone have any ideas as to why this is happening? Could it be
> > because a reference to the Oracle server/service hasn't been set up on
> > the server machine?
> >
> > Thanks in advance
>
>
> I wouldn't even try to reinvent Oracle's Hetergeneous Gateway or
> Microsoft DTS.
> Why writing your own application?
> Why posting a question without any detail on versions involved or the
> actual code?
> This is a volunteer forum, it is expected you do at least *something*
> to resolve your own problems, instead of just *dumping* them without
> providing the correct crystal ball.
>
> --
> Sybrand Bakker
> Senior Oracle DBA
Received on Tue Jan 23 2007 - 03:00:40 CST