Simple code worked fine with SQL2005, but now has a problem with SQL2000.

[Radu]

Hi. This code worked fine with SQL2005, but has a problem with
SQL2000.... Which one ????

cnSQL = New
SqlConnection(S ystem.Configura tion.Configurat ionManager.AppS ettings("Connec tionString"))
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="Connection String"
value="Data Source='SQLDEV0 01\SQLDEV001;In itial Catalog='SOP';U ser
ID=SOP_DEV;Pass word=AAA;"
/>

and

<add
name="OrderingP rocess"
connectionStrin g="server='SQLD EV001\SQLDEV001 ';database='SOP ';User
ID=SOP_DEV;Pass word=AAA;"
providerName="S ystem.Data.SqlC lient"
/>

which is used in some page as:

<asp:SqlDataSou rce
ID="LocationSql DataSource"
SelectCommand=" SELECT
Measures.[Measure ID] as ID,
Measures.[Measure Description] as Measure,
Locations_BY_Me asure.[Locations] as Location
FROM Locations_BY_Me asure INNER JOIN Measures
ON Locations_BY_Me asure.[Measure ID] = Measures.[Measure ID]"
EnableCaching=" True"
ConnectionStrin g="<%$ ConnectionStrin gs:OrderingProc ess %>"
CacheDuration=" 60"
FilterExpressio n="ID = {0}"
RunAt="server">
while the exact same code works great with the 2005 settings:

<!-- SQL2005, with Username/Password....-->
<add
key="Connection String"
value="Data Source='myOther Computer\SQLEXP RESS';Initial
Catalog='SOP';U ser ID=SOP_DEV;Pass word=AAA;"
/>

and

<add
name="OrderingP rocess"
connectionStrin g="server='SQLD EV001\SQLDEV001 ';database='SOP ';User
ID=SOP_DEV;Pass word=AAA;"
providerName="S ystem.Data.SqlC lient" />

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.

[=?Utf-8?B?UGV0ZXIgQnJvbWJlcmcgW0MjIE1WUF0=?=]

'SOP' - try removing the single quotes.
Peter

--
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
Short urls & more: http://ittyurl.net


"Radu" wrote:

Hi. This code worked fine with SQL2005, but has a problem with
SQL2000.... Which one ????

cnSQL = New
SqlConnection(S ystem.Configura tion.Configurat ionManager.AppS ettings("Connec tionString"))
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="Connection String"
value="Data Source='SQLDEV0 01\SQLDEV001;In itial Catalog='SOP';U ser
ID=SOP_DEV;Pass word=AAA;"
/>

and

<add
name="OrderingP rocess"
connectionStrin g="server='SQLD EV001\SQLDEV001 ';database='SOP ';User
ID=SOP_DEV;Pass word=AAA;"
providerName="S ystem.Data.SqlC lient"
/>

which is used in some page as:

<asp:SqlDataSou rce
ID="LocationSql DataSource"
SelectCommand=" SELECT
Measures.[Measure ID] as ID,
Measures.[Measure Description] as Measure,
Locations_BY_Me asure.[Locations] as Location
FROM Locations_BY_Me asure INNER JOIN Measures
ON Locations_BY_Me asure.[Measure ID] = Measures.[Measure ID]"
EnableCaching=" True"
ConnectionStrin g="<%$ ConnectionStrin gs:OrderingProc ess %>"
CacheDuration=" 60"
FilterExpressio n="ID = {0}"
RunAt="server">
while the exact same code works great with the 2005 settings:

<!-- SQL2005, with Username/Password....-->
<add
key="Connection String"
value="Data Source='myOther Computer\SQLEXP RESS';Initial
Catalog='SOP';U ser ID=SOP_DEV;Pass word=AAA;"
/>

and

<add
name="OrderingP rocess"
connectionStrin g="server='SQLD EV001\SQLDEV001 ';database='SOP ';User
ID=SOP_DEV;Pass word=AAA;"
providerName="S ystem.Data.SqlC lient" />

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.

[sloan]

www.connectionstrings.com has all the syntaxes.

be anal about spaces semi colons and single quotes.


"Radu" <cu************ *@yahoo.comwrot e in message
news:11******** **************@ h2g2000hsg.goog legroups.com...

Hi. This code worked fine with SQL2005, but has a problem with
SQL2000.... Which one ????

cnSQL = New

SqlConnection(S ystem.Configura tion.Configurat ionManager.AppS ettings("Connec t
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="Connection String"
value="Data Source='SQLDEV0 01\SQLDEV001;In itial Catalog='SOP';U ser
ID=SOP_DEV;Pass word=AAA;"
/>

and

<add
name="OrderingP rocess"
connectionStrin g="server='SQLD EV001\SQLDEV001 ';database='SOP ';User
ID=SOP_DEV;Pass word=AAA;"
providerName="S ystem.Data.SqlC lient"
/>

which is used in some page as:

<asp:SqlDataSou rce
ID="LocationSql DataSource"
SelectCommand=" SELECT
Measures.[Measure ID] as ID,
Measures.[Measure Description] as Measure,
Locations_BY_Me asure.[Locations] as Location
FROM Locations_BY_Me asure INNER JOIN Measures
ON Locations_BY_Me asure.[Measure ID] = Measures.[Measure ID]"
EnableCaching=" True"
ConnectionStrin g="<%$ ConnectionStrin gs:OrderingProc ess %>"
CacheDuration=" 60"
FilterExpressio n="ID = {0}"
RunAt="server">
while the exact same code works great with the 2005 settings:

<!-- SQL2005, with Username/Password....-->
<add
key="Connection String"
value="Data Source='myOther Computer\SQLEXP RESS';Initial
Catalog='SOP';U ser ID=SOP_DEV;Pass word=AAA;"
/>

and

<add
name="OrderingP rocess"
connectionStrin g="server='SQLD EV001\SQLDEV001 ';database='SOP ';User
ID=SOP_DEV;Pass word=AAA;"
providerName="S ystem.Data.SqlC lient" />

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.

[Alexey Smirnov]

On May 7, 8:02 pm, Radu <cuca_macaii2.. [e-mail] e:

>
<!-- SQL2000, with Username/Password....-->
<add
key="Connection String"
value="Data Source='SQLDEV0 01\SQLDEV001;In itial Catalog='SOP';U ser
ID=SOP_DEV;Pass word=AAA;"
/>

and

<add
name="OrderingP rocess"
connectionStrin g="server='SQLD EV001\SQLDEV001 ';database='SOP ';User
ID=SOP_DEV;Pass word=AAA;"
providerName="S ystem.Data.SqlC lient"
/>

they are the same strings, why the syntax is different?

I've tried to connect using such strings to my local SQL 2000 server
and I have no problem with quotes.

Alex, what about the named instance? Are you sure about the name?

[Radu]

On May 7, 3:07 pm, Alexey Smirnov <alexey.smir... @gmail.comwrote :

On May 7, 8:02 pm, Radu <cuca_macaii2.. [e-mail] e:

<!-- SQL2000, with Username/Password....-->
<add
key="Connection String"
value="Data Source='SQLDEV0 01\SQLDEV001;In itial Catalog='SOP';U ser
ID=SOP_DEV;Pass word=AAA;"
/>

and

<add
name="OrderingP rocess"
connectionStrin g="server='SQLD EV001\SQLDEV001 ';database='SOP ';User
ID=SOP_DEV;Pass word=AAA;"
providerName="S ystem.Data.SqlC lient"
/>

they are the same strings, why the syntax is different?

I've tried to connect using such strings to my local SQL 2000 server
and I have no problem with quotes.

Alex, what about the named instance? Are you sure about the name?- Hide quoted text -

- Show quoted text -

Hi. Finally.... it works.... Hmmmmmmm..... I took out all quotes, thus
the string (working for 2005)

<add name="OrderingP rocess"
connectionStrin g="server='C227 226\SQLEXPRESS' ;database='SOP' ;User
ID=SOP_DEV;Pass word=AAA;" providerName="S ystem.Data.SqlC lient" />

became for 2000

<add name="OrderingP rocess"
connectionStrin g="server=SQLDE V001\SQLDEV001; database=SOP;Us er
ID=SOP_DEV;Pass word=AAA;" providerName="S ystem.Data.SqlC lient" />

Note that the string (otherwise correct, from a 2005 standpoint)

<add name="OrderingP rocess"
connectionStrin g="server='SQLD EV001\SQLDEV001 ';database='SOP ';User
ID=SOP_DEV;Pass word=AAA;" providerName="S ystem.Data.SqlC lient" />

with single quotes did *NOT* work, so, to make it work,
'SOP'
became
SOP
and
'SQLDEV001\SQLD EV001'
became
SQLDEV001\SQLDE V001

Very strange, indeed.... looks like the strings are parsed
differently.... Again, as I was saying, Hmmmmmmmm......

I lost almost a whole morning fighting this problem !
Anyway, it works now. Thank you all very much for your kind
answers :-)))))

Alex.

[Alexey Smirnov]

On May 7, 10:53 pm, Radu <cuca_macaii2.. [e-mail] e:

>
Hi. Finally.... it works.... Hmmmmmmm..... I took out all quotes, thus
the string (working for 2005)

<add name="OrderingP rocess"
connectionStrin g="server='C227 226\SQLEXPRESS' ;database='SOP' ;User
ID=SOP_DEV;Pass word=AAA;" providerName="S ystem.Data.SqlC lient" />

became for 2000

<add name="OrderingP rocess"
connectionStrin g="server=SQLDE V001\SQLDEV001; database=SOP;Us er
ID=SOP_DEV;Pass word=AAA;" providerName="S ystem.Data.SqlC lient" />

Note that the string (otherwise correct, from a 2005 standpoint)

<add name="OrderingP rocess"
connectionStrin g="server='SQLD EV001\SQLDEV001 ';database='SOP ';User
ID=SOP_DEV;Pass word=AAA;" providerName="S ystem.Data.SqlC lient" />

with single quotes did *NOT* work, so, to make it work,
'SOP'
became
SOP
and
'SQLDEV001\SQLD EV001'
became
SQLDEV001\SQLDE V001

Very strange, indeed.... looks like the strings are parsed
differently.... Again, as I was saying, Hmmmmmmmm......

I lost almost a whole morning fighting this problem !
Anyway, it works now. Thank you all very much for your kind
answers :-)))))

Alex.

I don't get it.

The following code (using single quotes) works for me:

<asp:GridView ID="GridView1" DataSourceID="S qlDataSource1"
runat="server" />
<asp:SqlDataSou rce ID="SqlDataSour ce1" runat="server"
SelectCommand=" SELECT ... FROM ..."
ConnectionStrin g="Data Source='localho st';Initial
Catalog='databa sename';User ID=sa;Password= pass;" />

as well as:

<asp:GridView ID="GridView1" DataSourceID="S qlDataSource1"
runat="server" />
<asp:SqlDataSou rce ID="SqlDataSour ce1" runat="server"
SelectCommand=" SELECT ... FROM ... "
ConnectionStrin g="<%$ ConnectionStrin gs:OrderingProc ess %>" />

in web.config

<connectionStri ngs>
<add name="OrderingP rocess"
connectionStrin g="Data Source='localho st';Initial
Catalog='databa sename';User ID=sa;Password= pass;"
providerName="S ystem.Data.SqlC lient" />
</connectionStrin gs>

--ASP.NET 2.0, SQL 2000

where is the difference?

[=?Utf-8?B?UGV0ZXIgQnJvbWJlcmcgW0MjIE1WUF0=?=]

The connection string name=value pairs do not take 'quotation' marks. Unless
of course your database name really is 'SOP' instead of SOP.
Peter

--
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
Short urls & more: http://ittyurl.net


"Radu" wrote:

On May 7, 3:07 pm, Alexey Smirnov <alexey.smir... @gmail.comwrote :

On May 7, 8:02 pm, Radu <cuca_macaii2.. [e-mail] e:

<!-- SQL2000, with Username/Password....-->
<add
key="Connection String"
value="Data Source='SQLDEV0 01\SQLDEV001;In itial Catalog='SOP';U ser
ID=SOP_DEV;Pass word=AAA;"
/>

and

<add
name="OrderingP rocess"
connectionStrin g="server='SQLD EV001\SQLDEV001 ';database='SOP ';User
ID=SOP_DEV;Pass word=AAA;"
providerName="S ystem.Data.SqlC lient"
/>

they are the same strings, why the syntax is different?

I've tried to connect using such strings to my local SQL 2000 server
and I have no problem with quotes.

Alex, what about the named instance? Are you sure about the name?- Hide quoted text -

- Show quoted text -

Hi. Finally.... it works.... Hmmmmmmm..... I took out all quotes, thus
the string (working for 2005)

<add name="OrderingP rocess"
connectionStrin g="server='C227 226\SQLEXPRESS' ;database='SOP' ;User
ID=SOP_DEV;Pass word=AAA;" providerName="S ystem.Data.SqlC lient" />

became for 2000

<add name="OrderingP rocess"
connectionStrin g="server=SQLDE V001\SQLDEV001; database=SOP;Us er
ID=SOP_DEV;Pass word=AAA;" providerName="S ystem.Data.SqlC lient" />

Note that the string (otherwise correct, from a 2005 standpoint)

<add name="OrderingP rocess"
connectionStrin g="server='SQLD EV001\SQLDEV001 ';database='SOP ';User
ID=SOP_DEV;Pass word=AAA;" providerName="S ystem.Data.SqlC lient" />

with single quotes did *NOT* work, so, to make it work,
'SOP'
became
SOP
and
'SQLDEV001\SQLD EV001'
became
SQLDEV001\SQLDE V001

Very strange, indeed.... looks like the strings are parsed
differently.... Again, as I was saying, Hmmmmmmmm......

I lost almost a whole morning fighting this problem !
Anyway, it works now. Thank you all very much for your kind
answers :-)))))

Alex.

[Roland Dick]

Hi Alex,

just to add to the other posters: Unless it's a typo, the first
connection string is missing the closing quotation mark after the
instance name (apart from the fact that you don't need quotation marks).

Radu wrote:

<add
key="Connection String"
value="Data Source='SQLDEV0 01\SQLDEV001;In itial Catalog='SOP';U ser
ID=SOP_DEV;Pass word=AAA;"
/>

Roland

[Radu]

On May 8, 8:00 am, Roland Dick <[e-mail] wrote:

Hi Alex,

just to add to the other posters: Unless it's a typo, the first
connection string is missing the closing quotation mark after the
instance name (apart from the fact that you don't need quotation marks).

Radu wrote:

<add
key="Connection String"
value="Data Source='SQLDEV0 01\SQLDEV001;In itial Catalog='SOP';U ser
ID=SOP_DEV;Pass word=AAA;"
/>

Roland

Hi, all.

It's true, and it's strange. The same string worked great in 2005, but
stopped working with the above-mentioned error in 2000 (of course, I
have changed the name of the instance to match). At least this is the
way it behaved on my computer at work - I'm curious to test it at
home. Anyway, it all works now (without any quotation marks), and
that's what counts - I already forgot this aggravation, like so many
others :-))))))) This is the nature of this beast, I guess.

Thank you all for spending the time reading this. I honestly
appreciate it !

Alex.

PS. Yes, Roland, it was a typo :-)