January 30, 2006 at 12:30 pm
I've installed MS SQL Express, created a new db, and created a new system login with sysadmin rights and a new user for the database I created....and assigned my new system login to it. (all in the MS SQL Express Mgmnt GUI)
Trying to connect via:
MyConn.Open "Provider=sqloledb;Network Library=DBMSSOCN;Data Source=HOST;Initial Catalog=HelpDesk;User Id=bmdxtreme1;Password=password"
Continually getting failed message:
2006-01-30 17:39:15 W3SVC21984 HOST 67.43.5.218 POST /helpdesk/program/admin/index.asp REF_URL=|94|80004005|Cannot_open_database_requested_in_login_'HelpDesk'._Login_fails. 80 - 69.14.190.28 HTTP/1.1 Mozilla/5.0+(Windows;+U;+Windows+NT+5.1;+en-US;+rv:1.8)+Gecko/20051111+Firefox/1.5
February 2, 2006 at 8:00 am
This was removed by the editor as SPAM
February 2, 2006 at 8:18 am
February 2, 2006 at 10:38 am
DBMSSOCN was part of SQL Server 7. It is not used with later versions of SQL Server. Since the default library is TCP/IP, the above suggestion should work.
February 4, 2006 at 8:19 am
If you use SQL Server 2005 and Visual Studio 2005 you meed not write any connection string
V.Kadal Amutham
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply