How do I change the datasource for my Visual Basic 2008 project?

I have a Visual Basic 2008 project that I've created using my local SQL database as the datasource.  I need to distribute this project to another department using the network SQL server's database as the datasource.  I need to know how/where I need to change config to get the project to point to this new location.    
MCSFAsked:
Who is Participating?
 
srikanthreddyn143Connect With a Mentor Commented:
If it says it can't find the table, then you need to have a table of the name what you are using in you dataset/binding source in the network SQL Server.
0
 
srikanthreddyn143Commented:
In the connection string, where you wrote change the DataSource name

"Data Source=SQLServerName;database=DBName;User Id=User Id;password =pwd;"
0
 
MCSFAuthor Commented:
Okay, after I've done this now it says it can't find the table.  I created this project click and drag style.  Are there other things to consider with regards to data paths  in my bindingsource, tableadapter, dataset etc?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.