If you use our SQL plugins, you sometimes have trouble connecting. And so far 99% of our users who had trouble with our SQL plugin do just need to find the right connection string. Because if you pass in wrong format for the connection string, you just get an error, often not even a helpful error message.
Here a few sample connection strings:
DB2:
Driver={IBM DB2 ODBC DRIVER};Database=urDataBase;Hostname=yourServerAddress;Port=1234; Protocol=TCPIP;Uid=yourUsername;Pwd=yourPassword;
MySQL:
192.168.1.80:3306@test
PostgreSQL:
127.0.0.1:5432@TestDB
SQLite:
/Databases/test.db
Microsoft SQL Server direct:
PcName\SqlServerInstanceName@DatabaseName
As you see some databases use a ODBC style, some just IP or DNS Name with port and database name after the @ character. SQLite simply uses the path to the database file. And for Microsoft SQL Server, you need to know the instance name and the database name.
For some services, you can include the password in the connection string. In general we avoid that and pass the password through the password property/parameter. This way you can still show the connection string somewhere.
If you use SQLDatabaseMBS class in Xojo or Real Studio, please prefix the connection string with the right prefix. e.g. "DB2:" for DB2. With SQLConnectionMBS or our Filemaker plugin, please set the right client.
Recently at WWDC, Apple announced a couple of things. Beside the new hardware, there was quite a few software things. So the last days, I had some fun trying out some of the new features. It's nice to see that Apple got a couple of new satellite images for their maps application. Our house is now on the map. You can see it on iOS maps app already if you like.
The new Xcode 5 developer preview is already working well. I already tested our Filemaker and Xojo (Real Studio) plugins here with it and they compile file here. Already I found & fixed a few bugs found by the improved static analyzer.
If you have access to the
WWDC videos, please take the time to watch them. Including the ones from the last years. There are sessions about LLVM which will also be used in next year's Xojo version. So It's good to know the details about that compiler. You find all videos from WWDC conferences on
Apple's developer video page.
Of course once we move here to Mac OS X 10.9 as development platform, we may need to quit compiling Real Studio plugins for PPC target. Also at some point we may loose backwards compatibility for Mac OS X 10.4.
Twitter has an API which you can use from Filemaker with our CURL plugin functions. Now they have a search API and just today shutdown the 1.0 API version. Now we have to use 1.1. A little surprise for me. But it looks like I managed to update the example project for next plugin version to use 1.1 API there.
If you need, you can email me for a copy earlier than next prerelease.
New in this prerelease of the 3.3 plugins:
- Added more DynaPDF functions.
- Improved String.EncodeURLComponent to encode the way we need for Twitter search.
- Fixed Addressbook functions to load on older Mac OS X versions.
- Added SystemInfo.IdleTime function for Mac and Windows.
Download at
monkeybreadsoftware.de/filemaker/files/Prerelease/.
We bet you all saw the keynote if you are interested in Apple's products.
Some things on the OS X 10.9 Maverick presentation sounds very great. We'll soon dig into the details and make sure we have some powerful Xojo (Real Studio) & Filemaker plugins available for you in time.
Especially a few things like Maps API will be interesting, new notificaton APIs and all those functions to help saving energy.
If you have wishes, please do not hesitate to tell us.
Today I'm driving to Berlin for the
PauseOnError conference.
See you there!
New in this prerelease of the 3.3 plugins:
- Added FM.RunScriptIdle and SystemInfo.MacGlobalIdleTime for Mac.
- Added Window.RemoveMenu function.
- Added Email.Verify function.
- Added Container.Remove function.
- Added Addressbook.searchGroupsWithName function.
- Fixed bugs with CURL.FormAddKey* functions.
Download at
monkeybreadsoftware.de/filemaker/files/Prerelease/.