Connection string for SQL2000

Results 1 to 3 of 3

Thread: Connection string for SQL2000

  1. #1
    Wini Guest

    Default Connection string for SQL2000

    I am writing a com in visual basic. I have ODBC for this databse as this database resides on some other machine.<BR>My connection string for SQL 2000 is as follows. But it gives error. <BR>Option Explicit<BR>Const sCONNECTION_STRING As String = "Provider=SQLOLEDB.1;Persist Security Info=False;" & _<BR> "UID=sa;Data Source=PCMIS"<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default Don't crosspost. Already answered.

    In ASP Q&A.

  3. #3
    Join Date
    Dec 1969

    Default what's the error?

    error messages are *meant* to point to the problem. doesn&#039;t help when you don&#039;t tell us.<BR><BR>just SQLOLEDB should be fine, btw, not SQLOLEDB.1

Posting Permissions

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