Hi - using XP pro with IIS to develop offline asp data access site.

Suddenly, my DSNs and odbc drivers have disappeared - the only thing I can
think of is that an XP auto update has done this in some way.

Can anyone tell me how to get hold of and re-instal odbc drivers to allow
me to connect with ACCESS data bases.

Thanks Hugh

hugh welford wrote:[color=blue]
> Hi - using XP pro with IIS to develop offline asp data access site.
>
> Suddenly, my DSNs and odbc drivers have disappeared - the only thing I can
> think of is that an XP auto update has done this in some way.
>
> Can anyone tell me how to get hold of and re-instal odbc drivers to allow
> me to connect with ACCESS data bases.
>
> Thanks Hugh[/color]

The short answer is don't. Use the native OLEDB driver instead.

http://www.adopenstatic.com/faq/whyOLEDB.asp

/P.

hugh welford wrote:[color=blue]
> Hi - using XP pro with IIS to develop offline asp data access site.
>
> Suddenly, my DSNs and odbc drivers have disappeared - the only thing
> I can think of is that an XP auto update has done this in some way.
>
> Can anyone tell me how to get hold of and re-instal odbc drivers to
> allow me to connect with ACCESS data bases.
>
> Thanks Hugh[/color]
:-)
Seems like the perfect time to break the odbc crutch ...
http://www.aspfaq.com/show.asp?id=2126

However, if you're bound and determined,
You need to go to microsoft.com and search for the Jet components download.

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 bob - time to bite the bullet, as you say
hugh

"Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message
news:%23AkxRuFPGHA.344@TK2MSFTNGP11.phx.gbl...[color=blue]
> hugh welford wrote:[color=green]
>> Hi - using XP pro with IIS to develop offline asp data access site.
>>
>> Suddenly, my DSNs and odbc drivers have disappeared - the only thing
>> I can think of is that an XP auto update has done this in some way.
>>
>> Can anyone tell me how to get hold of and re-instal odbc drivers to
>> allow me to connect with ACCESS data bases.
>>
>> Thanks Hugh[/color]
> :-)
> Seems like the perfect time to break the odbc crutch ...
> http://www.aspfaq.com/show.asp?id=2126
>
> However, if you're bound and determined,
> You need to go to microsoft.com and search for the Jet components
> download.
>
> 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"
>[/color]

thanks paxton

hugh


"Paxton" <paxtonend@hotmail.com> wrote in message
news:1141113748.865989.184530@j33g2000cwa.googlegr oups.com...[color=blue]
>
> hugh welford wrote:[color=green]
>> Hi - using XP pro with IIS to develop offline asp data access site.
>>
>> Suddenly, my DSNs and odbc drivers have disappeared - the only thing I
>> can
>> think of is that an XP auto update has done this in some way.
>>
>> Can anyone tell me how to get hold of and re-instal odbc drivers to
>> allow
>> me to connect with ACCESS data bases.
>>
>> Thanks Hugh[/color]
>
> The short answer is don't. Use the native OLEDB driver instead.
>
> http://www.adopenstatic.com/faq/whyOLEDB.asp
>
> /P.
>[/color]