Print Page | Close Window

help connecting to rpt Printed From: Crystal Reports Book Category: Crystal Reports 9 through 2020 Forum Name: Data Connectivity Forum Discription: How to connect to data sources and export reports URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=17720 Printed Date: 04 May 2024 at 4:48pm Topic: help connecting to rpt Posted By: iamresearcher Subject: help connecting to rpt Date Posted: 09 Oct 2012 at 2:44pm 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.  Replies: Posted By: iamresearcher Date Posted: 09 Oct 2012 at 4:53pm please give me some input guys. I am waiting for some help. thanks

Print Page | Close Window