ODBiC Discussion Board

RE: installation problem, Louis Brachthuizen, 03-23-2005

You'll need to set up a System DSN in ODBC Manager

by Roger Harris, March 23, 2005 11:43

That problem means that the ODBC subsystem was unable to connect to the database using the connection string that you have specified in your DATABASE statement. On Win2003, you won't be able to use the "DSN-less" mode (i.e. directly specifying the driver and database file path), so you will need to create a Data Source Name (DSN) in the ODBC Manager. (If you have direct access to the system, you can use the Start menu, Administrative Tools, Data Sources (ODBC) function to do that. If you have a hosted site, your "control panel" interface should provide a way to create DSNs.) Make sure it is a System DSN (available to all processes) rather than a private User DSN. Then, your DATABASE statement just needs to specify the "DSN=..." name that you created.


Post Your Reply:

E-mail  optional

HTTP Link: 
Link text: 


Copyright ©1997-2003, Roger Harris. All rights reserved.