CodeCharge Studio
search Register Login  

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> PHP

 [Resolved] - Design Time MySQL ODBC DSN Connection

Print topic Send  topic

Author Message
cab33010

Posts: 26
Posted: 11/10/2008, 2:31 PM

I started a the Portal project in php, works ok using the Microsoft Access database and the Apache web server.

I created a MySQL database in phpMyAdmin by using the Internet_MySQL.sql file in the C:\Program Files\CodeChargeStudio4\Examples\Internet folder, installed ok.

I tried to make ODBC DSN MySQL Database Connection, using the mysql driver, per the Knowledge Base instruction in http://support.yessoftware.com/kb_article.asp?article_id=50 link.

When I tried to configure the (MySQL Connector?ODBC Data Source Configuration) window and click on the test button, I get this message
Quote :
Connection failed: [HY0000][MySQL][ODBC 5.1 Driver]Access denied for user "@'localhost' database 'internet'
.

I have CodeCharge Studio 4 trial installed

I have run and installed Joomla on my local web server and it works ok.

I have Wamp 2.0c install running under windows xp pro.

WampServer 2.0c
Includes :
- Apache 2.2.8
- MySQL 5.0.51b
- PHP 5.2.6

And I installed (mysql driver 5.1.5) (mysql-connector-odbc-5.1.5-win32.msi)
View profile  Send private message
Gena

Posts: 591
Posted: 11/10/2008, 2:50 PM

normally for the localhost username is

root

and password is blank
_________________
Gena
View profile  Send private message
cab33010

Posts: 26
Posted: 11/10/2008, 2:53 PM

Quote Gena:
normally for the localhost username is

root

and password is blank

I had tried that with no help thank you.
View profile  Send private message
cab33010

Posts: 26
Posted: 11/10/2008, 3:04 PM

Quote Gena:
normally for the localhost username is

root

and password is blank

Wow, thanks I though I tried it, it has been two days working on it, and that did it thanks.
View profile  Send private message
cab33010

Posts: 26
Posted: 11/10/2008, 7:03 PM

Here is what the finish working setup (using Apache, and a MySQL database) looks like.

created a MySQL database in phpMyAdmin


Add or modify connection name


Click on new


Click to add MySQL driver


Click MySQL ODBC Driver, pess finish


Fill connector text areas, test and then click OK



Click on the DSN you configured


Fill in the Server section


View profile  Send private message
mamboBROWN


Posts: 1713
Posted: 11/12/2008, 5:09 AM

cab33010
Could you please put [RESOLVED] or [SOLVED] or even [TIP] in your thread header. Thanks.
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.