# HOW TO: A database of tips and tricks **URL:** \ **Category:** Classic Servoy\ **Created:** [January 6, 2004, 10:11pm UTC](https://forum.servoy.com/t/how-to-a-database-of-tips-and-tricks/955 "2004-01-06T22:11:52Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![aklodner](https://avatars.discourse-cdn.com/v4/letter/a/8dc957/32.png) [@aklodner](https://forum.servoy.com/u/aklodner)\ **Post date:** [January 6, 2004, 10:11pm UTC](https://forum.servoy.com/t/how-to-a-database-of-tips-and-tricks/955/1 "2004-01-06T22:11:52Z")
Hey gang, Here’s a little tips and tricks file I’ve been putting together. It contains some how to tips and also shows off some of Servoy’s built in features that one might miss. It also shows a technique I use for data driven navigation. This file works on Windows. If you need a Mac version, feel free to drop me a line. It has to do with Firebird, not Servoy. To use this, drop the TSG\_Tips.gdb into the database folder and create a FireBird named connection called ‘tips\_n\_tricks’. I hope to have regular updates to this as well. I’d be interested in any feedback as well. # Enjoy Adam Adam Klodner The Support Group, Inc. [aklodner@supportgroup.com](mailto:aklodner@supportgroup.com) ---
**Author:** ![DFehrenbach](https://avatars.discourse-cdn.com/v4/letter/d/c67d28/32.png) [@DFehrenbach](https://forum.servoy.com/u/DFehrenbach)\ **Post date:** [January 6, 2004, 10:59pm UTC](https://forum.servoy.com/t/how-to-a-database-of-tips-and-tricks/955/2 "2004-01-06T22:59:17Z")
I understood the “drop the TSG\_Tips.gdb into the database folder”, but could you please be a little more specific about " create a Firebird connection…" instruction. My only experience is importing solutions that have been exported. ![:?]( "Confused") ---
**Author:** ![aklodner](https://avatars.discourse-cdn.com/v4/letter/a/8dc957/32.png) [@aklodner](https://forum.servoy.com/u/aklodner)\ **Post date:** [January 7, 2004, 2:40am UTC](https://forum.servoy.com/t/how-to-a-database-of-tips-and-tricks/955/3 "2004-01-07T02:40:23Z")
No problem. Launch Servoy, go to the Edit menu → Preferences. Then, go to the DB Servers tab. At the bottom of the dialog box, click on the drop down menu and select FireBird. This will pull up defaults for connecting to a FireBird database. In the Server name area, type in ‘tips\_n\_tricks’ (without quotes). In the Database Sever URL, replace \.gdb with TSG\_Tips.gdb. And that’s it. I’ve included a screenshot of what it should look like. Best, Adam ---
**Author:** ![DFehrenbach](https://avatars.discourse-cdn.com/v4/letter/d/c67d28/32.png) [@DFehrenbach](https://forum.servoy.com/u/DFehrenbach)\ **Post date:** [January 7, 2004, 2:29pm UTC](https://forum.servoy.com/t/how-to-a-database-of-tips-and-tricks/955/4 "2004-01-07T14:29:45Z")
![:cry:]( "Crying or Very sad") O.K. I seem to have set up the server properly. but there is no solution set up in the Repository. How do I get the solution to be included in the list? ---
**Author:** ![DFehrenbach](https://avatars.discourse-cdn.com/v4/letter/d/c67d28/32.png) [@DFehrenbach](https://forum.servoy.com/u/DFehrenbach)\ **Post date:** [January 7, 2004, 2:33pm UTC](https://forum.servoy.com/t/how-to-a-database-of-tips-and-tricks/955/5 "2004-01-07T14:33:50Z")
![:oops:]( "Embarassed") Never mind! I got it now! I have to import the Servoy101 solution. Thanks for your help! ---
**Author:** ![aklodner](https://avatars.discourse-cdn.com/v4/letter/a/8dc957/32.png) [@aklodner](https://forum.servoy.com/u/aklodner)\ **Post date:** [January 7, 2004, 2:34pm UTC](https://forum.servoy.com/t/how-to-a-database-of-tips-and-tricks/955/6 "2004-01-07T14:34:52Z")
Cool. Now, you want to open the Repository, under the File Menu. When that dialog comes up, click on the Import button. Then, navigate to the file called Sevoy101v3.servoy. This is the solution part of the system, whereas TSG\_Tips.gdb is the database part. After that, you should get the solution imported message and you should be all set. ---
**Author:** ![DFehrenbach](https://avatars.discourse-cdn.com/v4/letter/d/c67d28/32.png) [@DFehrenbach](https://forum.servoy.com/u/DFehrenbach)\ **Post date:** [January 7, 2004, 2:47pm UTC](https://forum.servoy.com/t/how-to-a-database-of-tips-and-tricks/955/7 "2004-01-07T14:47:10Z")
Bob’s your uncle! ![:lol:]( "Laughing") Thanks Adam. Super Job! ---
**Author:** ![Harry\_Catharell](https://avatars.discourse-cdn.com/v4/letter/h/e19adc/32.png) [@Harry\_Catharell](https://forum.servoy.com/u/Harry_Catharell)\ **Post date:** [January 7, 2004, 5:15pm UTC](https://forum.servoy.com/t/how-to-a-database-of-tips-and-tricks/955/8 "2004-01-07T17:15:39Z")
Hi Adam, Out of curisosity, I did try to use this on Mac OS X 10.3 and received the following error on setting up the database connection : org.firebirdsql.jdbc.FBSQLException: Resource Exception. unsupported on-disk structure for file /Applications/Servoy/database/TSG\_TIPS.gdb; found 2560, support 10 Reason: unsupported on-disk structure for file /Applications/Servoy/database/TSG\_TIPS.gdb; found 2560, support 10 If you have a Mac version then I would like a copy. Thanks in advance… ---
**Author:** ![david](https://avatars.discourse-cdn.com/v4/letter/d/aeb1de/32.png) [@david](https://forum.servoy.com/u/david)\ **Post date:** [January 8, 2004, 4:55pm UTC](https://forum.servoy.com/t/how-to-a-database-of-tips-and-tricks/955/9 "2004-01-08T16:55:54Z")
VERY cool file! Many thanks. - david ---
**Author:** ![joel\_studiosuite.com](https://avatars.discourse-cdn.com/v4/letter/j/2bfe46/32.png) [@joel\_studiosuite.com](https://forum.servoy.com/u/joel_studiosuite.com)\ **Post date:** [May 23, 2004, 9:49pm UTC](https://forum.servoy.com/t/how-to-a-database-of-tips-and-tricks/955/10 "2004-05-23T21:49:41Z")
Any hopes for that mac version? ---
**Author:** ![Jan\_Blok](https://avatars.discourse-cdn.com/v4/letter/j/41988e/32.png) [@Jan\_Blok](https://forum.servoy.com/u/Jan_Blok)\ **Post date:** [May 24, 2004, 6:31pm UTC](https://forum.servoy.com/t/how-to-a-database-of-tips-and-tricks/955/11 "2004-05-24T18:31:35Z")
Maybe Adam could post the solution again with sample data export option enabled, this whould make it platform independend. ---
**Author:** ![Harry\_Catharell](https://avatars.discourse-cdn.com/v4/letter/h/e19adc/32.png) [@Harry\_Catharell](https://forum.servoy.com/u/Harry_Catharell)\ **Post date:** [June 3, 2004, 11:52am UTC](https://forum.servoy.com/t/how-to-a-database-of-tips-and-tricks/955/12 "2004-06-03T11:52:03Z")
I found a copy of a Mac version. Adam has given his consent to post it here. I imported it and created the tables within the CRM solution. I exported it with sample data. Hope that it works for you all ! Harry ---
**Author:** ![uwgenetics](https://avatars.discourse-cdn.com/v4/letter/u/dc4da7/32.png) [@uwgenetics](https://forum.servoy.com/u/uwgenetics)\ **Post date:** [June 10, 2004, 7:54pm UTC](https://forum.servoy.com/t/how-to-a-database-of-tips-and-tricks/955/13 "2004-06-10T19:54:34Z")
> Harry Catharell: > I found a copy of a Mac version. > > Adam has given his consent to post it here. > > I imported it and created the tables within the CRM solution. > > I exported it with sample data. > > Hope that it works for you all ! > > Harry Where is this file located? ---
**Author:** ![pbakker](https://avatars.discourse-cdn.com/v4/letter/p/a4c791/32.png) [@pbakker](https://forum.servoy.com/u/pbakker)\ **Post date:** [June 10, 2004, 8:29pm UTC](https://forum.servoy.com/t/how-to-a-database-of-tips-and-tricks/955/14 "2004-06-10T20:29:27Z")
It’s attached to the reply just before yours… Click the download… Paul ---
**Author:** ![gstein](https://avatars.discourse-cdn.com/v4/letter/g/c89c15/32.png) [@gstein](https://forum.servoy.com/u/gstein)\ **Post date:** [July 27, 2004, 12:57pm UTC](https://forum.servoy.com/t/how-to-a-database-of-tips-and-tricks/955/15 "2004-07-27T12:57:32Z")
Adam, I followed your instructions but get the following error: org.firebirdsql.jdbc.FBSQLException: Resource Exception. Unable to complete network request to host “localhost”. Reason: Unable to complete network request to host “localhost”. What should I do? ---
**Author:** ![mvreade](https://avatars.discourse-cdn.com/v4/letter/m/838e76/32.png) [@mvreade](https://forum.servoy.com/u/mvreade)\ **Post date:** [September 22, 2004, 1:39pm UTC](https://forum.servoy.com/t/how-to-a-database-of-tips-and-tricks/955/16 "2004-09-22T13:39:18Z")
Sorry, but I can’t see where to download the Mac version of the Tips database. Can anyone point me in the right direction? Thanks, Michael Reade ---
**Author:** ![mvreade](https://avatars.discourse-cdn.com/v4/letter/m/838e76/32.png) [@mvreade](https://forum.servoy.com/u/mvreade)\ **Post date:** [September 22, 2004, 1:41pm UTC](https://forum.servoy.com/t/how-to-a-database-of-tips-and-tricks/955/17 "2004-09-22T13:41:33Z")
Sorry, I just saw it. I guess if you haven’t logged in you can see the attachments… ---
**Author:** ![megaquests](https://avatars.discourse-cdn.com/v4/letter/m/dec6dc/32.png) [@megaquests](https://forum.servoy.com/u/megaquests)\ **Post date:** [October 29, 2004, 11:57am UTC](https://forum.servoy.com/t/how-to-a-database-of-tips-and-tricks/955/18 "2004-10-29T11:57:25Z")
can you open tipsandtricks in latest versions of servoy using sybase? thanks ---
**Author:** ![Harry\_Catharell](https://avatars.discourse-cdn.com/v4/letter/h/e19adc/32.png) [@Harry\_Catharell](https://forum.servoy.com/u/Harry_Catharell)\ **Post date:** [October 29, 2004, 1:59pm UTC](https://forum.servoy.com/t/how-to-a-database-of-tips-and-tricks/955/19 "2004-10-29T13:59:22Z")
Hi Eugene, Yes, you can. If you have multiple versions runnign then export it from the older version and import into a current one ! Cheers Harry ---
**Author:** ![bobcart](https://avatars.discourse-cdn.com/v4/letter/b/71e660/32.png) [@bobcart](https://forum.servoy.com/u/bobcart)\ **Post date:** [February 28, 2005, 8:16am UTC](https://forum.servoy.com/t/how-to-a-database-of-tips-and-tricks/955/20 "2005-02-28T08:16:45Z")
I’m always looking for tips. SInce the attachment is now gone, is it available on the web somewhere? Thank you!