dbTalk Databases Forums  

Setting up ODBC between FMP7 Databases

comp.databases.filemaker comp.databases.filemaker


Discuss Setting up ODBC between FMP7 Databases in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Ron H.
 
Posts: n/a

Default Setting up ODBC between FMP7 Databases - 08-10-2005 , 06:33 AM






Hi All,
I have 2 separate databases set up on a small PTP network using FMP7 for
both databases
I want to do table lookups on one db from the other db across the netwok.
Obviously in this case FMP7 is going to be both a Client and a Source. My
questions
1. Because I am communicating between FMP7's only do I have to install a
driver
2. If so where do I find the driver and how do I install it
3. Do I have to install the driver in both Client and Source FMP7's
4. Because FMP7 networks only allow 6 users (Host + 5 Remotes) per database,
will a Client making a SQL request to a Source cause the user count on the
Source machine to step up by 1

Regards Ron H.



Reply With Quote
  #2  
Old   
Lynn allen
 
Posts: n/a

Default Re: Setting up ODBC between FMP7 Databases - 08-10-2005 , 03:16 PM






Ron H. <ronald_h70 (AT) hotttmail (DOT) commm> wrote:

Quote:
Hi All,
I have 2 separate databases set up on a small PTP network using FMP7 for
both databases
I want to do table lookups on one db from the other db across the netwok.
Obviously in this case FMP7 is going to be both a Client and a Source. My
questions
1. Because I am communicating between FMP7's only do I have to install a
driver
2. If so where do I find the driver and how do I install it
3. Do I have to install the driver in both Client and Source FMP7's
4. Because FMP7 networks only allow 6 users (Host + 5 Remotes) per database,
will a Client making a SQL request to a Source cause the user count on the
Source machine to step up by 1
Don't use ODBC between FM databases. Set them both to be multiuser, host
them both, and do the lookups directly using the Field definitons in FM.

Lynn Allen
--
Allen & Allen Semiotics www.semiotics.com
FSA Associate Filemaker Design & Consulting


Reply With Quote
  #3  
Old   
Ron H.
 
Posts: n/a

Default Setting up ODBC between FMP7 Databases - Thankyou - 08-11-2005 , 04:06 AM



Hi Lynne,
As always, you have something good to say. I did not realise that I could
make Table Relationships across db's. I tried it and it is simple. Thank you
Best Regards Ron H.

"Lynn allen" <lynn (AT) NOT-semiotics (DOT) com> wrote

Quote:
Ron H. <ronald_h70 (AT) hotttmail (DOT) commm> wrote:

Hi All,
I have 2 separate databases set up on a small PTP network using FMP7 for
both databases
I want to do table lookups on one db from the other db across the netwok.
Obviously in this case FMP7 is going to be both a Client and a Source. My
questions
1. Because I am communicating between FMP7's only do I have to install a
driver
2. If so where do I find the driver and how do I install it
3. Do I have to install the driver in both Client and Source FMP7's
4. Because FMP7 networks only allow 6 users (Host + 5 Remotes) per
database,
will a Client making a SQL request to a Source cause the user count on
the
Source machine to step up by 1

Don't use ODBC between FM databases. Set them both to be multiuser, host
them both, and do the lookups directly using the Field definitons in FM.

Lynn Allen
--
Allen & Allen Semiotics www.semiotics.com
FSA Associate Filemaker Design & Consulting



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.