I need to make my app portable. How do I change my dataadapter source?

  • Thread starter Thread starter Larry Woods
  • Start date Start date
L

Larry Woods

I am using dataconnections/dataadapters but I don't want to tie my
application down to a specific database. It seems as if I MUST use a
specific connectionstring when defining my dataadapters. This does make
sense but then how do I move this application to another site that has a
different SQL server name, etc.?

TIA,

Larry Woods
 
You can put the connection string in the web.config file.

And you can certainly set the connection string property in your code. Of
course, you'll need to know ahead of time the name of the SQL database. No
way around that. But you can always use (local) as the servername, if the
database is on the same server as your app

Jeff
 
Thanks, Jeff...

This isn't an ASP.NET project, but your suggestions still hold...execept for
the web.config idea.

Larry
 
Back
Top