Oracle connection driving me CRAZY!!!

G

Guest

I've had this problem for about a day and it's driving me nuts.
I'm writing a web app on my PC (without Oracle, with Studio .Net) for a PC with Oracle8i and no Studio .Net (it has the .Net framework):

I'm trying to connect to the Oracle8i DB with this code but I get this error *Unable to find an entry point named OCIEnvCreate in DLL oci.dll.*:

using System.Data;
using System.Data.OracleClient; //System.Data.OracleClient.dll is not in the target PC but it's included in the development PC
...
string myConnection = "User Id=myuser;Password=mypass;Data Source=Oracle8i";
OracleConnection myConn = new OracleConnection(myConnection);
string myInsertQuery = "select * from paemp1 where emplcode = '719051'";
OracleCommand myOracleCommand = new OracleCommand(myInsertQuery);
myOracleCommand.Connection = myConn;
myConn.Open();
myOracleCommand.ExecuteNonQuery();
myConn.Close();

The problem is that, if I want to modify something, I have to put it in floppy and copy it to the PC that will run the app.

Any help would be greatly appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top