Hi every1...
im new to programming so xcuse my dumbness
im doing beginning VB.net 2003ch16, the DataBase Programming with SQL server.
ive downloaded and installed SQL server, its running in my task bar. i
have xp. i set a password when SQL srv installed, through a command
prompt. My xp pc is called "HPPC"
SQL server is installed on the same pc as vb.net 2003 professional.

im trying to run the 'dataset example' try it out, i think i have
problems with this parameter:

Dim objConnection As SqlConnection = New _
SqlConnection("server=(local);database=pubs;user id=sa;password=")

Please tell me:
do i have to change these values with my own username and password?
also, where IS the pubs database? is it in vb.net already or in SQL server?
Hope u guys can help!

Hi,
Don't excuse !
We've all been new to programming not so long ago !

Take a first step:

If you run visual studio:
You have a server explorer window, probably to the left of the screen. There you can try to connect to the databases installed. Your server's name is probably either "(local)", "(local)\the name of your instance of MSDE" ie: "(local)\MYMSDE" or "(the name of your PC)\(the name of your instance)" ie: "MYMACHINE\MYMSDE". Use windows integrated security. If you get the server name right, you can see the databases in the combobox below. You can also test the connection. From there it is much easier to help you with the connectionstring

hmm..thanks for the reply:)
i know the name of the server, it is listed in the server window..its 'hppc' .
how do i change this line:
Dim objConnection As SqlConnection = New_
SqlConnection("server=(local);database=pubs;user id=sa;password=")

and make it use integrated security?