4/13/2021 0 Comments Microsoft Odbc Driver Manager
I just now installed Oracle 9i client it is giving me this error.It worked fine with Oracle 8.0 client.
![]() ![]() Microsoft Odbc Manager Password Using SQLI can connect to the server with the same username,password using SQL PLUS editor. Microsoft Odbc Manager Driver For OracleOracleMy code looks like this for ADO Dim Conn As ADODB.Connection Dim AdoCmd As ADODB.Command Dim ORCLServerConnect As String ORCLServerConnect driverMicrosoft ODBC for Oracle; PWD backoffice; UID backoffice; server aeptest; With Conn.ConnectionString ORCLServerConnect.Open End With I get an error as: MicrosoftODBC driver for OracleOracle I dont really understand what is happening to my connection. It worked fine with Oracle 8i without any change in my code but now with 9i seems to be not working. It uses an Oracle driver, but you shaould have it with your client install. I know the function works, because I am using it:) Public cnConn as ADODB.Connection Public Function OpenConnOracle() As Boolean Dim strConn As String Connection string to open database OpenConnOracle True On Error GoTo ERRORFUNCTION If cnConn Is Nothing Then Set cnConn New ADODB.Connection If cnConn.State adStateClosed Then strConn ProviderOraOLEDB.Oracle. Persist Security InfoFalse; User IDbackoffice;Passwordbac koffice;Da ta Sourceaeptest With cnConn.CursorLocation adUseClient.Open strConn LogError OpenConnOracle, 0, Connection Opened. End With End If End If EXITFUNCTION: Exit Function ERRORFUNCTION: OpenConnOracle False LogError OpenConnOracle, Err.Number, Err.Description Err.Clear MsgBox OpenConnOracle error: Err.Number Err.Description GoTo EXITFUNCTION End Function. Anyway, the way MS suggests ( ), it should be: Conn UID;PWD; driverMicrosoft ODBC for Oracle;SERVERRonOracle; Just for testing try creating a DSN and use that.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |