I am trying to set up my forum and I am getting an the following error:
The database could not be opened !! Check your config.asp file and set the strConnString so it points to the database. Also check if strDBType is set to the right database type.
Code : 80004005
Error Description : Cannot open database requested in login 'snitzdb'. Login fails.
I've searched on the error code and see that it generally is caused by permissions setup. I am hosting through ComCity.com and I have established a DSN entitled "snitzdb" with the database name the same (snitzdb) within the database control panel, which uses MS SQL 2000. My database control panel gives me an IP address of 205.178.132.160 and I'm using the following sequences:
strDBType = "sqlserver"
strConnString = "Provider=SQLOLEDB;Data Source=205.178.132.160;database=snitzdb;uid=********;pwd=******;" '## MS SQL Server 6.x/7.x/2000 (OLEDB connection)
I have replaced the uid= and the pwd= with asterisks, but my entry in the config.asp matches the username and password in my database control panel.
I extracted the Snitz files to a directory named "snitz" and uploaded that directory into my /htdocs directory on my host server.
I've actually had this working previously, using a different DSN and database name, but I deleted that database configuration from my control panel for unrelated reasons. Now I can't enter setup. Any ideas?
Thanks for the reply. I just went into my config.asp file and used the DSN string and put the ' back in front of the other string, saved it and uploaded it to my server. I then reloaded the setup.asp file from my browser and I got this message:
The database could not be opened !! Check your config.asp file and set the strConnString so it points to the database. Also check if strDBType is set to the right databasetype.
Code : 80040E4D
Error Description : [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Topic Locked
Posted - 20 July 2006 : 15:03:32
