wcboyd
Posts: 46
|
| Posted: 07/03/2006, 3:40 PM |
|
Hello All,
Another DB question. I have setup the DB on the Production target, but when I try to login I get the following error:
Warning: odbc_connect() [function.odbc-connect]: SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified, SQL state IM002 in SQLConnect in /srv/www/htdocs/TaskManager/db_odbc.php on line 57
Database error: Cannot connect ot Database: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
ODBC Error
Session halted
I am using PHP & MySQL. The Production PC is Linux (SuSE 10.0) I was not expecting an ODBC error. I would have thought CCS would have tried to use the native MySQL Connectors instead of ODBC, right? I am sure I am missing something simple....
Thanks,
Craig
_________________
Thanks,
Craig
"Stress is the body's way of saying you have not worked enough unpaid overtime." ~ Scott Adams |
 |
 |
peterr
Posts: 5971
|
| Posted: 07/03/2006, 6:06 PM |
|
The programs will use whichever method you specify in server connection. If you don't want to use ODBC you can change it to MySQL connection: http://docs.codecharge.com/studio3/html/UserGuide/Worki...Connection.html
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
wcboyd
Posts: 46
|
| Posted: 07/07/2006, 6:52 AM |
|
Peter,
I have carefully read the link you posted and I have made sure that all of my settings are similar to the ones shown in the diagram.
When I click "Publish" it generates all of the files w/o any warnings or errors and FTPs them to the correct server.
I then pop over to my Linux box and copy the files, as root, to the correct spot for my web server to see them.
From a different computer I can browse to the Login.php file and the screen displays as it should, but when I click on "Login" it gives me the same error as before.
Any ideas on what I should be checking?
Thanks,
Craig
_________________
Thanks,
Craig
"Stress is the body's way of saying you have not worked enough unpaid overtime." ~ Scott Adams |
|
|
|
peterr
Posts: 5971
|
| Posted: 07/11/2006, 2:44 AM |
|
The doc shows both variants: ODBC/MySQL and MySQL. Since it looks like you selected "ODBC" as your server database you may need to change that to "MySQL" instead, then republish.
In case you modified Common.php by hand then you would need to delete it, so that Common.php can be re-generated with the new connection settings.
BTW, I don't know of any other ways of using ODBC than to select it in Connection -> Server.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
wcboyd
Posts: 46
|
| Posted: 07/11/2006, 4:51 AM |
|
Thanks Peter. I appreciate your time.
I will look further into this. I KNOW I did not change the Common.php 
Craig
_________________
Thanks,
Craig
"Stress is the body's way of saying you have not worked enough unpaid overtime." ~ Scott Adams |
|
|
|
materix
Posts: 161
|
| Posted: 07/17/2006, 2:32 AM |
|
BTW: There is a small typo in line 60 in the file "db_odbc.php":
$this->Halt("Cannot connect ot Database: " . odbc_errormsg());
|
|
|
|
Mike McDonald
|
| Posted: 10/19/2006, 9:03 AM |
|
Hi -
I'm having the same problem. I have tried configuring the server connection with ODBC, MySQL and Improved MySQL and keep getting the error connecting to database message when trying to run the pages live.
Please assist !
|
|
|
|
wkempees
Posts: 1679
|
| Posted: 10/19/2006, 2:38 PM |
|
Mike,
Please read the docs carefully "deploy".
As a pointer consider this:
The Project Setting Connection has two main tabs, design and server.
For design you need the ODBC connect, preferably to a local MySQL DB.
For the server you need to configure the connection to NOT use ODBC, but MySQL.
Why? because MySQL generaly runs on a Linux box and that does not speak ODBC at least not well.
Sp for the Server, copy the setting you would have on the server even when not using CCS.
Host = localhost in general, the name of the database, the username/password your provider or yourself defined for MySQL.
Also in this topic there is a mention of "Publish to the server through FTP then go to server and move the files, all this is not needed if you deployment profile is correctly set, CCS will then generate a gfood Common.php and FTP everything (depending on the settings) for you.
Walter
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
|
