Re: MS SQL

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 : > Hi Rodney, > > > Am 26.04.2014 um 18:24 schrieb Rodne

Re: MS SQL

Hi Rodney, Am 26.04.2014 um 18:24 schrieb Rodney Green : > 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

Re: MS SQL

Thanks Matthias, that's good to know. I'm using the evaluation version but I think that its supposed to return 3 rows of data. This should work in the LC IDE correct? Any ideas on how I can trap this error? On Fri, Apr 25, 2014 at 7:22 PM, Matthias Rebbe | M-R-D < matthias_livecode_150...@m-r-d.d

Re: MS SQL

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 a

Re: MS SQL

On Thu, Apr 24, 2014 at 3:51 PM, Rodney Green wrote: > I'm curious, does anyone have a project that uses the revDataFromQuery() > command? > Yes, but I use it with SQLite and Postgres (and used it briefly with mySQL). But I'm old enough that I'd never consider using an MS database. -- Dr. Ri

Re: MS SQL

Just a heads up, remember that SQL servers have a timeout on connections, so when you open a database, remember to close it after you are done. If it has been idle for any length of time, Livecode still thinks it is open, but the SQL server has probably terminated the connection. This has reso

Re: MS SQL

Oh THAT is what does that! I usually just convert the email to plain text before posting to the list. Maybe a good practice for all? Bob S On Apr 22, 2014, at 7:34 PM, J. Landman Gay 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 se

Re: MS SQL

I use revDataFromQuery all the time, but it's to access a local (to the app) sqlite DB. Works great with SQLite I also use MS SQL Server, but only access it via custom web services. I have never had any luck connecting to it otherwise. I've heard good things about the Actual Drivers, but again,

re: MS SQL

Auto speller typo correction : read dbRecordSets["menu_r1"] instead of dbRecordSets[" menu_r1"] > I use it all the time in most of my projects running in a > LC-Server+PostgreSQL+RevIgniter+JQuery context (no experimented against MS > SQL Server at all, sorry). See below for a daily working

Re: MS SQL

I use it all the time in most of my projects running in a LC-Server+PostgreSQL+RevIgniter+JQuery context (no experimented against MS SQL Server at all, sorry). See below for a daily working example witch builds on the fly an HTML5/JQuery multi-hierarchical pulldown menu : > put revDataFromQue

Re: MS SQL

I'm sure there are many people who use revDataFromQuery, less so the ODBC driver you mentioned. If that ODBC driver works in Navicat, then it seems the finger is pointing at some problem between Livecode and the ODBC driver. I think you said you'd enetered a bug report so hopefully it will get re

Re: MS SQL

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 wrote: > I'll put in a bug report for this. Does anyone have any kind of > work-around for this? Have there bee

Re: MS SQL

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 wrote: > I tried it in 6.6 and 6.6.1. I'm using Actual Technologies O

Re: MS SQL

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 wrote: > That seems strange - I wouldn't expect to see fi

Re: MS SQL

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 Home of lcStackBrowser and SQLiteAdmin

Re: MS SQL

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 hangi

Re: MS SQL

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" 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 th

Re: MS SQL

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-onl

Re: MS SQL

It still hangs after I changed the line of code. Here's the entire script for the button. Also, this is a MS SQL server. Thanks again. *on* mouseUp *local* tDatabaseID *local* xQuery *local* rez *put* "Driver={Actual SQL Server};Server=xxx.xxx.x.x;Database=AT2005_Premier;UID=x

Re: MS SQL

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. Although it should work I'd also remove the first two parameters, tab and return, just to simplify things until you figure out exactly what's wrong. The mo