DSN-less sonnection - question for bob barrows

[Hugh Welford]

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

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]

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



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

 

[Bob Barrows [MVP]]

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.

 

[Hugh Welford]

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

Hugh