ODBC Prompt

[mlager]

I'm new to Visual Studio 2008 and have built my first application using Visual Basic. Super simple.

1) Added new data source which points to an ODBC data source.

2) Drug the table to the form which gave me a data grid view.

Everything works find. It works when I take it to another computer as well as long as the ODBC source is setup identically (auth methods too). Is there a simple way to create a button that allows the user to configure which data source or SQL server it is connecting to?

 

[RiverGuy]

Here's a tip. Don't use an ODBC DSN at all. If you're connecting to SQL Server, use SQLClient. If you're using ODBC for something else, build a connection string that does not use a DSN. See

http://www.connectionstrings.com/