Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    1

    Unanswered: Problems with myconnection.Open()

    When my program is running, at the line myconnection.Open()m it says that there is an error:

    An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll

    Additional information: System error.

    What is this?

    I aquired SQL server 2000 and installed it on my machine

    I thought the problem was with the line when setting up the connection as there wasnt previously a SQL server running on machine.

    Dim myconnection As SqlConnection = New SqlConnection("server=(local);database=pubs;uid=;p wd=")

    Does anyone know how to fix this problem???

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    At first guess, I'd say that it was because you have no loginid or password specified, but I could be confused!

    I'm really surprised that Tony hasn't moved this off to the VB area. He generally tries to keep this area tightly focused on SQL only.

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •