Par2: Signing onto MSSql 1998-04-29 -- Mike Pasley You can build the connectstring in the procedure setup of your first procedure like this
sysDBNAME=GETINI('ODBCDBNAME','ODBCDBNAME','demo','programname.INI')
sysname=GETINI('UserName','UserName','someuser','programname.INI')
syspassword=GETINI('pwd','pwd','somepassword','programname.INI')
connectstring=Clip(sysDBNAME)&','&Clip(sysName)&','&Clip(sysPassword)
Use getini or some other control method to remember the user or have a default user
and pasword. This way you can change the user and pwd if you want to. Put all fields
(sysDBNAME thru connectstring) in the global. Make sure connectstring is in the owner
name field of the DCT as !connectstring.
Printed May 2, 2024, 12:48 am This article has been viewed/printed 35117 times. |