fpodbc and sql connections

[Richard Hane]

Good morning Ken,

We ran the batch file again this morning and finally received a Windows error message we have never seen before.  I have not explored this error message on the web yet.  Maybe someone will know what it means.

We do have several versions of SQL, one being 2005.  But we have made no new changes in the past 6 months to my knowledge.  Below is the error message.



If we answer 'No' to the above, the process runs.

Thank you in advance,
Rick Hane



On Friday, February 6, 2015 8:31 AM, Kenneth Brody <kenbrody at spamcop.net> wrote:
 


On 2/5/2015 8:13 PM, Richard Hane wrote:
> I have a long batch file which contains 9 filepro processes that read
> data from our MRP software written in SQL Server.  The rest of the lines
> are rreport processes.  This batch file has worked for several years.
>
> We are now running in to a problem making the initial connection.  Some
> times we have to run that process 3 or 4 times to make the connection.

When it fails to make the connection, what error do you get?

> Also, on occasion we will loose the connection.

What error do you get when the connection is "lost"?


>  This batch file had been
> run from my workstation.  To try and solve this, I moved the batch file
> to the sever.  On 2/5/15 it worked correctly.  Today the same problem
> with the initial connection happened again.  Yes we have turned off any
> antivirus software.
>
> Has anyone else had this problem?  And if so, how did you solve it?  Any
> other thoughts what the problem might be.


-- 
Kenneth Brody
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20150206/657a01ab/attachment.html>