FerCastro
Posts: 5
|
| Posted: 04/07/2008, 10:08 AM |
|
Hello all,
I am about buy the program but it seems the only way to connect to a MySQL dabatase is trough ODBC. Am i correct? i mean, is there a way to connect to my database instead ODBC? what if my server is ie, Linux?
Thanks in advance
_________________
Fernando Castro
México, D.F.
------------------------
Absolut... rebel |
 |
 |
DonP
|
| Posted: 04/07/2008, 10:34 AM |
|
It needs ODBC only on the local development PC but not on the live
server. For the live server, it uses a regular connection string.
Don (DonP)
FerCastro wrote:
> Hello all,
>
> I am about buy the program but it seems the only way to connect to a MySQL
> dabatase is trough ODBC. Am i correct? i mean, is there a way to connect to my
> database instead ODBC? what if my server is ie, Linux?
>
> Thanks in advance
>
>
> _________________
> Fernando Castro
> México, D.F.
> ------------------------
> Absolut... rebel
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.yessoftware.com/
>
|
|
|
|
mbishop1980
Posts: 31
|
| Posted: 04/07/2008, 10:35 AM |
|
You can download ODBC drivers from the MySQL website (link below) for Windows, Linux & Mac OSX.
I use a Linux box to host my Intranet and databases and ODBC works fine.
http://dev.mysql.com/downloads/connector/
Hope this helps you out
_________________
Thanks,
Eric |
|
|
|
FerCastro
Posts: 5
|
| Posted: 04/07/2008, 3:02 PM |
|
Thanks a lot for Your help. Actually I have the ODBC driver, but my question is about what do I need to do in order to publish my site, i mean, where in the program I have to configure the remote connection?
Thanks a lot.
_________________
Fernando Castro
México, D.F.
------------------------
Absolut... rebel |
|
|
|
wkempees
|
| Posted: 04/07/2008, 4:18 PM |
|
Project->Settings->Connections: (Add/Modify)
also available in
ProjectExplorer->Connections: double click the connection name
Three Tabbed Dialogue:
- Design: the settings needed to access the database during design time.
- Advanced: extras
- Server: the settings for you (Design time) server
ODBC can be used in all two, but can be DB specific connect strings in the
'Server' Tab.
Answered.
Extra: See Help File and/or Docs also on 'Server Profiles'
These enable you to define the settings for 'production' servers
Walter
|
|
|
|
ckroon
Posts: 869
|
| Posted: 04/07/2008, 4:20 PM |
|
Open your project
In the top middle you will see a listbox with Server1(Local/Network) CLcik it and select Server 2 (FTP)
Now go into the publishing settings. SEt thete Desgin the same way yo have on Server1 and then the Server settings are the FTP, remote host settings.
_________________
Walter Kempees...you are dearly missed. |
|
|
|
|
