MS SQL

Sat Apr 26 14:38:14 EDT 2014

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_150811 at m-r-d.de>:

> Hi Rodney,
> 
> 
> Am 26.04.2014 um 18:24 schrieb Rodney Green <green.rodney at 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_150811 at 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.rodney at 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.rodney at 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.rodney at 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 <pete at 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.rodney at 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 <pete at 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" <jacque at 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         |     jacque at hyperactivesw.com
>>>>>>>>>> HyperActive Software           |     http://www.hyperactivesw.com
>>>>>>>>>> 
>>>>>>>>>> _______________________________________________
>>>>>>>>>> use-livecode mailing list
>>>>>>>>>> use-livecode at 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 at 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 at 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 at 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 at 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 at 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 at 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 at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode