Windows/SQL Authentication & Connection Strings...
From: Sai Prakash (saip_s@hotmail.com)
Date: 08/24/02
- Next message: Mid Damian: "Re: Linked Server Problem"
- Previous message: Basu: "SQL 7 Security Hotfix 7.00.1076"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Sai Prakash" <saip_s@hotmail.com> Date: Sat, 24 Aug 2002 10:46:31 +0300
An easy way to ensure that you have the right connection strings for SQL or
other data sources is as
follows:
1. Create a new text file (say test.txt) on your machine and rename it to
test.udl
2. Double-click the file and it will open a Data Source dialog. Click on the
first tab to select the kind of source - i.e. SQL Server for example.
3. Click the Next button and fill in the username, password etc and then
select
the database. You can test the connection by clicking the Test Connection
button.
4. Once done, click OK and the dialog will go. Then open the test.udl file
in Notepad and you will find in it an OLEDB connection string for the
source. Copy/paste into your code and your done. You can then delete the
file or use it for another source.
Regards,
Sai P.S.
- Next message: Mid Damian: "Re: Linked Server Problem"
- Previous message: Basu: "SQL 7 Security Hotfix 7.00.1076"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
