CodeCharge Studio
search Register Login  

Visual Web Reporting

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

YesSoftware Forums -> CodeCharge Studio -> ASP.NET - InMotion Framework

 Connection tests succesfully, but get data source error when run

Print topic Send  topic

Author Message

Posts: 122
Posted: 07/24/2013, 9:46 PM

Hi everyone,

When I Test my Connection in the Project Settings, it tests successfully.
But when I try to open one of my pages with a Record on it, it gives me an error message at the top of the Record, stating "Data source error. An OLE DB Provider was not specified in the ConnectionString. An example would be, 'Provider=SQLOLEDB;'."

Here's my Connection String:
DRIVER={MySQL ODBC 3.51 Driver};;PORT=3306;DATABASE=myDatabaseName;USER=myUserName;OPTION=0
And then I also have my Username and Password entered in the fields below the connection string.

My database is over on a GoDaddy server, and it's MySQL.

As I said earlier, when I test the connection within CodeCharge, it works perfectly.
I even created the Record with the builder, and it showed me all my tables and fields.

EDIT: And for the record, my Server settings are "same as design"

So why isn't working when I run the page? Any ideas?
View profile  Send private message

Posts: 122
Posted: 07/25/2013, 6:32 AM

Wow, I should not post on forums at 1:00 am...
For some reason, DRIVER and PROVIDER looked the same to me...

So now that I looked over my post, it's obvious why it tells me I don't have a Provider..
It's because I DON'T! haha

But what kind of Provider do I need to use if I'm using a MySQL database?
and is the rest of my connection string ok?

I also tried using this Connection String:
Provider=MySQL Provider; Data;User Id=myUserName,Password=myPassword;Initial Catalog=myDatabaseName;

But that just gives me this error when I simply test the connection:

Test Connection failed because of provider initialization error.
Unable to connect to the database. MySQL please verify the database provider's name and/or installed driver.

I'm so confused with all this! I've done lot's of reading, but I just can't seem to get a hold of what I need to do on this site, even though I've used CodeCharge to connect to 3 or 4 different MySQL servers in my other CCS projects which worked perfectly...
View profile  Send private message

Posts: 119
Posted: 10/09/2013, 5:10 AM

Please don't use OLE DB provider for MySQL. Be better to use Native connection. :)
Mor ve Ötesi
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

Web Database

Join thousands of Web developers who build Web applications with minimal coding.

Home   |    Search   |    Members   |    Register   |    Login

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