Hi Rodney, i am using the Actualtech ODBC driver with Microsoft SQL server without problems. Just to be sure that there are no problems with newer versions of LC i did a quick test right now with one of my projects with LC 6.7.0DP2, Actualtech ODBC driver version 3.2.3 and MS SQL Server 2005 and 2008. My select query is about 70 lines contains several case statements with several replace statements and several joins. All is working as expected even over VPN.
Regards, Matthias Am 25.04.2014 um 00:51 schrieb Rodney Green <green.rod...@gmail.com>: > I'm curious, does anyone have a project that uses the revDataFromQuery() > command? And does anyone use the Actual Technologies ODBC driver? > > > On Thu, Apr 24, 2014 at 9:23 AM, Rodney Green <green.rod...@gmail.com>wrote: > >> I'll put in a bug report for this. Does anyone have any kind of >> work-around for this? Have there been any updates to database in the >> developer previews? Maybe I'll give a DP a try. >> >> >> On Wed, Apr 23, 2014 at 7:53 PM, Rodney Green <green.rod...@gmail.com>wrote: >> >>> I tried it in 6.6 and 6.6.1. I'm using Actual Technologies ODBC manager >>> (demo). And I can connect successfully to the SQL server with Navicat. I'm >>> on a Mac (10.9.2) and connecting via a VPN. >>> >>> >>> On Wed, Apr 23, 2014 at 7:17 PM, Peter Haworth <p...@lcsql.com> wrote: >>> >>>> That seems strange - I wouldn't expect to see field names, just the data >>>> in >>>> them. What version of LC are you using? Might be time to enter a bug >>>> report. >>>> >>>> Pete >>>> lcSQL Software <http://www.lcsql.com> >>>> Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and >>>> SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html> >>>> >>>> >>>> On Wed, Apr 23, 2014 at 2:47 PM, Rodney Green <green.rod...@gmail.com >>>>> wrote: >>>> >>>>> I turned on tracing in the odbc driver and I can see field names in the >>>>> data. So I'm assuming the query is working. But still can't figure out >>>> why >>>>> LC is hanging. I have database checked in the stand alone settings, not >>>>> sure if this matters while in LC. Any ideas how I can track down why >>>> LC is >>>>> hanging? >>>>> >>>>> >>>>> On Wed, Apr 23, 2014 at 10:13 AM, Peter Haworth <p...@lcsql.com> >>>> wrote: >>>>> >>>>>> In gmail, you can fix that by using the "Paste and match style" >>>> option on >>>>>> the edit menu. >>>>>> >>>>>> Pete >>>>>> lcSQL Software >>>>>> On Apr 22, 2014 7:34 PM, "J. Landman Gay" <jac...@hyperactivesw.com> >>>>>> wrote: >>>>>> >>>>>>> On 4/22/14, 6:49 PM, Kay C Lan wrote: >>>>>>> >>>>>>>> I don't know if it's just your email client but what I'm seeing >>>> is an >>>>>>>> asterisk * around the words get, put and return which shouldn't be >>>>>> there. >>>>>>>> >>>>>>> >>>>>>> That happens to all keywords when a colorized script is copied >>>> from the >>>>>>> script editor and pasted into a text-only email list. I see it >>>> here all >>>>>> the >>>>>>> time. >>>>>>> >>>>>>> -- >>>>>>> Jacqueline Landman Gay | jac...@hyperactivesw.com >>>>>>> HyperActive Software | http://www.hyperactivesw.com >>>>>>> >>>>>>> _______________________________________________ >>>>>>> use-livecode mailing list >>>>>>> use-livecode@lists.runrev.com >>>>>>> Please visit this url to subscribe, unsubscribe and manage your >>>>>>> subscription preferences: >>>>>>> http://lists.runrev.com/mailman/listinfo/use-livecode >>>>>>> >>>>>> _______________________________________________ >>>>>> use-livecode mailing list >>>>>> use-livecode@lists.runrev.com >>>>>> Please visit this url to subscribe, unsubscribe and manage your >>>>>> subscription preferences: >>>>>> http://lists.runrev.com/mailman/listinfo/use-livecode >>>>>> >>>>> _______________________________________________ >>>>> use-livecode mailing list >>>>> use-livecode@lists.runrev.com >>>>> Please visit this url to subscribe, unsubscribe and manage your >>>>> subscription preferences: >>>>> http://lists.runrev.com/mailman/listinfo/use-livecode >>>>> >>>> _______________________________________________ >>>> use-livecode mailing list >>>> use-livecode@lists.runrev.com >>>> Please visit this url to subscribe, unsubscribe and manage your >>>> subscription preferences: >>>> http://lists.runrev.com/mailman/listinfo/use-livecode >>>> >>> >>> >> > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
