Opeing a DB Connection ...AGAIN

Results 1 to 2 of 2

Thread: Opeing a DB Connection ...AGAIN

  1. #1
    Join Date
    Dec 1969

    Default Opeing a DB Connection ...AGAIN

    I need to open a DB Connection to SQL server,<BR><BR>set Conn = Server.CreateObject("ADODB.Connection")<BR>Conn.Op en, "DSN=DBName;uid=someuid;pwd=somepword",0,3<BR><BR> However it returns one of two things "all objects are out of range", or "Login failed for user 0"<BR><BR>Any input on this matter will be VERY HIGHLY appreciated......don

  2. #2
    Join Date
    Dec 1969

    Default RE: Opeing a DB Connection ...AGAIN

    change <BR>Conn.Open, "DSN=DBName;uid=someuid;pwd=somepword",0,3<BR>TO<B R>Conn.Open "DSN=DBName;uid=someuid;pwd=somepword",0,3<BR><BR> jw<BR>megamicro.com<BR>

Posting Permissions

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