MSDE 2000 Connection String

[hfk0]

Hi,

I have a simple asp.net application running ok on my WinXP development
server with SQL Server Express 2005 installed locally. After moving to
the live server (Win 2000 server with MSDE 2000 installed locally),
it's giving me the 'SQL Network Interface Error (error 25): connection
string is not valid'.

So far, i've tried using the following connection string in my
web.config file:

connectionStrin g="Data
Source=.\SQLEXP RESS;AttachDbFi lename=|DataDir ectory|\registr ation.mdf;Integ rated
Security=True;U ser Instance=True" providerName="S ystem.Data.SqlC lient"
(this works fine on the development server)

connectionStrin g="Data Source=(local); Initial
Catalog=registr ation;Integrate d Security=SSPI"

Does anyone know how to solve this issue? Or is it just not possible to
use Sql Server .NET Data Provider (System.Data.Sq lClient) that I used
in the development server to connect to a MSDE 2000 database on the
live server? Originally I wanted to use SQL Server Express 2005 on the
live server, but I didn't enough memory on it, so I figured I tried
MSDE 2000 first to see if I can get the right connection string.

Any help would be appreciated.

THanks,

hfk0

[Juan T. Llibre]

The connection string will depend on what type of authentication you are using.

See :
http://www.codeproject.com/cs/databa..._in_csharp.asp

http://support.microsoft.com/default...b;en-us;321698

http://www.functionx.com/csharp/adonet/Lesson02.htm

Basically, the same connection strings valid for SQL Server are good for MSDE.

Check http://www.connectionstrings.com for SQL Server and MSDE connection strings.


--
Juan T. Llibre, asp.net MVP
aspnetfaq.com : http://www.aspnetfaq.com/
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
=============== =============== =====
"hfk0" <he**@infoventu res.com> wrote in message
news:11******** **************@ i40g2000cwc.goo glegroups.com.. .

Hi,

I have a simple asp.net application running ok on my WinXP development
server with SQL Server Express 2005 installed locally. After moving to
the live server (Win 2000 server with MSDE 2000 installed locally),
it's giving me the 'SQL Network Interface Error (error 25): connection
string is not valid'.

So far, i've tried using the following connection string in my
web.config file:

connectionStrin g="Data
Source=.\SQLEXP RESS;AttachDbFi lename=|DataDir ectory|\registr ation.mdf;Integ rated
Security=True;U ser Instance=True" providerName="S ystem.Data.SqlC lient"
(this works fine on the development server)

connectionStrin g="Data Source=(local); Initial
Catalog=registr ation;Integrate d Security=SSPI"

Does anyone know how to solve this issue? Or is it just not possible to
use Sql Server .NET Data Provider (System.Data.Sq lClient) that I used
in the development server to connect to a MSDE 2000 database on the
live server? Originally I wanted to use SQL Server Express 2005 on the
live server, but I didn't enough memory on it, so I figured I tried
MSDE 2000 first to see if I can get the right connection string.

Any help would be appreciated.

THanks,

hfk0

[Jonny]

Try http://www.connectionstring.com for your answer