oracle conncetion error
ASP.NET
1
Posts
1
Posters
0
Views
1
Watching
-
I am upgrading an application from asp 1.0 to 2.0. It seems like my old connection string for oracle doesn't work for this asp.net 2.0. No matter I read data or execute command, I always get this exception -- System.Data.OracleClient.OracleException: ORA-00911: invalid character at System.Data.OracleClient... which indicates the connection is not valid. My connnection string is: string connectionString = "Data Source=ora01;User ID=zd01;password=1234;Persist Security Info=True;"; OracleConnection con = new OracleConnection(connectionString); con.Open(); I can't find any errors in this connection setting, the sql commmand is tested and working. Any idea will be highly appreciated, Regards!