SQL Connection String

Results 1 to 2 of 2

Thread: SQL Connection String

  1. #1
    Join Date
    Dec 1969

    Default SQL Connection String

    Does anyone have a generic or really good way to connect to SQL Server 7. I just switched over from access and I am having a couple of problems. Is windows 2000 different from windows nt??<BR><BR>Thanks

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL Connection String

    cn.connectionstring = "Provider=SQLOLEDB.1;User ID=" & whoeveryouare & ";Password=" & yourpassword & ";Initial Catalog=" & thenameofyourdatabase & ";Data Source=" & thenameofyourserver<BR><BR>This is a minimum; you can add lots of other stuff if you want.

Posting Permissions

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