So now that I got it working from Windows, I tried OSX. Screenshot of error message: http://osswald.com/rb/issues/mbs/osx_db2cli.png
The only client software I found at IBM was the whole package, from here: DB2 Express-C 9.5.2 beta for Mac OS X http://www-01.ibm.com/software/data/db2/express/download.html I downloaded the client part and did run db2setup which installs the db2cli driver file to: OSX:opt:IBM:db2:V9.5:samples:cli:db2cli Then, running the code below on OSX brings up the above error message === dim db as new SQLDatabaseMBS Dim f as FolderItem f=GetFolderItem("/opt/IBM/db2/V9.5/samples/cli/db2cli", FolderItem.PathTypeShell) db.SetFileOption SQLConnectionMBS.kOptionLibraryDB2, f db.DatabaseName="DB2:Driver={IBM DB2 ODBC DRIVER};Database=SAMPLE;"_ + "Hostname=172.16.138.172;Port=50000; Protocol=TCPIP; _ + "Uid=db2admin;Pwd=somepassword;" if db.Connect then MsgBox "We are connected!" MsgBox "Server Version: "+db.GetConnection.ServerVersionString db.Close else MsgBox db.ErrorMessage end if === It looks like IBM does not have a suitable DB2 driver for OSX. So I guess that there is no solution for connecting to DB2 from OSX, using the MBS SQL Plugin? Oliver _______________________________________________ Mbsplugins_monkeybreadsoftware.info mailing list [email protected] https://ml01.ispgateway.de/mailman/listinfo/mbsplugins_monkeybreadsoftware.info
