Connecting to Oracle 9i Lite from VB.NET ODBC

[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;Tru sted_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

[Cor Ligthert]

Hi Andrew,

For Oracle related questions I advice you the newsgroup

Adonet
<news://msnews.microsoft.com/microsoft.public.dotnet.framework.adonet>

Web interface:
<http://communities2.microsoft.com/co...s/?dg=microsof
t.public.dotnet.framework.adonet>
I hope this helps a little bit?

Cor

[thomas wenning]

"Andrew McGregor" <an**@misk.co.uk> schrieb im Newsbeitrag
news:F9*******************@fe1.news.blueyonder.co. uk...

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;Tru sted_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")

Hi Andrew,

i hope this help's http://www.connectionstrings.com/

Greeting

Thomas

[Andrew McGregor]

"thomas wenning" <no*******************@gmx.de> wrote in message news:<uR**************@TK2MSFTNGP09.phx.gbl>...

"Andrew McGregor" <an**@misk.co.uk> schrieb im Newsbeitrag
news:F9*******************@fe1.news.blueyonder.co. uk...

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;Tru sted_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")

Hi Andrew,

i hope this help's http://www.connectionstrings.com/

Yes it does, thank you. It proves that my first attempt was correct,
and I should of trusted the exception .NET captured, POL-2200.

I am concerned that I am even getting a POL-2200 exception at all on
any modern system, but that is for an Oracle or XP discussion.

Many thanks.

Andy