Setting up a new ODBC connection

[Richard Kreiss]

Top Post:

I am not answering your question about filePro an ODBC.

However, it make more sense to run both on the server.  It should be a lot faster and it avoids the issue of mapped drives.  One must be logged in the system to see drive mappings.

I had to rewrite a lot of batch files used to run overnight tasks as they had too run on the server when no one was logged in.  Rather the using a simple f:\fp\rreport ......  I had to adjust this to e:\company\another folder\fp......

Yes, the locations are set in the batch file as my program reads the settings at time to know if the program is running from the server as a task, the server as a menu options or from RDP or a local computer.  This is especially true for creating PDF files as the files are placed into specific folders based on what the report is.

Richard Kreiss

> -----Original Message-----
> From: Filepro-list [mailto:filepro-list-
> bounces+rkreiss=verizon.net at lists.celestial.com] On Behalf Of Richard Hane via
> Filepro-list
> Sent: Wednesday, June 7, 2017 2:44 PM
> To: Filepro List <filepro-list at celestial.com>
> Cc: Rick Hane <rhane at deluxestitcher.com>
> Subject: Setting up a new ODBC connection
> 
> As you may be aware over my emails during the past week, we have had our old
> server go belly up, installed a new server, os, sql and installed filePro (fpodbc 16
> user) version 5.0.15D9.
> Now I must setup a new ODBC connection between filePro and our new ERP (in
> sql) software.
> A couple of questions for those who may have set an odbc or are aware of it...In
> the past I set this up on my workstation (before I retired 2 1/2 years ago) and ran
> the updates each morning from the workstation.  Is it better to set this up on the
> new server?  Both filePro and ERP our located on that server.  Once setup can
> this be run as a scheduled task without user input?
> Thank you,Rick HaneDeLuxe Stitcher Company IncYore Software Company
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://mailman.celestial.com/pipermail/filepro-
> list/attachments/20170607/de72d95d/attachment.html>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list