Dynamic connection string

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

this is what my connection string is as per below , how do i actually make
it dynamic , becoz this ms access program is to be used in many countried
which has their own SQL Server , i need it to prompt the user once for that
session
how do i do that ?

Dim conn1 As New ADODB.Connection
Dim cmdStr As New ADODB.Command
Dim prmSumOfMoney As New ADODB.Parameter
Dim prmRefNo As New ADODB.Parameter
Dim SumOfMoney As Currency
Dim strLoc As String


strLoc = "Provider=SQLOLEDB;Data Source=WWF;Initial Catalog=TEST User
ID=ssaa;Password=123;"

tls & rdgs
 
Hi,
you can make a form for entering Login/password, and then build your
connection string as:

strLoc = "Provider=SQLOLEDB;Data Source=WWF;Initial Catalog=TEST;User ID=" &
me.login & ;Password=" & me.password ";"

assuming that login and password are textboxes on this form
HTH
 
Hi, same like user:

strLoc = "Provider=SQLOLEDB;Data Source=" me.server & ";Initial
Catalog=TEST;User ID=" &
me.login & ;Password=" & me.password ";"
 
Back
Top