OleDB Connection hangs with no error

[DJ_Catboy]

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

[jmcilhinney]

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.

[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

[jmcilhinney]

Sorry, didn't realise it was a new addition.

[Sgt-Peppa]

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

[DJ_Catboy]

Thanks - am downloading now... will let you know.