I have installed IBM DB2 Express-C 9.7.4 32bit on a Windows 2008 Server. On a Windows 7 Client I have installed the 'IBM Data Server Driver for ODBC and CLI (CLI Driver)' and also the IBM Data Studio 2.2. I can install an ODBC Datasource and connect (by ODBC, from a RB app) to the Server and I also can connect to it with IBM Data Studio. And I have installed the MBS REAL Studio SQL Plugin with REALStudio 2010r5.1. - So far so nice.
According to information received earlier on, with the MBS plugin I would need to use a lib 'libdb2.dll' (http://www.monkeybreadsoftware.eu/listarchive/2011-01-23-1.shtml) But I cannot find such a file, neither using Google nor the IBM site, nor on my PC after installing the ODBC and CLI drivers downloaded from IBM. So my questions are: What is the correct driver file and from where do I get and install it? And how do I use it in code? Something like this, I guess: === dim db as new SQLDatabaseMBS // where is the library? db.SetFileOption SQLConnectionMBS.kOptionLibraryDB2, SpecialFolder.System.Child("libdb2.dll") db.DatabaseName="DB2:172.16.138.172:50000@sample" db.UserName="someadmin" db.Password="somepassword" if db.Connect then MsgBox "We are connected!" MsgBox "Server Version: "+db.GetConnection.ServerVersionString else MsgBox db.ErrorMessage end if === If anybody has a working DB2 example and knows how to install and use the client drivers, please share your insight :) Thanks, Oliver _______________________________________________ Mbsplugins_monkeybreadsoftware.info mailing list [email protected] https://ml01.ispgateway.de/mailman/listinfo/mbsplugins_monkeybreadsoftware.info
