Results 1 to 3 of 3
Thread: ODBC connections
-
12-06-2003, 08:04 AM #1WHT Addict
- Join Date
- Oct 2002
- Location
- Hong Kong
- Posts
- 166
ODBC connections
One of my clients is requesting an ODBC connection
to the MySQL database, are there any security
risks involved when offering this and if so, HOW
can i offer this? does it require installing anything?
Preferably i would like to cater to my clients as
much as possible but i dont really want to go
and re-install things on my server that is holding
50 clients..
Any suggestions? Also on Linux, can i offer
MS Access database support ?
-
12-06-2003, 09:12 AM #2Web Hosting Master
- Join Date
- Aug 2002
- Location
- UK
- Posts
- 852
Install MyODBC: http://www.mysql.com/products/myodbc/
what do you mean 'support', there are perl modules to read MS Access but I have no idea about PHP, it'd probably require a recompile (groan)
-
12-07-2003, 12:47 AM #3WHT Addict
- Join Date
- Mar 2003
- Posts
- 110
No, there are no security risks. An ODBC connection (refered to a DSN connection) is pretty much the same as a DSN-Less connection with the small fact that you dont have to define the driver string in the connection parameter. Yes you can use MS Access DB on Linux if you have the appropriate driver installed. Google for "MS Access on Linux"