Unable to save data on web
-
hi I have a web application hosted on web server and a database also on same server. But when i try to save data on the database, an error is displayed after some time that "The underlying connection was closed: Unable to connect to the remote server.". But i am using oledataadpater. so i don't need to open and close connection. . This same web application when run on local server gives no error. Please help me. shelly
-
hi I have a web application hosted on web server and a database also on same server. But when i try to save data on the database, an error is displayed after some time that "The underlying connection was closed: Unable to connect to the remote server.". But i am using oledataadpater. so i don't need to open and close connection. . This same web application when run on local server gives no error. Please help me. shelly
Check your connection string. Make sure that you are connecting to the database. If you are using an OleDbCommand object, call the .Connection.Open() method on it. If you are just using a an SQL string, then you need to go through the DataAdapter to get the command object. See snippet below:
OleDataAdapter myAdapter = new OleDbDataAdapter("SELECT * FROM TABLE", conn); myAdapter.SelectCommand.Connection.Open();If the last line throws an exception, there's an error with your connection string. Or you don't have access to the SQL. ~Javier Lozano (blog)