Chuck
Thanks for answering SQL is running and shows the active connection when the code is run from the client I have just copied the code to a single user database and I am on the same network and subnet Steve > On 9 May 2018, at 21:24, Chuck Miller via 4D_Tech <[email protected]> > wrote: > > Are you sure that > 1. SQL server is running > 2. you are trying to connect to same place > > Regards > > Chuck > ------------------------------------------------------------------------------------------------ > Chuck Miller Voice: (617) 739-0306 > Informed Solutions, Inc. Fax: (617) 232-1064 > mailto:cjmiller<AT SIGN>informed-solutions.com > Brookline, MA 02446 USA Registered 4D Developer > Providers of 4D and Sybase connectivity > http://www.informed-solutions.com > ------------------------------------------------------------------------------------------------ > This message and any attached documents contain information which may be > confidential, subject to privilege or exempt from disclosure under applicable > law. These materials are intended only for the use of the intended > recipient. If you are not the intended recipient of this transmission, you > are hereby notified that any distribution, disclosure, printing, copying, > storage, modification or the taking of any action in reliance upon this > transmission is strictly prohibited. Delivery of this message to any person > other than the intended recipient shall not compromise or waive such > confidentiality, privilege or exemption from disclosure as to this > communication. > >> On May 9, 2018, at 3:40 PM, Stephen Shaw via 4D_Tech <[email protected]> >> wrote: >> >> Hi all >> >> I get an error when using the sql login command from 4D Developer from a >> stand alone database, but not from a 4D client >> >> >> SQL LOGIN(“4D:DatabaseName”;"user”;"Userpassword";*) >> If (ok=1) >> ALERT("Success”) // works on 4d client attached to the database >> SQL LOGOUT >> Else >> ALERT("Failure”) >> // fails with stand alone (error = SQL error 9918. Generic SQL error >> [1006 SQL error 9918. Generic SQL error; 3 connection is broken]) >> End if >> >> I have plenty (3) spare client licences available. Is this expected >> behaviour or am I missing some subtlety > > ********************************************************************** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:[email protected] > ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
