Webmaster Forum / ASP / Database Access / April 2007

I need to tune up an application and I'd like to enable sql tracing to see
how query are made.
I've search around to see how I can do but I've find nothing.
I'm using adodb object with a connection string to connect to my sqlserver.

I have an Access DB where the table names are not helpful (e.g."ph"), but
the DESCRIPTION is friendly (e.g. "Public Health").
The descriptions have been put in by directly editing the Access interface
and right-clicking the table, selecting "Properties", and entering text into

I was wondering whether anyone could shed any light on why my SQL update
query works when run in an Access query, but doesn't work on the same
database when run through ASP and ODBC.
Here's the code:

Is there a tool for converting Microsoft Access Queries & Forms to
ASP
so you can put it on the web?
We have an Access database with a half dozen tables, plus a number of

I'm trying to access an access database on the file server from a web server
using asp.net and IIS 6.0.  I can do it when I have anonymous access enabled
in IIS 6.0 as in the public internet web site style.  I want to do the same
with the intranet setup where IIS 6.0 is not setup ...

Hi, I am new to ASP but have what should be a fairly simple task that I
can't figure out.
I need to parse a string from a single, semi-colon delimited, 60 character
field (el_text) in a recordset and display the results in a table on a

Hi, all!  Running IIS7 under Vista Business (RTM, from MSDN
Subscriptions).  ASP installed and MIME type for ASP page is correct.
I just dropped on a basic ASP website using an Access 2k3 database on
the backend via file DSN (tried System DSN also, no go).  When I call:

Hi, I am new to ASP but have what should be a fairly simple task that I
can't figure out.
I need to parse a string from a single, semi-colon delimited, 60 character
field (el_text) in a recordset and display the results in a table on a

Hi, I am new to ASP but have what should be a fairly simple task that I
can't figure out.
I need to parse a string from a single, semi-colon delimited, 60 character
field (el_text) in a recordset and display the results in a table on a

I was getting the error
[Oracle][ODBC][Ora]ORA-00933: SQL command not properly ended
For me, I had in my ASP page reading from an oracle table:
Select TT.myfield

Here is the scenario, i have a stored procedure, it calculates
commissions and runs fine in SQL.  However when the SP is run through
my asp page it will come back with a divide by zero error, but only
for one sales person...  I have been through this code a hundred times

I am trying to use ASP in html to retrieve and display data from an MS
Access database. I keep getting this error:
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'PersonID='.

I have a page (located at mywebsite/a.asp) that redirects to another page
(theirwebsite/b.asp) located in other server. This other page probably will
redirect to another link again (othersite/c.asp) and finally display the web
page I want the user to see  (finalwebsite/d.asp)

Wondered if you could help.
I have created a little backup routine (using classic ASP and ADO) to get my
data from my db into a bespoke XML file, ie I query the data into a
recordset, concat the XML tags with this data and then put it into a text

Can somebody direct me on proper syntax of SQL statement to insert
into one table that has child table in a relational database?
I can get the insert to work for the Parent, but a record also needs
to be inserted into the Child.   Below is an example of my tables.  I