Results 1 to 2 of 2

Thread: Connection probs with SQL Server

  1. #1

    Thread Starter
    Fanatic Member venerable bede's Avatar
    Join Date
    Sep 2002
    Location
    The mystic land of Geordies
    Posts
    1,018

    Connection probs with SQL Server

    I am developing a web page in asp.net

    I have a webform which uses a connection to an sql server 2000 database residing on the local machine.

    Whenever I try to connect to the database I get the error message :

    Login failed for user 'DELL\ASPNET'.

    I can view the database in Server Explorer and have succesfully tested the connection.

    Does anyone have any ideas?

    Parksie

  2. #2
    Hyperactive Member
    Join Date
    Feb 2001
    Location
    Houston, TX
    Posts
    342
    Pass a username and password in your connection string.

    VB Code:
    1. Dim cn As New OleDb.OleDbConnection()
    2.         cn.ConnectionString = "Provider=SQLOLEDB;Data Source=MySQLServer;Initial Catalog=MyCat;Userid=user;Password=pass;"

Posting Permissions

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



Click Here to Expand Forum to Full Width