Webmaster Forum / ASP / Database Access / April 2005

I have the following ASP...
set dbconn = server.createobject("ADODB.connection")
dbconn.open "dsn=news;uid=hello"
After the dbconn.open, how do I check if the dbconn.open has an error?

I'm trying to upsize a large Jet-based ASP application to use MS SQL
Server.
I am experiencing a slightly different behaviour when getting results
of a SQL join within a Recordset.

Hi all,
I have one field in db as integer, and i want to retreve only those who dont
have value 1
and my query is like this:

I am testing a asp page where I am trying to run a access update query
from a asp page using the command object. However, it gives the error
as following. I have no idea why the error is coming. Any help is appreciated.
Thanks.

Short version:
ODBC configuration for the Oracle ODBC driver includes a checkbox for
"Enable closing cursors". Does anyone know how to get the equivalent
behavior with the Oracle OLEDB Provider?

I got a asp page where I need insert record to a access table.
However, after running the page the following error is coming:
Error Type:
ADODB.Command (0x800A0E7C)

I am having a very odd problem.  With a database I recently created on MSSQL 2K (Win2K Server Machine), I use a Stored Procedure to handle getting the fields I need.
If I use MS Access to open the Stored Procedure (in an ADP File) it works 100%, same goes through Enterprise ...

I'm running a simpel SQL question towards an Accessdatabase where the
question is generic towards all my tabels in the database
Like this
MySql = "SELECT * from " & dbtable

I waould like to know if moving an ASP application from my Windows98 with
PWS 4 to WIndowsXP Pro with IIS would cut down on the amount of crashes in
inetinfo.exe?
I am closing all connections to the dbf files(I am using these because the

Is it possible to include a file in a web application which is outside the
web path (without virtual directory).
Language is ASP with IIS6.
for example :

I've set up a basic page to list the contents of an access database, which
happens to be a list of names - the strange problem i have is that, although
it lists the contents in order of ID number - it begins the list from half
way down - for instance - beginning at O'brian rather ...

I have this ASP page that inserts new records into an Access database via an
execute statement.
Taking the data from a form, I build my SQL statement like this:
<%

The following was posted to microft.public.scripting.vbscript but nobody
replied there, so here goes:
How come that
<%

I have an ASP form with the following textboxes,
RegNo - Primary Key
EventDate - Date of Event
EventTime - Time of Event

Machine is W2K, using IIS 5, and FP 2000.
I have a small site with 8 ASP pages. The home page opens fine, but the
ASP's just lock up and won't open. I have checked Tools>Datbase and Verify,
all my permissions, directory settings and the extensions, all come back OK.