Slopey
Posts: 33
|
| Posted: 11/13/2008, 4:14 AM |
|
Hi All,
I'm on 4.1 and trying to create a site in PHP. I have a mySQL database hosted over on dreamhost, and I can succesfully create an ODBC connection to it and browse the data on my machine here with MS Access etc.
When I try and use a Grid builder on a page, I enter my connection which I've set up with the ODBC connection, and then go to the next page of the wizard where you select the table/query/fields.
The "Data Source" combo box remains empty, regardless of what I do. If I type the table name in there manually, an press the "Build Query" button, I can use the "Show Data" button to see the data, but CCS doesn't retrieve fields or the table names.
There are no fields showing in the "Available fields" list either so I can't create the Grid.
Any ideas?
Cheers,
S.
|
 |
 |
peterr
Posts: 5971
|
| Posted: 11/13/2008, 12:13 PM |
|
This issue comes up from time to time and is often resolved by reinstalling the ODBC driver (MySQL connector in this case).
If this doesn't work you may want to contact product support.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
DonP
|
| Posted: 11/13/2008, 1:49 PM |
|
Did you say you are using MySQL on your live server and MS Access on
your development system? If so, I strongly suggest you install MySQL in
order to be compatible as MS-Access, while if can be used in both places
in a pinch, is not a truly relational database and even uses a different
flavor of SQL so would make development difficult when mixing the two.
Don (DonP)
Slopey wrote:
> Hi All,
>
> I'm on 4.1 and trying to create a site in PHP. I have a mySQL database hosted
> over on dreamhost, and I can succesfully create an ODBC connection to it and
> browse the data on my machine here with MS Access etc.
>
> When I try and use a Grid builder on a page, I enter my connection which I've
> set up with the ODBC connection, and then go to the next page of the wizard
> where you select the table/query/fields.
>
> The "Data Source" combo box remains empty, regardless of what I do. If I type
> the table name in there manually, an press the "Build Query" button, I can use
> the "Show Data" button to see the data, but CCS doesn't retrieve fields or the
> table names.
>
> There are no fields showing in the "Available fields" list either so I can't
> create the Grid.
>
> Any ideas?
>
> Cheers,
> S.
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.yessoftware.com/
>
|
|
|
|
mamboBROWN
Posts: 1713
|
| Posted: 11/13/2008, 4:59 PM |
|
Slopey,
I strongly agree with DonP. When you are developing it is best to have your development enironment closely mimic your Production environment. There are many development packages that will install a similar environment right on your desktop/laptop. To name a few:
http://www.wampserver.com/en/
http://www.apachefriends.org/en/xampp.html
and the list goes on.
Finally, as peterr mentioned if you wish to continue down your current path then the Yessoftware support team is definitely the ones to contact for assistance.
|
|
|
|
Slopey
Posts: 33
|
| Posted: 11/13/2008, 6:04 PM |
|
Thanks peterr - I'll try that an contact support if not.
DonP/mambo - my development environment does mimic the production one, I merely used MS Access to confirm that I could "access" the live database server to ensure it wasn't an access permission causing the problem.
|
|
|
|
|
