|
Buy Support
Incidents |
|
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
|
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
|
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
|
Click Here
|
Buy Support
Incidents |
|
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
|
Click Here
|
|
| ItemAssembliesCanBuild -- Access Errors |
| Author |
Message |
|
|
| Posted : 2008-04-05 02:38:27 |
This is a strange error from QODBC.
OS: Windows XP Pro Service Pack 2
QB: Premier Professional Services Edition 2008
Company File: Sample Consulting Business
Interface: Query Tool (Using ODBC) -- freeware SQL tool and my app
enter:
select * from ItemAssembliesCanBuild
get:
Error: 3120 - Object "X" specified in the request cannot be found.
State:S0000,Native:10057,Origin:[QODBC]
|
|
| |
Gilbert T Williams
Scientist
ProSync Technology Group, LLC
|
| | Top | |
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2008-04-07 11:34:53 |
|
|
|
|
|
| Posted : 2008-04-07 22:55:06 |
The VB example does return a table.
Why is this any different the other 100+ tables?
Is the VB demo source available?
Thanks! |
|
| |
Gilbert T Williams
Scientist
ProSync Technology Group, LLC
|
| | Top | |
|
|
| Tom |
| |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2008-04-08 15:42:24 |
Check that you haven't got a long memo field or another long value in the table. There are also text field handling settings in the Advanced Tab of the QODBC Setup Screen. Convert Fields > 255 to LONG VARCHAR and Limit length to 4096 characters (default): These fields help some development environments get data from long fields that would not be able to otherwise.
We have modified VB Demo to suit QODBC better, but the original source code to the program can be downloaded using this link: Visual Basic ODBC Demo Program 32 bit Source Code (35k) |
|
|
|
|