Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 270
  • Last Modified:

Converting Access 97 to Interbase 6

I have a website which uses a Microsoft Access 97 Database but I am planning on moving it to a server which only supports Interbase 6. I was wondering if anyone knew how you I would go about making this change or point me in the direction of a website that would help.

Also Im quite sure that this will effect the ASP in my pages which access the database will this be a large change or will it just be a matter of adjusting the existing ASP code. Bearing in mind at the moment im using standard ASP and the new server supports only ChilliSoft ASP (I dont know what the difference is im new to this). Once again I would be greatful I someone could point me in the direction of an ASP site that would help me out with this.

Note: Ive never used a site like this so I dont fully understand the points system, nor do I know whether this is an easy question or hard. But its hard to me. Thanks in advance
0
johnfreeman
Asked:
johnfreeman
1 Solution
 
BAlexandrovCommented:
You must use OleDB to connect to IB, there are ODBC drivers also but there are number of issues with them.

The best OleDB provider for Interbase is IBProvider http://www.ibprovider.com/eng/index.html

There is also free version and commercial one.

If you use OleDB I suppose that very small amount of things you must change - The connection string and rest must work.

For transfering the database structure and data use
IB DatabPump - get it from here
http://www.clevercomponents.com/products/datapump/ibdatapump.asp

ChilliSoft ASP is asp support for linux platforms. Ask developers of IBProvider if it will work in that environment...

Regards,
Bojidar Alexandrov
0

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

Tackle projects and never again get stuck behind a technical roadblock.
Join Now