Hi,

I'm trying to start a small development project in Visual Studio 2013 using the ODBC 9.1A and I'm getting an error when trying to retrieve the Tables.

My connection is successful as per the screen shot below but Visual Studoi cannot retrieve the tables.

SAny help would be appreciated.

Connection Successful

Connection Wizard

PS: I am able to get data into Excel...

Hi Yann:

Error code HYC00 represents a number of errors such as "Catalogs are not supported", "Schemas are not supported", "Create index statements are not supported", "Create table statements are not supported" and "Optional feature not implemented". As you can see, the messages aren't very specific but they do indicate a significant failure.

At the point this error appears, have you selected a table or are you are trying to populate the list of tables?

BTW, I don't know if it would make any difference at all, but there is a new version of the ODBC utility. If you are on the annual upgrades plan, you could install version 9.2.

Could you please add a screen shot of the DSN configuration?

Hi Bruce,

Thanks for the reply.

At the point where I get the error I am waiting for the Tables to populate.
I have tested with another ODBC Datasource (SQL Server) and it populates properly.

I am waiting for the install codes from my reseller to get the 9.2A installed, it might help...

Here is the screen shot of my Adagio 32 Bit DSN
Data Directory points to the Data Folder...
Username and Password are also populated.

Adagio 32 Bit DSN

Thanks
Yann

Hi Yann:

To the extent that the DSN has anything to show, it looks correct. You could try a single asterisk in place of "AR*", though it shouldn't make any difference in reality. You've created a 32-bit DSN which is correct for Visual Studio. Let's see if the new ODBC version helps at all.

I updated to 9.2A
tested and not working...

I changed the Table Selection to * from AR*
tested and not working...

I updated the Data Directory from \\SERVER\DATAFOLDER\ to mapped drive G:\DATAFOLDER
tested and not working...

Not sure what the issue is at this point...

Can you connect to the sample data using Excel? Can you connect to your data using Excel?

Yes, I have no issue using Excel Query to bring the data in.

Perhaps it is the call that is trying to populate the tables that is causing the problem. Have you tried just opening the connection and reading known fields from a known table? You can get the ODBC table and field names from the Data Dictionary Exporter.

Perhaps a description of what you are trying to accomplish would be useful.

Thanks Andrew,

At the end of the day, what we are trying to accomplish is show the current, +30, +60, +90 for each of our customers in a windows app.
The table I was thinking that would be appropriate to work with is the "AR Trans w Cust" (that's the name in GridView.

There seams to be different table names depending on where you look.
in Excel it comes up as ARTranswCust__ar92a100

I was looking for a matching table after using the Data Dictionary Exporter but could not find anything like the ARTranswCust__ar92a100 or "AR Trans w Cust"
Maybe these are views...

Any chance you could point me in the right direction?
Thanks
Yann

Hi Yann

Why not use the AR Customer Master table - it has those fields as well, and reading from that table is very very straightforward. The only downside is that someone has to run Receivables | Maintenance | Calculate Customer Aging once a day. But that is not so awful, because it can be set to run automatically when the first person launches Receivables each morning.

When you run that function, you probably will want to uncheck "Update on hold by", and you can choose whether to update the fields based on the document date or the due date.

Steve