Hi Rodney,
Am 26.04.2014 um 18:24 schrieb Rodney Green <green.rod...@gmail.com>: > Any ideas on how I can trap this error? > There are 2 things you could try. You could try to use the legacy database drivers in LC. In LC´s preferences go to "compatiblity" and activate "Use legacy drivers" This will force Livecode to download and use the data base drivers of version 2.8.1 Another possibility is to ask Acutaltech´s support. They are really helpful. To save some time you could send a logfile from the Actualtech ODBC drivers with your support request. I am pretty sure they will ask for it. Please follow the 7 steps below to create the log file: 1. Quit your application 2. Using the ODBC Manager (in /Applications/Utilities), select your DSN and press Configure 3. On the first panel, press "About" 4. Click on the Actual Technologies logo (the puzzle pieces) 5 times. You should see the following appear: "Log file: /Users/<account name>/Library/Logs/atsqlsrv.log 5. Restart your application, and using as few steps as possible, reproduce the problem 6. Go back to the About dialog and click on the logo 5 more times to disable logging 7. Send the following files to support(at)actualtech.com (located in the "/Users/<account name>/Library/Logs" folder): a. atsqlsrv.log b. atsqlsrv.log.tds and include as much information as you can. Maybe they can find out what is going wrong. Hope this helps. Regards, Matthias > > On Fri, Apr 25, 2014 at 7:22 PM, Matthias Rebbe | M-R-D < > matthias_livecode_150...@m-r-d.de> wrote: > >> 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 >> > _______________________________________________ > 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
