mysql odbc

Post here for help with installing or upgrading mojoPortal pre-compiled release packages. When posting in this forum, please provide all relevant details. You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

Post here for help with installation of mojoPortal pre-compiled release packages

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

  • What operating system were you running when the bug appeared?
  • What database platform is your site using?
  • What version of mojoPortal are you running?
  • What version of .NET do you use?
  • What steps are necessary to reproduce the issue? Compare expected results vs actual results.

You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

This thread is closed to new posts. You must sign in to post in the forums.
4/16/2008 5:45:11 PM
Gravatar
Total Posts 7

mysql odbc

My provider does not support the mysql ado.net in the cag
system.data.odbc is supported to access mysql

Do you have an Odbc datalayer .dll for mysql ?

Jan Peter

4/16/2008 8:18:16 PM
Gravatar
Total Posts 18439

Re: mysql odbc

Sorry but we only support using the MySql Connector for .NET not odbc.

You might consider using DiscountASP.net, thats where this site is hosted. You get good support for MySql and full trust environment.

Best,

Joe

4/18/2008 7:15:39 PM
Gravatar
Total Posts 7

Re: mysql odbc

I decided to stay with my current provider and wrote an ado.net to odbc wrapper

I will send it when it is bug free.

After porting the site from my test domainname to production the browser called with /default.aspx always goes to /setup/default.aspx.

Is there anything in the database what causes this behavour?

 

4/24/2008 7:05:10 AM
Gravatar
Total Posts 18439

Re: mysql odbc

Hi,

If you want to make thi adapter available, I can out it on the Community Download page, just let me know when its ready.

Its really not a great idea in my opinion to populate a content management system on one machine and then move it to another. Its not so bad if the doain/hostname stays the same on the new machine but if you start on localhost/mojo and move to somedomain.com there are little issues which can cause problems and are most easily avoided by starting clean on your prodution server.

The install/upgrade system works like this.

1. If mp_Sites table doesn't exist it starts installation by redirect to /Setup/Default.aspx

2. If an unhandled error occurs it checks the current version of mojoportal core in the db in the mp_SchemaVersion table against the version reported by the code itself. If the version in the db is lower or an error happens trying to lookup the version, it directs to the /Setup/Default.aspx page for upgrade because any error is likely caused by this version mismatch and upgrading should fix it.

If the version reported in the db is the same as the code then the setup page reports that your system is up to date.

Hope it helps,

Joe

ps appolgies that it took 5 days to answer, I got busy and this one slipped below my radar at the bottom of my inbox.

6/19/2009 3:14:13 AM
Gravatar
Total Posts 2

Re: mysql odbc

Hi Jan Peter,

What is the status of the MySQL ODBC support? I really would like to have it while my provider does not support the MySQL .NET connector.

Kind regards,
Berthold Hutten

You must sign in to post in the forums. This thread is closed to new posts.