why Sql error 20599 is appearing

Hai guys,

Im getting the error 20559 'cannot open sql server'
I am using connecting to sql serevr thru sql authentication.when i try to connect the report with VB its telling the error.

I have checked with Verify Database option,unchecked the Discard data and also unchecked with the 'save data with Report' option,but still the report is not coming.

I have created the DSN in both client and server machines exactly the same way in terms of description and the 'client configuration'.But the error remains the same

Could anyone guide me in solving this error

Its very very urgent .im in dire straits.please help me


Who is Participating?
RajaRajeswariAuthor Commented:
Hai mlmcc

Thanks for the good link.sorry for the delay as i was away.
U have given me a good lin .so i would give u a grade B
once again Thanks.
Glad I could help

All Courses

From novice to tech pro — start learning today.