I am getting this error while i'm trying to set the connection string of crystal report the error msg is error '20599' Cannot open SQL server.
Actually I have met this problem long time ago, but I have choose to avoid it by doing crp.connect="PWD="
Well, in the end i still need to programmatically set my connection string, my original setting is like
May I know is there anything wrong with this, cos i keep getting this error, and I am sure that all the parameter is correct because i have successfully use same parameter to do my database connection for ADODB connection which is
"Provider=SQLOLEDB.1;Persist Security Info=False;" & _
"User ID=sa;password=ttnika;" & _
"Initial Catalog=Shipping" & ";Data Source=ADRIAN"
So, any expert out there please help me, cos i'm desperate searching the internet whole day and find no solution.
Secondly, I would like to know also, how can I programmatically use vb syntax to set the printer for crystal report?