Thanks Wong
 I was unable to do this with my Crystal Report 4.5. I tried the Set
Location menu in Database menu. But this only changes the database file (NO
ODBC DSN) to another location. I tried to do this programatically within VB.
That did not work either. Report shows design time data.

regards

Niaz


----- Original Message -----
From: "Wong Tze Lun" <tzelun0502@l...>
To: "professional vb" <pro_vb@p...>
Sent: Monday, September 30, 2002 3:31 AM
Subject: [pro_vb] Re: Crystal Report Conversion from Access to SQL Server


> Hi Niaz,
>    If you have created your report from crystal report there is no need to
create it from scratch you can alwiz change the database driver in crystal
report into SQL native driver or ODBC driver without any modification to
your report layout.
>
> regards
> tl wong
>
>
> ____________________________________________________________
> Tired of all the SPAM in your inbox? Switch to LYCOS MAIL PLUS
> http://www.mail.lycos.com/brandPage.shtml?pageId=plus
>
>
> ---
> Visual C# - A Guide for VB6 Developers
> This book will make it easy to transfer your skills
> from Visual Basic 6 to C#, the language of choice
> of the .NET Framework.
> http://www.wrox.com/ACON11.asp?ISBN=1861007175&p2p0059
>
>
>