Hello A DSN is an alias to a connection configuration. The configuration itself is saved on your PC in the ODBC data sources under administrative tools. To be able to use DSN=Bob you have to check if the data source 'Bob' exists (by checking the DSN System tab in the ODBC Data Source. It must have a dsn connection saved there with the name 'Bob') and check if the user and password suplied work with your connection. The DSN=Contracts works because you have a DSN named Contarcts configured in your DSN System tab.
Normally the DNS connects directely to a database. You can use the same connection string to access all databases by using the SQL statement 'use [database name]' before your SELECT, INSERT, UPDATE or DELETE statements to change the working database. Regards, Américo _______________________________________________ ActivePerl mailing list [email protected] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
