Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

ConnectionString Problems?

Posted on 2009-05-19
1
Medium Priority
?
209 Views
Last Modified: 2012-05-07
I am trying to put a chat room onto my site...the problem I have is I get an error that says the following when I try to login:

Keyword not supported: 'premsql2g.brinkster.com;initial catalog'.

What is the deal here?  I was told by Brinkster.com that premsql2g.brinkster.com is the host name for a connectionstring.  Can you guys please help?  This is what I have in the web.config file:

<add key="ConnectionString" value="premsql2g.brinkster.com;Initial Catalog=database;user id=user;password=password"/>

Obviously the initial catalog and the userid/password has been changed.  Can you guys help?  Thanks!
0
Comment
Question by:VBBRett
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 11

Accepted Solution

by:
Muhammad Ousama Ghazali earned 2000 total points
ID: 24425065
You were missing the word server in the value attribute. Use this one:
<add key="ConnectionString" value="server=premsql2g.brinkster.com;Initial Catalog=database;user id=user;password=password"/>
And for all kinds of connection strings, always resort to this link: http://www.connectionstrings.com/
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Sometimes in DotNetNuke module development you want to swap controls within the same module definition.  In doing this DNN (somewhat annoyingly) swaps the Skin and Container definitions to the default admin selections.  To get around this you need t…
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question