Hackside
|
| Posted: 03/23/2005, 7:45 PM |
|
hello how can i add connection using internet with CCS?
|
|
|
 |
hackside
Posts: 1
|
| Posted: 03/23/2005, 7:48 PM |
|
any help on this one?
|
 |
|
peterr
Posts: 5971
|
| Posted: 03/23/2005, 9:24 PM |
|
Please see:
http://docs.codecharge.com/studio/html/UserGuide/Workin...Connection.html
http://docs.codecharge.com/studio/html/UserGuide/Workin...Connection.html
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
wontonu
|
| Posted: 04/02/2005, 6:57 PM |
|
I can't seem to figure this thing out either. I'm following the directions, but when I press OK is says
"Test connection failed because of provider initialization error.
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified."
And, yes, I do have a database set up properly and I am using the correct name in the database name field.
Any ideas? 
|
|
|
|
peterr
Posts: 5971
|
| Posted: 04/02/2005, 7:13 PM |
|
Did you create a User or System DSN in Windows?
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
wontonu
|
| Posted: 04/02/2005, 8:05 PM |
|
I'm using Root as my username.
My database is local and I thought that local databases didn't require a System DSN.
Assuming I'm incorrect on one or more of these assumptions, how do I go about changing this?
Thank you in advance.
|
|
|
|
wontonu
|
| Posted: 04/02/2005, 8:16 PM |
|
Also, why do all of these special things have to be set up for a simple database connection? I've already got three PHP-based websites on localhost that interface flawlessly with mySQL (I didn't do any of the coding). All that was needed for a connection were the database name, username and password.
|
|
|
|
peterr
Posts: 5971
|
| Posted: 04/02/2005, 8:28 PM |
|
That was trick question to see if you really followed directions as you wrote 
Yes, you need to create ODBC/DSN if you want any Windows program to connect to your database, whether CodeCharge, Excel or any other.
Of course Web applications don't need ODBC, therefore in the server connection you don't need to specify ODBC for PHP.
Your only problem is with the design connection, not the server.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
wontonu
|
| Posted: 04/02/2005, 8:58 PM |
|
It's still not working. I've got a System DSN set up with the ODBC Data Source Adminstrator and it tests fine. However, when I try to set the connection in CC, I get:
Test connection failed because of provider initialization error.
[MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'localhost' (10061)
|
|
|
|
wontonu
|
| Posted: 04/02/2005, 9:15 PM |
|
Actually, I meant to say that I set up the System DSN with MyODBC and it tests successfully.
|
|
|
|
peterr
Posts: 5971
|
| Posted: 04/02/2005, 9:22 PM |
|
There could be several reasons for such error.
Do you have that MySQL running on local computer?
Also try it without putting usernamed/password in CCS.
Other solutions may be available at
http://www.google.com/search?hl=en&q=%22Can%27t+connect...localhost%27%22
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
wontonu
|
| Posted: 04/02/2005, 9:22 PM |
|
Oh, now this is embarrassing. Turns out it wasn't working because of a bad setting on my firewall.
Thanks so much for your help! 
|
|
|
|
