I am following the video tutorials for VBX (quite good BTW) and am on Lesson 09. When I add a data source, the wizard does not produce a connection string. I am following the instructions exactly. What is wrong
Peter Feigl
I am following the video tutorials for VBX (quite good BTW) and am on Lesson 09. When I add a data source, the wizard does not produce a connection string. I am following the instructions exactly. What is wrong
Peter Feigl
Why do you believe that no connection string is produced What are you expecting to see I don't know which set of video tutorials you're talking about as there are several.
When you create a data source in VB it creates the connection string and stores it in the settings file of the project you're working in. Normally it also creates a data set that automatically uses the connection string. You have to open up the settings file to see the connection string.
Mike
Hi,
look in the Code behind and examine the connection object, right before the open method you can check the connectionstring property for the actual value. I doubt that VB didn¡¯t put something in place if you used the designer.
HTH, Jens K. Suessmeyer.
I am using the absolute beginner tutorials. Actually I think there must be a connection string because as I said, Test Connection succeeds, the string is just not displayed when you click on the connection string expander. It may be a VBX bug
Peter
Hi Peter,
Did you track this down yet
If the connection succeeds, there is a connection string, I promise. The issue is understanding where to look. I'm not completely certain what you're looking at when you talk about the connection string expander, maybe you can give the exact steps you're using to try and view the connection string and I can see if I see the same behavior.
As I said before, VS stored the connection string it creates in the properties of the project. I downloaded the finished project for Lesson 9 (C# version since that's what I have on my computer, but they are identical other than the language used) and found the connection string used by the project as follows:
You should see a single entry for MyCompanyConnectionString which is the connection string (listed under the Value column) that is created by VS when you add the DataSet.
Let me know if this helps you find the connection string being used.
Mike