index | search | no replies | posting guidelines | help

login | register

Index » Products » ASP Report Wizard v2

search this forum:

:: problem with mysql :: (4) Post a New Message | Post a Reply
Jan 28 2005, 8:24 AM	problem with mysql Post a Reply
langtech from: somewhere	Im having trouble testing the product with mysql.  I have tested with both mysql server 4.0.23a  and 3.23.54  with same results. I planned on purchasing the product if I can get this to work. Errors Occured! Error #:-2147418113 Catastrophic failure Im sure its connecting however, because If i put the wrong password in I would get a different error: Errors Occured! Error #:-2147467259 [MySQL][ODBC 3.51 Driver]Access denied for user: 'root@xxx.xxx.xxx(Using password: YES) I have read the messageboards and tried a few things. Even if i specify usertable i still get the Errors Occured! Error #:-2147418113 Catastrophic failure Any ideas?   Really interested in getting this to work. Thanks, Rob
Jan 28 2005, 10:00 AM	Re: problem with mysql Post a Reply
whichman from: Laurel, MD	Can you please show me a sample of your code! Also, what MySQL driver does your machine have? ------------------------- Master of the Game
Jan 28 2005, 10:25 AM	Re: problem with mysql Post a Reply
langtech from: somewhere	I've tried serveral combinations with and without usetables, etc. The database odbc driver is the latest one downloaded from mysql.com: 3.51.10.00 even with or without the usetables statement it still gets the catostrophic errors.   <% connstr = "DRIVER={MySQL ODBC 3.51 Driver};DESC=;DATABASE=mysql;SERVER=xxx.xxx.xxx;UID=xxxx;PASSWORD=xxxxx;PORT=;OPTION=0;STMT=;" Dim objWiz Set objWiz = Server.CreateObject("AspWebSolution.ReportWizard2")      'Make sure you initialize before adding any HTML text 'TODO: Change this to your actual connection tring objWiz.DatabaseType = "MySQL" objWiz.usetables = "user" objWiz.Init(connstr)      'put this where you want your reports objWiz.DisplayReports      Set objWiz = Nothing %>
Jan 29 2005, 2:20 PM	Re: problem with mysql Post a Reply
langtech from: somewhere	fixed the problem with this patch: http://forums.mysql.com/read.php?37,13020
Pages: (1)   [1]

search this forum: