catalyst2 community forums  

Go Back   catalyst2 community forums > Support > Database Support

Reply
 
LinkBack Thread Tools Rate Thread Display Modes
Old 10-03-2008, 07:05 PM   #1 (permalink)
Registered User
 
Join Date: Apr 2006
Posts: 4
Mysql database

I have a mysql database up and running on the server which I can administer with the mysql Administrator. However I cant for the life of me get my web site to connect to it.
The site is written in .NET and I have a connection string that looks something like this
DRIVER={MySQL ODBC 3.51 Driver};SERVER=mysql5.active-ns.com;Option=131072;uid=UserName;pwd=Password;db= DatabaseName;
Is there anything else I'm missing?

Please Help
Denster is offline   Reply With Quote
Old 10-03-2008, 11:04 PM   #2 (permalink)
Administrator
 
WhiskyFudge's Avatar
 
Join Date: Oct 2003
Posts: 1,484
Are you using the MySQL connector?

Can you detail the error messages you are getting?

Jas
__________________
Jason Robbins
jason@catalyst2.com
WhiskyFudge is offline   Reply With Quote
Old 10-03-2008, 11:24 PM   #3 (permalink)
Registered User
 
Join Date: Apr 2006
Posts: 4
mysql

I originally had the connector but then I took it out as I wasnt sure where it was supposed to go or what I was supposed to do with it.
I assumed it went in the bin folder but it didnt make any difference when I tried it.
There are no errors when running the site - just not populating the relevant areas.
Denster is offline   Reply With Quote
Old 11-03-2008, 08:23 AM   #4 (permalink)
Administrator
 
WhiskyFudge's Avatar
 
Join Date: Oct 2003
Posts: 1,484
Can you post of PM me some sample code?

I suspect your using some try catch code somewhere which needs temporary removing so we can see what the error is.

I suspect the route of the problem is that your not using the MySQL connector correctly. Your right that it does need to go in the bin folder but you need to uses the database connector class contained with in the dll rather than the default .net ones.
__________________
Jason Robbins
jason@catalyst2.com
WhiskyFudge is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


All times are GMT. The time now is 09:30 AM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.