database path and dataadapters

[John Smith]

Hello,

I connect to an access database through the ui oledbdataadapters. This is
fine becuase the wizard prompts for a file location. Puttig my page on a
server, I have run into a few diffilculties. The page still asks for
c:\database\database.mdb. I have changed all the other events such as
submit/delete etc to server.mappath("/database/database.mdb"). How then do i
change that in the dataadapters?

 

[Miha Markic [MVP C#]]

Hi John,

There should be an OleDbConnection instance you shoud act on.
See its ConnectionString property.

 

[Cor Ligthert]

John,

In addition to Miha.

Assuming you are doing this using a form because you did use the UI, than
you can set the connectionstring form your connection in the Form_Load
event.

Probably when you did not rename anything

OleDB.OleDBConnection1.Connectionstring = "blabla"

(Do not delete your original setting in the designer created code)

http://www.connectionstrings.com/

http://www.able-consulting.com/ADO_Conn.htm

I hope this helps

Cor