I have a problem with MS Access and SQL over ODBC

[mschmid]

Hello Forum!

i have the following problem, i use a MS Access database and i want to query datasets from a table with 1100000 datasets. I had configure a System-DSN using the standart "Microsoft Access Driver (*.mdb)". Now i execute the following code

  T1 = "select test.x, test.y from test"
  Call SQL_ExecDirect("T1")
  Call SQL_BindChannel("x","x","n")
  Call SQL_BindChannel("y","y","n")

Normally all the datasets must be in the channels, but there are only 200000 datasets. furthermore i use diadem in the version 10.00.2541 but only the evaluation version and MS Access 2003 version 11.0. Are there any limitation with the ODBC-SQL-Dataquery?

with best regards

Markus Schmid

[Walter_Rick]

Hello Markus,

Because of performance the internal buffer size contains the first 200000 records. To read until the end of the table we added the additional command "SQL_FetChNext".

Here is an example for the commands you are looking for:

....
Call SQL_BindChannel("y","y","n")

Do While (SQL_Next)
  call SQL_FetChNext()
Loop

Greetings
Walter