cocoll 0 Junior Poster in Training

while long search and issues with connection to oracle database,i installed oracle database 10g express edition or XE,32 bits.
i have win 7 and 64bits machine.
so i tried to connect to this database after setting the ODBC driver (32 bits driver),but the problem is:
i successful connected from windows application,but failed from and i use the same code.
this is the error from

ERROR [NA000] [Microsoft][ODBC driver for Oracle][Oracle]ORA-06413: Connection not open.
ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
ERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr).

and i tried to connect from another laptop using win 7 32 bits,it worked from and windows application.
so i don't figure where is the error,and why it worked from windows application but it didn't from
this is the code:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.Odbc;
public partial class _Default : System.Web.UI.Page
    protected void Page_Load(object sender, EventArgs e)
        String con = "DRIVER={Microsoft ODBC for Oracle};DSN=XE;UID=hr;PWD=hr;SERVER=localhost;";
        OdbcConnection conx = new OdbcConnection(con);
        OdbcCommand command = new OdbcCommand("insert into test values('hi')", conx);


thank you very much.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.