I have set up a SQL connection using the VB2005 database connection wizard. Now, the SQL database I have connected is moved to another location, and the database name itself is changes as well. How do I make changes in my VB coding to have my application to connect to the new location? Do I have to use the wizard again to reconnect?

Any help will be appreciated!

VB-Newbee

Use find to find the old string, an edit the code to hold the new string.

Many of the features of the code the designer creates are normally not shown to the programmer, but they are nonetheless there, and are in plain text like all code.

Thank you Brian for looking into my post and answering my question. I tried in the code of the form but I can't find the place containing the string of the database path. It must be hidden somewhere. And the table adapters showing the old name, how can I change the name of the table adapter to the new database name?

Thank you!

When you search, be sure to include hidden items and so forth (there are checkboxes on the Search dialog). Everything you create through the design interface (textboxes, buttons, etc.) is represented in VB code that you can read (as opposed to VB 6 that put some things into a .frx file that you could not read).

Brian, Thank you very much!

Song