cowtram Posted November 16, 2001 Share Posted November 16, 2001 PROBLEM: SQL query using ODBC and ASP We are connecting through ASP to an FM DB over ODBC, no problem: var oRS=Server.CreateObject(“ADODB.Recordset” ; oRS.Open(“myFMDB.fp5, “DSN=myDSNname” ; However, how can you do an SQL Query? This wont work: oRS.Open(“SELECT * FROM myFMDB.fp5”, “DSN=myDSNname” ; Thanks in advance. Link to comment Share on other sites More sharing options...
cowtram Posted November 16, 2001 Author Share Posted November 16, 2001 This problem is now solved. Thankyou. Link to comment Share on other sites More sharing options...
Newbies daminsky Posted January 26, 2002 Newbies Share Posted January 26, 2002 What did you do to fix? It seems that most of the regular users on this forum will bad mouth other programming languages and say that ODBC is slow, but no one will shed light on how to do it. IMO, FileMaker messed up again by claiming to support ODBC, but it really doesn't not. Link to comment Share on other sites More sharing options...
Anatoli Posted January 26, 2002 Share Posted January 26, 2002 RE: ODBC is slow In FileMaker yes, it is slow... Link to comment Share on other sites More sharing options...
Garry Claridge Posted January 26, 2002 Share Posted January 26, 2002 Do you have "Local Data Access Companion" and/or "Remote Data Access Companion" enabled in the FM Plug-Ins preference? If not, this will prevent FM returning data to ODBC queries. Garry Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8266 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