AutoLogin for VB App

[Rick Joslin]

I have a VB application which uses a SQL 7 dbase. Currently the app requests a SQL login (via a screen) where the user enters the server name, dbase name, userid and pwd. Is there anyway to plpace this info on the target line of the shortcut to automatically pass the info to the sql server (similar to the /user /pwd tags for access)?

What you can do is read the Server name, db name,user name and pwd from ini file, or else if all are using same user name for SQL Server something like "sa", what you can do is this.
dim cn as new adodb.connection
cn.open "server=xserver;Database=dbname;pwd=x;uid=y&#3 4;

hope helps you


------------
Rick Joslin at 5/10/01 3:27:37 PM

I have a VB application which uses a SQL 7 dbase. Currently the app requests a SQL login (via a screen) where the user enters the server name, dbase name, userid and pwd. Is there anyway to plpace this info on the target line of the shortcut to automatically pass the info to the sql server (similar to the /user /pwd tags for access)?