| Author |
 Topic  |
|
|
dekouw
Starting Member
Netherlands
6 Posts |
 Posted - 10 February 2007 : 10:24:26
|
After changing the config file as derscribed is get this message:
Microsoft OLE DB Provider for SQL Server error '80004005'
Cannot open database requested in login 'databasename'. Login fails.
/forum/inc_header.asp, line 111
annybody who can help with this?? |
|
|
Podge
Support Moderator
Ireland
3776 Posts |
|
|
dekouw
Starting Member
Netherlands
6 Posts |
Posted - 10 February 2007 : 11:47:40
|
yes, i checked two times (i changed the name in this message
|
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 10 February 2007 : 12:47:31
|
are you sure you didn't miskey, add a space, lose or add an extra ' or " or anything? Did you change the data in the db?
Could you post the few lines of code around the error (you can obfuscate the password) so we could see if anything is obvious? |
|
|
|
dekouw
Starting Member
Netherlands
6 Posts |
Posted - 10 February 2007 : 16:14:11
|
| I will try once more |
|
|
|
dekouw
Starting Member
Netherlands
6 Posts |
Posted - 10 February 2007 : 16:30:21
|
'#################################################################################
'## SELECT YOUR DATABASE TYPE AND CONNECTION TYPE (access, sqlserver or mysql)
'#################################################################################
strDBType = "sqlserver"
'strDBType = "access"
'strDBType = "mysql"
'## Make sure to uncomment one of the strConnString lines and edit it so that it points to where your database is!
strConnString = "Provider=SQLOLEDB;Data Source==Server_IP;database=DBName;uid=username;pwd=XXXXXXXX;" '## MS SQL Server 6.x/7.x/2000 (OLEDB connection)
'strConnString = "driver={SQL Server};server=SERVER_NAME;uid=UID;pwd=PWD;database=DB_NAME" '## MS SQL Server 6.x/7.x/2000 (ODBC connection)
'strConnString = "driver=MySQL;server=Server_IP;uid=username;pwd=xxxxxx;database=DBName" '## MySQL w/ MyODBC v2.50
'strConnString = "driver={MySQL ODBC 3.51 Driver};option=16387;server=SERVER_IP;user=UID;password=PWD;DATABASE=DB_NAME;" '##MySQL w/ MyODBC v3.51
'strConnString = "DSN_NAME" '## DSN
strTablePrefix = "FORUM_"
strMemberTablePrefix = "FORUM_"
Edited by ruirib - we don't need the actual DB and server access data |
Edited by - dekouw on 10 February 2007 16:31:35 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
dekouw
Starting Member
Netherlands
6 Posts |
Posted - 10 February 2007 : 17:08:03
|
| You lost me with your question but thanks for editing away the access data |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 10 February 2007 : 17:11:56
|
| Right now you need to determine if the username / password are correct for that database. You could try logging in using one of the SQL Server tools, if you had them... |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 11 February 2007 : 06:48:21
|
If you don't have the SQL Server tools, you could try using Access to connect to the remote database (try creating a linked table)
Rui - a thought, could the databasename dekouw is trying to use be a dupe of an existing db, hence the credentials failure? |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 11 February 2007 : 10:51:20
|
That's a good suggestion, the Access one. It means that dekouw needs either to create an ODBC connection to the database, or use a data access project, that will allow him to connect to the database server directly...
Not sure about the second thought, though. You mean a duplicate of the DB? |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 11 February 2007 : 11:13:04
|
| Well rather a dupe of the existing db name. I don't know his host, or how they're configured or how well they're segmented, but if, for instance, there's already a database called 'DBName' (or some other default, maybe 'snitz', etc) in their sql server, and someone else tried to connect to that db then the u:p would fail. I guess more details on the host would clear that one up! |
|
|
|
daveo
New Member
97 Posts |
Posted - 11 February 2007 : 12:47:46
|
| Also, is the account a windows domain account so username would be domain\account or a SQL account where the username would be account? |
http://copdforum.portalone.us/ |
|
|
| |
Topic |
|
Topic Locked
