cowtram

posted November 27, 2001 07:32 AM -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- Hi On W98/PWS this code works fine. On W2k/IIS5 we get the message: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [FileMaker][ODBC FileMaker Pro driver][FileMaker Pro]Connect failed This is the code: var rs=Server.CreateObject('ADODB.recordset'); var cn='DSN=FMDSN'; rs.Open ("Select * from properties.fp5", cn); This is a simple conneciton string. It works on W98/PWS why not on W2K/IIS5? Urgent Solution Required!

Hi On W98/PWS this code works fine. On W2k/IIS5 we get the message: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [FileMaker][ODBC FileMaker Pro driver][FileMaker Pro]Connect failed This is the code: var rs=Server.CreateObject('ADODB.recordset'); var cn='DSN=FMDSN'; rs.Open ("Select * from properties.fp5", cn); This is a simple conneciton string. It works on W98/PWS why not on W2K/IIS5? Urgent Solution Required!

Is there only one copy of the FM DB on your server, this can someitmes cause problems.

Having set up the DSN (which does not specify a DB) I can successfully run SQL Queries on a DB through an ASP script. var oRS=Server.CreateObject("ADODB.recordset"); oRS.Open('SELECT * FROM myFMDB.fp5 WHERE fieldname="value"', "DSN=myDSN") One thing I would say is that it seems important not to have more then one copy of the DB with the same name on the local machine/network. This is because, since the DSN does not specify a DB, The connection source must be a unique DB Name. So you just use the name of your DB in your connection source. This is just my observation. HTH

Hi, 1. I had a problem using SQL Query to FM DB in an ASP Page. I renamed all copies of the DB so that there was only one copy of the DB on the Web server. This seemed to solve the problem. (Because there is no Path to a DB specified in the ODBC setup, it might caused problems if there was multiple copies of the DB on the webserver, albiet if they were in different folders.) Could anyone confirm if this is the case. ie Must there only be one copy of the DB on the Web server and or network? 2.Secondly, are there any issues associated with connecting Multiple Users to an FM DB on an IIS web server. ie I am told the FM ODBC Driver is single threaded, and ASP applications are multi threaded, would this be an issue? Thanks in advance.

This problem is now solved. Thankyou.

PROBLEM: SQL query using ODBC and ASP We are connecting through ASP to an FM DB over ODBC, no problem: var oRS=Server.CreateObject(“ADODB.Recordset” ; oRS.Open(“myFMDB.fp5, “DSN=myDSNname” ; However, how can you do an SQL Query? This wont work: oRS.Open(“SELECT * FROM myFMDB.fp5”, “DSN=myDSNname” ; Thanks in advance.