Error in DAO2516.DLL using SQL on ODBC-Source 
Author Message
 Error in DAO2516.DLL using SQL on ODBC-Source


I hope there is someone who can help me...

I am writing a 16-Bit VB4.0 program which receives data from an IBM AS/400
using SQL queries. I am using a Showcase Vista ODBC driver Ver. 01.2.0000.
The ODBC DLL file is dated at 16.08.94.

My SQL query looks like the following...

Data1.RecordSource = "SELECT month, filter, Sum(data) AS SumData " & _
                "FROM DATAFILE " & _
                "WHERE (month = '" & month "') AND (filter = '" & xxx & "')
" & _
                "GROUP BY month"

The program crashes at not regular intervals. If the ODBC connection runs
clearly I can make as many queries as I want, so I can exclude that the
has an error. But if the connection is "not stable" I only can make a few
The error occurs in the file DAO2516.DLL and later in MSAJT200.DLL.

Visual Basic is installed on a local HDD to be sure that all DLL-, OCX-, ..
files are
correctly registered.
I think I have tried everything except installing a new ODBC-Driver,
because it may be
an expensive try if it doesn't work. I reinstalled the ODBC-Driver, tried
every protocol,
every option - without success.
Maybe it depends on the many queries which are running one after another.
For example,
I need 16 queries for one process, that means, that after a query has been
made and
evaluated the next queries starts at once with other parameter.

Is the problem the old ODBC-Driver, Visual Basic, ...

I don't know... I am helpless and desperated.

You are my last hope...


Mon, 24 May 1999 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Error in DAO2516.DLL using SQL with ODBC-Source

2. Error in DAO2516.DLL using SQL with ODBC

3. Error 3131 Syntax error in FROM clause - using SQL accessing external ODBC problem

4. Error 3131 Syntax error in FROM clause - using SQL accessing external ODBC problem

5. dao2516.dll error

6. dao2516.dll error

7. dao2516.dll error

8. Setup Problem: Error registering DAO2516.DLL

9. Error in DAO2516.dll

10. DAO350.DLL page fault error - VB5 odbc connection to local SQL Server7

11. Getting error message when using SQL for data source in ADOC

12. ODBC error when using SQL delete from dBase table


Powered by phpBB® Forum Software