You have two options that I know of. 1. ODBC 2. ADO plugin from Rob Laveaux/Pluggers
You will, of course, need to write some SQL code and dump any data results into arrays. Randy Engle, Director XC2 Software LLC – XC2LIVE! -----Original Message----- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of STARDATA via 4D_Tech Sent: Friday, October 13, 2017 3:29 AM To: 4d_tech@lists.4d.com Cc: STARDATA <stard...@stardata.info> Subject: Connect to MS Sql database Hi everyone, I'm looking for a way to connect 4d to sql server and query it as if it is a 4D database. Can anyone help me? -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************