quote:Originally posted by dkaufmann
Finally solved the problem by using Tools - Connect To Database. This utility created a connection string of "Data Source=.\SQLEXPRESS;AttachDbFilename='C:\SQL Server 2000 Sample Databases\PUBS.MDF';Integrated Security=True;Connect Timeout=30;User Instance=True"
The previous attempts at a connection string resulted in an error pertaining to "remote access". I suspect that I might have done something when I installed the sample pubs database. I am really not sure what I was doing wrong, but this new connection string worked.
Awesome I'm glad it worked for you. As for the remote access error I believe you can fix that by to going to SQL server configuration manager...but since you fixed it through to tools then its all good :D.
One thing though..if you use the tool wizard ..and don't quote me on this because i could be fully wrong..but doesn't the code that it generates then makes it more to machine specific...meaning if you want to transport your program to another machine and run it there it wouldnt run correctly because it was generated by the wizard..
Again I'm not too sure about this, but just wondering about it.