connection string

Results 1 to 2 of 2

Thread: connection string

  1. #1
    Join Date
    Dec 1969

    Default connection string

    Does anyone know how do I make a connection string to an access DB fom a com class in VB6?<BR>The sample below is for SQL DB.<BR>Also, how do you specify the DB path??<BR><BR>&#039; objConn.Open "Data Source=DBname;" & _<BR>&#039; "Provider=SQLOLEDB;" & _<BR>&#039; "Initial Catalog=tableName;" & _<BR>&#039; "User ID=sa"<BR><BR>Thanks,<BR>Nate

  2. #2
    RDM Guest

    Default Like this...

    "Provider=SQLOLEDB;Data Source=MYSERVERNAME;User ID=sa;Password=somepassword;Initial Catalog=MYDATABASENAME" <BR><BR>If the SQL Server instances is on the same web server you can change the Data Source=(local)<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