| Oracle Lite + ADO.NET + C# [message #355951] |
Tue, 28 October 2008 12:40  |
aness
Messages: 1
Registered: October 2008
Location: Berlin
|
Junior Member |
|
|
Hi all!
I need to use Oracle Lite with C#. I did google three days and read tutorials, but I have got problems to use the oracle lite database or driver in C#. I created a Oracle Lite Database with createdb.exe on command line. With msql.exe command line tool, I could work correctly with this created database. Furthermore I I created Java-Project and used JDBC to communicate with my database. It works fine. But unfortunately I could not use Java but C#. I created C#-Project in Visual Studio 2008 and referenced libraray Oracle.DataAccess.Lite.dll. Unfortunately I could not open a connection to my database. Could somebody please tell me, what I'm doing wrong?. It would be very very great if somebody could answer me!!
Here is my code:
String DSN = "POLITE";
IDbConnection conn = new OracleConnection(DSN);
conn.ConnectionString = "Database=GREENE;DSN=POLITE;UID=SYSTEM;PWD=MANAGER";
conn.Open();
Error message is: Oracle.DataAccess.Lite.OracleException: [POL-3013] bad database or invalid password
But password and database name are correct. My correct working JDBC URL is:
Class.forName("oracle.lite.poljdbc.POLJDBCDriver");
Connection conn = DriverManager.getConnection(
"jdbc:polite:greene;" +
"IsolationLevel=READ COMITTED;" +
"Autocommit=ON;",
"system",
"manager");
Thank you very much in advance!
Bye Aness
|
|
|
|
| Re: Oracle Lite + ADO.NET + C# [message #360392 is a reply to message #355951] |
Thu, 20 November 2008 16:39  |
artvanhecke
Messages: 3
Registered: November 2008
Location: Suitland, Maryland
|
Junior Member |
|
|
Hi Aness,
ADO.Net may not be the problem, but your ODBC driver could be 2.0 which I have had a boatload of trouble with with Visual Studio 2008. If you are loading olod2040.dll then you are using 2.0, you need to load the olod3540.dll to get the 3.5 driver.
The 2.0 driver is the default installation.
You must also package the Oracle.DataAccess.Lite.dll assembly with the .exe when deploying or put it on the target machine and put it's path in the Global Assembly Cache with GACutil.exe (on SDK). You must have administrator rights and also run as administrator (open a dos box with run as administrator) if you are targeting Vista, for XP and Win2000 you only have to have administrator rights.
Art
[Updated on: Fri, 21 November 2008 12:47] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
