Ah, i forgot a 3rd option. Try the odbc driver from Openlink Software.
http://uda.openlinksw.com/odbc-sqlserver-ee/ They are also offering a evaluation of it. Regards, Matthias Am 26.04.2014 um 20:31 schrieb Matthias Rebbe | M-R-D <matthias_livecode_150...@m-r-d.de>: > 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 _______________________________________________ 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
