AndyGB4
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};SERVER=xx.xx.xx.xxx;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?
|
|
|
AndyGB4
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 Source=xx.xx.xxx.xxx;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.
Continue?
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...
|
|
|
mor
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 |
|
|
|
|
|
|
|