| Author |
 Topic  |
|
|
woodywyatt
New Member
61 Posts |
 Posted - 02 June 2001 : 08:42:32
|
This has probably been asked many times before. The forum seems to work fine on my PWS locally, but when uploaded I get the error message
'The database could not be opened !!
Check your config.asp file and set the
strConnString so it points to the database.
(The strDBType is set up correctly)
Tried to change this many times in the config.asp, but still not working. The path on my remote site (according to ultra dev) is /e:/31/fuerte.tv/user (the forum is located in 'htdocs' in the 'forum' directory the database in the 'private' directory).
What would be the exact path?
Hope you can help
Gary
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
|
|
BuffyNET
Junior Member
United Kingdom
126 Posts |
Posted - 02 June 2001 : 12:15:32
|
looks like a fasthosts or 121host path, the correct path is e:/domains/fuerte.tv/user/private
Neil
This is my Sig! ©2001 My Sig & Co. Ltd. Plc. etc
|
 |
|
|
woodywyatt
New Member
61 Posts |
Posted - 03 June 2001 : 05:21:52
|
Hi Guys I owe you a beer
Many thanks for your help and speedy replies (and superb forum). It all works fine now after I uploaded the 'whereami'.asp file. Incidentally, I actually got the forum working at first with a DSN connection. Can you tell me the difference between this and using a 'connection string'?
Thanks again
Gary
|
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 03 June 2001 : 13:41:24
|
DSN AND DSNLESS NOTES 6/3/2001
================================
Connection strings, DSN's are all part of MS MDAC (Microsoft Data Access Components). ADO (ActiveX Data Objects) must establish a connection between the application software and the database. Connections can be setup at the system or user level in NT using DSN's (Data Source Names) which are created by your system administrator. The admin will open the ODBC Data Sources Control Panel and create a named connection between the computer and a data source.
When a DSN is set up, the application program only needs to know the name of the DSN to use it, without regard for the actual database location.
DSN's can be either System DSN's, User DSN's or File DSN's.
A DSNLess connection is where the application code provides all the specifics for the database connection via a connection string, and bypasses the entire DSN mechanism. DSNLess are somewhat faster, but for web work their main advantage is that you can set up your connection without bothering your ISP.
The sample connection strings in the config file are representative samples of connection strings, but there are a ton of other options and configurations you can use if you are comfortable with creating your own connections.
If you want to see how a MS string looks and you have W2K, you can use this trick. Create a new desktop item and name it something.udl (something is any filename you want). Then right-click and choose properties, the MS DataLinks configuration screen will open where you can specify your provider, etc., and a complete connection string is built. Open the same .udl file in notepad and cut & paste the connection string if you want to use it. There will be a lot of other connection options that aren't in the basic config sample strings.
END OF FILE
===========
======
Doug G
====== |
|
|
| |
Topic |
|
Topic Locked
