COMPGROUPS.NET | Search | Post Question | Groups | Stream | About | Register

### ODBC connection to FM - ebase

• Email
• Follow

I am trying to make an ODBC connection to FileMakerPro Server, Windows
2000, which is running the non-profit eBase application for FileMaker.
I think I am doing everything OK, but get a response that no
Filemaker tables can be found.

Presumably this is because eBase uses non-standard extensions, i.e.
..102 instead of .fm, etc. for the FileMaker Pro tables.

Is there anyway to get the ODBC to recognize the non-standard
extensions?

Or is there some other problem?

Thanks

 0

See related articles to this posting

To connect to FileMaker using ODBC, you have to set up Local (or
Remote) Data Access Companion on FileMaker Pro (not FileMaker Server).
FileMaker Server does not serve data to any application other than
FileMaker Pro and FileMaker Unlimited.  If you want to access
FileMaker data through ODBC, you have to designate a second computer
to run FileMaker Pro and act as the ODBC data source.

BTW, FileMaker is an extremely slow ODBC data source.  If possible,
you should try to get data from FileMaker using its Web companion
instead, which is much faster.  You have to send it HTTP requests, and
get back HTML or XML.  This is a little more complicated and less
straight forward than using ODBC, but is substantially faster.

Good luck!

 0

1 Replies
290 Views

Similar Articles

12/12/2013 1:47:49 PM
page loaded in 24520 ms. (0)

Similar Artilces:

ODBC/Oracle connection setup for Windows FM 7.0?
I'm sure I'm missing something but... In Mac OSX, there's the "ODBC Import Drivers Installer". This gives me an Oracle ODBC driver connection. Easily set up. I'm not finding the analogue in the Windows version. The on-line help says (rightly) that there are drivers are in \Program Files\Common Files\ODBC\FIlemaker. But I can't figure out a way to get these into the list of ODBC drivers available in the Administrative Tools --> Data Sources (ODBC) Control Panel. I'm missing something obvious -- any idea what? Thanks! - Steve In article <0510200...

odbc connection
I am using PSQL 2000i SP3 on windows 2000 server. I am intenting to write a web application with php on linux. How should I connect from the php to PSQL in windows? I have installed a odbc manager on linux but there is no driver. Where could I find relevant drivers? And what are the settings required for windows and linux odbc manager? I'm not sure that what you want is possible. I would recommend upgrading to a newer version, specifically PSQLv9, which comes with c Linux client, and should do the job quite handily. If it helps, Pervasive (and some resellers like us) are running a s...

Close ODBC Connection / DSN vs DSN-less Connection / Access 2k2 Front-End
Hello All, The short questions are 1 Do you know how to make DSN connection close in Access to Oracle 10g Express Edition? &/or 2 Do you know how to make a DSN-less pass-through query work from Access 2k2 to Oracle 10g Express Edition? I'm experimenting using Access 2k2 as front-end to Oracle 10g Express Edition. I've tried a DSN connection, and it works. The problem is that once Access creates the connection using a password and UserID from a form, it does NOT close the connection. The only way to close the connection is to close Access. This is not good if different user...

FM 6 Odbc Bug?
Hi all, When running this sql against an FM 6 database, the application performing the query just exits. No error codes or anything. It doesn't matter if its my .Net application or Microsofts query tool. Any ideas? Select * from Table where Col1 = 'Value A' OR Col1 = 'Value B' It supports the AND in the where clause, but not OR?? Thanks Andy Found the solution.. You have to wrap each part of the OR in parans...like so SELECT * FROM TABLE WHERE ( ID = 235 ) OR ( ID = 234 ) Otherwise the driver will crash (bleck). andy Actually that didn't fix it.. well it d...

Problem with Topspeed ODBC connection
Hey all, I am having trouble connecting to a topspeed database through ODBC. It is already connected to Oracle and MSSQL, with no current problems. But when I try to create the equivalent .tsp files I get the error message 'Expected lexical element not found: )' I have narrowed it down to when a table has a key....works no problem if you don't define a key at all. This is further narrowed down to a primary key. When I remove the keyword primary....and try connecting, (I still get a file system error, although there is no fileerror message) the table does get created. these ta...

ODBC connection to MAX db
Hi There, I need to interface my company's MAX database and i can't get the odbc connection going. I have an entry in the Windows Control panel ODBC thingy under "System DSN" called MAXDAT which is also the database name. Hence I have tried to estrablish a connection as follows: database connect db {Driver=MAXDAT;Database=MAXDAT} but all i get is an error saying: "IM002 02 {[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified} while executing "database connect db {Driver=MAXDAT;Database=MAXDAT}" ("bla\bla\file"...

DSN Less ODBC Connection
I went thru heXX trying to get a DSN less connection to File Maker using c#. After wasting 2 hours I came up with this and it works; String connectionString = "DRIVER=DataDirect 32-BIT SequeLink 5.4;" + "UID=userid;" +//your user id "PWD=password;" +//your password "PRT=2399;" + "HST=10.127.55.22;" + //your ip here "SDSN=dbname"; //your db name Enjoy Timothy Huertas ...

Creating ODBC Connection to SQL Server
Hi, I've been using Access 2000 for a while but this is my first time trying to connect an Access Front End to a SQL Server back-end. I've created a few tables in SQL Server (2005 Standard) in a database file I call CustInfo.mdf. I go into into MS Access and create the ODBC connection to this file. When I click on the new ODBC connection I see a load of tables I can link to, but they are all from the SQL Master Database (tables and Views). None of my CustInfo tables are there. I think I'm probably doing something fairly stupid, but I can't quite put my finger on it. Any t...

Connecting to Orable DB with Microsoft ODBC
Sorry for the cross post but I wasn't sure which group might be able to help. I'm having a problem with connecting to Oracle DB using MS Access. I setup a system DNS but when I try to connect, I get the below error: ODBC call failed. [Microsoft][ODBC driver for Oracle][Oracle]ORA-06401: NETCMN: invalid driver designator (#6401) [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed IM006 0 [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed (#0) I can make a connection using Toad, but I need to connect with MS SQL and MS Access and becuase I'...

ODBC Bridge Connections From JSP Help
Hi All, I'm just learning JSP and I've run into a problem. I'm trying to get a database connection for a login page I've created using Jakarta's DBTag library. I configured the ODBC data source (proj3odbc) on the box that Tomcat 5.X runs on. The DBMS, however, runs on another box. I've verified that the datasource works. The user name is userxxx and the password is ASECRET. Here's my JSP connection code: // Make database connection via the Sun ODBC Bridge <sql:connection id="dbCon"> <sql:url>jdbc:odbc:proj3odbc:...

Using odbc to execute FM scripts
Hi all, Its been a while (almost a year), but I have more questions for the group. The company I was working for closed and was absorbed into the sister company, but the work I did was absorbed as well.. now acting as an outside consultant. Anyway, the company is now on FM8, we decided to skip 7 and got it covered to 8 just before the company totally closed down. I'm now at a point where there is a Filemaker script, which is being built by one of the employees there. Its a variation of a script that creates a bunch of records and sets up some data. Normally, the user enters data on t...

ODBC connection fails only for a single table
I have Oracle 9.2 tables linked in Access. Data can be pulled from all the tables except one !! It gives "ODBC connection failed" error when trying to open the link.I deleted the link and created it again. But didn't help. Closing and reopening Access didn't work either. Any ideas? Thanks in advance. Nitin wrote: > I have Oracle 9.2 tables linked in Access. Data can be pulled from all > the tables except one !! It gives "ODBC connection failed" error when > trying to open the link.I deleted the link and created it again. But > didn't help. Closin...

ODBC connection to a DB on another computer?
In a PHP script, I'm using a DSN-less ODBC connection to connect to an MS Access database. Like so: $DBConn = 'Driver={Microsoft Access Driver (*.mdb)}; DBQ=c:\path\to\MyDatabase.MDB';$conn = odbc_connect($DBConn,'',''); This works fine - no problems. Now, I want to connect to an Access database that is on another computer (on a LAN). Using a similar statement:$DBConn = 'Driver={Microsoft Access Driver (*.mdb)}; DBQ=\\ComputerName\c\path\to\MyDatabase.MDB'; $conn = odbc_connect($DBConn,'',''); But this results in an error: SQL error: ...

FM Server 7, Mac OSX, and ODBC
The errata sheet for FM Pro Server 7.0 says that it does not support ODBC on Mac OSX. It also says that they're working on it. Has that been fixed yet? Does that mean that FM Server can't connect to another database through ODBC? Or does it only mean the reverse, that another database can't connect to the FM Server through ODBC? If it's the second case, I'm in the clear! =) audleman@quasika.net wrote: > The errata sheet for FM Pro Server 7.0 says that it does not support > ODBC on Mac OSX. It also says that they're working on it. Has that been > fixed yet? ...

Re: connect ODBC database from SAS #3
Thank you Sigurd. I still get some error message like this: ERROR: CLI describe error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'subject date'. : [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared. When I use the totally same code to pull out another table with name without space, everything is fine. Do you have any idea about it? Thanks Jane On 5/8/07, Sigurd Hermansen <HERMANS1@westat.com> wrote: > > Jane: > SAS has options that permit variations in dataset and column variable > na...

Oracle connection problems; Odbc call failed
Hello all. I just installed Oracle 10g developer tools on a machine running XP Pro and Office XP. Before this I had just the Oracle 9 client installed. I the previous configuration, I was able to access any of the Oracle tables on another machine but now I am having problems. Unfortunately, I don't remember the correct syntax for the ODBC connect string and I am hoping that is my whole problem. I am trying to connect to an Oracle 9 database on a VMS server. Here's the info: VMS machine: -IP Address 192.168.0.250 -Database global name: db1.mcbill PC: -IP Address: 192.168.0.202 -Win X...

how connect to MS-SQL directly without ODBC?
have Library to connect SQL server directly without ODBC, like .NET do? mtczx...@yahoo.com wrote: > have Library to connect SQL server directly without ODBC, like .NET do? I guess JDBC will do what you want. For MS-SQL you might check out jTDS (http://jtds.sourceforge.net/). From my experience it is reasonably stable, even for productive systems, by now. /philipp mtczx232@yahoo.com wrote: > have Library to connect SQL server directly without ODBC, like .NET do? Just download the appropriate jdbc driver from microsoft. sql server 2005 : http://msdn.microsoft.com/data/ref/jdbc/ s...

SQL Server ODBC Read-Only Connection Problem
Hi, I have two, similar SQL Server 7.0 databases (in the same SQL Server Group) that I use as the backend for two Access 2000 front end applications - one is the live version, the other is the development version. The live version works fine. But the other version is read-only, i.e. no changes can be made to the data in the tables, over the ODBC connection. Both systems have similar ODBC connection properties, the permission settings on the SQL Server databases are the same - users, table access, database access, etc. The connections use Windows authenication and the users are set up in S...

MS Access ODBC -- Connect failed!! #2
I wrote about this one a while ago, and got a few responces, but nothing resolved the issue. Figured I'd give everyone one more crack at it. I have an established MS Access database using linked tables to an external MS-SQL datasource, through ODBC. I can establish the ODBC link, I can link the tables in a new MS Access database (File -> Get External Data -> Link Tables...), I can view the structure of the linked table(s), I can querie the tables and view table data. When trying to run a form which uses multiple linked tables & queries, the application responds ODBC -- call fai...

C++ Database Connections. OLE DB, ODBC, ADO, ...
Hi, I've been trying to find out what the best way to connect to databases, specifically SQL Server is from a c++ app. There seems to be lots of ways suggested by microsoft - ADO, OLE DB, ODBC, DB Library, Embedded SQL for C. Last 2 aren't really options i think. I would have thought ADO would be strongly recommended but it doesn't seem to be. Does anybody have a really strong preference for ADO, OLE DB or ODBC?? Or opinion about why one is better? I would expect OLEDB +ODBC would be faster and ADO easier to use for clients?? I don't care about portability though dont like th...