OleDB Connection hangs with no error
Hi,
I am trying to execute the following statement on a citrix server, connecting to an Oracle database:
OleDbConnection con = new OleDbConnection();
con.connectionstring = "blah blah blah";
con.open;
Please note this is not exact syntax and this code does work on my local development computer. However when I run the compiled executable on a Citrix server it freezes at the con.open line. It doesn't error or anything just hangs. Anybody got any ideas? I have created loads of test UDL files, etc.. and dsn's and stuff and it would appear that the DLL's for connecting to the database are functioning correctly. I am really stuck and would appreciate some help.
Thanks guys,
DJ
Re: OleDB Connection hangs with no error
I'm not sure that OleDb wouldn't work, but the .NET Framework has the System.Data.OracleClient namespace specifically for interfacing with Oracle. I suggest you switch to that and see if you still get the same error. The connection string would be different I would imagine so it may take into account something that OleDb is not.
Re: OleDB Connection hangs with no error
Hi,
I would love to be able to use the direct oracle namespace however that only came in for the .net framework 1.1 and unfortunately my company will not pay to upgrade me from 1.0!!!
Thanks anyway,
DJ
Re: OleDB Connection hangs with no error
Sorry, didn't realise it was a new addition. :cry:
Re: OleDB Connection hangs with no error
Quote:
Originally Posted by DJ_Catboy
Hi,
I would love to be able to use the direct oracle namespace however that only came in for the .net framework 1.1 and unfortunately my company will not pay to upgrade me from 1.0!!!
Thanks anyway,
DJ
You could download the .NET library from Oracle Homepage if you want to give it try. I cant tell you if it fixes your problem, but it might be worth a try.
http://www.oracle.com/technology/tec...net/index.html
Stephan
Re: OleDB Connection hangs with no error
Thanks - am downloading now... will let you know.