| Author |
 Topic  |
|
|
Jim Riley
New Member
United Kingdom
64 Posts |
 Posted - 19 August 2001 : 11:23:37
|
Downloaded TableEditor today following all the positive comments about this software on these boards. But cold I get the config file to connect to my Snitz database? Er...no
I've got a standard Snitz db sat in the Forum directory (e.g.http://www.domain.com/forum/snitz_forum2000.mdb)
TableEditor stored in a TableEditor directory at the same level as Forum
After 3 hours of trying every combination known to man, I just cannot get the connection to work.
Has anyone else managed to make this software work for their Snitz Forum mdb...or should I just forget it/find an alternative
Yours frustratingly
Jim
http://www.tutor2u.net
The Study Portal for the Economic and Political Sciences
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 19 August 2001 : 18:08:40
|
Table editor works fine for me. Easiest configuration is if you have a DSN to your database file, just add a DSN entry in te_config. Otherwise you should be able to copy your Snitz connection string and use a connection string type connection in te_config. There are about 3 different places you need to make entries in te_config, look over the sample entries in the file carefully.
======
Doug G
====== |
 |
|
|
Jim Riley
New Member
United Kingdom
64 Posts |
Posted - 21 August 2001 : 19:00:39
|
I have now connected to my Snitz Forum using a DSN connection via Table Editor. I want to amend a member's user name. I can search Forum_members and the query returns details of the member I need to edit. But I don't see any editing options (delete a member appears to be the only option - not desirable!).
Is this becuase I am using a DSN connection? Would I be able to edit fields by using a direct string connection?
Help? Please!
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 21 August 2001 : 20:17:22
|
You can edit a Member's Username without going into the Database.
Goto your Member's Page (while logged in as Admin). Click on the  that is in the right hand column of icons. You'll be asked for the Admin Username/Password, then on the next page, you can edit the Username of that User.
btw...
In TableEditor, the icon to edit a record looks like this: 
It's right beside the icon to delete a record: 
They are both in the Action column. |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 21 August 2001 : 21:00:16
|
Hey Richard, what do you use to do your screen captures and edits?
======
Doug G
====== |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 21 August 2001 : 21:21:34
|
I'm just linking to the images from the TableEditor website...  |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 22 August 2001 : 00:30:34
|
quote:
Hey Richard, what do you use to do your screen captures and edits
I was gonna ask the same question when I saw that screen capture...then I remembered I saw that image somewhere on the Table Editor website. lol
To add to the topic, if you're not using a DSN to connect to your database, there many errors you will run into when trying to use the Connection String. The code is quite buggy, in the te_config.asp file. Took me quite a while to get it working...and I'm a seasoned asp scripter...at least I consider myself so.
- David |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 22 August 2001 : 00:44:04
|
Davio,
Really? I've never had a problem setting up database connections.
Are you using the latest version? |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 22 August 2001 : 00:50:51
|
yeah, the 0.7 beta. The one Hakan released before he left.
If you check out thier message board you will see many users have encountered the same problems I had ran into. I even tried helping a few of them. hehe
- David |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 22 August 2001 : 02:29:38
|
quote:
I'm just linking to the images from the TableEditor website...
Here I was hoping to get some great graphics tips :)
I've copied an Interdev generated connection string right into Table Editor with no problem. Basically, I've not run across any problems with table editor connections, although I think te_config could be redone so all your connection information is together.
======
Doug G
====== |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 22 August 2001 : 02:40:17
|
quote:
I've copied an Interdev generated connection string right into Table Editor with no problem.
Just recalling back now, that's mainly what led to the problems I had with it. Thier connection string. Oh well.
- David |
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 22 August 2001 : 03:01:01
|
Ehm...should have replied earlier...never had problem with TableEditor.
I'm using the same connectionstring as in config.asp
I bypassed the default logic a bit like this:
'Define database locations
arrDBs(0) = "/<path to database>/teadmin.mdb"
arrDBs(1) = "/"
'Define descriptions for corresponding connections
arrDesc(0) = "Table Editor User Administration"
arrDesc(1) = "Snitz Forums database on Sql Server 7"
'Construct connection strings
for iConnection = 0 to iTotalConnections
arrConn(iConnection) = "Provider=Microsoft.Jet.OLEDB.4.0;" &_
"Persist Security Info=False;" &_
"Data Source=" & Server.MapPath(arrDBs(iConnection))
next
arrConn(1) = "driver={SQL Server};server=xxx.xxx.xxx.xxx;uid=xxx;pwd=xxx;database=xxx" '## MS SQL Server 7
arrDBs(0) is a real virtual path, since that is the one to the access database with the users.
arrDBs(1) is just set to "/" because it was the least code-change.
For the extra arrConn(1) = line I used the exact same connectionstring as in config.asp
This way, if I wanted to add another database, I would simply change the iTotalConnections line in the file:
'Define your total number of connections here
const iTotalConnections = 2
and add the new connection:
'Define database locations
arrDBs(0) = "/<path to database>/teadmin.mdb"
arrDBs(1) = "/"
arrDBs(2) = "/"
'Define descriptions for corresponding connections
arrDesc(0) = "Table Editor User Administration"
arrDesc(1) = "Snitz Forums database on Sql Server 7"
arrDesc(2) = "Another database"
'Construct connection strings
for iConnection = 0 to iTotalConnections
arrConn(iConnection) = "Provider=Microsoft.Jet.OLEDB.4.0;" &_
"Persist Security Info=False;" &_
"Data Source=" & Server.MapPath(arrDBs(iConnection))
next
arrConn(1) = "driver={SQL Server};server=xxx.xxx.xxx.xxx;uid=xxx;pwd=xxx;database=xxx" '## MS SQL Server 7
arrConn(2) = "driver={SQL Server};server=yyy.yyy.yyy.yyy;uid=yyy;pwd=yyy;database=yyy" '## MS SQL Server 7
Works all the time using version 0.6
Any important new things in version 0.7 ?
Pierre
Join a Snitz Mailinglist |
|
|
|
tomasalsbro
Average Member
Sweden
818 Posts |
Posted - 22 August 2001 : 03:03:01
|
Well, I'm one of those who'm never got it to work!
As I noticed many more like myself hade this configure problems and posted questions about it, but their was no answers.
Tomas
!-Keep distance in traffic-!
www.whiplash.se
www.whiplash.pp.se |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 22 August 2001 : 03:24:17
|
quote:
I'm using the same connectionstring as in config.asp
gee, so i guess like I'm the only guy around here who didn't change the connection string with something he was more familiar with. I could have saved myself a whole lot of trouble. sheesh lol
- David |
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 22 August 2001 : 04:13:08
|
quote:
Well, I'm one of those who'm never got it to work!
As I noticed many more like myself hade this configure problems and posted questions about it, but their was no answers.
Tomas
You posted the questions here ?
Did my fix work ?
Pierre
Join a Snitz Mailinglist |
|
|
| |
Topic |
|
Topic Locked
