ODBC + Filemaker Pro 5
I was looking at Filemaker Pro 5 ODBC driver and saw that it said "FileMaker Pro 5 is Level 1 ODBC-compliant with limited Level 2 support".
Where can I find a definition of the ODBC levels?
Also, I am sort of confused as to what this means, "FileMaker Pro 5 will not allow you to front-end an SQL-compliant data source with a live dynamic connection. "
Does that mean that I couldn't, say use CF or ASP, to query/insert a file using this driver? I have been asked to do some CF programming and their DB is Filemaker Pro 5. I know nothing about FMP, so any information would be helpful. Thanks
Peter J. Boettcher posted this at 15:53 — 13th April 2000.
They have: 812 posts
Joined: Feb 2000
RC,
I can't help you with FileMaker Pro since I've never used it.
I'm not sure where you can find a definition of the compliance levels but I know they refer to the level of complexity of your SQL statements.
The most basic level of compliance are simple commands like:
create table
drop table
selects (simple)
insert (simple)
update (simple)
delete (simple)
Then the next level contains more advanced commands like:
alter table
create view
create index
etc.
An so on.
Looks like you answered your second question. It sounds like they're limiting your ability to use it inside server side pages.
Can you import the data into another database format that is better suited for the web?
Regards,
Peter J. Boettcher
PJ | Are we there yet?
pjboettcher.com
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.