System error 5

[NeDall]

Hi

To day I suddenly got the same error message when I
connected to all my databases using
ADODB.conection. "Application popup: ASP Script Error :
Specified driver could not be loaded due to system error
5 (Microsoft Access Driver (*.mdb))." All the codes works
fine on my mirror computer. Do any one have a solution on
this problem. The OS is Win2000 with IIS 5.0.

N.E. Dall

[Bob Barrows]

NeDall wrote:

> Hi
>
> To day I suddenly got the same error message when I
> connected to all my databases using
> ADODB.conection. "Application popup: ASP Script Error :
> Specified driver could not be loaded due to system error
> 5 (Microsoft Access Driver (*.mdb))." All the codes works
> fine on my mirror computer. Do any one have a solution on
> this problem. The OS is Win2000 with IIS 5.0.
>
> N.E. Dall

Stop using ODBC. Switch to using the native Jet OLEDB Provider for your
connection strings, which can be as simple as:
connection.open "provider=microsoft.jet.oledb.4.0;" & _
"data source=p:\ath\to\your\database.mdb"

See here:
[url]http://msdn.microsoft.com/library/en-us/ado270/htm/ado_deprecated_components.asp[/url]



Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[N E Dall]

>-----Original Message-----
>NeDall wrote:

>> Hi
>>
>> To day I suddenly got the same error message when I
>> connected to all my databases using
>> ADODB.conection. "Application popup: ASP Script Error :
>> Specified driver could not be loaded due to system error
>> 5 (Microsoft Access Driver (*.mdb))." All the codes

works

>> fine on my mirror computer. Do any one have a solution

on

>> this problem. The OS is Win2000 with IIS 5.0.
>>
>> N.E. Dall

>
>Stop using ODBC. Switch to using the native Jet OLEDB

Provider for your

>connection strings, which can be as simple as:
>connection.open "provider=microsoft.jet.oledb.4.0;" & _
>"data source=p:\ath\to\your\database.mdb"
>
>See here:
>[url]http://msdn.microsoft.com/library/en-[/url]

us/ado270/htm/ado_deprecated_components.asp

>
>
>
>Bob Barrows
>
>--
>Microsoft MVP - ASP/ASP.NET
>Please reply to the newsgroup. This email account is my

spam trap so I

>don't check it very often. If you must reply off-line,

then remove the

>"NO SPAM"
>
>
>.
>

Thanks for the answer.

I have changed some of the call to microsoft.jet.oledb.4.0
and it work fine on the mirror server, but not at the
other server, whit the problem. I get the error
message "Application popup: ASP Script Error : Provider
cannot be found. It may not be properly installed. ". It
look like my IIS 5.0 have lost all it connection to it's
DB's. I have reinstalled the IIS 5.0 with no result. Have
anyone else experimented this problem? Is there a
solution?

N E Dall

[Bob Barrows [MVP]]

> Thanks for the answer.

>
> I have changed some of the call to microsoft.jet.oledb.4.0
> and it work fine on the mirror server, but not at the
> other server, whit the problem. I get the error
> message "Application popup: ASP Script Error : Provider
> cannot be found. It may not be properly installed. ". It
> look like my IIS 5.0 have lost all it connection to it's
> DB's. I have reinstalled the IIS 5.0 with no result. Have
> anyone else experimented this problem? Is there a
> solution?
>
> N E Dall

Install the latest version of MDAC
([url]http://msdn.microsoft.com/data/Default.aspx[/url]) on the server
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.