By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,929 Members | 1,245 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,929 IT Pros & Developers. It's quick & easy.

Connecting to Oracle 9i Lite from VB.NET ODBC

P: n/a

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
Nov 20 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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
Nov 20 '05 #2

P: n/a

"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
Nov 20 '05 #3

P: n/a
"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
Nov 20 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.