A
Andrew McGregor
Hi,
I am trying to get a VB.NET application to connect to a local Oracle 9i Lite
database.
What is the correct form for a connect string?
cn = New
Microsoft.Data.Odbc.OdbcConnection("dsn=POLite;Trusted_Connection=yes;User
Id=SYSTEM;Password=MANAGER")
raises the following exception:
could not open oracle connection: Microsoft.Data.Odbc.OdbcException: ERROR
[S1000][POL-2200] failed to create mapped file
ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr
failed
ERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support
the version of the ODBC behaviour that the application requested (see
SQLSetEnvAttr)
at Microsoft.Data.Odbc.OdbcConnection.Open
I have also tried the following:
cn = New Microsoft.Data.Odbc.OdbcConnection("Driver={Oracle Lite 40 ODBC
Driver};DataBase=mobile;User Id=SYSTEM;Password=MANAGER;Persist Security
Info=False;DSN=POLite")
which provides a more serious failure:
OracleLiteTest.exe has encountered a problem and needs to be shut down.
and
could not open oracle connection: Microsoft.Data.Odbc.OdbcException:
ERROR - no error information available
at Microsoft.Data.Odbc.OdbcConnection.Open
Server Explorer displays some Data Connections, am I incorrectly mixing OLE
and ODBC?
Regards,
Andy
I am trying to get a VB.NET application to connect to a local Oracle 9i Lite
database.
What is the correct form for a connect string?
cn = New
Microsoft.Data.Odbc.OdbcConnection("dsn=POLite;Trusted_Connection=yes;User
Id=SYSTEM;Password=MANAGER")
raises the following exception:
could not open oracle connection: Microsoft.Data.Odbc.OdbcException: ERROR
[S1000][POL-2200] failed to create mapped file
ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr
failed
ERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support
the version of the ODBC behaviour that the application requested (see
SQLSetEnvAttr)
at Microsoft.Data.Odbc.OdbcConnection.Open
I have also tried the following:
cn = New Microsoft.Data.Odbc.OdbcConnection("Driver={Oracle Lite 40 ODBC
Driver};DataBase=mobile;User Id=SYSTEM;Password=MANAGER;Persist Security
Info=False;DSN=POLite")
which provides a more serious failure:
OracleLiteTest.exe has encountered a problem and needs to be shut down.
and
could not open oracle connection: Microsoft.Data.Odbc.OdbcException:
ERROR - no error information available
at Microsoft.Data.Odbc.OdbcConnection.Open
Server Explorer displays some Data Connections, am I incorrectly mixing OLE
and ODBC?
Regards,
Andy