Fw: Need assistance with fpODBC

[Richard Hane]

[ Sorry top posted ]
 
Thanks to all who helped.  Ken please ignore my last email.
 
I think I have it now although I am having trouble with the DSN connection.  However, I think that has to do with the path.
 
My confusion was that looking at the sample ODBC files I assumed there was someplace outside of the file you were updating to set the connection data, table, fields, etc.  I'm sure when I took the class they probably told us this but it was 6-8 years ago and I am old and forget things.
 
Again thanks to all who helped.
 
Rick Hane

----- Forwarded Message -----
From: Rick Hane <rhane at deluxestitcher.com>
To: Kenneth Brody <kenbrody at spamcop.net> 
Cc: file Pro Mailing List <filepro-list at lists.celestial.com> 
Sent: Thursday, October 25, 2012 10:02 AM
Subject: RE: Need assistance with fpODBC




-----Original Message-----
From: Kenneth Brody [mailto:kenbrody at spamcop.net] 
Sent: Thursday, October 25, 2012 9:41 AM
To: Rick Hane
Cc: file Pro Mailing List
Subject: Re: Need assistance with fpODBC

On 10/24/2012 4:58 PM, Rick Hane wrote:
>>[... Populating a file from an ODBC "import" ...]
>>
>> Thanks for the reply and information.  Here is the info I copied from

>> the ODBC link in Excel.
>>[...]
>> From this I see most that I need to set up the ODBC Link in fp.
>> I looked through the ODBC 'Sample' files and I have three questions.

>> I am still not understanding the flow.
>>
>> 1. In what filePro file do you put this link? New or do you use the 
>> 'sample' files they came with fp?
>>
>> 2. If it is a new file, do you create a record for each table to
read?
>>
>> 3. If it is only one link definition, do you "use" the appropriate 
>> table in each processing?
>>
>> As I said I'm just not getting the flow.  Actually it just my age
(64).

> If you were to populate a filePro from from a CSV file via IMPORT
ASCII, how would you do it?  The same answers apply to your 3 questions
above.
>
>(Again, this is going under the assumption that you want to "import"
the file into filePro, rather than have live access to the SQL data.)
>
>--
>Kenneth Brody

Ken,

That's my point exactly.

I use dif with import dif but it's the same.  The link, tables and
fields are all defined in the dif file.  There is no intermediate file
any longer.

So I assume (insert joke here) that I would define the link, table and
fields in the import process.  If that is correct then I just
misunderstood what the sample files show and all makes sense.

Thanks
Rick


_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
Subscribe/Unsubscribe/Subscription Changes
http://mailman.celestial.com/mailman/listinfo/filepro-list
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20121025/a101b13c/attachment.html