SQL Select problem

[Guest]

Hi,

I have written a program that reads certain rows from a table in a local JET
database file. I use SQL strings to select the rows that I want to read.
Everything works fine on my development computer and all the SQL strings in
the program return the desired rows from the database. but when I install
this program on another computer then some SQL strings return zero rows.

For example:
This SQL string returns rows on both computers:
"SELECT * FROM myTable ORDER BY col0"

However, this SQL string returns rows on my development computer only and
returns no rows on the other computer:
"SELECT * FROM myTable WHERE col0 BETWEEN #09/08/2005 9:45:30AM# AND
#10/08/2005 9:45:30AM# ORDER BY col0"

Now, both computers use WinXP, and they access identical database files.
However, the development computer has MS Access installed and the other
computer doesn't.

Does anyone know why do I get different results on two different computers
althoutgh I'm running the same program and accessing the same data files?

Any suggestions on how to troubleshoot the issue?

 

[]

| "SELECT * FROM myTable WHERE col0 BETWEEN #09/08/2005 9:45:30AM# AND
| #10/08/2005 9:45:30AM# ORDER BY col0"
|
| Now, both computers use WinXP, and they access identical database files.
| However, the development computer has MS Access installed and the other
| computer doesn't.

LOL !!!

either install access or the jet db engine on the "problematic" computer.

roflmao