Results 1 to 9 of 9
Thread: odbc?
-
04-09-2008, 10:40 AM #1Web Hosting Master
- Join Date
- Jan 2007
- Posts
- 688
odbc?
Someone asked this, not sure what to say as I never dealt with ODBC before
I'm am using MS Access 2003 as a front-end to a mysql server database. I'm able to connect to mysql databases on my local server using ODBC wizard and selecting the MySQL ODBC 3.5.1 driver. But I can't figure out what the correct syntax to use to conect to the database on the server.
Please let me know if this type of connection is allowed. And if so, what is the syntax to complete the fields in the MS Access ODBC connection wizard.
The fields to be completed to make the connection are:
Server:
User:
Password:
I've tried the below (replaced my password and database names with example ifno)
Server: http://domain:mycPanelPwd@ipaddress
This is a Cpanel box with Centos 5 / Mysql 5
-
04-09-2008, 01:29 PM #2WHT Addict
- Join Date
- Aug 2007
- Location
- Minneapolis
- Posts
- 111
I don't have much experience with this either but the ODBC driver for MySQL should be an interface to talk to MySQL naively, meaning you don't have to install anything on the MySQL server to support this.
All you need to do is let him connect to the MySQL server remotely, so you'll need to set his user permissions in MySQL to allow him to connect from any REMOTE or local host. Lots of people don't want to do this for the potential security issues since most MySQL passwords are pretty weak.
So the reason his original attempt failed is because you are blocking these remote connections to your MySQL server.
-
04-09-2008, 04:04 PM #3Web Hosting Master
- Join Date
- Jan 2007
- Posts
- 688
What would be the syntax for the Server, Username and Password? I already opened port 3306 as well
-
04-09-2008, 05:19 PM #4Web Hosting Master
- Join Date
- Jan 2007
- Posts
- 688
What about this?
http://dev.mysql.com/downloads/conne...x86-32bit-rpms
I tried doing this, not working for me. I tried rpm'ing both setup and driver files.
Code:root@server [~]# rpm -Uvh mysql-connector-odbc-setup-3.51.24-0.x86_64.rpm warning: mysql-connector-odbc-setup-3.51.24-0.x86_64.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5 error: Failed dependencies: libX11.so.6()(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64 libXcursor.so.1()(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64 libXext.so.6()(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64 libc.so.6()(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64 libc.so.6(GLIBC_2.2.5)(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64 libc.so.6(GLIBC_2.3)(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64 libdl.so.2()(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64 libdl.so.2(GLIBC_2.2.5)(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64 libgcc_s.so.1()(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64 libgcc_s.so.1(GCC_3.0)(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64 libm.so.6()(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64 libm.so.6(GLIBC_2.2.5)(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64 libodbcinst.so.1()(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64 libpthread.so.0()(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64 libpthread.so.0(GLIBC_2.2.5)(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64 libpthread.so.0(GLIBC_2.3.2)(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64 libstdc++.so.5()(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64 libstdc++.so.5(CXXABI_1.2)(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64 libstdc++.so.5(GLIBCPP_3.2)(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64 libz.so.1()(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64 mysqlodbcrpmpack is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64
Code:root@server [~]# rpm -Uvh mysql-connector-odbc-3.51.24-0.x86_64.rpm warning: mysql-connector-odbc-3.51.24-0.x86_64.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5 error: Failed dependencies: libc.so.6()(64bit) is needed by mysql-connector-odbc-3.51.24-0.x86_64 libc.so.6(GLIBC_2.2.5)(64bit) is needed by mysql-connector-odbc-3.51.24-0.x86_64 libc.so.6(GLIBC_2.3)(64bit) is needed by mysql-connector-odbc-3.51.24-0.x86_64 libcrypt.so.1()(64bit) is needed by mysql-connector-odbc-3.51.24-0.x86_64 libdl.so.2()(64bit) is needed by mysql-connector-odbc-3.51.24-0.x86_64 libltdl.so.3()(64bit) is needed by mysql-connector-odbc-3.51.24-0.x86_64 libm.so.6()(64bit) is needed by mysql-connector-odbc-3.51.24-0.x86_64 libm.so.6(GLIBC_2.2.5)(64bit) is needed by mysql-connector-odbc-3.51.24-0.x86_64 libnsl.so.1()(64bit) is needed by mysql-connector-odbc-3.51.24-0.x86_64 libodbc.so.1()(64bit) is needed by mysql-connector-odbc-3.51.24-0.x86_64 libodbcinst.so.1()(64bit) is needed by mysql-connector-odbc-3.51.24-0.x86_64 libpthread.so.0()(64bit) is needed by mysql-connector-odbc-3.51.24-0.x86_64 libpthread.so.0(GLIBC_2.2.5)(64bit) is needed by mysql-connector-odbc-3.51.24-0.x86_64 libpthread.so.0(GLIBC_2.3.2)(64bit) is needed by mysql-connector-odbc-3.51.24-0.x86_64 libz.so.1()(64bit) is needed by mysql-connector-odbc-3.51.24-0.x86_64
-
04-09-2008, 11:16 PM #5WHT Addict
- Join Date
- Aug 2007
- Location
- Minneapolis
- Posts
- 111
MySQL is a remote administration client of sorts for the MySQL server. It's NOT what you're looking for. The server address is your regular server address, and username/password are that user's MySQL username and password.
What you need to do is go into the MySQL configuration and allow that user to connect from any IP address. Usually this is limited to only the local machine (127.0.0.1, localhost) and the machine's "machine name" as well as the fully qualified domain name. You will need to change this. Administration panels allow you to do this easily or you can install Webmin and do it from there.
-
04-10-2008, 12:22 AM #6Disabled
- Join Date
- Apr 2005
- Location
- Cochin
- Posts
- 2,452
The following should help you
http://www.washington.edu/computing/...ccess-3.5.html
-
04-10-2008, 09:48 AM #7Web Hosting Master
- Join Date
- Jan 2007
- Posts
- 688
Client responded with:
I already have the MySQL ODBC Connector. I need to know exactly what to fill in for the MySQL ODBC screen for the following fields:
Server:
User:
Password:
Port:
Socket:
Initial Statement:
I've tried several combinations. But no matter what I try, I'm getting:
[MySQL][ODBC 3.51 Driver]Unknown MySQL server host 'https://ipaddress' (11004)
-
04-10-2008, 07:06 PM #8Web Hosting Master
- Join Date
- Jan 2007
- Posts
- 688
What goes in the Connection Options tab, aside port 3306? Can the ssl / other fields remain blank?
-
04-10-2008, 10:12 PM #9Web Hosting Master
- Join Date
- Feb 2004
- Posts
- 633
For the hostname, try using just the IP address or hostname (i.e. don't use "http://" or "https://"). SSL is not required for MySQL connections unless you have a very unusual configuration. Also verify the username/password is in the mysql.user table, and that the host parameter for that user is set to "%" to allow connections from any host IP address.