Can't connect to database [resolved]

[d1lb3rt]

Hi guys and gals!

I was wondering if anyone could help me? I'm using a book called "Karl Moore's Visual Basic .NET: The Tutorials" and getting on great with it..... but for one thing!

I can't seem to connect to the database I need to use (I know it works cos I can manually add data to it)

I'm using the following connection string, as prescribed by the book:

Dim objConnection As New SqlClient.SqlConnection _
("server=.;database=KeepFit;trusted_connection=true")

Whenever I try to run this, I just get an error message saying SQL Server does not exist or access denied.

Any help you can give would be very very much appreciated

Thanks

[kleinma]

Dim objConnection As New SqlClient.SqlConnection _
("server=.;database=KeepFit;trusted_connection=true")

well unless the name of the SQL Server is "." I can see exactly why this wouldn't work.

[d1lb3rt]

the dot signifies that the instance of the server is on the local machine, as quoted in Karl's book. When I set a breakpoint, I can see it is looking at the right place. Even when I substitute the full server name, I get the same message.

[Asgorath]

Hi

Try removing trusted_connection=False and add the username and password in the connection string.

Regards
Jorge

[d1lb3rt]

Thanks for the suggestion, but I don't have a user name or password. I'm not using the full SQL server, it's just MSDE that comes with VS.NET - unless you know of what the default user name and password are? If it helps, my database was set up using windows security rather than a specific uname and pwd.

[kleinma]

did you name the instance of the MSDE when you installed it?

[d1lb3rt]

I didn't get the opportunity - it just went in as potter\netsdk

[kleinma]

maybe you should add a SQLConnection control onto a form and setup a connection that way... the system will do a lot of the work for you.. then once you have made a successful connection, you can look at the connection string it is using, and use that in your code.. the SQLConnection object can be found under the data tab in the toolbox

[d1lb3rt]

Managed to fix it with the help of another web site - I had to manually grant myself access to the database before I could do anytyhing.

Thanks for all your help guys!