topic Re: why no ODBC or SQL on Mac in Collaboration with other software

why no ODBC or SQL on Mac

Aussie John — Thu, 21 Jul 2005 03:44:53 GMT

Just wondering why Mac is out in cold regarding access to SQL or ODBC. Filemaker is ODBC savvy.

Re: why no ODBC or SQL on Mac

James Murray — Thu, 21 Jul 2005 14:15:38 GMT

I have nothing to contribute but I would like to second the question.

Re: why no ODBC or SQL on Mac

TomWaltz — Thu, 21 Jul 2005 15:23:34 GMT

I also have no information, and would like to "third" the question...

Re: why no ODBC or SQL on Mac

Anonymous — Thu, 21 Jul 2005 15:54:07 GMT

Aussie wrote:
Just wondering why Mac is out in cold regarding access to SQL or ODBC. Filemaker is ODBC savvy.

I guess I'm to sheltered in my own little world. What is SQL or ODBC?

Re: why no ODBC or SQL on Mac

TomWaltz — Thu, 21 Jul 2005 16:02:22 GMT

Structured Query Language and Open DataBase Connectivity. They are methods for database management and reporting.

Re: why no ODBC or SQL on Mac

Aussie John — Fri, 22 Jul 2005 04:37:08 GMT

Milard
They are protocols to link the one database to another, Since Archicad is one large database then it is possible to link take offs to a third party database such as filemaker.

Re: why no ODBC or SQL on Mac

Karl Ottenstein — Fri, 22 Jul 2005 17:47:35 GMT

It is a mystery. Providing ODBC for each platform would be a reasonable thing to expect.

I believe that the OBDC driver was written by a 3rd party, and would guess that it was a 'bonus' that it was released for all of us to use. So, I would guess that GS would need to hear loudly how much the Mac half of us needs it before they commit (e.g., budget) to that development.

I'm confused about the SQL question, John: I have a SQL menu option on my Mac ... but certain tables (schema) do not work correctly, notably my old tip on retrieving layer information. But others seem to work fine.

Karl

Re: why no ODBC or SQL on Mac

Anonymous — Wed, 10 Aug 2005 17:40:09 GMT

try this....

SQL for Mac....

http://developer.mimer.se/macosx/

Re: why no ODBC or SQL on Mac

Anonymous — Wed, 10 Aug 2005 19:02:48 GMT

r wrote:
try this....

SQL for Mac....

http://developer.mimer.se/macosx/

Interesting!...can a Mac Archicad user look into this to see if it addresses the "....Mac is out in cold regarding access to SQL or ODBC..." issue?

If it does, maybe we can move this thread to the next level by looking further into the possibilities. If PC's and Macs can equally access the model with this method, maybe Graphisoft would be more inclined to offer some insight about how to use it.

Dan K

Re: why no ODBC or SQL on Mac

TomWaltz — Wed, 10 Aug 2005 19:11:56 GMT

It's not SQL, but ODBC that is lacking. SQL on Mac works fine.

Re: why no ODBC or SQL on Mac

Anonymous — Wed, 10 Aug 2005 19:50:04 GMT

TomWaltz wrote:
It's not SQL, but ODBC that is lacking. SQL on Mac works fine.

Tom,
Fair enough...Let me apologize in advance as I'm am not really "database" literate. So what do we need? Does Graphisoft need to write an ODBC driver or something? If that's the case, it's curious why they haven't done so yet...any ideas???

Even though I'm not really database literate, I understand outstanding potential for this connectivity! I just want to get the ball rolling so I can figure out how to take advantge of it.

Dan K

Re: why no ODBC or SQL on Mac

TomWaltz — Wed, 10 Aug 2005 20:08:53 GMT

Dan wrote:
Does Graphisoft need to write an ODBC driver or something?

Yes, probably to tie in with FileMaker, since that's the reigning Apple Database system.

Dan wrote:
If that's the case, it's curious why they haven't done so yet...any ideas???

I've never heard an official answer, but my guess would be lack of available programming resources for something that would not generate noticeable revenue.

Re: why no ODBC or SQL on Mac

Anonymous — Wed, 10 Aug 2005 20:59:42 GMT

TomWaltz wrote:
Dan wrote:
Does Graphisoft need to write an ODBC driver or something?
Yes, probably to tie in with FileMaker, since that's the reigning Apple Database system.

Dan wrote:
If that's the case, it's curious why they haven't done so yet...any ideas???
I've never heard an official answer, but my guess would be lack of available programming resources for something that would not generate noticeable revenue.

Tom,
Seems like a good item for the wishlist so I've posted it...
Care to vote?
http://archicad-talk.graphisoft.com/viewtopic.php?p=43102#43102

Dan K

Re: why no ODBC or SQL on Mac

stefan — Sun, 08 Jan 2006 19:10:31 GMT

TomWaltz wrote:
It's not SQL, but ODBC that is lacking. SQL on Mac works fine.

what about http://www.iodbc.org/index.php?page=about ?

Re: why no ODBC or SQL on Mac

Karl Ottenstein — Sun, 08 Jan 2006 19:41:15 GMT

Good thought, Stefan. But it isn't the ODBC machinery that is missing on the MAC (it is there). It is that Graphisoft has not provided the ODBC driver for PLN/PLA files as they have for Windows. This driver is in some sense a special subset of ArchiCAD itself, providing the ability to read and extract info from PLN and PLA files. As the 'guts' are proprietary code (part of AC itself) to Graphisoft, there is not anything that an open source solution can do to help ... the ball is in Graphisoft's court. 😉

Karl

Re: why no ODBC or SQL on Mac

stefan — Sun, 08 Jan 2006 19:46:28 GMT

It's clear that I'm a database-newbie...

However, I'm catching up now through some old-school book-reading.