topic Re: ODBC in Collaboration with other software

ODBC

Anonymous — Tue, 16 Jan 2007 03:24:01 GMT

Hi again all
Does anyone have a simple working example of a v10 odbc connection and output using Access?

I traced the problems I was having and got this;

MSACCESS 178-72c ENTER SQLExecDirectW
HSTMT 08BF1AA8
WCHAR * 0x081D1638 [ -3] "SELECT "COMPONENTS_OF_ZONES"."ZONE_ID" FROM "COMPONENTS_OF_ZONES" \ 0"
SDWORD -3

MSACCESS 178-72c EXIT SQLExecDirectW with return code 0 (SQL_SUCCESS)
HSTMT 08BF1AA8
WCHAR * 0x081D1638 [ -3] "SELECT "COMPONENTS_OF_ZONES"."ZONE_ID" FROM "COMPONENTS_OF_ZONES" \ 0"
SDWORD -3

If I carry this query out manually (inside AC) it doesnt work either. GS...is there a help resource for this anywhere?
Regs

Re: ODBC

Karl Ottenstein — Tue, 16 Jan 2007 06:04:07 GMT

image_engine wrote:
Does anyone have a simple working example of a v10 odbc connection and output using Access?

I did not realize that the ODBC driver for 10 was ever released. What's the download link for it?

If I carry this query out manually (inside AC) it doesnt work either. GS...is there a help resource for this anywhere?
Regs

The schema format/naming and SQL syntax for SQL inside ArchiCAD and SQL via ODBC are not the same. You cannot simply copy/paste queries from one to the other and expect success. Don't ask me why they did it that way...

Of course, the schema inside AC are listed directly from the menus. The schema for ODBC were in the help file for the initial release. I think there are links to it or more info somehwere on this forum if you search for SQL and plod through the results.

Karl

Re: ODBC

Anonymous — Tue, 16 Jan 2007 22:33:38 GMT

Hi Karl
Im aware of the differences, the internal system is a dot syntax whereas the odbc is underscore and has different compounds etc. Sorry if I didn't make my understanding clear. ie If I carry out the query with the format translation...
I dont think its (v10) publicly available as yet. Does the same in v9 though.
Regs
Mark