Solved

ConnectionString Problems?

Posted on 2009-05-19
1
207 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 500 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

Enroll in July's Course of the Month

July's Course of the Month is now available! Enroll to learn HTML5 and prepare for certification. It's free for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

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

I recently went through the process of creating a Calendar Control of events with the basis of using a database to keep track of the dates that are selectable, one requirement was to have the selected date pop-up in a simple lightbox.  At first this…
IntroductionWhile developing web applications, a single page might contain many regions and each region might contain many number of controls with the capability to perform  postback. Many times you might need to perform some action on an ASP.NET po…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

617 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