Re: Where are server connections stored in project?
- From: "WJ" <JohnWebbs@xxxxxxxxxxx>
- Date: Sat, 14 May 2005 23:18:39 -0400
To get around, You can use the period (.) as DataSource. This will work with
SQL Instant on your PC at work, your laptop, and remote server. You also
need to reference the same database (catalog) on all 3 machines (have to). I
use SQL authentication, it seems working fine across machines.
Example:
Data Source=.;
Initial Catalog=Northwind;
User ID=sqlLogonID;
Password=xxxx;
Packet Size=4096;
The above connection string will work with all three machines: My PC in my
office, my Laptop on my laps, and my remote server in St. Paul. Just make
sure SQL/ ID & PW are the same on all 3 places. Once development is
completed, you can change the connection from SQL to Windows Integrated.and
or encrypt the connection string via Web.Config while still enjoying the
design time feature.
John
.
- Follow-Ups:
- Re: Where are server connections stored in project?
- From: Eric The Viking
- Re: Where are server connections stored in project?
- References:
- Where are server connections stored in project?
- From: richard
- Where are server connections stored in project?
- Prev by Date: Re: Parameters Question
- Next by Date: Re: Parameters Question
- Previous by thread: Where are server connections stored in project?
- Next by thread: Re: Where are server connections stored in project?
- Index(es):
Relevant Pages
|
