VB 6.0 with SQL server 2000 databse with crystal reports

[yagnik3128]

i am using vb6 with sqlserver 2000 and crystal reports 7..
every time i am calling report it asks me for databaase and password....

is there any way to set database string and password in coding?

 

[paulmarr]

Put the database username/pwd in the ODBC connection - it should stop prompting you then.

I hope this helps

Cheers
paulmarr