Hi Greg, The error occurs as soon as I Open() the connection. I do have multiple homes, but the home selector is pointed to the correct one, the 817 version. But yes, the 817 version is installed in the ora92 dir, strange? I've tried the permissions test, and
that still didn't work. And no, I can't even create an oledb connection when i try to add and test a Data Connection from Visual Studio. I appreciate your help.
Public Function GetConnection() As System.Data.IDbConnection
Dim objConnect As System.Data.IDbConnection
Select Case p_strDatabaseType
Case "SQLServer"
objConnect = New System.Data.SqlClient.SqlConnection(p_strDSN)
Case "Oracle"
objConnect = New System.Data.OleDb.OleDbConnection(p_strDSN)
Case "Netezza"
objConnect = New Microsoft.Data.Odbc.OdbcConnection(p_strDSN)
Case Else
Err.Raise(InvalidDatabaseType, Me, "An invalid database type of " & p_strDatabaseType & " was encountered. Please check your database settings.")
End Select
objConnect.Open()
Return objConnect
End Function
goofsr
Member
70 Points
14 Posts
Re: Oracle error occurred, but error message could not be retrieved from Oracle.
Aug 26, 2003 08:51 PM|LINK
Public Function GetConnection() As System.Data.IDbConnection Dim objConnect As System.Data.IDbConnection Select Case p_strDatabaseType Case "SQLServer" objConnect = New System.Data.SqlClient.SqlConnection(p_strDSN) Case "Oracle" objConnect = New System.Data.OleDb.OleDbConnection(p_strDSN) Case "Netezza" objConnect = New Microsoft.Data.Odbc.OdbcConnection(p_strDSN) Case Else Err.Raise(InvalidDatabaseType, Me, "An invalid database type of " & p_strDatabaseType & " was encountered. Please check your database settings.") End Select objConnect.Open() Return objConnect End Function