garycrunk
Posts: 23
|
| Posted: 02/26/2007, 3:55 PM |
|
I've been connecting to Access Databases Forever...
I am trying now to use MySQL Databases. I have the database on the server.... And I am able to setup the connection as per instructions here... And I can "Test Connection" and it all tests Good, I can Populate fields from the database while Designing...
But when I Upload and Publish the file.... I receive:
Unable to establish connection to database.
* Error information:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
* Other possible cause of this problem:
The database cannot be opened, most likely due to incorrect connection settings or insufficient security set on your database folder or file.
For more details please refer to http://support.microsoft.com/default.aspx?scid=kb;en-us;Q306518
Any Ideas Anyone???
_________________
Gary Crunk
Job Examiner |
 |
 |
Benjamin Krajmalnik
|
| Posted: 02/26/2007, 6:24 PM |
|
Your server connection settings are incorrect.
You have it set to ODBC - change it to MySQL for starters.
|
|
|
|
garycrunk
Posts: 23
|
| Posted: 02/27/2007, 8:05 AM |
|
I set up the database as per instructions from the online guide to MySql, I downloaded the Mysql driver... and my database connection string is:
ConnectionString = "Provider=MSDASQL.1;Persist Security Info=False;Data Source=AVM_DB1"
The Provider is set to MSDASQL1 ....
I used the drivers downloaded... What am I missing in this equation please????
Thanks for your assist.
Gary
_________________
Gary Crunk
Job Examiner |
|
|
|
csydow
Posts: 22
|
| Posted: 02/27/2007, 3:16 PM |
|
This is what I use, works great:
ConnectionString ="Provider=MSDASQL;DSN=YourDSNName;UID=YourLogonNametoMySQLServer;PWD=YourPassword;"
|
|
|
|
Benjamin Krajmalnik
|
| Posted: 02/27/2007, 6:11 PM |
|
YOu should use the mysql native library on the published app, and not
"middleware".
My "Design" tab has the following:
Database: MySQL
Use ODBC Data Source name (you need to download MyODBC and create a System
DSN)
My "Server" connection settings are:
PHP Database Library: MySQL
Database - the name of the database
Host - the name of the server, in this case localhost, although if it were
running on a remote server you would point to it
Login - an account created in MySQL which has rights from the specific
machine it will be accessing
Password - self explanatory
Persistent Connectio - on.
"garycrunk" <garycrunk@forum.codecharge> wrote in message
news:645e456bc1573e@news.codecharge.com...
>I set up the database as per instructions from the online guide to MySql,
>I
> downloaded the Mysql driver... and my database connection string is:
>
> ConnectionString = "Provider=MSDASQL.1;Persist Security Info=False;Data
> Source=AVM_DB1"
>
> The Provider is set to MSDASQL1 ....
>
> I used the drivers downloaded... What am I missing in this equation
> please????
>
> Thanks for your assist.
>
> Gary
>
> _________________
> Gary Crunk
> Job Examiner
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
|
