` Comment on an Icetips Article
Icetips - Templates, Tools & Utilities for Clarion Developers

Templates, Tools and Utilities
for Clarion Developers

Add a comment to an Icetips Article

Please add your comments to this article. Please note that you must provide both a name and a valid email address in order for us to publish your comment. Comments are moderated and are not visible until they have been approved. Spam is never approved!

Your Name:  
Email:  
Header text/Subject:  

Please enter your comment in the box below:

Back to article list   Search Articles     Add Comment     Printer friendly     Direct link  

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.


Today is May 1, 2024, 9:56 pm
This article has been viewed 35117 times.



Back to article list   Search Articles   Add Comment   Printer friendly

Login

User Name:

Password: