ODBC Locks Application

This is a discussion on ODBC Locks Application within the ODBC forums in Framework and Interface Programming category; In the following code segments if conORCALE is set to strDIRECT the recordset opens OK. If it is set to strODBC the application locks up. Anyone got any ideas? ' Direct connection Public Const strDIRECT = "Provider=MSDAORA.1;Password=" & ORA_PSWD & ";User ID=" & ORA_USER & ";Data Source=" & ORA_SRVC & ";Persist Security Info=true" ' ODBC Connection Public Const strODBC = "Provider=MSDASQL.1;Password=" & ORA_PSWD & ";User ID=" & ORA_USER & ";Data Source=" & ODBC & ";Persist Security Info=true" ' ... With RS .ActiveConnection = conORACLE .CursorType = adOpenKeyset .LockType = adLockOptimistic .CursorLocation = adUseServer .Open strSQL End With...