Hi i am currently doing my final year project. I am using MS SQL and ASP. I uncounter the error below when i am doing my login.
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database requested in login 's01673925'. Login fails.
this is my connection string:
Set connection = Server.CreateObject("ADODB.Connection")
connection.Open "DSN=LocalServer1;UID=s01673925;PWD=password;DATABA SE=s01673925"
Can any1 help mi by telling mi why i cant connect 2 database?did you test your DSN connection when you created it ?|||As it seems to the a security issue, ensure the login used have required permission to access the database.
Go thru this KBA (http://support.microsoft.com/default.aspx?scid=kb;EN-US;283860) to fix the issue.|||Cool...it's your final and you can't connect...must be a great course...
What's your major?|||BK : Arrte d'tre aussi nerv pour un rien
Pense ta tension
Un arrt cardiaque peut arriver si vite|||Lighten up france'es...**
Let me ask you.
Your in school..you take a class in SQL Server...
It's the end of the term...
And you don't know how to connect?
What does that say?
1 of 2 things, doesn't it...
And yes google has a wonderful translator....
** Bill Murray reference...who got screwed last night...|||it's not the END of his term (I hope)|||Are you sure your UID and DATABASE parameters are supposed to be the same? Try replacing DATABASE=s34765345 with DATABASE=pubs|||Did you put the instance name after the server name
in the DSN ?
ServerName\InstanceName
No comments:
Post a Comment