cemo
Posts: 5
|
| Posted: 11/24/2009, 9:02 AM |
|
Hi,
Sorry if this was asked before.
Is there any way to use MySQL db connection without ODBC ?
If not, I don't understand why we really need to deal with ODBC at all.
Any comment or work around will be appreciated.
Thanks
|
 |
 |
DonP
|
| Posted: 11/24/2009, 10:25 AM |
|
As far as I know, ODBC is a Windows requirement to initiate
communication with the database but I think you can then switch over to
a connection string once a connection has been made. Your Linux Web
server (if that's what it is) does not use the ODBC, of course, so it is
needed mainly for your site development. I know I've used connection
strings on VBScript / SQL Server sites and it also may work with PHP but
I always had to start with ODBC.
Don (DonP)
cemo wrote:
> Hi,
> Sorry if this was asked before.
> Is there any way to use MySQL db connection without ODBC ?
> If not, I don't understand why we really need to deal with ODBC at all.
>
> Any comment or work around will be appreciated.
> Thanks
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.yessoftware.com/
>
|
|
|
|
datadoit
|
| Posted: 11/24/2009, 10:44 AM |
|
Connection strings can be set for any DB connection where required.
Using ODBC makes your application cross-platform compatible without
having to do a single bit of extra programming for your connections.
We've built applications supporting tens of thousands of users on both
Windows and Nix hosts using MySQL's ODBC with zero technical or security
issues in nearly eight years of usage. "Dealing with ODBC" should not
be a problem.
|
|
|
|
cemo
Posts: 5
|
| Posted: 11/24/2009, 10:46 AM |
|
Thanks Don,
I have tried several php RAD tools and none of them required MySQL ODBC or other external gateways to communicate with mysql server.
I was surprised that although CCS looks more professional, it has no direct connection to MySQL.
|
|
|
|
datadoit
|
| Posted: 11/24/2009, 12:25 PM |
|
cemo wrote:
> I was surprised that although CCS looks more professional, it has no direct
> connection to MySQL.
Please elaborate on what that means, or what you think it means. I'm
not aware of any application that has a "direct" connection to MySQL -
all connections and connectors go through the MySQL default listening
port 3306 (or the ODBC port), whether it be defined via ADODB, DSN'less,
SSH, CLI, PHP PDO, Native, etc. It's still going through that port.
All CodeCharge does is define parameters for it's connection classes and
saves them for you so you can just initiate the class at any time.
Doesn't matter whether I'm using CCS or Billy Bob's Designer software,
at some point the server location, port number, user name and password
have to be specified in order to connect to MySQL.
|
|
|
|
quasimidi
Posts: 151
|
| Posted: 11/25/2009, 2:27 AM |
|
Data is right: basically ODBC needed for the CCS IDE, not for the generated application. That's all.
_________________
RS |
|
|
|
cemo
Posts: 5
|
| Posted: 11/25/2009, 2:40 AM |
|
Thanks quasimidi,
Now it is clear. I thought it would be required on the server side etc.
But I still suggest the developers to include this functionality in the CCS itself. Having to install extra piece of software is a little bit annoying even it is open source.
|
|
|
|
datadoit
|
| Posted: 11/25/2009, 11:08 AM |
|
Gentlemen, no other software is required to connect your locally
installed PHP configuration to your locally installed MySQL application.
You DO NOT need the MySQL ODBC Driver to connect to MySQL from PHP -
though it makes it a thousand times easier. A DSN'less string can be
used when defining your CCS project connections.
|
|
|
|
|
