Anyone know the maximum number of databases that can be maintained by PSQL v8?

 What exactly do you mean by "databases"?  If you're talking databases listed in the Pervasive Control Center, I think it's limited by memory. 

I think DBNAMES.CFG file has a limit as well but I'm not sure what it is.  

Are you having a specific problem?   

 Mirtheil thanks for you response. I'm talking databases listed in PCC as you guessed. Not having a specific problem yet, but am looking for am looking for information on this because the PSQL environment that I intend to setup could potentially host over 5000 different DB names in PCC. To elaborate on the problem I am attempting to solve...

 I am creating a web application for our client base. Each client will have a set of 5 PSQL tables in there home directory and exist as a separate Datasource in PCC. I am using CF8 to connect to the PSQL data sources via JDBC T4 driver. Upon successful login each users datasource name is set and used thru-out my CF pages.

<Please refer to the diagram I've attached for clarity>

You might be best off using DSN-less connections that specify the file locations, instead of trying to create all 5000 databases in the PCC.  Either SHOULD work, but it might be easier to manage the system with only a few test databases permanently registered. 

Bill

 Thanks for you perspective on this topic. I have been unsuccessful in setting up a DSN-Less connection in Coldfusion 8. I believe this may be due to the fact that this version of CF no longer supports native drivers and works purely off JDBC. While an option exists to use an (ODBC-JDBC bridge) and I am able to specify connection string info i.e. Driver={Pervasive Software ODBC-32};DDFPATH=C:\DDF;DATAPATH=C:\Data I have discovered that these additional parameters are completely ignored. You are correct:)  it could get ugly trying to manage all the DBs thru PCC, but I happen to have a Dataflex 7 programmer on staff who should be able to write a module that should simpfy DB creation in lieu of using PCC.

Perhaps I am missing something on the CF side, do you have an insight on settings up DSN-Less connections in CF8?

Here is the connection string I am attempting to use:

CF Driver: ODBC Socket <Cannot change this Type 3 ODBC driver>
CF Data Source Name: PSQLWEB
ODBC DSN: PSQLWEB
Connection String: Driver={Pervasive Software ODBC-32};DDFPATH=C:\WEB\CLIENT_DDF;DATAPATH=C:\WEB\CLIENT_DATA

If it worked as it should I would simply swap out the CLIENT_DDF and CLIENT_DATA upon successful login to the site for the real location of that client's data.

 Again Bill thanks for your expertise in this area:)

I am aware that a single PSQL DB has a max size of approx 65,000 fields, however my question as to how many individual DBs can be hosted by single PSQL engine has gone unanswered. Are you aware of any limits?