IIS, asp and a database

[Jim Bowman]

I am getting inconsistent results from an e-learning
program - asp page - database connection.

I have installed IIS on my computer from Win XP Pro. My
authoring program (Authorware 5.2) executes a ReadURL
function that calls an asp page. The asp page contains a
SQL SELECT command that is sent to an Access database.
If the desired record exists in the database, the record
is sent back to the asp page which sends it back to the
Authorware file where the contents of the record
display. If an error occurs, an error message displays.

When I first boot up the computer and run the Authorware
file, the sequence runs correctly. On the 2nd run and
most subsequent runs, Authorware returns an error,
IOStatus = 5006 and a message = "unknown error (5006)".
On an occasional subsequent run, the example runs
correctly. Then on the next run, it returns the same
error.

I have uninstalled and reinstalled IIS and have checked
the Authorware and asp page carefully. The problem
persists. What might be the cause of this inconsistency?

Thanks.

Jim Bowman

[Ken Schaefer]

Please try to run the ASP page directly, to determine if the problem is
within the ASP page, or with the ASP page's ADO objects accessing the Access
database.

Otherwise, the problem may be in the Authorware part of your application.

Cheers
Ken

"Jim Bowman" <anonymous@discussions.microsoft.com> wrote in message
news:0b2501c425a3$66d86090$a501280a@phx.gbl...
: I am getting inconsistent results from an e-learning
: program - asp page - database connection.
:
: I have installed IIS on my computer from Win XP Pro. My
: authoring program (Authorware 5.2) executes a ReadURL
: function that calls an asp page. The asp page contains a
: SQL SELECT command that is sent to an Access database.
: If the desired record exists in the database, the record
: is sent back to the asp page which sends it back to the
: Authorware file where the contents of the record
: display. If an error occurs, an error message displays.
:
: When I first boot up the computer and run the Authorware
: file, the sequence runs correctly. On the 2nd run and
: most subsequent runs, Authorware returns an error,
: IOStatus = 5006 and a message = "unknown error (5006)".
: On an occasional subsequent run, the example runs
: correctly. Then on the next run, it returns the same
: error.
:
: I have uninstalled and reinstalled IIS and have checked
: the Authorware and asp page carefully. The problem
: persists. What might be the cause of this inconsistency?
:
: Thanks.
:
: Jim Bowman
:

[Mark Schupp]

It would also be helpful if you posted the ASP script.

--
Mark Schupp
Head of Development
Integrity eLearning
[url]www.ielearning.com[/url]


"Ken Schaefer" <kenREMOVE@THISadOpenStatic.com> wrote in message
news:u0eKPobJEHA.3848@TK2MSFTNGP09.phx.gbl...

> Please try to run the ASP page directly, to determine if the problem is
> within the ASP page, or with the ASP page's ADO objects accessing the

Access

> database.
>
> Otherwise, the problem may be in the Authorware part of your application.
>
> Cheers
> Ken
>
> "Jim Bowman" <anonymous@discussions.microsoft.com> wrote in message
> news:0b2501c425a3$66d86090$a501280a@phx.gbl...
> : I am getting inconsistent results from an e-learning
> : program - asp page - database connection.
> :
> : I have installed IIS on my computer from Win XP Pro. My
> : authoring program (Authorware 5.2) executes a ReadURL
> : function that calls an asp page. The asp page contains a
> : SQL SELECT command that is sent to an Access database.
> : If the desired record exists in the database, the record
> : is sent back to the asp page which sends it back to the
> : Authorware file where the contents of the record
> : display. If an error occurs, an error message displays.
> :
> : When I first boot up the computer and run the Authorware
> : file, the sequence runs correctly. On the 2nd run and
> : most subsequent runs, Authorware returns an error,
> : IOStatus = 5006 and a message = "unknown error (5006)".
> : On an occasional subsequent run, the example runs
> : correctly. Then on the next run, it returns the same
> : error.
> :
> : I have uninstalled and reinstalled IIS and have checked
> : the Authorware and asp page carefully. The problem
> : persists. What might be the cause of this inconsistency?
> :
> : Thanks.
> :
> : Jim Bowman
> :
>
>

Thanks to Ken and Mark for the ideas.

I ran a similar asp page from a form and got the same
results. So, Authorware is not the cause. Here's the
test:

1. I run the asp page with a connection to an Access
db. The asp page contains the VBScript and a form. Both
the asp page and the db are in the same folder in the
wwwroot folder of IIS. Through the form, I run a SQL
SELECT statement. The form correctly returns the record
identified in the SELECT statement.
2. I modify the name of the db.
3. I run the SELECT statement and get an error, as
expected. The error message: "Microsoft OLE DB Provider
for ODBC Drivers error '80004005'. [Microsoft][ODBC
Microsoft Access Driver]General error Unable to open
registry key 'Temporary (volatile) Jet DSN for process
0x6c8 Thread 0xbbc DBC 0x241442c Jet'.
/Tutorial/query.asp, line 80. (line 80 is:
Response.Write("<td><b>" & f.Name & "</b></td>")).
4. I restore the correct db name.
5. I run the SELECT statement. It runs correctly once.
On subsequent runs, it either runs correctly or returns
this error: "Provider error 80004005".
6. I delete the asp page and create a new one with the
same code.
7. I run the SELECT statement. It returns an error once
and then runs correctly thereafter.

The purpose of the test is to see if the system recovers
after an error. Currently, it recovers only when I
replace the asp page. Do you have suggestions? Here is
the asp page code:

<% Response.Buffer=True %>

<%
'database startup code
dim RS 'recordset object
Set RS = Server.CreateObject("ADODB.Recordset")

'data source strings for drop down list
dim dsnarray(0)

'be sure to only populate the array elements zero
'through the upper bound of the DSN array

dsnarray(0) = "Driver={Microsoft Access Driver
(*.mdb)};DBQ=" & Server.MapPath("blank.mdb")

'retrieve the form values
sql = Request.Form("sql") 'the SQL statement
dsn = Request.Form("dsn") 'the data source string
%>
<html>
<head>
<title>SQL Test</title>
<style>
TD {font-size: smaller }
</style>
</head>
<body bgcolor="#cecece">

<form action="query.asp" method=POST>
<table border=0 cellspacing=0>
<tr>
<td>
<b>SQL Code</b>
</td>
</tr>

<tr>
<td>
<textarea name="sql" rows="8" cols="50" wrap=soft><%
=sql%></textarea>
</td>
</tr>

<tr>
<td colspan=2>
<!-- using the drop down list of connect string -->
<select name="dsn">
<% ' loop through the array of DSN's select the
current one
for i = LBound(dsnarray) to UBound(dsnarray)
if dsnarray(i) = dsn then
Response.Write("<option selected>" &
dsnarray(i))
else
Response.Write("<option>" & dsnarray(i))
end if
next
%>
</select>
</td>
</tr>

<!-- this code allows you to test different connect
strings -->
<!--
<tr>
<td colspan=2>
<textarea name="dsn" rows="2" cols="80" wrap=soft><%
=dsn%></textarea>
</td>
</tr> -->

</table>

<input type=submit>
</form>

<%
'for long winded queries, this will write out the
response buffers
Response.Flush
%>

<%
if sql <> "" then ' execute the SQL if it's not
empty
RS.Open sql, dsn
Response.Write("<table border=1 cellspacing=0>")
if RS.State = 1 then 'if the recordset has rows

'show the column names
Response.Write("<tr bgcolor=LightSteelBlue>")

for each f in RS.Fields
Response.Write("<td><b>" & f.Name & "</b></td>")
next

Response.Write("</tr>")

'show the rows
do while not RS.EOF
Response.Write("<tr bgcolor=White>")

for each f in RS.Fields
Response.Write("<td>" & f.Value & "</td>")
next

Response.Write("</tr>")

RS.MoveNext
loop
else
'DML was performed
Response.Write("<tr bgcolor=White><td><b>")
Response.Write("Command Completed
Successfully</b>")
Response.Write("</td></tr>")
end if

Response.Write("</table>")
end if
%>

<%
'database clean up code
Set RS = Nothing
%>
</body>
</html>

>-----Original Message-----
>It would also be helpful if you posted the ASP script.
>
>--
>Mark Schupp
>Head of Development
>Integrity eLearning
>[url]www.ielearning.com[/url]
>
>
>"Ken Schaefer" <kenREMOVE@THISadOpenStatic.com> wrote in

message

>news:u0eKPobJEHA.3848@TK2MSFTNGP09.phx.gbl...

>> Please try to run the ASP page directly, to determine

if the problem is

>> within the ASP page, or with the ASP page's ADO

objects accessing the

>Access

>> database.
>>
>> Otherwise, the problem may be in the Authorware part

of your application.

>>
>> Cheers
>> Ken
>>
>> "Jim Bowman" <anonymous@discussions.microsoft.com>

wrote in message

>> news:0b2501c425a3$66d86090$a501280a@phx.gbl...
>> : I am getting inconsistent results from an e-learning
>> : program - asp page - database connection.
>> :
>> : I have installed IIS on my computer from Win XP

Pro. My

>> : authoring program (Authorware 5.2) executes a ReadURL
>> : function that calls an asp page. The asp page

contains a

>> : SQL SELECT command that is sent to an Access

database.

>> : If the desired record exists in the database, the

record

>> : is sent back to the asp page which sends it back to

the

>> : Authorware file where the contents of the record
>> : display. If an error occurs, an error message

displays.

>> :
>> : When I first boot up the computer and run the

Authorware

>> : file, the sequence runs correctly. On the 2nd run

and

>> : most subsequent runs, Authorware returns an error,
>> : IOStatus = 5006 and a message = "unknown error

(5006)".

>> : On an occasional subsequent run, the example runs
>> : correctly. Then on the next run, it returns the same
>> : error.
>> :
>> : I have uninstalled and reinstalled IIS and have

checked

>> : the Authorware and asp page carefully. The problem
>> : persists. What might be the cause of this

inconsistency?

>> :
>> : Thanks.
>> :
>> : Jim Bowman
>> :
>>
>>

>
>
>.
>

[Ken Schaefer]

Use the Jet OLEDB Provider, not the ODBC driver, and you should avoid these
issues. Otherwise, you can delete the DSN, and recreate it, and the problem
will go away (for a while)

The connection string for the Jet OLEDB Provider is here:
[url]http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForMicrosoftJet[/url]
(watch for wrapping).

Also, ensure that you have:
a) the latest MDAC (currently v2.8) from: [url]www.microsoft.com/data/[/url]
b) the latest Jet Service Pack (currently SP8). This is rolled into the
recent MS security update in bulletin MS04-014
[url]http://www.microsoft.com/technet/security/bulletin/MS04-014.mspx[/url]

Cheers
Ken


<anonymous@discussions.microsoft.com> wrote in message
news:12d001c4264f$1e9b69b0$a501280a@phx.gbl...
: Thanks to Ken and Mark for the ideas.
:
: I ran a similar asp page from a form and got the same
: results. So, Authorware is not the cause. Here's the
: test:
:
: 1. I run the asp page with a connection to an Access
: db. The asp page contains the VBScript and a form. Both
: the asp page and the db are in the same folder in the
: wwwroot folder of IIS. Through the form, I run a SQL
: SELECT statement. The form correctly returns the record
: identified in the SELECT statement.
: 2. I modify the name of the db.
: 3. I run the SELECT statement and get an error, as
: expected. The error message: "Microsoft OLE DB Provider
: for ODBC Drivers error '80004005'. [Microsoft][ODBC
: Microsoft Access Driver]General error Unable to open
: registry key 'Temporary (volatile) Jet DSN for process
: 0x6c8 Thread 0xbbc DBC 0x241442c Jet'.
: /Tutorial/query.asp, line 80. (line 80 is:
: Response.Write("<td><b>" & f.Name & "</b></td>")).
: 4. I restore the correct db name.
: 5. I run the SELECT statement. It runs correctly once.
: On subsequent runs, it either runs correctly or returns
: this error: "Provider error 80004005".
: 6. I delete the asp page and create a new one with the
: same code.
: 7. I run the SELECT statement. It returns an error once
: and then runs correctly thereafter.
:
: The purpose of the test is to see if the system recovers
: after an error. Currently, it recovers only when I
: replace the asp page. Do you have suggestions? Here is
: the asp page code:
:
: <% Response.Buffer=True %>
:
: <%
: 'database startup code
: dim RS 'recordset object
: Set RS = Server.CreateObject("ADODB.Recordset")
:
: 'data source strings for drop down list
: dim dsnarray(0)
:
: 'be sure to only populate the array elements zero
: 'through the upper bound of the DSN array
:
: dsnarray(0) = "Driver={Microsoft Access Driver
: (*.mdb)};DBQ=" & Server.MapPath("blank.mdb")
:
: 'retrieve the form values
: sql = Request.Form("sql") 'the SQL statement
: dsn = Request.Form("dsn") 'the data source string
: %>
: <html>
: <head>
: <title>SQL Test</title>
: <style>
: TD {font-size: smaller }
: </style>
: </head>
: <body bgcolor="#cecece">
:
: <form action="query.asp" method=POST>
: <table border=0 cellspacing=0>
: <tr>
: <td>
: <b>SQL Code</b>
: </td>
: </tr>
:
: <tr>
: <td>
: <textarea name="sql" rows="8" cols="50" wrap=soft><%
: =sql%></textarea>
: </td>
: </tr>
:
: <tr>
: <td colspan=2>
: <!-- using the drop down list of connect string -->
: <select name="dsn">
: <% ' loop through the array of DSN's select the
: current one
: for i = LBound(dsnarray) to UBound(dsnarray)
: if dsnarray(i) = dsn then
: Response.Write("<option selected>" &
: dsnarray(i))
: else
: Response.Write("<option>" & dsnarray(i))
: end if
: next
: %>
: </select>
: </td>
: </tr>
:
: <!-- this code allows you to test different connect
: strings -->
: <!--
: <tr>
: <td colspan=2>
: <textarea name="dsn" rows="2" cols="80" wrap=soft><%
: =dsn%></textarea>
: </td>
: </tr> -->
:
: </table>
:
: <input type=submit>
: </form>
:
: <%
: 'for long winded queries, this will write out the
: response buffers
: Response.Flush
: %>
:
: <%
: if sql <> "" then ' execute the SQL if it's not
: empty
: RS.Open sql, dsn
: Response.Write("<table border=1 cellspacing=0>")
: if RS.State = 1 then 'if the recordset has rows
:
: 'show the column names
: Response.Write("<tr bgcolor=LightSteelBlue>")
:
: for each f in RS.Fields
: Response.Write("<td><b>" & f.Name & "</b></td>")
: next
:
: Response.Write("</tr>")
:
: 'show the rows
: do while not RS.EOF
: Response.Write("<tr bgcolor=White>")
:
: for each f in RS.Fields
: Response.Write("<td>" & f.Value & "</td>")
: next
:
: Response.Write("</tr>")
:
: RS.MoveNext
: loop
: else
: 'DML was performed
: Response.Write("<tr bgcolor=White><td><b>")
: Response.Write("Command Completed
: Successfully</b>")
: Response.Write("</td></tr>")
: end if
:
: Response.Write("</table>")
: end if
: %>
:
: <%
: 'database clean up code
: Set RS = Nothing
: %>
: </body>
: </html>
:
:
:
:
:
:
: >-----Original Message-----
: >It would also be helpful if you posted the ASP script.
: >
: >--
: >Mark Schupp
: >Head of Development
: >Integrity eLearning
: >[url]www.ielearning.com[/url]
: >
: >
: >"Ken Schaefer" <kenREMOVE@THISadOpenStatic.com> wrote in
: message
: >news:u0eKPobJEHA.3848@TK2MSFTNGP09.phx.gbl...
: >> Please try to run the ASP page directly, to determine
: if the problem is
: >> within the ASP page, or with the ASP page's ADO
: objects accessing the
: >Access
: >> database.
: >>
: >> Otherwise, the problem may be in the Authorware part
: of your application.
: >>
: >> Cheers
: >> Ken
: >>
: >> "Jim Bowman" <anonymous@discussions.microsoft.com>
: wrote in message
: >> news:0b2501c425a3$66d86090$a501280a@phx.gbl...
: >> : I am getting inconsistent results from an e-learning
: >> : program - asp page - database connection.
: >> :
: >> : I have installed IIS on my computer from Win XP
: Pro. My
: >> : authoring program (Authorware 5.2) executes a ReadURL
: >> : function that calls an asp page. The asp page
: contains a
: >> : SQL SELECT command that is sent to an Access
: database.
: >> : If the desired record exists in the database, the
: record
: >> : is sent back to the asp page which sends it back to
: the
: >> : Authorware file where the contents of the record
: >> : display. If an error occurs, an error message
: displays.
: >> :
: >> : When I first boot up the computer and run the
: Authorware
: >> : file, the sequence runs correctly. On the 2nd run
: and
: >> : most subsequent runs, Authorware returns an error,
: >> : IOStatus = 5006 and a message = "unknown error
: (5006)".
: >> : On an occasional subsequent run, the example runs
: >> : correctly. Then on the next run, it returns the same
: >> : error.
: >> :
: >> : I have uninstalled and reinstalled IIS and have
: checked
: >> : the Authorware and asp page carefully. The problem
: >> : persists. What might be the cause of this
: inconsistency?
: >> :
: >> : Thanks.
: >> :
: >> : Jim Bowman
: >> :
: >>
: >>
: >
: >
: >.
: >

[Jim Bowman]

Thanks Ken. The Jet OLEDB Provider solves the problem.

The original driver was this: "Driver={Microsoft Access
Driver (*.mdb)}; DBQ=" & Server.MapPath("HelloWorld.mdb")
& ";"

The new driver is
this: "Provider=Microsoft.JET.OLEDB.4.0;Data
Source=C:\InetPub\Wwwroot\Tutorial\HelloWorld.mdb; "

I will provide the asp page and Access database to a
variety of clients with intranet servers. Are there
tradeoffs between the original driver and the new one?
For example, is the ODBC Driver or the Jet OLEDB Provider
more flexible so that one driver runs on more versions of
IIS? Is the performance of one driver better than the
other?

Jim

>-----Original Message-----
>Use the Jet OLEDB Provider, not the ODBC driver, and you

should avoid these

>issues. Otherwise, you can delete the DSN, and recreate

it, and the problem

>will go away (for a while)
>
>The connection string for the Jet OLEDB Provider is here:
>[url]http://www.able-[/url]

consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLE
DBProviderForMicrosoftJet

>(watch for wrapping).
>
>Also, ensure that you have:
>a) the latest MDAC (currently v2.8) from:

[url]www.microsoft.com/data/[/url]

>b) the latest Jet Service Pack (currently SP8). This is

rolled into the

>recent MS security update in bulletin MS04-014
>[url]http://www.microsoft.com/technet/security/bulletin/MS04-[/url]

014.mspx

>
>Cheers
>Ken
>
>
><anonymous@discussions.microsoft.com> wrote in message
>news:12d001c4264f$1e9b69b0$a501280a@phx.gbl...
>: Thanks to Ken and Mark for the ideas.
>:
>: I ran a similar asp page from a form and got the same
>: results. So, Authorware is not the cause. Here's the
>: test:
>:
>: 1. I run the asp page with a connection to an Access
>: db. The asp page contains the VBScript and a form.

Both

>: the asp page and the db are in the same folder in the
>: wwwroot folder of IIS. Through the form, I run a SQL
>: SELECT statement. The form correctly returns the

record

>: identified in the SELECT statement.
>: 2. I modify the name of the db.
>: 3. I run the SELECT statement and get an error, as
>: expected. The error message: "Microsoft OLE DB

Provider

>: for ODBC Drivers error '80004005'. [Microsoft][ODBC
>: Microsoft Access Driver]General error Unable to open
>: registry key 'Temporary (volatile) Jet DSN for process
>: 0x6c8 Thread 0xbbc DBC 0x241442c Jet'.
>: /Tutorial/query.asp, line 80. (line 80 is:
>: Response.Write("<td><b>" & f.Name & "</b></td>")).
>: 4. I restore the correct db name.
>: 5. I run the SELECT statement. It runs correctly

once.

>: On subsequent runs, it either runs correctly or returns
>: this error: "Provider error 80004005".
>: 6. I delete the asp page and create a new one with the
>: same code.
>: 7. I run the SELECT statement. It returns an error

once

>: and then runs correctly thereafter.
>:
>: The purpose of the test is to see if the system

recovers

>: after an error. Currently, it recovers only when I
>: replace the asp page. Do you have suggestions? Here

is

>: the asp page code:
>:
>: <% Response.Buffer=True %>
>:
>: <%
>: 'database startup code
>: dim RS 'recordset object
>: Set RS = Server.CreateObject("ADODB.Recordset")
>:
>: 'data source strings for drop down list
>: dim dsnarray(0)
>:
>: 'be sure to only populate the array elements zero
>: 'through the upper bound of the DSN array
>:
>: dsnarray(0) = "Driver={Microsoft Access Driver
>: (*.mdb)};DBQ=" & Server.MapPath("blank.mdb")
>:
>: 'retrieve the form values
>: sql = Request.Form("sql") 'the SQL statement
>: dsn = Request.Form("dsn") 'the data source string
>: %>
>: <html>
>: <head>
>: <title>SQL Test</title>
>: <style>
>: TD {font-size: smaller }
>: </style>
>: </head>
>: <body bgcolor="#cecece">
>:
>: <form action="query.asp" method=POST>
>: <table border=0 cellspacing=0>
>: <tr>
>: <td>
>: <b>SQL Code</b>
>: </td>
>: </tr>
>:
>: <tr>
>: <td>
>: <textarea name="sql" rows="8" cols="50"

wrap=soft><%

>: =sql%>

[Bob Barrows [MVP]]

Jim Bowman wrote:

> Thanks Ken. The Jet OLEDB Provider solves the problem.
>
> The original driver was this: "Driver={Microsoft Access
> Driver (*.mdb)}; DBQ=" & Server.MapPath("HelloWorld.mdb")
> & ";"
>
> The new driver is
> this: "Provider=Microsoft.JET.OLEDB.4.0;Data
> Source=C:\InetPub\Wwwroot\Tutorial\HelloWorld.mdb; "
>
> I will provide the asp page and Access database to a
> variety of clients with intranet servers. Are there
> tradeoffs between the original driver and the new one?
> For example, is the ODBC Driver or the Jet OLEDB Provider
> more flexible so that one driver runs on more versions of
> IIS? Is the performance of one driver better than the
> other?
>

The OLEDB Provider for ODBC has been deprecated. You are better off using
the native provider when one is available:
[url]http://msdn.microsoft.com/library/en-us/ado270/htm/ado_deprecated_components.asp[/url]

HTH,
Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Thanks to all of you for the help. The problem is
resolved.

Jim

>-----Original Message-----
>Jim Bowman wrote:

>> Thanks Ken. The Jet OLEDB Provider solves the problem.
>>
>> The original driver was this: "Driver={Microsoft Access
>> Driver (*.mdb)}; DBQ=" & Server.MapPath

("HelloWorld.mdb")

>> & ";"
>>
>> The new driver is
>> this: "Provider=Microsoft.JET.OLEDB.4.0;Data
>> Source=C:\InetPub\Wwwroot\Tutorial\HelloWorld.mdb; "
>>
>> I will provide the asp page and Access database to a
>> variety of clients with intranet servers. Are there
>> tradeoffs between the original driver and the new one?
>> For example, is the ODBC Driver or the Jet OLEDB

Provider

>> more flexible so that one driver runs on more versions

of

>> IIS? Is the performance of one driver better than the
>> other?
>>

>The OLEDB Provider for ODBC has been deprecated. You are

better off using

>the native provider when one is available:
>[url]http://msdn.microsoft.com/library/en-[/url]

us/ado270/htm/ado_deprecated_components.asp

>
>HTH,
>Bob Barrows
>--
>Microsoft MVP -- ASP/ASP.NET
>Please reply to the newsgroup. The email account listed

in my From

>header is my spam trap, so I don't check it very often.

You will get a

>quicker response by posting to the newsgroup.
>
>
>.
>

One last question. Is performance better in a OLEDB
Provider if you set the Data Source=the complete path to
the database, or set Data Source=a relative path using
Server.MapPath?

Jim

>-----Original Message-----
>Jim Bowman wrote:

>> Thanks Ken. The Jet OLEDB Provider solves the problem.
>>
>> The original driver was this: "Driver={Microsoft Access
>> Driver (*.mdb)}; DBQ=" & Server.MapPath

("HelloWorld.mdb")

>> & ";"
>>
>> The new driver is
>> this: "Provider=Microsoft.JET.OLEDB.4.0;Data
>> Source=C:\InetPub\Wwwroot\Tutorial\HelloWorld.mdb; "
>>
>> I will provide the asp page and Access database to a
>> variety of clients with intranet servers. Are there
>> tradeoffs between the original driver and the new one?
>> For example, is the ODBC Driver or the Jet OLEDB

Provider

>> more flexible so that one driver runs on more versions

of

>> IIS? Is the performance of one driver better than the
>> other?
>>

>The OLEDB Provider for ODBC has been deprecated. You are

better off using

>the native provider when one is available:
>[url]http://msdn.microsoft.com/library/en-[/url]

us/ado270/htm/ado_deprecated_components.asp

>
>HTH,
>Bob Barrows
>--
>Microsoft MVP -- ASP/ASP.NET
>Please reply to the newsgroup. The email account listed

in my From

>header is my spam trap, so I don't check it very often.

You will get a

>quicker response by posting to the newsgroup.
>
>
>.
>

[Bob Barrows [MVP]]

[email]anonymous@discussions.microsoft.com[/email] wrote:

> One last question. Is performance better in a OLEDB
> Provider if you set the Data Source=the complete path to
> the database, or set Data Source=a relative path using
> Server.MapPath?
>

It makes no difference. Both techniques result in a string containing the
full path to the database. Prove it to your self. Do:

Response.Write Server.MapPath("dbname.mdb")

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.