kevind
Posts: 251
|
| Posted: 02/10/2013, 4:58 PM |
|
hi all,
upgraded from xp to win 7 home premium and I'm putting my CCS 3.2 on to it.
I have a small project I'm doing that needs to connect to mysql for design and server tabs.
can someone confirm if the mysql ODBC driver 5.1 driver works with CCS 3.2, I can't seem to make it behave even when i have the same settings as on my XP station.
thanks.
_________________
thanks
Kevin
======================
CCS 3.2.x / ASP / MS Access /mySQL / PHP / jQuery / jQuery UI / jQuery Mobile
|
 |
 |
Oper
Posts: 1195
|
| Posted: 02/10/2013, 5:16 PM |
|
yes it work
any odbc version
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
DataDoIT
|
| Posted: 02/10/2013, 5:55 PM |
|
Time for an upgrade Kevin. 3.2 is as old as XP. Upgrade from 3.2 PE to
5.0 PE is $80. That's the bargain of the century.
For your ODBC, make sure you're matching up the driver with your OS
architecture (32/64 bit) and your web server.
|
|
|
|
Oper
Posts: 1195
|
| Posted: 02/10/2013, 6:02 PM |
|
i will recommend upgrade too
but...................
ODBC dont work during Design mode in 5.0
4.3 Work
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
DataDoIT
|
| Posted: 02/10/2013, 7:19 PM |
|
Oper I'm not seeing any issues here with ODBC in Design mode. Again I
emphasize, the ODBC driver MUST MATCH the environment as it pertains to
the OS and the web server. CCS @ 32bit doesn't matter - it's the driver
that matters. CCS merely makes calls to the driver.
|
|
|
|
kevind
Posts: 251
|
| Posted: 02/10/2013, 7:43 PM |
|
thanks for all the feedback.
I will post a longer follow up tomorrow
_________________
thanks
Kevin
======================
CCS 3.2.x / ASP / MS Access /mySQL / PHP / jQuery / jQuery UI / jQuery Mobile
|
|
|
|
Oper
Posts: 1195
|
| Posted: 02/10/2013, 9:17 PM |
|
Sorry i have to be clear, i was referening to DNS Less Connection using ODBC
DBS-Less ODBC Connection dont work
you has to use DNS Connection
DNS less conection dont work, They just get it out for some compatiblity isue (no idea , never was a staigh answer)
as a example you can use connection string like this anymore during design mode
Driver={MySQL ODBC 5.1 Driver};Server=localhost;Port=3306;Database=MYDATA;Uid=root; pwd=mypwd;tableoption=3
no idea why but that what support said.
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
kevind
Posts: 251
|
| Posted: 02/11/2013, 7:59 AM |
|
Quote DataDoIT:
Time for an upgrade Kevin. 3.2 is as old as XP. Upgrade from 3.2 PE to
5.0 PE is $80. That's the bargain of the century.
For your ODBC, make sure you're matching up the driver with your OS
architecture (32/64 bit) and your web server.
yeah, I know, but I still have 3.2 projects that clients won't pay me to upgrade that occasionally need tweaking - I want to get 3.2 working on new computer, then I'm going to grab 5
_________________
thanks
Kevin
======================
CCS 3.2.x / ASP / MS Access /mySQL / PHP / jQuery / jQuery UI / jQuery Mobile
|
|
|
|
kevind
Posts: 251
|
| Posted: 02/11/2013, 8:04 AM |
|
Quote DataDoIT:
Oper I'm not seeing any issues here with ODBC in Design mode. Again I
emphasize, the ODBC driver MUST MATCH the environment as it pertains to
the OS and the web server. CCS @ 32bit doesn't matter - it's the driver
that matters. CCS merely makes calls to the driver.
Can you give a few pointers on set up. My database is on remote host for both design and server - I don't have mysql running with a local database. I have tried comparing my previous, working, xp setup to the Win7 config and i'm stumped. When I look at XP I have a System DSN visible but, if I try to replicate in W7 the DSN will only show in CCS connection settings if it is User DSN.
Any advice appreciated.
_________________
thanks
Kevin
======================
CCS 3.2.x / ASP / MS Access /mySQL / PHP / jQuery / jQuery UI / jQuery Mobile
|
|
|
|
kevind
Posts: 251
|
| Posted: 02/11/2013, 11:39 AM |
|
Quote DataDoIT:
Oper I'm not seeing any issues here with ODBC in Design mode. Again I
emphasize, the ODBC driver MUST MATCH the environment as it pertains to
the OS and the web server. CCS @ 32bit doesn't matter - it's the driver
that matters. CCS merely makes calls to the driver.
hi,
previous XP environment would definitely be 32 bit for local design work.
In new environment I have created a DSN ODBC 5.1 connection in data sources and when I click TEST it works. I then modified my CCS connection, setting the design connection as instructed in documentation, setting database to MySQL and ODBC to the DSN connection I created.
current Win 7 env. is 64bit and I have installed the 64bit drivers from oracle. I have now got the install to stop error-ing out and complaining, however, I can't see the table names when using a builder.
I can downgrade to 32 bit 5.1 drivers or 3.x ODBC drivers if necessary.
any suggestions to this new issue would be appreciated.
_________________
thanks
Kevin
======================
CCS 3.2.x / ASP / MS Access /mySQL / PHP / jQuery / jQuery UI / jQuery Mobile
|
|
|
|
DataDoIT
|
| Posted: 02/11/2013, 2:45 PM |
|
http://support.microsoft.com/kb/942976
|
|
|
|
kevind
Posts: 251
|
| Posted: 02/11/2013, 5:16 PM |
|
Quote DataDoIT:
THANKS DataDoIT !!
that was the answer. To get the DSN(s) to show up in Codecharge for their use in Design Mode I needed to download and install the mySQL 5.1 ODBC 32 bit version ( I had installed the 64 bit version since my OS is 64 bit).
Am I right in understanding I needed to use the 32bit ODBC mySQL connector since CodeChargeStudio is 32bit application ?
thanks again, I can now see mySQL project database and get back to work.
_________________
thanks
Kevin
======================
CCS 3.2.x / ASP / MS Access /mySQL / PHP / jQuery / jQuery UI / jQuery Mobile
|
|
|
|
kevind
Posts: 251
|
| Posted: 02/13/2013, 5:17 PM |
|
update....
ended up having to use ODBC 3.51 driver locally and for remote server - as it turns out, the remote hosting company doesn't support 5.x driver directly - so created ODBC 3.51 on remote site and all is good now
thanks everyone, now back to programming.
_________________
thanks
Kevin
======================
CCS 3.2.x / ASP / MS Access /mySQL / PHP / jQuery / jQuery UI / jQuery Mobile
|
|
|
|
