MS SQL

Sat Apr 26 14:31:24 EDT 2014

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