473,320 Members | 1,832 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

ASP.NET and SQL 2000 not playing nice?

Hi,

I have just installed a shopping cart system that is build using the asp.net
1.1 frame work and a SQL 2000 db.

The production server is a WS03 box running IIS 6, SQL 2000 (sp3), and has
asp.net fw 1.1 and the Data Thingy 2.7.

Both the web server and the SQL server are running and I can connect to
either of them directly but I can't get the web.config connnection string to
intialize. I've made this connection string with the MDL thingy (which
tested fine) and copy/pasted into the web.config file. I'm still getthing
this:

Server Error in '/' Application.
----------------------------------------------------------------------------
----

The ConnectionString property has not been initialized.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: The ConnectionString
property has not been initialized.

Source Error:

An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below.

Stack Trace:

[InvalidOperationException: The ConnectionString property has not been
initialized.]
System.Data.SqlClient.SqlConnection.Open() +433
AspDotNetStorefront31Common.DB.GetDS(String sql, String cacheName,
Boolean useCache, DateTime expiresAt)
AspDotNetStorefront31Common.DB.GetDS(String sql, Boolean useCache,
DateTime expiresAt)
AspDotNetStorefront31Common.Common.AppConfig(Strin g paramName)
AspDotNetStorefront31Common.Common.UserCookieName( )
AspDotNetStorefront31Common.Common.SessionStart()
AspDotNetStorefront31.Global.Session_Start(Object sender, EventArgs e)
System.Web.SessionState.SessionStateModule.RaiseOn Start(EventArgs e) +132
System.Web.SessionState.SessionStateModule.Complet eAcquireState() +514
System.Web.SessionState.SessionStateModule.BeginAc quireState(Object
source, EventArgs e, AsyncCallback cb, Object extraData) +697

System.Web.AsyncEventExecutionStep.System.Web.Http Application+IExecutionStep
..Execute() +66
System.Web.HttpApplication.ExecuteStep(IExecutionS tep step, Boolean&
completedSynchronously) +173

----------------------------------------------------------------------------
----
Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET
Version:1.1.4322.2032
Nov 18 '05 #1
3 1374

"Hugh G. Johnson" <hu*************@comcast.net> wrote in message news:q-********************@comcast.com...
Hi,

I have just installed a shopping cart system that is build using the asp.net
1.1 frame work and a SQL 2000 db.

The production server is a WS03 box running IIS 6, SQL 2000 (sp3), and has
asp.net fw 1.1 and the Data Thingy 2.7.

Both the web server and the SQL server are running and I can connect to
either of them directly but I can't get the web.config connnection string to
intialize. I've made this connection string with the MDL thingy (which
tested fine) and copy/pasted into the web.config file. I'm still getthing
this:

[snipped]

Probably your connection string has a "provider" clause. You don't need that
as you already are using a sqlserver connection. And in fact you will get an error if
you do use it.

Hans Kesting
Nov 18 '05 #2
Hans,

Thank you for your reply. You're saying I should get rid of <add
key="DBProvider" value="MSSQL" />? Thanks!

Here's the Connection string:

<appSettings>

<add key="DBProvider" value="MSSQL" />
<add key="DBConn" value="data source=127.0.0.1;initial
catalog=AspDotNetStore;user id=sa;password=XXXX;;persist security
info=False" />
<add key="UseStaticLinks" value="true" />

</appSettings>


"Hans Kesting" <ne***********@spamgourmet.com> wrote in message
news:eb**************@TK2MSFTNGP15.phx.gbl...

"Hugh G. Johnson" <hu*************@comcast.net> wrote in message news:q-********************@comcast.com...
Hi,

I have just installed a shopping cart system that is build using the asp.net 1.1 frame work and a SQL 2000 db.

The production server is a WS03 box running IIS 6, SQL 2000 (sp3), and has asp.net fw 1.1 and the Data Thingy 2.7.

Both the web server and the SQL server are running and I can connect to
either of them directly but I can't get the web.config connnection string to intialize. I've made this connection string with the MDL thingy (which
tested fine) and copy/pasted into the web.config file. I'm still getthing this:

[snipped]

Probably your connection string has a "provider" clause. You don't need

that as you already are using a sqlserver connection. And in fact you will get an error if you do use it.

Hans Kesting

Nov 18 '05 #3

"Hugh G. Johnson" <hu**********@NOTcomcast.net> wrote in message news:Oi**************@TK2MSFTNGP09.phx.gbl...
Hans,

Thank you for your reply. You're saying I should get rid of <add
key="DBProvider" value="MSSQL" />? Thanks!
True, only use the value of "DBConn".
Hans Kesting

Here's the Connection string:

<appSettings>

<add key="DBProvider" value="MSSQL" />
<add key="DBConn" value="data source=127.0.0.1;initial
catalog=AspDotNetStore;user id=sa;password=XXXX;;persist security
info=False" />
<add key="UseStaticLinks" value="true" />

</appSettings>


"Hans Kesting" <ne***********@spamgourmet.com> wrote in message
news:eb**************@TK2MSFTNGP15.phx.gbl...

"Hugh G. Johnson" <hu*************@comcast.net> wrote in message

news:q-********************@comcast.com...
> Hi,
>
> I have just installed a shopping cart system that is build using the asp.net > 1.1 frame work and a SQL 2000 db.
>
> The production server is a WS03 box running IIS 6, SQL 2000 (sp3), and has > asp.net fw 1.1 and the Data Thingy 2.7.
>
> Both the web server and the SQL server are running and I can connect to
> either of them directly but I can't get the web.config connnection string to > intialize. I've made this connection string with the MDL thingy (which
> tested fine) and copy/pasted into the web.config file. I'm still getthing > this:
>

[snipped]

Probably your connection string has a "provider" clause. You don't need

that
as you already are using a sqlserver connection. And in fact you will get

an error if
you do use it.

Hans Kesting


Nov 18 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

48
by: ik | last post by:
ERROR after uninstalling SQL Server 2005 Express I get this message, SQLDMO has not been registered. Please re-run your setupand contact your system administrator. GREAT!!! ReInstalled SQL...
3
by: Stickleback | last post by:
Morning All I have been developing and deploying with Office 2000 for about 3 years, mainly Access based programs and although I have gotten used to it's quirks, I am starting to feel that I...
9
by: Richard W Collens | last post by:
Hi Folks, Just wondering if there is any real need to convert an application from 2000 or XP to 2003, if the application is not going to grow or change. Ive had a couple people ask about it...
5
by: rey17 | last post by:
i've found a way to set up SSID from other forums, but the problem is i have to change the register value at Pocket PC to use it.. so, my question : is there any way to join these register in c#...
2
by: Nicolas Mailhot | last post by:
Hi, I've been tasked with doing a study of how to migrate our current excel VBA macros (that currently dig in a very insecure and uncontroled way in various corporate databases) to a setup were...
6
by: Matthew Wells | last post by:
Can you bind ado recordsets to combo boxes and list boxes in Access 2000? thanks Matthew Wells MWells@FirstByte.net
1
by: rdraider | last post by:
Hi, I am trying to use the Upgrade Wizard in SQL 2000 to upgrade a SQL 6.5 db to 2000. I am only choosing to update a single database, not system objects. The Upgrade wizard connects to SQL 6.5,...
1
by: haries.ahmad | last post by:
Hi all.. i'm newbie in aspnet. i kind a confuse which one should i use for my database system. SQL 2000 or 2005, and what is the different. thankyou
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.