Click here to Skip to main content

Article

Online DB Administration

Bjornar Henden

Rate me:

3.88/5 (16 votes)

17 Mar 2003

236.4K

2.5K

58

82

Online administration of your database. Create or modify tables, keys, and indexes. Edit or insert data.

Download source files - 38 Kb

Introduction

This is an application for online administration of your database.

Features

Supports MS SQL Server (not completely) and MS Access.
Create, modify, and drop tables and views.
Create and drop keys (primary, foreign, and unique).
Create and drop indexes.
Edit, insert, and duplicate rows in tables.
Foreign keys are used to create filters/lookups when browsing and editing data.
Export tables and views to a CSV file.

Installation

Unzip all files to a directory available from your web server.
Modify config.asp to point to your database.

History

Feb 27 2003

Included adojavas.inc since a few seems to have problem with metadata and global.asa.
Lots of minor changes and bug fixes.

Mar 18 2003

Updated source code.

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

Written By

Bjornar Henden

Web Developer

Norway

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Comments and Discussions

Missing ado constants

smorley16-Jan-03 6:02

16-Jan-03 6:02

The only problem that I'm getting is that none of the ado constants are defined. I'm running this on a WinXP system on which I primarily do ASP maint. Is there some config setting which makes the ado constants available to the scripts. I usually need to include adovbs.inc if I want these values available for VB Scripts.

Re: Missing ado constants

smorley16-Jan-03 6:29

16-Jan-03 6:29

Answered my own question.

Forgot to move the METADATA stuff to the active global.asa.

Also needed to update for ADO2.7

Here's some info on METADATA if your so interested: http://www.atgconsulting.com/adotypelibs.asp

Sw_writer16-Jan-03 1:00

16-Jan-03 1:00

The install took < 60 seconds (made an application in IIS, changed provider string) and it was up & running!

I'm impressed.

Nice work. Smile | :)

Smile | :)

will dbadmin work w/ PWS? getting error

Bill McGhee8-Jan-03 4:56

8-Jan-03 4:56

All I have changed is the config to point to test.mdb (in the same dir). Getting this.

Response object error 'ASP 0156 : 80004005'
Header Error
/dbadmin/common.asp, line 25

The HTTP headers are already written to the client...

If I remove lines 25 and 26 I get:

Microsoft JScript runtime error '800a1391'

'adUseClient' is undefined

/dbadmin/common.asp, line 30

I have the properties in PWS set to Execute for this dir but I am not sure tht is the same as an IIS application.

bill

Can't run Online DB Administration

tnh28-Dec-02 5:24

28-Dec-02 5:24

I Can't run Online DB Administration well, it cause some errors that in source file wrote.
So can you help me ?

Member 13441118-Dec-02 9:59

18-Dec-02 9:59

Got it to work and bring up all my tables in the Database but why can I add, edit and delete from some tables and not from others? Is it a setting in the code or is it my database? Using SQL 2000 on Windows 2000 server. Thanks for any help.

Swanger

help I got an error message

sohair zaki17-Dec-02 7:42

17-Dec-02 7:42

Please i got a table with two foreign key
on using data.asp?table=xxx
where xx is my table name on clicking the edit button
the edit screen pop up nicely but on clicking the save button
i received the following error message

Multiple-step operation generated errors. Check each status value.

some file is missing!

missbean11-Dec-02 19:05

11-Dec-02 19:05

menu of 'view/Overview' linked table_info.asp

but there is not in zip file.

Re: some file is missing!

Bjornar Henden15-Feb-03 0:17

15-Feb-03 0:17

The file shouldn't be there, and therefore the link shouldn't have been there either.

Please Help I've tried the dsn pointing to sql server 2000 It didn't work

sohair zaki19-Nov-02 7:42

19-Nov-02 7:42

Please i changed the config.asp
as follows

case 'connstr': return 'DSN=xxxx';

i created a system data source pointing to a database on sql server 2000 on another server
I used but i got the error message microsoft ole db provider
with sql authentication using loginid i entered the sa and its corresponding password

but i got the following error message oledb provider for odbc driver error 80040e4d login failed for user null reason not associated with a trusted sql server connection

Help please

Re: Please Help I've tried the dsn pointing to sql server 2000 It didn't work

g.fiorentini26-Nov-02 7:59

26-Nov-02 7:59

1 - Check that Sql2k permit Mixed Mode auth ( simply verify that you can connect by (sa , xxxx) using QueryAnalyser

2 - Check the authentication mode on your DSN system source

3 - Please post the connection string. I think that can be more useful using a DSN-LESS connection string, using OleDb provider. For example: try:
"DRIVER=SQL Server;SERVER=YOURSERVERNAME;UID=sa;PWD=xxxx;DATABASE=YOURCATALOGNAME"

Hope this can help you.

Giacomo

can it be used with dsn connecttion to sql on another server

sohair zaki15-Nov-02 3:31

15-Nov-02 3:31

can it be used with dsn connecttion to sql on another server
what changes should be done

Re: can it be used with dsn connecttion to sql on another server

Bjornar Henden15-Nov-02 8:35

15-Nov-02 8:35

Take a look at config.asp, should be pretty obvious I think Big Grin | :-D

Big Grin | :-D

Please Help help I've tried to use dsn with sql it didn't work

sohair zaki19-Nov-02 6:29

19-Nov-02 6:29

Please i changed the config.asp
as follows

case 'connstr': return 'DSN=xxxx';

i created a system data source pointing to a database on sql server 2000 on another server
I usedbut i got the error message microsoft ole db provider
with sql authentication using loginid i entered the sa and its corresponding password

but i got the following error message oledb provider for odbc driver error 80040e4d login failed for user null reason not associated with a trusted sql server connection

Help please

Re: Please Help help I've tried to use dsn with sql it didn't work

Bjornar Henden19-Nov-02 7:48

19-Nov-02 7:48

Is your sql server set up to use only windows authenticationand not sql server authentication? I believe this is the default for MSDE2000.

Re: Please Help help I've tried to use dsn with sql it didn't work

sohair zaki19-Nov-02 8:58

19-Nov-02 8:58

My sql 2000 is setup to use windows and sql (equivalent to mixed mode in sql 7)

Re: Please Help help I've tried to use dsn with sql it didn't work

Bjornar Henden19-Nov-02 9:03

19-Nov-02 9:03

And you don't have anything like "Trusted Connections" or something similar in the connection string?

can we set lookup from a list of values instead of a table

sohair zaki14-Nov-02 0:45

14-Nov-02 0:45

can we add grid.setlookup(xxxx) how to write it so that we can have for example gender field do have a combo box male, female

Re: can we set lookup from a list of values instead of a table

Bjornar Henden15-Nov-02 8:34

15-Nov-02 8:34

If you put male and female into a recordset that should work.

Please lookup is lost on using views or selecting records according to a criteria in sql

sohair zaki13-Nov-02 17:46

13-Nov-02 17:46

Lookup is lost on using views or selecting particular records in a table
select * from table where field1='x'
i also tried to use views

Re: Please lookup is lost on using views or selecting records according to a criteria in sql

Bjornar Henden15-Nov-02 8:31

15-Nov-02 8:31

Lookup depends on foreign keys, and views have no foreign keys. Cool | :cool:

Cool | :cool:

Re: can we filter a table and still make use of foreign keys

15-Nov-02 10:13

15-Nov-02 10:13

can we filter a table and still make use of foreign keys thanks for your reply

Re: can we filter a table and still make use of foreign keys

Bjornar Henden17-Nov-02 3:26

17-Nov-02 3:26

I guess a recordset created from a select statement instead of a table can be used instead, but this application only supports tables (and views), and not select statements.

lookup shows now but on adding a new record error message

sohair zaki9-Nov-02 6:27

9-Nov-02 6:27

thanks the lookup box shows up but on clicking add without disabling the lookup an error message is displayed infront of the field name of the foreign key instead of a text box
microsoft ole db provider for sql server error 80040e14 invalid column name '2' where 2 is the value of the primary key of the related table

Re: lookup shows now but on adding a new record error message

Bjornar Henden9-Nov-02 10:35

9-Nov-02 10:35

Probably a bug in my code. Doesn't the error message tell you what line (and file) this happens on?

General News Suggestion Question Bug Answer Joke Praise Rant Admin

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Go to top