Search  
Sunday, May 11, 2008 ..:: Getting Started ::.. Register  Login
 Getting Started Minimize

We are working on the DotNetNuke® FireBird® provider.
Until then you can download FireBird and get familiar with it.

Download a copy of FireBird (1.5.2-Release) from www.firebirdsql.org. Make sure you get a copy of the .NET drivers too. Make sure you choose "super server" when installing rather than "classic".

FireBird Guardian and FireBird Server services should be running.  Double check these in the service manager.

You now need to download and install an administration program.

IBExpert Free Personal Edition is a handy and free FireBird utility. Download the free version from here: http://www.ibexpert.com/ (there is a video demo of IBExpert here)

1) Open IBExpert then go to "Database" then "Create Database".

firebirdsample1.jpg

firebirdsample2.jpg

2) Click the little folder icon to the right of the “Database” box and go to a directory of your choice then type in a name in the “File Name” box and click OPEN. 

firebirdsample3.jpg

After doing that, back on the "Create Database" form, make sure the "Register Database After Creating" box is checked.

firebirdsample4.jpg

Indicate it is "local", enter "Dotnetnuke" in the database box, and use

Username: SYSDBA
Password: masterkey

3) Select "Firebird 1.5" as the "Server Version" in the upper right hand corner. Enter Dotnetnuke as the "Database Alias". Click the Register button.

4) The database will now show up in the "Database Explorer" window.

firebirdsample5.jpg




5)
Obtain the latest DotNetNuke Firebird database set-up script. Use search and replace to remove "{objectQualifier}" from the script.

6) In IB Expert, go to TOOLS then SCRIPT EXECUTIVE

7) Ensure that "Dotnetnuke" is in the the second drop down and that "Use current connect" box is checked. Click the yellow open folder icon to locate the SQL setup script and after opening it in the Script Executive, click the green right arrow button to run the script.

If you need a graphical designer for Firebird queries you can use this program.

Click here for information on creating Stored Procedures in Firebird

Migration from MS-SQL to Firebird

Firebird support community:
http://groups.yahoo.com/group/firebird-support/


  

DotNetNuke® is a registered trademark of Perpetual Motion Interactive Systems Inc.
Firebird® is a registered trademark of Firebird Foundation Incorporated.

Copyright 2002-2005 ADefWebserver.com   Terms Of Use  Privacy Statement
DotNetNuke® is copyright 2002-2008 by DotNetNuke Corporation