Results 1 to 2 of 2

Thread: open sql db with dsn

  1. #1

    Thread Starter
    Frenzied Member sebs's Avatar
    Join Date
    Sep 2000
    Location
    Aylmer,Qc
    Posts
    1,606

    open sql db with dsn

    Helllllllo

    i've created a user dsn to connect to my sql db!
    i've tested the connection and it work!

    but i can't use within vb

    here's the syntax i use

    conn.Open "DSN=landark;UserID=landarkSQL;PWD=myPassword"

    is'nt ok!

  2. #2

    Thread Starter
    Frenzied Member sebs's Avatar
    Join Date
    Sep 2000
    Location
    Aylmer,Qc
    Posts
    1,606
    never mindit's not UserID it's UID

    i dunno where i got that from???

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