bowtellj
Posts: 65
|
| Posted: 07/29/2007, 1:05 AM |
|
I have just got mysql,php & apache running on windows XPSP2 and I have also run the installer for the MYSQL Connector.
PHPMyadmin can access the database I have created. When I try to get Codecharge to connect there is no MYSQL option in the Datalink Provider OLE DB List.
Have I forgotten to do something??
Thanks
Apache 2.24
PHP 5.2.3
MySQL 5.0.41
_________________
Thanks
James
Just another Newbie! - Apache 2.24, PHP 5.2.3, MySQL 5.0.41, Windows XP SP2. CCS 3.2.0.2/4.0.2
|
 |
 |
wkempees
|
| Posted: 07/29/2007, 6:11 AM |
|
Downoad the MySQL ODBC connector
http://dev.mysql.com/downloads/connector/odbc/3.51.html.
Walter
"bowtellj" <bowtellj@forum.codecharge> schreef in bericht
news:246ac4a3e11a3f@news.codecharge.com...
>I have just got mysql,php & apache running on windows XPSP2 and I have also
>run
> the installer for the MYSQL Connector.
>
> PHPMyadmin can access the database I have created. When I try to get
> Codecharge
> to connect there is no MYSQL option in the Datalink Provider OLE DB List.
>
> Have I forgotten to do something??
>
> Thanks
>
> Apache 2.24
> PHP 5.2.3
> MySQL 5.0.41
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.yessoftware.com/
>
|
|
|
|
bowtellj
Posts: 65
|
| Posted: 07/29/2007, 6:34 AM |
|
I have already installed this and My SQL is not in the list. Do I need to configure the ODBC further??
I have restarted services with no luck...
James
_________________
Thanks
James
Just another Newbie! - Apache 2.24, PHP 5.2.3, MySQL 5.0.41, Windows XP SP2. CCS 3.2.0.2/4.0.2
|
|
|
|
wkempees
|
| Posted: 07/29/2007, 7:33 AM |
|
Connecting in the Design or Server tab of the connection manager?
In the Design Tab, you should set
Database: MySQL
Check Use ODBC Data Source Name
Press "New" that should bring you to ODBC Datasource Management
Click Add, choose the MySQL ODBC 3.51 driver
That should take you to an easy configuration window
Enter your details, press test, if ok press OK, in ODBC Datasource
management select the just created and press ok
In CCS Connection enter username password.
The Server Tab should not be ODBC it should normally be direct connect to
MySQL
Hope this helps, see the docs too
Walter
"bowtellj" <bowtellj@forum.codecharge> schreef in bericht
news:246ac977a8dec9@news.codecharge.com...
>I have already installed this and My SQL is not in the list. Do I need to
> configure the ODBC further??
>
> I have restarted services with no luck...
>
> James
> _________________
> Thanks
>
> James
>
> Apache 2.24, PHP 5.2.3, MySQL 5.0.41, Windows XP SP2.
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.yessoftware.com/
>
|
|
|
|
bowtellj
Posts: 65
|
| Posted: 07/29/2007, 2:00 PM |
|
Did everything as explained. Test Connection was successful. CCS seems to connect to MySQL but CCS does not see any tables.
James
_________________
Thanks
James
Just another Newbie! - Apache 2.24, PHP 5.2.3, MySQL 5.0.41, Windows XP SP2. CCS 3.2.0.2/4.0.2
|
|
|
|
wkempees
|
| Posted: 07/29/2007, 2:27 PM |
|
What version CCS?
Suggest contact support.
"bowtellj" <bowtellj@forum.codecharge> schreef in bericht
news:246acfff2ed2f4@news.codecharge.com...
> Did everything as explained. Test Connection was successful. CCS seems to
> connect to MySQL but CCS does not see any tables.
>
> James
> _________________
> Thanks
>
> James
>
> Apache 2.24, PHP 5.2.3, MySQL 5.0.41, Windows XP SP2.
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
bowtellj
Posts: 65
|
| Posted: 07/29/2007, 4:22 PM |
|
Thanks. I have contacted support. (CCS 3.2)
_________________
Thanks
James
Just another Newbie! - Apache 2.24, PHP 5.2.3, MySQL 5.0.41, Windows XP SP2. CCS 3.2.0.2/4.0.2
|
|
|
|
bowtellj
Posts: 65
|
| Posted: 07/31/2007, 9:26 PM |
|
This was resolved by removing v3.51.17 and reinstalling the myODBC v.3.51.14 connector.
James
_________________
Thanks
James
Just another Newbie! - Apache 2.24, PHP 5.2.3, MySQL 5.0.41, Windows XP SP2. CCS 3.2.0.2/4.0.2
|
|
|
|
wkempees
|
| Posted: 07/31/2007, 11:13 PM |
|
Very usefull, thanks for reporting back.
Happy charging!
Walter
"bowtellj" <bowtellj@forum.codecharge> schreef in bericht
news:246b00b7abba01@news.codecharge.com...
> This was resolved by removing v3.51.17 and reinstalling the myODBC
> v.3.51.14
> connector.
>
> James
> _________________
> Thanks
>
> James
>
> Apache 2.24, PHP 5.2.3, MySQL 5.0.41, Windows XP SP2. CCS 3.2
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.yessoftware.com/
>
|
|
|
|
|
