RE: SQLStringConnect

2016-06-01 Thread Richard Kaye
6 AM To: profoxt...@leafe.com Subject: RE: SQLStringConnect Thanks Ted I highlighted the SQLStringConnect line in the watch window and dragged it to the command window - IOW am issuing _exactly_ the same command There is no typo in cConnectionString - and even if there were I would expect SQL

RE: SQLStringConnect

2016-06-01 Thread Paul Newton
@leafe.com] On Behalf Of Ted Roche Sent: 31 May 2016 18:00 To: profoxt...@leafe.com Subject: Re: SQLStringConnect On Tue, May 31, 2016 at 11:33 AM, Paul Newton wrote: > nConnectionHandle = SQLStringConnect(cConnectionString) > Assert .F. > > In the debugger Watch window nConnectionHandle

RE: SQLStringConnect

2016-06-01 Thread Paul Newton
Thanks Alan Tried that - no difference :( -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Alan Bourke Sent: 31 May 2016 16:55 To: profoxt...@leafe.com Subject: Re: SQLStringConnect Well, it works OK for me using SQL Server Native Client ... Try

Re: SQLStringConnect

2016-05-31 Thread Ted Roche
On Tue, May 31, 2016 at 11:33 AM, Paul Newton wrote: > nConnectionHandle = SQLStringConnect(cConnectionString) > Assert .F. > > In the debugger Watch window nConnectionHandle shows with value 1 > If I check SQLGetProp(1,"ConnectString") it shows expression cannot be > evaluated > > If do another

Re: SQLStringConnect

2016-05-31 Thread Alan Bourke
Well, it works OK for me using SQL Server Native Client ... Try sleeping for half a second before SqlGetProp() maybe ... in case it is a timing thing. -- Alan Bourke alanpbourke (at) fastmail (dot) fm ___ Post Messages to: ProFox@leafe.com Subscri

Re: SQLSTRINGCONNECT not respecting ConnectTimeout setting (VFP9SP1)

2008-07-21 Thread MB Software Solutions General Account
Paul McNett wrote: > MB Software Solutions General Account wrote: >> My ISP's MySQL database appears to have a problem. I can't conect to >> it, and in fact, my attempts just "hang." > > Sounds like a firewall issue, either on your end or on their end. Go to > a terminal and type "telnet 3306"

Re: SQLSTRINGCONNECT not respecting ConnectTimeout setting (VFP9SP1)

2008-07-21 Thread MB Software Solutions General Account
Bob Lee wrote: > What response code does the sqlstringconnect() function give you app ? It doesn'tthe entire app freezes on that line. It's noteworthy that from the DOS prompt, I can ping the server address just fine. ___ Post Messages to: ProFo

Re: SQLSTRINGCONNECT not respecting ConnectTimeout setting (VFP9SP1)

2008-07-21 Thread Paul McNett
MB Software Solutions General Account wrote: > My ISP's MySQL database appears to have a problem. I can't conect to > it, and in fact, my attempts just "hang." Sounds like a firewall issue, either on your end or on their end. Go to a terminal and type "telnet 3306" and see if you get a respons

Re: SQLSTRINGCONNECT not respecting ConnectTimeout setting (VFP9SP1)

2008-07-21 Thread Bob Lee
What response code does the sqlstringconnect() function give you app ? Bob Lee - Original Message - From: "MB Software Solutions General Account" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 21, 2008 12:08 PM Subject: SQLSTRINGCONNECT not respecting ConnectTimeout set