M
Michael Khalsa
I have an access db 2000 running default ansi sql89.
In vb.net, I will use as an example, following portion of
a sql string
(fed through OleDbClient objects in Net framework)
Where BeginDate <= #1/1/1900#
works fine on my machine, however when i move the code
and database to another XP machine, I recieved a Syntax
error complaining about the # literals (which was easy to
fix by removeing the syntax and replacing with a
OleDbParameter object in VbNet). However, this should not
occur, because i never specified the database as
ansiSql92. I assume it is expecting the "'" literals
instead of "#" literals.
In addition i cannot replicate the error on my machine,
even if i make the database a true AnsiSQl 92 format.
Also tried setting the ExtendedAnnsiSql switch in driver.
Still cannot replicate the error. IN fact it looks like
nothing was changed at all on my machine.
I am using Jet SP7 driver 4.00.619 on XP pro
Would like to now what is going on. I fixed the above to
be platform independent by using OleDbparamters to do the
syntac formatting, however there may be other differences
in syntax that is being forced.
Help?
Michael Khalsa
In vb.net, I will use as an example, following portion of
a sql string
(fed through OleDbClient objects in Net framework)
Where BeginDate <= #1/1/1900#
works fine on my machine, however when i move the code
and database to another XP machine, I recieved a Syntax
error complaining about the # literals (which was easy to
fix by removeing the syntax and replacing with a
OleDbParameter object in VbNet). However, this should not
occur, because i never specified the database as
ansiSql92. I assume it is expecting the "'" literals
instead of "#" literals.
In addition i cannot replicate the error on my machine,
even if i make the database a true AnsiSQl 92 format.
Also tried setting the ExtendedAnnsiSql switch in driver.
Still cannot replicate the error. IN fact it looks like
nothing was changed at all on my machine.
I am using Jet SP7 driver 4.00.619 on XP pro
Would like to now what is going on. I fixed the above to
be platform independent by using OleDbparamters to do the
syntac formatting, however there may be other differences
in syntax that is being forced.
Help?
Michael Khalsa