Hi Sergey,
AERROR[1] 1526
AERROR[2] Connectivity Error. Unable to retrieve specific error information. Driver is probably out of resources.
But, when I use the same DSN in Excel for importing, it lets me get the table right away. When I run all of this from command prompt, same thing. Apologies for mistake earler: lnTESTER=SQLEXEC(lnSQLHandle, 'select * FROM myTable', '_myTable'). This line does not work (it was a different connection element which works).
Ric
>Hi Rick,
>
>The VFP error 1526 means that there was ODBC error. The details of error are stored in the array populated by AERROR(). What's ODBC error message ( 3rd item of AERROR() array), for example?
>
>>Hi all,
>>
>>I have a very curious problem here. I want to get data from many tables, so I created the follow lines:
>>
>>
>>
>>*-- The SQLCONNECT has already fired and I have a valid connection in lnSQLHandle
>>
>>lcSource = "select * FROM " + lcTable
>>lcDestin = lcAlias
>>lnTESTER=SQLEXEC(lnSQLHandle, lcSource, lcDestin)
>>
>>*lnTester is returning -1. AERROR() is 1526. But, when I run:
>>
>>lnTESTER=SQLEXEC(lnSQLHandle, 'select * FROM myTable', '_myTable')
>>
>>*-- all is well... comments please?
>>
>>
>>
>>
>>Ric