How to Connect SQL server 2000 from crystal report 8.5?

[ganeshvkl]

hi ,
i 'm using VB 6.0 with sql server 2000 .Report - Crystal Report 8.5

when i try to connect the database from vb 6.0. The Code is

strDSNName = "Provider=sqlol edb;Data Source=server;I nitial Catalog=ga0809; User Id=saar;Passwor d=12saarsol;"

crystalreport1. connect = "dsn = " & strdsnname

i got error "Cannot open Sql server ", whereas from strdsnname the
program is working fine.

Thanx in adv.

Ganesh

[simonrule]

Thanks you can you help me how to download videos in vb2005