REQ: Easy 3 column database help

[igotregistered]

Hi,

I would like to create an extremely small database, only three columns in one table, (preferably excel). It will be used to archive links to old project urls linked to our intranet ticket records.

I would like the front end to be html with 3 fields to enter the data, (ie. Date, ID, Project Name) with a submit button. And have the records presented on an html page.

Is this possible? I am not allowed to have mysql or access. Basically, they don't want me to create a monster on their server.

Thank you

[traq]

I'm sure you could use excel, but I don't think it would be easy (convenient/non-monstrous) to integrate with your website.

If they don't like MySQL (which isn't really all that monster-like), you could see if your host supports SQLite (http://www.sqlite.org/). It's very small and portable.

[igotregistered]

Hi, thank you for responding. This is my company, actually. Basically I built a small utility site for my particular job function. I admin our phone systems voIP network. The site has all our locations, call manager and CME IP connections, vendor references.....etc.

I also included parts of our intranet in iframe tags which pertain to my job function as well.

Basically I want to keep a running list of all our site projects, outside of headquarters. I'd like to be able to enter the project info into text fields and submit to create a new record. I'm not allowed to do anything but host my html files in a small directory on this production server. I figured I might be able to use something from microsoft, maybe. And make an HTML form to add the records

[igotregistered]

How about flat file, with text files? Can that be done with an html front end to view existing records, and enter new?

[djr33]

Yes, but it won't give you the flexibility or availability of a database: you can't search, cross reference or do anything else easily.

If your system is simple you may be able to design a flat file system that works fine, but it won't be the most efficient way. The irony here is that mysql will be less work for the server than flat files... but... that's that, I guess...

[traq]

SQLite doesn't require any special configuration; if your PHP version supports it, you simply save the database file on your server, just like any other file.

However, to clarify, do you have PHP (or another server-side scripting language, ASP, etc.) available? HTML alone can not do anything like this.

[igotregistered]

SQLite doesn't require any special configuration; if your PHP version supports it, you simply save the database file on your server, just like any other file.

However, to clarify, do you have PHP (or another server-side scripting language, ASP, etc.) available? HTML alone can not do anything like this.


Hi traq, thank you for replying.

No, firstly this is windows 2008 server with IIS. No apache, PHP, or Mysql. It's just a business run web server for our IS intranet.

Is there any kind of form I can use to enter data to store the records on my site? I tried access but completely forget how to use it. It's been a very long time since the last.

[igotregistered]

The server is running .asp. Thats it.

[traq]

I don't know ASP, though a quick search turns up several tutorials that seem to indicate ASP can run a SQLite DB: here (http://www.aspfree.com/c/a/Database/Using-SQLite-for-Simple-Database-Storage/) and here (http://sqlite.phxsoftware.com/)

As far as a "form that can enter records" on your site, forms only collect and submit information. They have no way of processing it. You must use an external script of some sort to process and save the information; HTML by itself is not capable of that.

[igotregistered]

After some searching, I found this
http://www.stardeveloper.com/articles/display.html?article=2000040101&page=1

I made no changes to any of the code, and added my existing html into each page.

I can add records manually into the table via MS access, and they do show up on my "showall.asp" page.

However, I cannot enter any records through my form.

I get this message:


Microsoft JET Database Engine error '80004005'

Operation must use an updateable query.

/telco/form_ac.asp, line 166



This is line 166


' Creating Connection Object and opening the database
Set con = Server.CreateObject("ADODB.Connection")
con.Open data_source
line 166 ---> con.Execute sql_insert
' Done. Close the connection
con.Close
Set con = Nothing
Response.Write "All records were successfully entered into the database."

[traq]

Unfortunately, I don't know enough about ASP or Access to help you here - and I'm not sure we have many ASP users here on DD, either. You could post another thread about this in the ASP sub-forum, or look around for a good ASP community forum that might be able to offer some help.

[igotregistered]

Unfortunately, I don't know enough about ASP or Access to help you here - and I'm not sure we have many ASP users here on DD, either. You could post another thread about this in the ASP sub-forum, or look around for a good ASP community forum that might be able to offer some help.

I got it!. The error code generated from the access table was a permissions issue. I had to grant "Users" full permission to write to the table. Everything is working perfect now. A nice light database backend, with a tight and clean front end.

[traq]

glad to hear it.