| Author |
 Topic  |
|
|
Ribkick
Junior Member
USA
296 Posts |
 Posted - 07 June 2001 : 18:37:39
|
Many of you have recommended Table Editor as an on line database editing tool on my server. I have ver 7.0 beta and have uploaded it as well as it's test.mdb to it's own directory on my server, checked the config.asp file and have tried to run all *.asp files to start it....nothing.
Which file is the main program file and or how do I use it/get it to run?
So you know, I've been to their site, looked at their Q&A's, asked my own questions and still have not gotten any help. I wouldn't bother you all if I hadn't tried there first. They do not include a readme file or directions with their download.
What am I missing here? Anyone know?
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 07 June 2001 : 18:52:39
|
ahmm, the index.asp file is the file to start with.
The te_config.asp file is the file that you need to edit to reflect where your databases are that you want to edit.
|
 |
|
|
Ribkick
Junior Member
USA
296 Posts |
Posted - 08 June 2001 : 02:30:36
|
I started with the index first...nothing. I'll fiddle some more. Thanks Davio 
|
|
|
|
barky81
Junior Member
USA
166 Posts |
Posted - 08 June 2001 : 13:03:25
|
Well, three quick things...
(1) the code assumes the database is located in the same directory as the .asp files... In situations where this is not true for whatever reason (separate DB folder--either in or out of the web hierarchy), the code must be modified...(and the included DBs--both admin and test, must be moved to a writeable DB folder).
(2) Related to #1 above, is that the code assumes a .map path to the databases. It must be modified to use "d;\....." when you have a hard path to the DB folder (this really applies when the DB folder is outside the web directory). And the code must be modified--on a "case" by case basis, depending on which DB type you are connecting to and how....
(3) The default code is setup for only 4 DB connections (using three different connection methods). You can modify it to handle as many DBs as you want, however you want to connect to them, but you must modify the code in several different places to do so.
These really are enough "hints" to fix up the code, but I would be happy to be more specific, if you can tell me (1) what type of DB (access or SQL), (2) what type of DB folder setup, (3) and how you plan to connect to it (DSN or direct).
Oops, almost forgot, the file to edit is te_config.asp (it's not well-enough documented).
barky
quote:
I started with the index first...nothing. I'll fiddle some more. Thanks Davio
|
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 08 June 2001 : 16:00:24
|
quote:
3) The default code is setup for only 4 DB connections (using three different connection methods). You can modify it to handle as many DBs as you want, however you want to connect to them, but you must modify the code in several different places to do so.
I remember only one edit to add additional databases when I setup table editor, in the config file.
======
Doug G
====== |
|
|
|
barky81
Junior Member
USA
166 Posts |
Posted - 08 June 2001 : 17:38:22
|
quote:
quote:
3) The default code is setup for only 4 DB connections (using three different connection methods). You can modify it to handle as many DBs as you want, however you want to connect to them, but you must modify the code in several different places to do so.
I remember only one edit to add additional databases when I setup table editor, in the config file.
======
Doug G
======
There's this:
'Define your total number of connections here
'(The biggest "i" of arrDBs(i) should be equal to this)
const iTotalConnections = 4
Then you have to add info here (one for each database):
arrType(i) = XXXXXX
You need one of these for each database...
'arrDBs(i) = connection method
arrDBs(4) = one for each database
And finally, if you want to accurately reflect which DB you are accessing, you add to this array...
'--[»]--- Define Descriptions for Connections ---------------
arrDesc(0) = "Table Editor User Administration"
There is an alternative config file that will simply access all the databases in a folder (thus limited to file-based DBs), but I don't believe it is included in the basic zip. It's a file you substitute....
I may be wrong, however....
barky
P.S. The e-mail notification appears to NOT be working on snitz today...
|
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 08 June 2001 : 20:00:31
|
Yes, this is what I recalled. To me, that's just one place. Several places to me would be either widely scattered in a big file, or in different files. Just a different interpretation.
======
Doug G
====== |
|
|
|
Ribkick
Junior Member
USA
296 Posts |
Posted - 12 June 2001 : 11:14:36
|
Thank you all!! Barky81, I'll give it a try and if I need more help I'll post here.
I'm on an Access DB, seperate database folder, read/write enabled, using the Access 2000 drivers. I loaded the TE files in their own folder on the same level of the DB folder.
|
|
|
| |
Topic |
|
Topic Locked
