Have to reset Sql Connection String for sample applications

[jello]

For all of the sample applications in my VB.NET course that deal with Databases, I have to reset the ConnectionString property to connect to the database (I have installed Sql Server 2000 on my computer).

Is it normal that example/sample applications come with an incorrect Sql CommandString property, or is something wrong with the Microsoft applications that were given to me for this course?

 

[cjard]

No no, not at all.. It's completely abnormal to have to edit a connection string.. Every PC in the world has had the same name, IP address, drivers, hardware and software/folder structure since.. about 1987!

So, yeah, it's really weird that you should find any variation in any of these components among the computers you use.. As such, the preprogrammed connection string from the examples should work for every computer in the world.

Mmm. Very strange.

 

[jello]

The Connection String as it comes is originally:

data source=(local)\MOC;initial catalog=Northwind;integrated security=SSPI;persist security info=False;workstation id=BILLREB90;packet size=4096

And this never works if I press F5 to run the program. If someone knows the clarification for this, it would be good to see it.

 

[MattP]

Sarcasm isn't lost on you at all.

http://www.ondotnet.com/pub/a/dotnet/excerpt/progvisbasic_ch08/index.html?page=2

Check out table 8.1 on the linked page for a description ow what each connection string setting means. You should be able to modify the one you've supplied to work once you're done reading the article.