Configuring adapters @ time of installation.

[work4me]

i have created a client/server application that stores some data to the databade @ the server,the problem is whenever i try to install the application on another system it shows an unhandled exception & states tht the particular field cannt be found but reconfiguring the data adapters solve the problem. How to overcome this situation.?????

[mbuller]

you can use an application .config file to specify the location of the database then refer to the application .cofig file when pointing to the database with your connection string. To get to the app.config file ... right click, add new item, app.config... then open it you should see something like mine below. The easiest way to get a good connection string for Ex. Conn String (Access) "if need another database tell me..." 'Place This in a Module Public cnnRate As New OleDb.OleDbConnection Public odaCustomer As New OleDb.OleDbDataAdapter Public Sub Connect() Try cnnRate.ConnectionString = _ System.Configuration.ConfigurationSettings.AppSettings("odaCustomer.ConnectionString") Catch ex As Exception MsgBox(ex) End Try Michael

[mbuller]

Also ... if you have plans for deployment and other issue's let me konw so i can tell you about other small details that might get in your way. The idea above allows for configuring the connection string at any point after installation... you can simply open the app config file after install with notepad and change the small section refering to connection string. Then its fixed Michael