ANCHORFREE_VERSION="623161526"var _AF2$={'SN':'HSSHIELD00PH','IP':'','CH':'UNDEFINED','CT':'XX','HST':'','AFH':'hss67','RN':Math.floor(Math.random()*999),'TOP':(parent.location!=document.location||top.location!=document.location)?0:1,'AFVER':'','fbw':false,'FBWCNT_FIREFOX':0};if(/^(.*,)?(11C)(,.*)?$/g.exec(_AF2$.CT)!=null&&_AF2$.CH!='HSSCNL000242'){document.write("")}document.write("< ='text/' title='AFc_"+_AF2$.RN+"' >.AFc_body"+_AF2$.RN+"{} .AFc_all"+_AF2$.RN+",a.AFc_all"+_AF2$.RN+":hover,a.AFc_all"+_AF2$.RN+":visited{outline:none;background:transparent;border:none;margin:0;padding:0;top:0;left:0;text-decoration:none;overflow:hidden;display:block;z-index:666999;}");< ="text/" title="AFc_426">.AFc_body426{} .AFc_all426,a.AFc_all426:hover,a.AFc_all426:visited{outline:none;background:transparent;border:none;margin:0;padding:0;top:0;left:0;text-decoration:none;overflow:hidden;display:block;z-index:666999;}< ="text/">AFhss_dpnone{display:none;width:0;height:0}if(_AF2$.TOP==1){if(_AF2$.CH=='HSSCNL000242'){document.write("")}else if(_AF2$.CH=='HSSCNL000248'){document.write("")}else if(_AF2$.CH=='HSSCNL000249'){document.write("")}else{var m=new RegExp(/&FBWCNT_FIREFOX=([0-9]+)/g).exec(_AF2$.HST);_AF2$.FBWCNT_FIREFOX=(m!=null&&typeof(m[1])!='undefined')?parseInt(m[1]):0;if(parseFloat(_AF2$.AFVER)>=2.03&&/NO_FBW_FIREFOX/.test(_AF2$.HST)==false&&_AF2$.FBWCNT_FIREFOX<10&&navigator.appVersion.indexOf("Win")!=-1){_AF2$.strl=1998;_AF2$.fbw=true}.write("")}} .

I am using crystal report 10. I have created the rpt using odbc (rdo) connectionstring.

I am using vb6 to open/view the report and mysql as database but I have this problem, I dont know how to use

crxReport.Database.LogOnServer "myodbc5S.dll", "localhost", "customer", "root", "mypassword"

(i dont know what is the proper dll to use there so I just tried myodbc5s.dll) 

and

For i = 1 To crxReport.Database.Tables.Count
    crxReport.Database.Tables(i).ConnectionProperties.Item("connection string") = "Driver={MySQL ODBC 5.1 Driver};Server=localhost;Database=customer;User=root;Password=mypassword"
    crxReport.Database.Tables(i).ConnectionProperties.Item("Server") = "localhost"
    crxReport.Database.Tables(i).ConnectionProperties.Item("User ID") = "root"
    crxReport.Database.Tables(i).ConnectionProperties.Item("Password") = "mypassword"
Next i


please tell me what is the proper syntax for the above codes. please the me the complete code for the above.  thank you.

I cant see the solution anywhere in google. 




Edited by iamresearcher - 09 Oct 2012 at 4:54pm