Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Connection string and dynamically determined uid/pwd
Message
 
To
07/10/2005 09:42:59
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Environment versions
Environment:
C# 1.1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01057158
Message ID:
01059828
Views:
9
This message has been marked as the solution to the initial question of the thread.
Andrew,

>I'm having a hard time understanding the following statement in the MMDevGuide :

>Note: If you are using SQL Server authentication, you only need to specify a user id (sa) and password (if any) on your development machine so the MM .NET builders can access your database. On end-user's machines at runtime, the user id and password are determined dynamically based on the user login information.
>
>Does this mean that the login information given in the mmUsersFormLang will be used to connect to the database (I get a user(null) exception if I remove uid and pwd from the connection string). Also, does this mean that the user must be listed in the database's user list as well as the mm Users table?

That's right...the information entered in the Login form will be used to connect to the database. This would also require you to enter the user information in SQL Server and the MM User's table. For more information on initially connecting to the database, see the MM .NET Dev Guide topic "Step 5: Displaying a Login Form". Alternately, you can use Windows Authentication to connect to SQL Server and completely bypass the need for id and password. Another good MM. NET Help topic that relates to this is "Integrating with Windows Security".

Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com
Previous
Reply
Map
View

Click here to load this message in the networking platform