Ryan1256
|
| Posted: 05/14/2005, 10:34 AM |
|
hey everyone, I 'm having trouble just getting this thing setup.
I have a MySql db that is remotely hosted and I usually use this connection string to
DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=;USER=;PASSWORD=;OPTION=3;
How do I set it up to conect with code charge
|
|
|
 |
peterr
Posts: 5971
|
| Posted: 05/14/2005, 10:51 AM |
|
You don't need connections strings, just select the ODBC option and then select the ODBC name (DSN).
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
 |
|
ryan1256
|
| Posted: 05/14/2005, 11:08 AM |
|
what do I put for the server path and server url
|
|
|
|
ryan1256
|
| Posted: 05/14/2005, 11:09 AM |
|
where do I find the dsn name
|
|
|
|
ryan 1256
|
| Posted: 05/14/2005, 11:11 AM |
|
sorry I'm just getting started
|
|
|
|
peterr
Posts: 5971
|
| Posted: 05/14/2005, 11:19 AM |
|
Quote :what do I put for the server path and server url
This is not related to database connection. But you can press F1 when you're there to see the instructions.
Quote :where do I find the dsn name
You have to create it in Windows first. Press F1 when you're on that screen to see the instructions.
Or refer to MySQL ODBC documentation at http://dev.mysql.com/doc/mysql/en/data-source-name.html
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
ryan1256
|
| Posted: 05/14/2005, 11:45 AM |
|
this is what I put
C:\hotspotreviews.com\wwwroot\search server path
http://www.hotspotreviews.com/search/ server url
MySql database
odbc dsn
file.dsn=DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=hotspotr_hotspots;USER=;PASSWORD=;OPTION=3;
still says cannot connect to localhost
|
|
|
|
peterr
Posts: 5971
|
| Posted: 05/14/2005, 12:00 PM |
|
We're back to the starting point. You don't need connections strings, just select the ODBC option and then select the ODBC name (DSN).
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
ryan1256
|
| Posted: 05/14/2005, 12:30 PM |
|
I did exactly what you said and it still says cannot connect to mysql server
|
|
|
|
peterr
Posts: 5971
|
| Posted: 05/14/2005, 12:35 PM |
|
That's really not enough information to help you. Sorry, but you'd need to be more specific.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
