Xojo Developer Conference
25/27th April 2018 in Denver.
MBS Xojo Conference
6/7th September 2018 in Munich, Germany.

[MBS] SQL Plugin question (MBS Xojo Plugin Mailinglist archive)

Back to the thread list
Previous thread: [MBS] REAL Studio Summit 2011 in Atlanta
Next thread: [MBS] Preference Window and SmoothResizeMBS


Re: [MBS] MBS Real Studio Audio Plugin crash   -   Garth Hjelte
  [MBS] SQL Plugin question   -   Oliver Osswald
   Re: [MBS] SQL Plugin question   -   Christian Schmitz

[MBS] SQL Plugin question
Date: 23.01.11 11:57 (Sun, 23 Jan 2011 11:57:07 +0100)
From: Oliver Osswald
I wish to provide access to a broader range of multiuser databases from
within an app of mine.

Currently I am using REALSQLServer and MySQL from REALSoftware. The list of
servers from the MBS SQL Plugin sounds attractive to me ("ODBC:" ,"Oracle:"
,"SQLServer:" , "InterBase:" "SQLBase:", "DB2:" "Informix:", "Sybase:",
"MySQL:", "PostgreSQL:" or "SQLite:")

I already have test installations ready with Oracle XE, MS SQLServer 2008
and PostgreSQL

Now, when reading the docu, I'm pretty clueless about this sentence:

// where is the library?
db.SetFileOption SQLConnectionMBS.kOptionLibraryMySQL,
SpecialFolder.UserHome.Child("libmysqlclient.dylib")

I do not know about this dylib. Do I need to install it separately? Where
does it come from, and how do I know where it is on a users system? Which
are the dylib names for the various servers listed above?

=s
I have written a wrapper class which exposes methods Connect, SQLExecute,
SQLSelect, Commit, Rollback, FieldSchema, etc.

For instance in Connect I have:

Select case DatabaseType
// ----------------------------------------------------
Case db.isType.MySQL
myDB = New MySQLCommunityServer
MySQLCommunityServer(myDB).Host=me.Host
MySQLCommunityServer(myDB).Port=me.Port
MySQLCommunityServer(myDB).DatabaseName=me.DatabaseName
MySQLCommunityServer(myDB).UserName=me.UserName
MySQLCommunityServer(myDB).Password=me.Password
...

I wonder if I can add here a Case for SQLDatabaseMBS in a similar way? My
guess is yes, but I have not tried out yet. Any comments here?

=
However, it remains the question about the sylib above.

Thanks for any help!
Oliver






_______________________________________________
Mbsplugins_monkeybreadsoftware.info mailing list
<email address removed>
https://ml01.ispgateway.de/mailman/listinfo/mbsplugins_monkeybreadsoftware.info

Re: [MBS] SQL Plugin question
Date: 23.01.11 12:16 (Sun, 23 Jan 2011 12:16:44 +0100)
From: Christian Schmitz

Am 23.01.2011 um 11:57 schrieb Oliver Osswald:

> // where is the library?
> db.SetFileOption SQLConnectionMBS.kOptionLibraryMySQL,
> SpecialFolder.UserHome.Child("libmysqlclient.dylib")
>
> I do not know about this dylib. Do I need to install it separately? Where
> does it come from, and how do I know where it is on a users system? Which
> are the dylib names for the various servers listed above?

This library comes with mysql. You need the 32 bit version of the lib and simply load it. The plugin does not include all those client libs.

The libraries:

MySQL: libmysqlclient
Inf: libifcli, iclit09a and iclit09b
ODBC: libiodbc
Oracle 8 and newer: libclntsh
Postgres: libpq
SQLbase: libsqlbapl
Sybase: libsybintl, libsybcomn or libsybtcl
DB2: libdb2
SQLite: libsqlite3
Interbase and Firebird: libgds and libfbclient

On Mac typically with .dylib extension, on Windows with .dll and on Linux with .so.

> I wonder if I can add here a Case for SQLDatabaseMBS in a similar way? My
> guess is yes, but I have not tried out yet. Any comments here?

Yes, of course.

Greetings
Christian