SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 MSDE (2000)
 ConnectionString Case-Sensitive?!!!
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

markduran
Starting Member

Philippines
4 Posts

Posted - 04/21/2005 :  05:41:47  Show Profile  Send markduran a Yahoo! Message  Reply with Quote
I'm using MSDE release A that servers as a local storage for caching.
I've setup another instance for my msde database.
Whenever I connect to the msde database, using the connectionstring property in SqlConnection(ADO.Net),
setting the Data Source Property to :
"Data Source="(LOCAL)\INSTANCENAME";Initial Catalog=Toys;User ID=sa;Password=foo;Persist Security Info=False;"

Opening the sqlconnection returns an sql exception saying "SQL Server does not exist or access denied."

however, setting datasource (local) to lowercase like :
"Data Source="(local)\INSTANCENAME";Initial Catalog=Toys;User ID=sa;Password=foo;Persist Security Info=False;"

opens the connection and works, lowercase (local) and . works but uppercase (LOCAL) doesn't!!!

I don't see this problem in SQL Server...
What's Wrong?! Is MSDE case-sensitive?!!

AjarnMark
SQL Slashing Gunting Master

USA
3246 Posts

Posted - 04/21/2005 :  14:06:16  Show Profile  Visit AjarnMark's Homepage  Reply with Quote
I'm surprised that the connection is case sensitive like that, but it does not reflect on whether the database is setup with a case-sensitive collation or not.

Then again, I never use "(local)". I always use the computer name, even when it's my own.

---------------------------
EmeraldCityDomains.com
Go to Top of Page

markduran
Starting Member

Philippines
4 Posts

Posted - 04/22/2005 :  00:52:36  Show Profile  Send markduran a Yahoo! Message  Reply with Quote
weird thing is, the error only comes up when connecting using sqlconnection.
connecting with query analyzer works fine with the uppercase (LOCAL) and enterprise manager register it successfully.... Tongue Tied
Go to Top of Page

AjarnMark
SQL Slashing Gunting Master

USA
3246 Posts

Posted - 04/22/2005 :  02:07:45  Show Profile  Visit AjarnMark's Homepage  Reply with Quote
Well, my fallback generic answer is to check to make sure you have a current version of MDAC installed...

---------------------------
EmeraldCityDomains.com
Go to Top of Page

markduran
Starting Member

Philippines
4 Posts

Posted - 04/22/2005 :  05:13:51  Show Profile  Send markduran a Yahoo! Message  Reply with Quote
I have the latest version of mdac, I reinstalled it but I still get the same behavior
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.2 seconds. Powered By: Snitz Forums 2000