Monday, March 19, 2012

Cannot open database

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