Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Book / SQL connection question
Message
 
To
25/06/2003 16:55:10
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Miscellaneous
Thread ID:
00749702
Message ID:
00804082
Views:
42
Gordon,

>May I make a simple request? Please add Charles' solution into your FAQs area of the MM documentation. I have been banging my head against the wall as well. Mind you I still need to try it as well before I finally get up and running with the samples in MM .NET 1.0.

Good suggestion...that said, you can create connection strings that use Windows Authentication rather then SQL Server authentication in MM .NET 1.0. Have you checked out the different sample connection strings listed in the MM .NET Dev Guide topic "Specifying Connection Strings in the Config File?".

If none of these work for you, try the following:

1. Open one of your forms in the design surface by double-clicking it in the Solution Explorer.

2. Select the Data tab in the VS .NET Toolbox, then drag a connection class of the proper type (SQL Server, Oracle, OLE DB) and drop it on your form. This adds a connection object in the Component Tray at the bottom of the IDE.

3. Go to the Properties Window and select the Connection String property. Open the associated combo box and select New Connection....

4. In the Data Link Properties dialog, follow the steps listed on the Connection tab to connect to your data source. You can click the Test Connection button to make sure you've got everything set up properly.

5. Click the OK button when you're done. This adds the corresponding connection string to the ConnectionString property.

6. Double-click the ConnectionString property shown on the left side of the Properties Window. This selects the entire connection string on the right.

7. Go to your configuration file and paste this in as the value of your connection string. NOTE: If the string contains any double quotes, simply remove them.

8. When you're done, go back to the form, select the connection object in the component tray and press the delete key to delete it.

Let me know how this works for you!

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
Next
Reply
Map
View

Click here to load this message in the networking platform