[MBS] SQL Plugin question (MBS Xojo Plugin Mailinglist archive)
|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
Now, when reading the docu, I'm pretty clueless about this sentence:
// where is the library?
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?
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
myDB = New MySQLCommunityServer
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!
Mbsplugins_monkeybreadsoftware.info mailing list
<email address removed>
|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,
> 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.
Inf: libifcli, iclit09a and iclit09b
Oracle 8 and newer: libclntsh
Sybase: libsybintl, libsybcomn or libsybtcl
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.