| Author |
 Topic  |
|
|
martybatten
Starting Member
United Kingdom
6 Posts |
 Posted - 17 October 2005 : 06:57:12
|
Hi there,
Im having some problems during the initial setup, I have successfully set up the forum on our local test SQL server, but when running the setup on our live site I get the following errors (diff error depending on either OLEDB connection or ODBC).
Error #1 - OLEDB
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 : 80004005
Error Description :
[DBNMPNTW]Access denied.
Error #2 - ODBC
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 : 80004005
Error Description :
[Microsoft][ODBC SQL Server Driver][Named Pipes]Access denied.
I have checked and double checked the config and all seems fine, this is especially weird as it worked no probs locally on our test/development server.
Any help greatly appreciated and thanks in advance..
Marty :-) |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
martybatten
Starting Member
United Kingdom
6 Posts |
Posted - 17 October 2005 : 12:10:37
|
| Thanks for the reply - we have checked that and we have the correct username/password for the database - which makes this just plain crazy.. ?! |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
martybatten
Starting Member
United Kingdom
6 Posts |
Posted - 20 October 2005 : 04:48:26
|
| I tried both methods as pasted above - both gave similar errors.. . |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 20 October 2005 : 05:24:12
|
| Named Pipes/tcpip are not related to which connection string you are using, it is a server setting on the SQL server, you need to enable TCPIP as the connection type at the SQL end not the forum |
|
|
|
martybatten
Starting Member
United Kingdom
6 Posts |
Posted - 20 October 2005 : 05:53:05
|
| Aah got ya, sorry am such a noobie :-S.. . |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 20 October 2005 : 17:40:55
|
Usually tcp is enabled at the sql server. But if you use the sql server's computer name in you connection string the connector will generally default to named pipes. Try using the sql server's IP address in the connection string rather than the name, or if you search the documentation there you can add an attribute in your connection string that will force a particular network library.
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
martybatten
Starting Member
United Kingdom
6 Posts |
Posted - 21 October 2005 : 11:42:01
|
| Yeah it gave me the same error using the IP, am going to look into the TCP/IP thing next week.. its been too mad here to look into it anymore, thanks everyone for the help.. hopefully this will sort out.. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
martybatten
Starting Member
United Kingdom
6 Posts |
Posted - 21 October 2005 : 11:54:59
|
Ok - fixed it!.. random. . forced the network ("Network=...") and that worked a treat. . friday beers will taste all the sweeter!
Thanx team.. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
Topic Locked
