Web app to Sql Server

Databases
1

Is the support for web app connections to Sql Server in Xojo good? Is there a full web app demo using Sql Server somewhere to examine?
Thanks.

2

You can use the database plugin, or if your app is running on a Windows server, use ADOObjects. (this is what I use most often). When all else fails, MBS has very good support for various RDBMS through their plugin. MSSQL is one of the supported databases. There are several threads that you can find on the forums that will point you in the right direction.

In short, the support for MSSQL connection through a web app is good.

3

Thank you very much.

When I searched the Language Reference, I only saw the MSSQLServerDatabase plug-in.
I didn’t find ADOObjects.

4

you may want to take a look at this thread: https://forum.xojo.com/11676-sql-server-native-client-not-installed/p1#

It will give you the general idea on using OLEObject for MSSQL connexion.

5

I have used ODBC and the Xojo MS SQL database driver and both work just fine.

6

if you are going to use ole, then have a look at

makes life easier. well, it does for me !