Daniel Magin’s Weblog

My life in the Developers World

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

Advertisements

October 20, 2008 - Posted by | Embarcadero (CodeGear) stuff

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: