If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > FileMaker > ODBC/OLEDB for FileMaker Pro 7.0

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 05-06-08, 21:53
rdjabarov rdjabarov is offline
Registered User
 
Join Date: Jul 2003
Location: San Antonio, TX
Posts: 3,611
ODBC/OLEDB for FileMaker Pro 7.0

I've been searching for it on and off today, but came up with nothing. Anybody happens to know where to get either one of those?
__________________
"The data in a record depends on the Key to the record, the Whole Key, and
nothing but the Key, so help me Codd."
Reply With Quote
  #2 (permalink)  
Old 05-07-08, 03:33
gvee gvee is offline
www.gvee.co.uk
 
Join Date: Jan 2007
Location: UK
Posts: 10,156
This will give you the answer.


Moved to Other PC Databases
__________________
George
Twitter | Blog
Reply With Quote
  #3 (permalink)  
Old 05-07-08, 03:43
healdem healdem is offline
Jaded Developer
 
Join Date: Nov 2004
Location: out on a limb
Posts: 9,243
erm probably best in the filemaker section I'd of thought.......
__________________
I'd rather be riding my Versys or my Tiger 800 let alone the Norton
Reply With Quote
  #4 (permalink)  
Old 05-07-08, 13:49
gvee gvee is offline
www.gvee.co.uk
 
Join Date: Jan 2007
Location: UK
Posts: 10,156
Wow, I've developed forum blindness, never saw this one on the list!!
__________________
George
Twitter | Blog
Reply With Quote
  #5 (permalink)  
Old 05-08-08, 10:39
rdjabarov rdjabarov is offline
Registered User
 
Join Date: Jul 2003
Location: San Antonio, TX
Posts: 3,611
Quote:
Originally Posted by georgev
This will give you the answer.
Nope, all they have is a instruction set on how to use the driver, not the driver itself. All I need is to get the contents of xxx.FP7 files into SQL. Will have to call their support now.
__________________
"The data in a record depends on the Key to the record, the Whole Key, and
nothing but the Key, so help me Codd."
Reply With Quote
  #6 (permalink)  
Old 05-10-08, 17:50
gvee gvee is offline
www.gvee.co.uk
 
Join Date: Jan 2007
Location: UK
Posts: 10,156
That linked to this which links to this... sorry, I was only two steps away from the answer
__________________
George
Twitter | Blog
Reply With Quote
  #7 (permalink)  
Old 05-11-08, 18:12
rdjabarov rdjabarov is offline
Registered User
 
Join Date: Jul 2003
Location: San Antonio, TX
Posts: 3,611
Hmmm...yup, I've gone there. This ODBC driver allows linking SQL from FileMaker. What I need is the other way around, so that I can create a linked server or issue OPENROWSET from SQL. After struggling on my own I placed a call to FileMaker ... only to find out that I need to have a credit card handy...This means, - back to re-quoting the proposal to include the cost.
__________________
"The data in a record depends on the Key to the record, the Whole Key, and
nothing but the Key, so help me Codd."
Reply With Quote
  #8 (permalink)  
Old 05-11-08, 18:35
gvee gvee is offline
www.gvee.co.uk
 
Join Date: Jan 2007
Location: UK
Posts: 10,156
Dam, sorry to hear that. Did the extra dollarini solve your problems in the end?
__________________
George
Twitter | Blog
Reply With Quote
  #9 (permalink)  
Old 05-25-08, 14:01
rdjabarov rdjabarov is offline
Registered User
 
Join Date: Jul 2003
Location: San Antonio, TX
Posts: 3,611
What a piece of junk this SequeLink ODBC driver from DataDirect! First, I did manage to create a linked server to FileMaker, by creating a system DSN, and then using MSDASQL provider for ODBC. But when I started working with it, all "memo" and some numeric fields started causing the driver failure. On some tables, when even doing "select...where 1=2" the driver was reporting "Out of memory" error. Using linked server I was able to get to 40% of the tables. So I ended up importing about 90% of tables into Access directly, then creating linked tables from Access to FileMaker for the other 10% of tables that were bombing with all kinds of driver errors, then creating "Create Table" queries by having to skip certain fields. Then, generating a cleanup script for all tables that have date/time field to set dates earlier than 1751 to null...And only then, - creating a linked server to Access, and loading every table with "select...into...from..." What a mess, the entire weekend is gone!
__________________
"The data in a record depends on the Key to the record, the Whole Key, and
nothing but the Key, so help me Codd."
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
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

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On