DSN-less sonnection - question for bob barrows

[Hugh Welford]

Hi Bob - had the advice below from you recently:-

hugh welford wrote:

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

:-)
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

I have implemented this which works fine EXCEPT in one case where I try to
access a table field called "read" which gives me an unspecified error. This
error is not present if i use a DSN connection, and also goes away if I
rename the field "read1" with the OLEDB driver.

I have the solution - i.e. rename the field, but I would like to know why
this problem arises - is "read" a reserved word ???

Thanks Hugh

[Mike Brind]

Hugh Welford wrote:

Hi Bob - had the advice below from you recently:-

hugh welford wrote:

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

:-)
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

I have implemented this which works fine EXCEPT in one case where I try to
access a table field called "read" which gives me an unspecified error. This
error is not present if i use a DSN connection, and also goes away if I
rename the field "read1" with the OLEDB driver.

I have the solution - i.e. rename the field, but I would like to know why
this problem arises - is "read" a reserved word ???

Thanks Hugh

I'm not Bob, but READ is not a reserved word in Access. It is,
however, in SQL and Jet.

This is a handy reference: http://www.aspfaq.com/show.asp?id=2080

--
Mike Brind

[Bob Barrows [MVP]]

Mike Brind wrote:

Hugh Welford wrote:

Hi Bob - had the advice below from you recently:-

hugh welford wrote:

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

:-)
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

I have implemented this which works fine EXCEPT in one case where I
try to access a table field called "read" which gives me an
unspecified error. This error is not present if i use a DSN
connection, and also goes away if I rename the field "read1" with
the OLEDB driver.

I have the solution - i.e. rename the field, but I would like to
know why this problem arises - is "read" a reserved word ???

Thanks Hugh

I'm not Bob, but READ is not a reserved word in Access. It is,
however, in SQL and Jet.

.... and in ODBC. The thing is: OLE DB enforces these a little more strongly
than the older ODBC drivers.

--
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.

[Hugh Welford]

Thank you Mike and Bob - what would we all do without you????

Hugh
"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:uJ**************@TK2MSFTNGP12.phx.gbl...

Mike Brind wrote:

Hugh Welford wrote:

Hi Bob - had the advice below from you recently:-

hugh welford wrote:
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
:-)
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

I have implemented this which works fine EXCEPT in one case where I
try to access a table field called "read" which gives me an
unspecified error. This error is not present if i use a DSN
connection, and also goes away if I rename the field "read1" with
the OLEDB driver.

I have the solution - i.e. rename the field, but I would like to
know why this problem arises - is "read" a reserved word ???

Thanks Hugh

I'm not Bob, but READ is not a reserved word in Access. It is,
however, in SQL and Jet.

... and in ODBC. The thing is: OLE DB enforces these a little more
strongly
than the older ODBC drivers.

--
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.