Solved

Starting ODBC Drivers in Linux

Posted on 2006-06-12
3
2,307 Views
Last Modified: 2010-05-18
My company had a power outage a couple of weeks ago.  After restarting the Linux Server, I noticed that any time I attempt to run certain MySQL applications, I receive a Runtime Error '-2147467259 (80004005) [mySQL] [ODBC 3.5.1 Driver] Can't connect to MySQL Server on MySQL' on the PC attempting to running the job.  

Can anyone tell me how to restart ODBC on a Linux Server?  Please HELP this non-Linux guy.

Thanks,
jtb
0
Comment
Question by:ILLMO
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 24

Expert Comment

by:fridom
ID: 16886032
ODBC does not need any special restart. The proper odbc.ini is enough.
Can you connect to MySQL via net?

Friedrich
0
 
LVL 22

Accepted Solution

by:
pjedmond earned 500 total points
ID: 16886096
I presume that you are connecting to the mySQL database on a linux server, from a Windows PC (Which is configured to connect to the mySQL database using an odbc connection?

Can you check that the mySQL daemon is running on the server. For Redhat (and similar SysV init systems):

service mysqld status

If it's not running, then:

service mysqld start

If that isn't the problem, can you tell us what version of linux it is, and preferably the output from:

uname -a

Also a little bit more about the setup might be useful.

HTH:)



0
 
LVL 22

Expert Comment

by:pjedmond
ID: 16886139
To test whether the server is connectable from the windows PC, open up a command prompt, and type:

>telnet ww.xx.yy.zz 3306

If you get a response similar to:

(
 3.23.58 9"=LG^&A☻

Connection to host lost.

C:\tmp>

Then it is possible to connect to the mySQL server, and the network and firewall settings are OK.

HTH:)
0

Featured Post

Containers & Docker to Create a Powerful Team

Containers are an incredibly powerful technology that can provide you and/or your engineering team with huge productivity gains. Using containers, you can deploy, back up, replicate, and move apps and their dependencies quickly and easily.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction We as admins face situation where we need to redirect websites to another. This may be required as a part of an upgrade keeping the old URL but website should be served from new URL. This document would brief you on different ways ca…
I. Introduction There's an interesting discussion going on now in an Experts Exchange Group — Attachments with no extension (http://www.experts-exchange.com/discussions/210281/Attachments-with-no-extension.html). This reminded me of questions tha…
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question