«

Tried all kinds of things. I get the error.

The ConnectionString property has not been initialized.



Any help appreciated.

-----------------------------------------------------------------------------------------------------
This is the web.config info

<configuration>

<appSettings>

<add key="connectionstring" value="Data Source=path to database;
database=testingsite;User Id=UserID;Password=password" />

</appSettings>

-------------------------------------------------------------------------------------------------------------------------------------------------------------------

Here is the doc mentioned in the error.



Imports System.Data.SqlClient



Public Class Catalog

Public Shared Function GetDepartments() As SqlDataReader

' Create the connection object

Dim connection As New SqlConnection(connectionString)

' Create and initialize the command object

Dim command As New SqlCommand("dbo.GetDepartments", connection)

command.CommandType = CommandType.StoredProcedure

' Open the connection

connection.Open()

' Return a SqlDataReader to the calling function

Return command.ExecuteReader(CommandBehavior.CloseConnect ion)

End Function

Private Shared ReadOnly Property connectionString() As String

Get

Return ConfigurationSettings.AppSettings("ConnectionStrin g")

End Get

End Property

End Class

Laura K wrote:
> Tried all kinds of things. I get the error.
>
> The ConnectionString property has not been initialized.
>
>
>
> Any help appreciated.
>
> -----------------------------------------------------------------------------------------------------
> This is the web.config info
>
> <configuration>
>
> <appSettings>
>
> <add key="connectionstring" value="Data Source=path to database;
> database=testingsite;User Id=UserID;Password=password" />
>
> </appSettings>
>
> -------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Here is the doc mentioned in the error.
>
>
>
> Imports System.Data.SqlClient
>
>
>
> Public Class Catalog
>
> Public Shared Function GetDepartments() As SqlDataReader
>
> ' Create the connection object
>
> Dim connection As New SqlConnection(connectionString)
>
> ' Create and initialize the command object
>
> Dim command As New SqlCommand("dbo.GetDepartments", connection)
>
> command.CommandType = CommandType.StoredProcedure
>
> ' Open the connection
>
> connection.Open()
>
> ' Return a SqlDataReader to the calling function
>
> Return command.ExecuteReader(CommandBehavior.CloseConnect ion)
>
> End Function
>
> Private Shared ReadOnly Property connectionString() As String
>
> Get
>
> Return ConfigurationSettings.AppSettings("ConnectionStrin g")
>
> End Get
>
> End Property
>
> End Class
>
>

I know the tags are case-sensitive in web.config. Can't remember about
the keys/vals values. Try changing the case sensitivity of your
..AppSettings call or the key name in the config (make them the same).

--
Craig Deelsnyder
Microsoft MVP - ASP/ASP.NET

I tried dozen of case changes. That doesn't seem to be it.

Any other ideas?


"Craig Deelsnyder" <cdeelsny@NO_SPAM_4_MEyahoo.com> wrote in message
news:...
> Laura K wrote:
>> Tried all kinds of things. I get the error.
>>
>> The ConnectionString property has not been initialized.
>>
>>
>>
>> Any help appreciated.
>>
>> -----------------------------------------------------------------------------------------------------
>> This is the web.config info
>>
>> <configuration>
>>
>> <appSettings>
>>
>> <add key="connectionstring" value="Data Source=path to database;
>> database=testingsite;User Id=UserID;Password=password" />
>>
>> </appSettings>
>>
>> -------------------------------------------------------------------------------------------------------------------------------------------------------------------
>>
>> Here is the doc mentioned in the error.
>>
>>
>>
>> Imports System.Data.SqlClient
>>
>>
>>
>> Public Class Catalog
>>
>> Public Shared Function GetDepartments() As SqlDataReader
>>
>> ' Create the connection object
>>
>> Dim connection As New SqlConnection(connectionString)
>>
>> ' Create and initialize the command object
>>
>> Dim command As New SqlCommand("dbo.GetDepartments", connection)
>>
>> command.CommandType = CommandType.StoredProcedure
>>
>> ' Open the connection
>>
>> connection.Open()
>>
>> ' Return a SqlDataReader to the calling function
>>
>> Return command.ExecuteReader(CommandBehavior.CloseConnect ion)
>>
>> End Function
>>
>> Private Shared ReadOnly Property connectionString() As String
>>
>> Get
>>
>> Return ConfigurationSettings.AppSettings("ConnectionStrin g")
>>
>> End Get
>>
>> End Property
>>
>> End Class
>>
>>
>
> I know the tags are case-sensitive in web.config. Can't remember about
> the keys/vals values. Try changing the case sensitivity of your
> .AppSettings call or the key name in the config (make them the same).
>
> --
> Craig Deelsnyder
> Microsoft MVP - ASP/ASP.NET

Try this:-
<add key="ConnectionString" value="Data Source=(local);
database=Northwind; Integrated Security=SSPI" />

MAKE SURE U ARE PASSING THE CORRECT KEY IN UR APPLICATION.

Patrick



*** Sent via Developersdex http://www.developersdex.com ***

> <add key="connectionstring" value="Data Source=path to database;
> database=testingsite;User Id=UserID;Password=password" />

When this says "path to database", what exactly is the value you're specifying?
It should be "servername" or "servername\instance".

-Brock
DevelopMentor
http://staff.develop.com/ballen

Patrick Olurotimi Ige wrote:
> Try this:-
> <add key="ConnectionString" value="Data Source=(local);
> database=Northwind; Integrated Security=SSPI" />
>
> MAKE SURE U ARE PASSING THE CORRECT KEY IN UR APPLICATION.
>
> Patrick
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***

Heh, I blew right past that part Obviously that's pry the problem...

--
Craig Deelsnyder
Microsoft MVP - ASP/ASP.NET

When I say path to database it is remote.

sql3.webcontrolcenter.com


"Brock Allen" <> wrote in message
news: ...
>> <add key="connectionstring" value="Data Source=path to database;
>> database=testingsite;User Id=UserID;Password=password" />
>
> When this says "path to database", what exactly is the value you're
> specifying? It should be "servername" or "servername\instance".
>
> -Brock
> DevelopMentor
> http://staff.develop.com/ballen
>
>
>
>

Brock good u figured out that issue ..
And Laura have u finally fixed the connection?
Patrick


*** Sent via Developersdex http://www.developersdex.com ***

Nope connection not fixed. I am also posting this on another forum. Here
is a list of docs. would love to have help. I am totally lost on this one.

Here is the exact same thing as I posted on the other forum. Any help
appreciated.

Here is the situation. I am following a book, "Beginning ASP.NET 1.1
E-Commerce. The book has me working on a local SQL server. I am working
remotly and trying to make the changes needed to do it that way.

Instead of posting code I will post a txt version of the docs.

This contains the code for the connection

http://209.200.112.194/txtdocs/catalog.vb.txt

This is a user control code behind

http://209.200.112.194/txtdocs/depar...st.ascx.vb.txt

this is the user control - view source to see the code

http://209.200.112.194/txtdocs/departmentslist.ascx.txt

web config

http://209.200.112.194/txtdocs/web.config.txt

Help???




Laura

"Patrick Olurotimi Ige" <> wrote in message
news:Otxjw$...
> Brock good u figured out that issue ..
> And Laura have u finally fixed the connection?
> Patrick
>
>
> *** Sent via Developersdex http://www.developersdex.com ***

Laura maybe you can give a try like this:-
Don't use:-
ConfigurationSettings.AppSettings("ConnectionStrin g")

Try including your connectionstring in ur code like:-

Dim connection As New SqlConnection("Data Source=SERVERNAME;Initial
Catalog=YOURDATABASE;User Id=sa;Password=asdasd;")

Hope that helps
** See how it goes**

Patrick




*** Sent via Developersdex http://www.developersdex.com ***