var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: 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.
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;DATAB ASE=s01673925"
Can any1 help mi by telling mi why i cant connect 2 database?
Re: Cannot open 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 to fix the issue.
Cool...it's your final and you can't connect...must be a great course...
What's your major?
BK : Arrête d'être aussi énervé pour un rien
Pense à ta tension
Un arrêt 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 ?