Solved

Firebird Database connectivity with ASP

Posted on 2004-09-17
4
557 Views
Last Modified: 2008-02-01
I have a Firebird Application. I am trying to create a web interface to the Database. I am using the IBPhoenix ODBC Drivers on a Windows 2000 Server.

I have written other web applications using MS SQL Server with no problems but at the moment I cannot get the Database to even connect.
Here is my Connection Script

Set RecordSet1 = Server.CreateObject("ADODB.RecordSet")
connect = "data source=wsiyard;user id=SYSDBA;password=masterkey;dbase=c:\warehouse\warehouse.gdb"
query = "select * from export_checkin"
adOpenKeyset = 1

      recordset1.Open query, connect, adOpenKeyset <---- Error Occurs here.
I get an error. "unavailable database"
I have confirmed all the settings in the ODBC Configuration are Correct. The Database does exist. It just will not Connect.

Please any ideas, comments and solutions would be much appreciated.

Andy
0
Comment
Question by:andyd70
  • 2
  • 2
4 Comments
 
LVL 12

Expert Comment

by:GoofyDawg
Comment Utility
Have you tried to connect to the database through the ODBC Manager in Windows? This would probably be the best place to start so you could see if you can connect at all. From there, you could use that information to build a connection string that should work in ASP.

GoofyDawg
0
 
LVL 1

Author Comment

by:andyd70
Comment Utility
In the ODBC Manager I can actually see all my Tables, Views and Stored procedures.
Using Dreamweavers Recordset Wizard also sees the Tables and creates the Queries.
When I try and execute the page I get the error. This is why I'm so confused as to why it doesn't work.
0
 
LVL 12

Accepted Solution

by:
GoofyDawg earned 500 total points
Comment Utility
Hmmm... Do you have permissions set so that IUSR_<machine> can access the database on your web server?

GoofyDawg
0
 
LVL 1

Author Comment

by:andyd70
Comment Utility
I tried giving the IUSR Administrator rights and that still didn't work.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now