Newbies dasley Posted June 11, 2001 Newbies Share Posted June 11, 2001 I'm new to FM, and i would like to export some FP5 files to another database. I correctly connect to the FM ODBC driver. THE PROBLEM IS : BECAUSE I do not know the table name generated by FM (i only know the fp5 file name where i save the table), i cannot call "SELECT, INSERT, ..." SQL statements through ODBC. How can i know the table name in FM 5 ? Thank you Link to comment Share on other sites More sharing options...
colinwright Posted June 11, 2001 Share Posted June 11, 2001 Some one please correct me if I am wrong, but I believe that FM uses the filename. Since each table in a database in FM is in its own file, each table is referenced as the filename. It is referenced that way when trying to create relationships, and I believe it is like that when using ODBC. Colin Link to comment Share on other sites More sharing options...
Newbies dasley Posted June 11, 2001 Author Newbies Share Posted June 11, 2001 I tried to open the file C:Program FilesFileMakerTutorialSample FilesSample02.fp5 by using this statement : select * from Sample02 But it does not work (error : database not open). How must i open the database ? The ODBC driver does not accept any FP5 file name. The FM ODBC driver is 3.11.00.00 Link to comment Share on other sites More sharing options...
JPaul Posted June 11, 2001 Share Posted June 11, 2001 quote: Originally posted by dasley: I tried to open the file C:Program FilesFileMakerTutorialSample FilesSample02.fp5 by using this statement : select * from Sample02 But it does not work (error : database not open). How must i open the database ? The ODBC driver does not accept any FP5 file name. The FM ODBC driver is 3.11.00.00 What kind of language / environment do you are using to launch the SQL statement (MS Access / VB or other) from ? Link to comment Share on other sites More sharing options...
Newbies dasley Posted June 11, 2001 Author Newbies Share Posted June 11, 2001 I'm using many tools to run SQL statements. The first one is the database explorer from the "Borland Database Engine" shipped with Delphi. When using this tool, i get error [key violation]. The others tools are those shipped with the ODBC SDK 3.5. When using these tools, i get error [database not open]. In final, i used MS Access to import datas from an ODBC DSN source (which is FM DSN). Unfortunately, MS Access returned me an error. I did many things but nothing works. I create some FP5 files AND i cannot export datas from FM to another database. I cannot believe it is impossible to do such thing. please help !!! Link to comment Share on other sites More sharing options...
colinwright Posted June 12, 2001 Share Posted June 12, 2001 Is the file you are trying to access open within FM? One requirement that FM has is that both FM and the database (file) you are trying to access be open/running when using ODBC or JDBC. Colin Link to comment Share on other sites More sharing options...
Newbies dasley Posted June 12, 2001 Author Newbies Share Posted June 12, 2001 Thank you very much Colin. This is the correct procedure in order to read the datas within my FP5 file. Sincerely, thank you very much. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8492 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now