Hello.

I use a Crystal Reports using ODBC to connect a Microsoft Sql Server 6.5.

I use Microsoft ODBC Drivers for SQL Server.

My VB appl. uses Open Client 4.2 (vbsql.vbx).

I use a Data Source Name in my development, but i need to use other Data
Source Name in production. The .rpt does'nt permit change the Data Source
Name.
I use object.connect="DSN=<server_name>+";uid=<username>+";
                      pwd=<password>+";dsq=<data_base_name>
but it does not work!!!

How can i change the DSN in run time???

Thanks.
Daniel.

This should work.  The only thing I can think of is you are passing the DSN
incorrectly.  It should not be the name of the server but the new ODBC
Datasource.

--
Sincerely,
Brian Dong

To reply, remove nospam from the address.