Help!! SQL/ADO problem (easy...!)

im learning vb thru a book, which says i need access to SQL server and the Pubs database.
ive downloaded the sql server, but i cannot connect to it.
the book suggests the following code:
Dim objConnection As New SqlConnection = New_
SqlConnection("Server=(local);database=pubs;userid=sa;password=")

how do i modify this code to connect to the server and use the pubs database? Do i have to download the pubs database as well?
i notice in the task bar the sql server i installed is called HPPC.

also, when i installed the server it requested a "Strong password"...what is this?

hope u guys can help!!

Comments

  • First: sql server 2000 sp? From SP3 the setup require an option (sapassword or sapwd in setup.ini) to protect Administrator account of SQL Server.

    Second: the instance require sql authentication or windows authentication? (HKEY_LOCAL_MACHINESOFTWAREMICROSOFTMSSQLSERVERMSSQLSERVER key LoginMode 0x0002 for sql authentication)

    if you have problem write..

    bye
    cod
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

In this Discussion