Writing UDFs for Firebird Embedded SQL Server

Apriorit Inc, Ivan_Komarov

Rate me:

4.92/5 (19 votes)

23 Oct 2009CPOL4 min read

40.1K

698

We will describe how to create your own native Firebird extension and show some approaches how to use it in managed code applications

udfsample.zip
- UDFSample
  - Firebird
    - fbembed.dll
    - firebird.msg
    - FirebirdSql.Data.FirebirdClient.dll
    - GDS32.DLL
    - ib_util.dll
    - icudt30.dll
    - icuin30.dll
    - icuuc30.dll
    - include
      - ib_util.h
      - ibase.h
      - iberror.h
      - perf.h
    - lib
      - ib_util_ms.lib
  - MainApp
    - batch.sql
    - MainApp.csproj
    - Program.cs
    - Properties
      - AssemblyInfo.cs
    - SampleProvider.cs
  - SampleUdf
    - main.cpp
    - SampleUdf.vcproj
  - UDFSample.sln


Microsoft Visual Studio Solution File, Format Version 9.00
# Visual Studio 2005
Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "MainApp", "MainApp\MainApp.csproj", "{A565072D-6383-4F9B-BE1A-04A62357D693}"
	ProjectSection(ProjectDependencies) = postProject
		{EAD46388-8104-4C10-BE0E-E0482BC9E2CD} = {EAD46388-8104-4C10-BE0E-E0482BC9E2CD}
	EndProjectSection
EndProject
Project("{8BC9CEB8-8B4A-11D0-8D11-00A0C91BC942}") = "SampleUdf", "SampleUdf\SampleUdf.vcproj", "{EAD46388-8104-4C10-BE0E-E0482BC9E2CD}"
EndProject
Global
	GlobalSection(SolutionConfigurationPlatforms) = preSolution
		Debug|Any CPU = Debug|Any CPU
		Debug|Mixed Platforms = Debug|Mixed Platforms
		Debug|Win32 = Debug|Win32
		Release|Any CPU = Release|Any CPU
		Release|Mixed Platforms = Release|Mixed Platforms
		Release|Win32 = Release|Win32
	EndGlobalSection
	GlobalSection(ProjectConfigurationPlatforms) = postSolution
		{A565072D-6383-4F9B-BE1A-04A62357D693}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
		{A565072D-6383-4F9B-BE1A-04A62357D693}.Debug|Any CPU.Build.0 = Debug|Any CPU
		{A565072D-6383-4F9B-BE1A-04A62357D693}.Debug|Mixed Platforms.ActiveCfg = Debug|Any CPU
		{A565072D-6383-4F9B-BE1A-04A62357D693}.Debug|Mixed Platforms.Build.0 = Debug|Any CPU
		{A565072D-6383-4F9B-BE1A-04A62357D693}.Debug|Win32.ActiveCfg = Debug|Any CPU
		{A565072D-6383-4F9B-BE1A-04A62357D693}.Release|Any CPU.ActiveCfg = Release|Any CPU
		{A565072D-6383-4F9B-BE1A-04A62357D693}.Release|Any CPU.Build.0 = Release|Any CPU
		{A565072D-6383-4F9B-BE1A-04A62357D693}.Release|Mixed Platforms.ActiveCfg = Release|Any CPU
		{A565072D-6383-4F9B-BE1A-04A62357D693}.Release|Mixed Platforms.Build.0 = Release|Any CPU
		{A565072D-6383-4F9B-BE1A-04A62357D693}.Release|Win32.ActiveCfg = Release|Any CPU
		{EAD46388-8104-4C10-BE0E-E0482BC9E2CD}.Debug|Any CPU.ActiveCfg = Debug|Win32
		{EAD46388-8104-4C10-BE0E-E0482BC9E2CD}.Debug|Mixed Platforms.ActiveCfg = Debug|Win32
		{EAD46388-8104-4C10-BE0E-E0482BC9E2CD}.Debug|Mixed Platforms.Build.0 = Debug|Win32
		{EAD46388-8104-4C10-BE0E-E0482BC9E2CD}.Debug|Win32.ActiveCfg = Debug|Win32
		{EAD46388-8104-4C10-BE0E-E0482BC9E2CD}.Debug|Win32.Build.0 = Debug|Win32
		{EAD46388-8104-4C10-BE0E-E0482BC9E2CD}.Release|Any CPU.ActiveCfg = Release|Win32
		{EAD46388-8104-4C10-BE0E-E0482BC9E2CD}.Release|Mixed Platforms.ActiveCfg = Release|Win32
		{EAD46388-8104-4C10-BE0E-E0482BC9E2CD}.Release|Mixed Platforms.Build.0 = Release|Win32
		{EAD46388-8104-4C10-BE0E-E0482BC9E2CD}.Release|Win32.ActiveCfg = Release|Win32
		{EAD46388-8104-4C10-BE0E-E0482BC9E2CD}.Release|Win32.Build.0 = Release|Win32
	EndGlobalSection
	GlobalSection(SolutionProperties) = preSolution
		HideSolutionNode = FALSE
	EndGlobalSection
EndGlobal

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Apriorit Inc

Chief Technology Officer Apriorit Inc.

United States

ApriorIT is a software research and development company specializing in cybersecurity and data management technology engineering. We work for a broad range of clients from Fortune 500 technology leaders to small innovative startups building unique solutions.

As Apriorit offers integrated research&development services for the software projects in such areas as endpoint security, network security, data security, embedded Systems, and virtualization, we have strong kernel and driver development skills, huge system programming expertise, and are reals fans of research projects.

Our specialty is reverse engineering, we apply it for security testing and security-related projects.

A separate department of Apriorit works on large-scale business SaaS solutions, handling tasks from business analysis, data architecture design, and web development to performance optimization and DevOps.

Official site: https://www.apriorit.com
Clutch profile: https://clutch.co/profile/apriorit

This is a Organisation

33 members

Written By

Ivan_Komarov

Ukraine

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Writing UDFs for Firebird Embedded SQL Server

License

Comments and Discussions