MSSQL

[Christian_Schmitz]

@248091:@Jürg Otter

An example would be appreciated. The one included in the Plugins examples uses the Connection-Class. I couldn’t figure out how to get it to work with SQLDatabaseMBS.Connect. Somehow the Library (.dylib) has to be assigned and the “connection string” seems to go into “SQLDatabaseMBS.Databasename” somehow. Just… how?

Which example needs translation?

We prefix with client name on SQLDatabase. Rest is same:

db.DatabaseName = “ODBC:”+ConnectionString

[Terry_Eutsler]

[quote=248120:@Christian Schmitz]I don’t support Edit/Update.
I don’t like the idea of this automatically writing of SQL commands by detecting primary keys.[/quote]
That’s what I was afraid of. I need to write binary data to a field in the database. The only way that I can do it is using rs.Edit / rs.Update.

[Christian_Schmitz]

For that we use prepared statements and than Bind the BLOB value to the parameter.

[Carsten_Belling]

I agree with Christian.
I use the SQL plugin for a few weeks now and I’m very happy. Especially with the MT methods that don’t lock the main thread (UI). But: It was a lot of work to migrate from Xojo’s SQLiteDatabase class. For example RecordSet is very limited. But all problems are solved now. Thanks to Christian for the quick and excellent support!

[Sascha_S]

[quote=250434:@Carsten Belling]I agree with Christian.
I use the SQL plugin for a few weeks now and I’m very happy. Especially with the MT methods that don’t lock the main thread (UI). But: It was a lot of work to migrate from Xojo’s SQLiteDatabase class. For example RecordSet is very limited. But all problems are solved now. Thanks to Christian for the quick and excellent support![/quote]

Same here since 1 or 2 Years now. Everything works like a charm from OS X and Windows 7 without having the user to install anything but my App.

[Richard_Duke]

@247838:@Christian Schmitz

You can use MBS SQL Plugin with freetds library (on our website) to connect from Mac to MS SQL without ODBC drivers.

Where can i find the FreeDTS library for the Mac OSX??
I want the ability to connect and query the the information from a MS SQL Server.

[Christian_Schmitz]

I have a copy here:
https://www.monkeybreadsoftware.de/xojo/download/plugin/Libs/

[Richard_Duke]

thanks… already got it working… was up to 4am trying to get it working.
turn out all i need to set 1433 on the tcp/ip setup for the ms sql server

i am still using mbs sql plugin from 2014.
what enhancements on this plugin has been done since 2014??

just wonder of there is improvement on speed between the db.Connect and the r<>Nil??

If db.Connect Then
  Dim r As RecordSet = db.SQLSelect("Select Originator, Title FROM tblValItem WHERE Title LIKE '%Mother%' ORDER BY Originator")
  If r<>Nil Then