[QODBC] Driver not capable problem |
Author |
Message |
GB |
|
Group | : Members |
Posts | : 2 |
Joined | : 2006-12-16 |
|
Profile |
|
Posted : 2006-12-16 04:38:49 |
I recently upgraded from QODBC 2006 to QODBC2007 (7.000.00.199) and receive [QODBC] Driver not capable error when try to retrieve data fields from the ItemService table. I can read data from that table up until the eigth column and then I receive the error for all subsequent columns for each row. I haven't changed the code in years and the other code I have for ItemInventory and Customers still works fine. I am using VB.Net, DotNet 1.1, ADO.Net. Thanks. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-12-16 09:25:18 |
Ok, VB.Net is not happy with the typing of one of your columns. It's being sent as a string and VB.NET insists it's an integer. I'm guessing it doesn't like either IsActive or SubLevel. You can retype an offending column like this:
{fn CONVERT(SubLevel, SQL_INTEGER)} as Level
Because you didn't provide the SQL Query statement, I can't see which columns, but this should get on the track to fixing it. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-12-20 10:18:46 |
This problem turns out to have been caused by SQL_SLONG types. In QODBC v7.00.00.204 we have added conversion support for SQL_C_SLONG, SQL_C_ULONG, and SQL_C_SSHORT. See: QODBC v7.0.0.204 Released for more. |
|
|
|
|
Posted : 2009-01-30 18:04:23 |
I am getting the same error using Borland DBExplorer (from Delphi 7) with this syntax
select * from SalesReceipt where "TxnDate" >= {fn CURDATE() - 30}
results vary slightly depending on whether I use < or >= but basically no data comes back and it is in there....
My versions: QuickBooks Pro 2008 USA QODBC - latest version (9), downloaded and installed today.
Thanks. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2009-02-01 11:09:10 |
Your syntax is wrong, should be:
select * from SalesReceipt where (TxnDate >= {fn CURDATE()} - 30) |
|
|
|
|
Posted : 2009-02-01 11:19:30 |
THANK YOU. I am used to SQL variations where the outer () are not required.
Do you know a URL for a doc that specifies the allowed SQL for use with QODBC, and maybe even lists the functions such as CURDATE? That would be great.
Ann |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2009-02-01 11:35:36 |
|
|
|