Deploying Delphi 2007 ASP.net and DBXpress (Interbase) on Windows 64 bit server

I found out on my trainings, many people have problems to deploy the asp.ent application to the windows server with 64bit architecture.

ERROR:
Unable to find the requested .Net Framework Data Provider.  It may not be installed.

1. Install the ADO.DBXProvider from your InterBase CD also

2. Check and perhaps modify the
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\CONFIG\machine.config
in the tag     <system.data> <DbProviderFactories>
there must be a line

<add name=”AdoDbx Data Provider” invariant=”Borland.Data.AdoDbxClient” description=”.Net Framework Data Provider for dbExpress Drivers” type=”Borland.Data.TAdoDbxProviderFactory, Borland.Data.AdoDbxClient, Version=11.0.5000.0, Culture=neutral, PublicKeyToken=91d62ebb5b0d1b1b” />

3. do not forget to copy the  Borland.Data.DbxDynalinkDriver.dll in your bin folder of your asp.net application

4. copy Dbxint30.dll (you can find on your local machine on c:\windows\system32) to  C:\WINDOWS\SysWOW64\

5. copy dbxadapter30.dll (you can find on your local machine on c:\windows\system32) to  C:\WINDOWS\SysWOW64\

6. in your web.config do not forget to use in the connectionString settings to your interbase to use localhost or 127.0.0.1 The Asp.net user have no (and did not need it) access to the interbase database file
    <connectionStrings>
                               <add name=”MYDB”

… Database=127.0.0.1:C:\DATA\EMPLOYEE.IB

…. />
                </connectionStrings>

 

regards Daniel Magin