ODBC connection with Word ...

[Nro]

I think I finally need some advice from Filemaker Pros

I'm working with Win Xp (home Ed.), Filemaker v8 (demo) and Word 2003 and Visual Foxpro 9.0

I want to connect to a FM db. I've created a ODBC DSN with Filemaker Pro Driver. I'm surprised that there is no place to select the DB...

In the DB (let's say Customer.fp7), I have put the Edit/Share ODBC Active ... but I have no clue from that point, so far.

If I try to connect with Fox (or Word), it return an error.

I only need the 1 2 3 steps to connect to my Filemaker Database.

Thanks in advance.

Nro

 

[JeanW]

I don't know for other applications other than FM, since you say 'I only need the 1 2 3 steps to connect to my Filemaker Database.'

This is how I connect FM to another application.(which is the other way round, to your question ¿?)

Before you can import, you must have the proper ODBC drivers installed. Because each application is different you have to find out what you need and what resources are available.

You open the FM db into which you want to import ODBC source data, and go to Import records.
In that dialog box, select ODBC Data Sources, other choices are csv, slk, mer, dbf etc

In the Select ODBC Data Source dialog box, choose the type of data source you want to import from, you have there FoxPro, FM, Access etc.

If you need a password to access the data, enter this in the next box.

From this point on you can make your query y following the steps in the different screens.

If you want to share your FM db. you have to register the db in windows.

To make it possible for others using ODBC to access the FM files, you must first register the FM db on your computer as a data source, then turn on the Data Access plug ins.

Open the FM db you want to register, in Windows, start - Settings - control panel - ODBC Data Sources.
If there is no Filemaker in the list, you have to click on Add and follow the instructions tht appear.

Click the system DSN tab and the Add button.
In the Create New Data Source dialog box, click the Filemaker Pro driver/Finish

In the ODBC Filemaker Pro Driver Setup dialog box, type the name of your db in the Name box/Apply/OK

Your db will be listed in the System Data Sources window and will be available to other ODBC apps.

HTH

JW

 

[Nro]

Hello

What I try to do is very simple. I want to connect to a Filemaker Pro DB from an other application. Export or import is not an option, so, my only choice is ODBC.

Now, I've create an ODBC System DSN (Add/select Filemaker Pro driver/ put a name for the DSN and Apply).

I try this with Filemaker pro V6
After that, I opened my DB (customer.fp5) and goto Sharing, and checked "Remote Data Access". I then change the applications preferences, and checked "Remote data access compagnion".

If I try to use my OBDC DSN in one application to connect to Customer.FP5, for exemple, create a view in Visual Foxpro, I've received a connection error.

I don't have any place to put the name of the table in the ODBC manager. Is there an other place ?

Thanks in advance.

 

[JeanW]

You have to do nearly the same in your application to connect to a FM db as you have to do in FM to connect to an other application.

Register that application in Windows and after that you can put the name in the ODBC manager.

HTH

JW

 

[Nro]

Sorry Jean but I'm still in nebulae about Registering an application in windows. Can you explain a little bit more.

Thanks for your advice and your patience.


Nro

 

[philhege]

Nro, I believe you have to have the FM db opened (that is, running in the Filemaker application) for ODBC to take effect. This is unlike Access, Excel et al. datasources, where all you need is permissions to the file.

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
I'm not as think as you confused I am.
-----------
Flabbergasted (a.): Amazed at how much weight one has gained.
-----------
Oyster (n.): One who sprinkles their conversation with Yiddish expressions.