Created By
DMG Development
As Seen On

Main Page  |  Forums  |  Register  |  Active Topics  |  Members  |  Search

 
Username:
Password:
DMG Forums >> DMG Forums Discussion >> General Discussion >> Table 'dmg.sysobjects' doesn't exist - MySQL
Table 'dmg.sysobjects' doesn't exist - MySQL
Author Topic
Cap


Newbie


Join Date: 12/28/2008
Posts: 7
Location: Zagreb, Croatia

Posted: 12/28/2008 2:15:59 PM

Hello all,
I previously post this message on a wrong place, I'am sorry for that, but
I think that this is right place.

Here we go.

I am trying to setup this interesting forum on my home server, but I always get this error:

ERROR: There was a SQL error during setup. View the error message below and then Click Here to try again.

System.Data.Odbc.OdbcException: ERROR [42S02] [MySQL][ODBC 5.1 Driver][mysqld-5.1.30-community]Table 'dmg.sysobjects' doesn't exist at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader) at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior) at DMGForums.Global.Database.Read(String strSql, Int32 Rows) at DMGForums.Setup.SQLSetup.Page_Load(Object sender, EventArgs e)

I am not sure what went wrong so I need a litle direction for this.
Tnx. in advance.

Cap


Newbie


Join Date: 12/28/2008
Posts: 7
Location: Zagreb, Croatia

Posted: 12/28/2008 2:29:32 PM

Sorry, my mistake I forget to uncomment second line for MySQL.

grimmeissen


Administrator


Join Date: 8/30/2005
Posts: 656
Location: Cincinnati, Ohio

Posted: 12/29/2008 7:52:35 AM

Good catch. Let me know if you have any other questions.
Cap


Newbie


Join Date: 12/28/2008
Posts: 7
Location: Zagreb, Croatia

Posted: 12/29/2008 9:00:49 AM

Tnx, everything is how it supposed to be, forum is simple, fast and is easy to configure (everything I needed) :)

I am working on adaptation forum to my current web design and is going ok, but (maybe it's a stupid question) is there any chance to combine C# and VB project? Because I have my all projects in C# and if I try to integrate forum to my project it say that cannot be more then one "page directive" I assume that this is because of 2 different type of language and they cannot be combined?

I am still relatively new to .net, but I'm learning. :)

empkey2


Intermediate

Join Date: 2/20/2008
Posts: 74

Posted: 12/29/2008 11:52:32 AM

This problem is not because of using both C# and VB in the same project. C# and VB are MS managed languages and you can even use both of them in a function or procedure. Just check your web pages inheritance schema.

I currently develop DMG forums and add-ons using C#.




Cap


Newbie


Join Date: 12/28/2008
Posts: 7
Location: Zagreb, Croatia

Posted: 12/29/2008 1:36:29 PM

Thanks for that.
I'll try it one more time then.

I found it, I had include file in aspx page. Basicaly I had 2 page declaration and 2 form runat="server" what isn't allowed, so I deleted those two in main page and leave it from included page.

Interesting but logical.

I'm afraid that I have only beginners mistakes.
Sorry for that.


  Copyright DMG Development DMG Forums 3.2