MSSQL Support?

[Skip Kimpel]

Awesome.... Thank you for that!

SKIP

> On Mar 11, 2014, at 1:27 PM, Matthias Rebbe | M-R-D <matthias_livecode_150811 at 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 <bobsneidar at 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 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