Re: Simple code worked fine with SQL2005, but now has a problem with SQL2000.
- From: "sloan" <sloan@xxxxxxxxx>
- Date: Mon, 7 May 2007 14:50:43 -0400
www.connectionstrings.com has all the syntaxes.
be anal about spaces semi colons and single quotes.
"Radu" <cuca_macaii2000@xxxxxxxxx> wrote in message
news:1178560955.270436.154800@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi. This code worked fine with SQL2005, but has a problem withSqlConnection(System.Configuration.ConfigurationManager.AppSettings("Connect
SQL2000.... Which one ????
cnSQL = New
ionString"))
cnSQL.Open()
fails with the error
"Format of the initialization string does not conform to specification
starting at index 0."
if in web.config I have
<!-- SQL2000, with Username/Password....-->
<add
key="ConnectionString"
value="Data Source='SQLDEV001\SQLDEV001;Initial Catalog='SOP';User
ID=SOP_DEV;Password=AAA;"
/>
and
<add
name="OrderingProcess"
connectionString="server='SQLDEV001\SQLDEV001';database='SOP';User
ID=SOP_DEV;Password=AAA;"
providerName="System.Data.SqlClient"
/>
which is used in some page as:
<asp:SqlDataSource
ID="LocationSqlDataSource"
SelectCommand="SELECT
Measures.[Measure ID] as ID,
Measures.[Measure Description] as Measure,
Locations_BY_Measure.[Locations] as Location
FROM Locations_BY_Measure INNER JOIN Measures
ON Locations_BY_Measure.[Measure ID] = Measures.[Measure ID]"
EnableCaching="True"
ConnectionString="<%$ ConnectionStrings:OrderingProcess %>"
CacheDuration="60"
FilterExpression="ID = {0}"
RunAt="server">
while the exact same code works great with the 2005 settings:
<!-- SQL2005, with Username/Password....-->
<add
key="ConnectionString"
value="Data Source='myOtherComputer\SQLEXPRESS';Initial
Catalog='SOP';User ID=SOP_DEV;Password=AAA;"
/>
and
<add
name="OrderingProcess"
connectionString="server='SQLDEV001\SQLDEV001';database='SOP';User
ID=SOP_DEV;Password=AAA;"
providerName="System.Data.SqlClient" />
Of course, using Enterprise Manager I can connect using the SOP_DEV
and AAA info to both databases.
Could you help me, please ?
Thanks, Alex.
.
- References:
- Prev by Date: Re: ASP.NET project
- Next by Date: Re: Determine RAM using Web Application...
- Previous by thread: RE: Simple code worked fine with SQL2005, but now has a problem with S
- Next by thread: Re: Simple code worked fine with SQL2005, but now has a problem with SQL2000.
- Index(es):
Relevant Pages
|
