ODBC driver problems with various clients

[aim4min]

I'm trying to place various forms from a filemaker database online. We have Filemaker Server 5, Filemaker Pro Unlimited 5.5, and Filemaker developer 5.

We want users to be able to login using a separate authentication system, and only get access their their own record in the database.

We hoped to accomplish this using Filemaker Pro Unlimited, however after I eveluated the instant web publishing I found the generated html was not suitable. (Did not look good in netscape 4.75, and when accessed with netscape 6.2 it crashed fm pro unlimited)

Instead we are going to use script a web application in coldfusion 5. I set up the filemaker ODBC driver as a datasource in coldfusion. Accessing the database through ColdFusion Studio shows only 1 table with 1280 columns.

When I execute a query like SELECT * FROM "Web Worksheet.fp5" FileMaker Pro unlimited starts to use all the available CPU, but I haven't been able to see any of the rows.

Another thing has been really bugging me. If there is only one large table that holds all the fields, how would you write SQL Queries? Usually SQL queries depend on joining multiple tables.

So, my two questions are: How can I browse the FM Pro database through ODBC? How do I write SQL queries?

Thanks

[Anatoli]

RE: So, my two questions are: How can I browse the FM Pro database through ODBC?

IMHO -- you don't. Way to slow. Use CDML and that is much much faster.