Seichobob
Posts: 55
|
Posted: 01/22/2013, 9:21 AM |
|
hi there,
im new to codecharge 5 and i have lots of questions about database connections. im planning to create a little crm based on php and mysql5. currently im using mysql 5.5.16.
first question:
where is the difference between the connection types:
1. odbc
2. connection string
3. directly to mysql
????
when i use "directly to mysql" i cant work with variables in the codecharge query builder.
for example:
Select
@test:=10 AS test1,
@test AS test2
it gives me an error. why?
should i use an odbc connector for ccs5 query builder? what would u recommend? i need to work with variables in my selects...
thanks...
|
|
|
DataDoIT
|
Posted: 01/22/2013, 9:57 AM |
|
Start here: http://dev.mysql.com/doc/refman/5.5/en//connecting.html
Then: http://en.wikipedia.org/wiki/Data_source_name
Then: http://dev.mysql.com/doc/refman/5.0/en/connector-odbc-c...sn-windows.html
All you should care about is when developing on your Winblows system run
a local MySQL database and connect to it via the MySQL ODBC driver. You
could conjure up a DSN'less connection, but why?
For your production environment, you'll likely be on a Linux system,
which you'll connect directly via the localhost MySQL socket. That
means the database will reside on the same instance as your application,
and the server URL should be 'localhost'. If for whatever reason your
database is not on the same instance as your application, then the
connection between the database and the application should always be
secured and encrypted, typically via a SSH-type of connection first, or
only allowing connections from the local network, or both.
Always avoid a remote ODBC connection to your database - via TCP/IP
through port 3306 listening for connections from the world. If your
hosting provider allows for that, then analyze the security of that
provider. Changing the listening port from the default does not mean
it's more secure. Some providers will open the port because it's
"easier" for them. Run like hell from that provider, since the security
of your data is not of interest to them.
You should be thoroughly confused by now. :)
|
|
|
Seichobob
Posts: 55
|
Posted: 01/22/2013, 10:05 AM |
|
the database server is inhouse, its also a windows 2008 server with xampp on it. so i use a local ip to connect to it. the first question of all was:
which is better: "directly to mysql" OR using an odbc connector? if odbc connector, which one?
|
|
|
DataDoIT
|
Posted: 01/22/2013, 10:12 AM |
|
Please read the links that I posted.
|
|
|
Seichobob
Posts: 55
|
Posted: 01/22/2013, 10:15 AM |
|
yes, i know the links and i know how to get a connection to mysql established. this is not the question... maybe someone else can answer my questions...
|
|
|
DataDoIT
|
Posted: 01/22/2013, 10:18 AM |
|
You can lead a horse to water....
|
|
|
|