adiamond
Posts: 2
|
| Posted: 11/16/2007, 10:38 AM |
|
Can’t create connection to my MySql ODBC DB anymore only through Codecharge (3.2.0.4)
I am using Vista. I have a MySql DB which I have Added to my Windows “Data Source (ODBC)” using the most recent MySql 3.51 driver. Pressing the “Test” button in the Windows “Data Source (ODBC)” dialog shows it works. Furthermore, I can connect etc to the DB through Microsoft Access (which uses that same ODBC driver) and in Maestro MySql (which does not use that ODBC driver). Bottom line: The DB, its ODBC connection, etc., seems to be fine.
Unfortunately, not only can I not create a connection to that DB in Codecharge, but the connection dialog box, after entering the data and pressing OK, becomes non-responsive and I eventually have to kill the Codecharge process. What’s really bizarre about it is that at one point I had a Codecharge app which not only did connect to that same DB but actually worked. Then, a few days later, I brought up the app and there was no connections listed under the connections item in the left pane. I tried re-specifying the connection but that didn’t work. Then I tried, a bunch of times, making codecharge applications from scratch (just the creation of the connection from a blank project*) and that never worked (had to kill the process as per the above). I tried rebooting a couple of times and then re-trying the above to no avail.
So, now not only can’t I get this to work but I’ve lost the work I had.
Note that I did not install any new programs.
*
1) Click on New Project (use default name, etc, Language PHP4/PhP4 with Templates, English, HTML).
2) Do a Save All (I’ve tried omitting this step…no difference).
3) Launch “Add New Connection” dialog
3a) From its “Design” Tab select a MySql DB, choose the “Use ODBC Data Source Name” option with the appropriate DB name (IDT) as selected from its drop down list. Enter in the User Name and Password of the DB (the same one I specified in the Windows Data Source ODBC connection).
3a1) I have tried this leaving the username and password blank also though I don’t recall doing so in the original working version
3b) Optional (tried with and without) specify MySQL on the PHP Database Library drop down list and type the same ODBC database name (IDT) as was done in the “Design Tab”. NOTE: I leave the rest as default (use Limit/TOP, no specification of Host, Port/Socket, Login, Password, and Persistent Connection is unchecked)
3b1) I have tried specifying the Login and Password here also but I don’t recall doing so in the original working version.
3c) Click OK – program/dialog hangs
4) Kill Codecharge process.
|
 |
 |
mamboBROWN
Posts: 1713
|
| Posted: 11/21/2007, 11:52 AM |
|
adiamond
I would contact support ( http://support.yessoftware.com ) to see if they can assist you. I do know that some developers did have problems with Vista and that support did try to resolve any problems that they had. You might want to also search the forums to see if you can find any related information concerning your issue.
|
|
|
|
jeden
Posts: 20
|
| Posted: 11/26/2007, 5:56 PM |
|
Hi,
I hope in the meanwhile you have solved the problem.
If not, maybe I can help you, since I had the same problem. I tried with ODBC 3.51 and the latest alpha 5.1 with no luck - then I installed an oldest version, 2.50.39, available here:
http://downloads.mysql.com/archives.php?p=mysql-connector-odbc-2.50&o=-win
Although I experience a bit of slowness when accessing to the db, it is working - strange thing is that the ODBC data source admin reports me I'm using version v. 3.51.
Let me know if it works for you as well.
Instead, if you solved the problem in some other way, please share your solution with us.
Thanks
Antonio
_________________
Antonio Bello
Elapsus - Software & Solutions
http://www.elapsus.com
Developer's Corner
http://www.developer-corner.com |
|
|
|
adiamond
Posts: 2
|
| Posted: 11/27/2007, 11:16 AM |
|
I confess, I gave up. I was new to codecharge and heard good things about it but after losing work and time for this I felt I couldn't justify fielding a codecharge app and having such a basic unresolvable problem. I suspect this is yet another of the charming Vista issues. Still, the fact is that even MS Access can access the DB via the same ODBC driver which to my mind lays the blame on codecharge but it could be a PHP/VISTA issue. If I was a PHP etc GOD I'd investigate but I'm not.
Thanks
|
|
|
|
Stanj
Posts: 166
|
| Posted: 12/02/2007, 10:04 AM |
|
Quote adiamond:
I confess, I gave up. I was new to codecharge and heard good things about it but after losing work and time for this I felt I couldn't justify fielding a codecharge app and having such a basic unresolvable problem. I suspect this is yet another of the charming Vista issues. Still, the fact is that even MS Access can access the DB via the same ODBC driver which to my mind lays the blame on codecharge but it could be a PHP/VISTA issue. If I was a PHP etc GOD I'd investigate but I'm not.
Thanks
Actually it is probably a MySQL<>Vista problem and not at all related to CodeCharge Studio. I had the same problem after moving to Vista on a new laptop and downloaded the appropriate connector from MySQL and it worked perfectly. This was a known issue on the MySQL support forums. Vista, when the right drivers and connectors are used, seems to work very nicely for project development.
You should give CCS another shot, it will save you much more time than any other way of developing database driven web sites and applications. Since there are hundreds if not thousands of CCS users who are also working on Vista without problems, it is unlikely to be a general incompatibility or any defect in CCS.
_________________
Stan
St Petersburg Russia |
|
|
|
|
