Solved

Starting ODBC Drivers in Linux

Posted on 2006-06-12
3
2,105 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
  • 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
VirtualBox in Fedora 25 Linux:  Unable to Install OS 11 233
Backup Raspberri Pi over the netowrk to a Windows Share 5 42
How to enable sync between two yum repo? 1 32
linux 13 50
Setting up Secure Ubuntu server on VMware 1.      Insert the Ubuntu Server distribution CD or attach the ISO of the CD which is in the “Datastore”. Note that it is important to install the x64 edition on servers, not the X86 editions. 2.      Power on th…
It’s 2016. Password authentication should be dead — or at least close to dying. But, unfortunately, it has not traversed Quagga stage yet. Using password authentication is like laundering hotel guest linens with a washboard — it’s Passé.
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

810 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