whats wrong wif my connection?

[Steve Pullan]

pandapatin wrote:

the spelling is ok,i've double check it.it is the same as my connection string as it in my web config file.So anything i can do to solve it?

Dim MyConn As New SqlConnection(ConfigurationManager.AppSettings("psmConnectionString2"))

This is the line it is crashing on right? Make sure that whatever psmConnectionString2 contains is in the correct format and properly constructed. Hint: Put the cursor on SqlConnection in the line above (in Visual Studio) and press F1. ...Steve "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." (Translation: I'll show you the way, but not write the code for you.) I read that somewhere once :-)

[pandapatin]

do i need a datatable adapter with it?i dun know how to used it?

[HimaBindu Vejella]

Your code is correct May be u r wrong in placing the right connection string In ur web.config what's the code that u r using for assigning psmConnectionString2 Just print psmConnectionString2 and Check ,If It's giving error or not Nothing is Impossible Even Impossible says I'MPOSSSIBLE

[pandapatin]

in my web config : how can i print the psmConnectionString2 and Check ,If It's giving error or not?

[HimaBindu Vejella]

Is this your connection string or some other Just print using lblMessage.Text =ConfigurationManager.AppSettings("psmConnectionString2")); Response.End(); If ur label gets the Connection string value u have declared then ur connection string and D connection is correct Other wise problem with connection string declaration /DB Connection Senior Software Engineer Nothing is Impossible Even Impossible says I'MPOSSSIBLE

[pandapatin]

it return nuthing.the page when blank.whats wrong?

[HimaBindu Vejella]

That means that u are not getting ur connection string in the label So problem with connection string Have u delclatred it like this or not here strCon is My connection stirng Senior Software Engineer Nothing is Impossible Even Impossible says I'MPOSSSIBLE

[Guffa]

The error is in your connection string, no the code. The format of the connection string is "keyword=value;keyword=value;...;keyword=value". What you have put in the connection sting does not follow this syntax. --- b { font-weight: normal; }

[pandapatin]

could u show me one of ur example?

[pandapatin]

where should i change.is it in the web config?

[Guffa]

Yes. --- b { font-weight: normal; }

[pandapatin]

there is an error: Unrecognized attribute 'keyword'. Note that attribute names are case-sensitive. the code is: add keyword="name=psmConnectionString2" keyword1="connectionString=Data Source=HAPPYFAM-B614E1\SQLEXPRESS;Initial Catalog=psm;Integrated Security=True" providerName="System.Data.SqlClient" -- modified at 4:06 Wednesday 1st March, 2006

[HimaBindu Vejella]

in my web config : providerName="System.Data.SqlClient" /> It's not a valid connection string declaration Please declare a vlaid connection string by generating connection string through typed dataset Senior Software Engineer Nothing is Impossible Even Impossible says I'MPOSSSIBLE

[pandapatin]

i cant understand what did u mean?could u show my what ur web config look like.

[HimaBindu Vejella]

This is my web.config file

[HimaBindu Vejella]

My Web.Config file configuration appSettings add key="connstring" value="data source=192.168.0.18;database=ABDATABASE;user id=sa; password=; appSettings system.web Senior Software Engineer Nothing is Impossible Even Impossible says I'MPOSSSIBLE -- modified at 4:30 Wednesday 1st March, 2006

[pandapatin]

where did u specified ur connection string?

[Guffa]

The attribute names in the tag shold be "key" and "value", not "keyword", "keyword1" and "providerName". Remove "connectionString=" from your connection string. Remove the providerName attribute. --- b { font-weight: normal; }

[Jai Mataji]

pandapatin wrote:

Dim MyConn As New SqlConnection(ConfigurationManager.AppSettings("psmConnectionString2"))

Can you paste the value for the key psmConnectionString2 in Web.config to obtain better picture. Sneha