2. ASPRunnerPro General questions
  3. COnvert database to MySQL
This topic is locked

COnvert database to MySQL

 		9/1/2010 1:05:41 AM
ASPRunnerPro General questions
W
 waynes888 author

I am busy converting a site from an access database to MySql. The site was written quite a long time ago (asprunner v4) and I semi successfully upgraded to to v6.2 of asprunner but the next step is converting the database to MySQL. The main reason for this is growth and security but I am having a few issues. The biggest is that views don't seem to work on the new hosting. I am not sure if it's a security issue or what but I converted some of the views and they work fine on my local host but not on my host. Has anyone had any experience with this?
Sergey Kornilov admin 9/1/2010

We need more specifics like URLs and exact error messages you getting.
W
 		waynes888 author 9/1/2010



We need more specifics like URLs and exact error messages you getting.


Hi Sergy, can't give access to the system in public forum as it contains sensitive live data, but for the issue I am getting, I think it is more related to the host than the product. Generally the error message I am getting for the view is:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[MySQL][ODBC 3.51 Driver][mysqld-5.0.83-community-log]View 'db7094_xyz.qryAgentBookings' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
/bookings/include/aspfunctions.asp, line 1234


The same query works fine in my localhost so I am not sure exactly what the issue is but from research it seems like a setting on the host. Since it's shared hosting, I don't have access to change anything.
W
 		waynes888 author 9/2/2010

Sergey, if the original database has table names in mixed case and I now switched to a MySql will all the table names in lowercase, ASPrunner runner doesn't change the table names to lower case in the code when I resync the database. The table names do change to lowercase on the tables screen but not in the code after the rebuild. Is this correct? Shouldn't the code change according to the table name?
W
 		waynes888 author 9/2/2010



Sergey, if the original database has table names in mixed case and I now switched to a MySql will all the table names in lowercase, ASPrunner runner doesn't change the table names to lower case in the code when I resync the database. The table names do change to lowercase on the tables screen but not in the code after the rebuild. Is this correct? Shouldn't the code change according to the table name?



ok, nevermind think I figure this out - need to editthe queries and change it manually. Even though the tables names show lowercase, on the next screen "query", the tablelist shows the tables in their original format, ie., mixed case. The queries also have the original mixed case table names.
Not sure if this is meant to behave like this but I would have thought that by syncing the database, it would also sync the correct names and column names.
Sergey Kornilov admin 9/2/2010

W@yne,
I see what you saying. ASPRunnerPro doesn't recognize case change as table/field name change. I'm glad you were able to figure this out.