Yes thanks. For some reason I didn’t get the original reply to this.
Bob
On Mar 11, 2014, at 11:17 , Skip Kimpel <skiplon...@gmail.com> wrote:
> Awesome.... Thank you for that!
>
> SKIP
>
>> On Mar 11, 2014, at 1:27 PM, Matthias Rebbe | M-R-D
>> <matthias_livecode_150...@m-r-d.de> wrote:
>>
>> Hi Bob,
>>
>> i am using ODBC to MSSQL connections on Mac and Windows for some years now
>> with great success.
>>
>> I am using system dsn and in some projects also ODBC connection strings.
>> Advantage of the ODBC connection string is the customer do not have to
>> create a dsn.
>>
>> Here are some examples of ODBC connection strings under Windows
>>
>> SQL SERVER Driver
>> get revOpenDatabase("ODBC","DRIVER=SQL
>> Server;SERVER=192.168.1.250;DATABASE=DBNAME;UID=DBUSER;PWD=DBUSERNAME;Trusted_Connection=No",,,)
>>
>>
>> SQL Server Driver - connect to instance
>> get revOpenDatabase("ODBC","DRIVER=SQL
>> Server;SERVER=192.168.1.250\INSTANCENAME;DATABASE=DBNAME;UID=DBUSER;PWD=DBUSERPASSWORD;Trusted_Connection=No",,,)
>>
>>
>> Native Client 11 Driver
>> get revOpenDatabase("ODBC","DRIVER={SQL Server Native Client
>> 11.0};SERVER=192.168.1.250;DATABASE=DBNAME;UID=DBUSER;PWD=DBUSERPASSWORD;Trusted_Connection=No",,,)
>>
>>
>> Native Client 11 Driver - connect to instance
>> get revOpenDatabase("ODBC","DRIVER={SQL Server Native Client
>> 11.0};SERVER=192.168.1.250\InstanceName;DATABASE=DBNAME;UID=DBUSER;PWD=DBUSERPASSWORD;Trusted_Connection=No",,,)
>>
>>
>> and under Mac using the Actualtech ODBC driver
>> get revOpenDatabase("ODBC","Driver={Actual SQL
>> Server};Server=192.168.1.250\INSTANCENAME;Database=DBNAME;UID=DBUSER;PWD=DBPASSWORD;",,,)
>>
>>
>>
>>
>> Regards,
>>
>> Matthias
>>
>>
>>> Am 11.03.2014 um 18:05 schrieb Bob Sneidar <bobsnei...@iotecdigital.com>:
>>>
>>> Has anyone had any success querying MSSQL? I suppose it could be done via
>>> shell, but I’m not sure I want to go that route. ODBC seems fairly clunky
>>> to implement as well, and I’m not sure MS even supports ODBC for MSSQL.
>>>
>>> Bob
>>> _______________________________________________
>>> 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
