R
roger.breton
Guest
In VisualStudio, here is my Data Sources window:
As you can see, I have three Data Sources. The "Database1DataSet" was an initial attempt…
The important one is the "CIMSQLDataSet" which I use all over my code like this:
Me.CIMSQLDataSet.Products.DefaultView.Sort = "ProductCode ASC"
All along, I had the database on my workstation but now I need to put it on a separate machine, for the purpose of development and testing. Soon, I hope, my application will be finished and I'll need to "deploy" it on my client SQL Server.
As you can see, above, I had to create a *New* Data Source when I moved my database from my machine to the other machine on my network. As a consequence, I could not use the "same" connection?
Maybe I missed something but I have not found a way to "update" the connection in the existing Data Source: VisualStudio insisted I created a new one. I don't mind doing that and I can simply Find & Replace all occurrences of "CIMSQLDataSet" by "CIMSQLDataSet2" in my Solution, but what about the day I deploy? I can't possibly be expected to create yet another Data Source to match my client's SQL Server? Which I know nothing about yet?
I looked everywhere in DataSource Properties. There aren't a whole lot of options:
The only thing that comes "close" to what I need to do is the "Configure Data Source with Wizard...".
When I launch it, the window shows up but then VisualStudio hangs ("Not Responding"). And I know why, because it must be trying to contact the remote SQL Server that corresponds to "CIMSQLDataSet2" and it can't get a response...
After a period of several minutes (I have not counted), VisualStudio comes back to life with this message:
Continue reading...
As you can see, I have three Data Sources. The "Database1DataSet" was an initial attempt…
The important one is the "CIMSQLDataSet" which I use all over my code like this:
Me.CIMSQLDataSet.Products.DefaultView.Sort = "ProductCode ASC"
All along, I had the database on my workstation but now I need to put it on a separate machine, for the purpose of development and testing. Soon, I hope, my application will be finished and I'll need to "deploy" it on my client SQL Server.
As you can see, above, I had to create a *New* Data Source when I moved my database from my machine to the other machine on my network. As a consequence, I could not use the "same" connection?
Maybe I missed something but I have not found a way to "update" the connection in the existing Data Source: VisualStudio insisted I created a new one. I don't mind doing that and I can simply Find & Replace all occurrences of "CIMSQLDataSet" by "CIMSQLDataSet2" in my Solution, but what about the day I deploy? I can't possibly be expected to create yet another Data Source to match my client's SQL Server? Which I know nothing about yet?
I looked everywhere in DataSource Properties. There aren't a whole lot of options:
The only thing that comes "close" to what I need to do is the "Configure Data Source with Wizard...".
When I launch it, the window shows up but then VisualStudio hangs ("Not Responding"). And I know why, because it must be trying to contact the remote SQL Server that corresponds to "CIMSQLDataSet2" and it can't get a response...
After a period of several minutes (I have not counted), VisualStudio comes back to life with this message:
Continue reading...