Urgent!!!! Connect Timeout For OleDB (OraOLEDB.Oracle)
419272Apr 15 2004 — edited Apr 16 2004Hi,
I'm trying to connect oralce db 8ix from asp.net (vb.net) with connection string as
"Provider=OraOLEDB.Oracle; Oledb.Net=true; PLSQLRSet=true; User ID=xxx; Password=xxx;PwdChgDlg = 1;"
But, when I try to connect using EXPIRED user, my connection.open hangs. It is not returning any error code or poping window for password change.
How to overcome this problem ?
Is there a timeout property available for OraOLEDB.Oracle provider.(eg. connect time=10 for all microsoft providers)
Please help.
Thanks
Mahesh