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

[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

 

[Jeff Dillon]

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

 

[Earl]

Check out SQLDMO.

 

[Larry Woods]

Thanks, Jeff...

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

Larry

 

[Guest]

Sorry, the term "site" to me often implies "web site"

Jeff.