Login or Register to Ask a Question and Join Our Community


Debian

Connect MySQL databse to debian

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Operating Systems Linux Debian Connect MySQL databse to debian
# 1  
Old 03-30-2010
Connect MySQL databse to debian
Hello,
I wont to connect a MySQL database to debian:
I have installed libmyodbc package and after i have configured /etc/odbcinst.ini:
Code:
[MySQL] 
Description = MySQL driver 
Driver      = /usr/lib/odbc/libmyodbc.so 
Setup       = /usr/lib/odbc/libodbcmyS.so

and /etc/odbc.ini :
Code:
[MySQL-gestion] 
Description  = MySQL database gestion 
Driver       = MySQL 
Server       = localhost 
Database     = test 
Port         = 3306 
Socket       = 
Option       = 3 
ReadOnly     = N

But after there is two erros when i try the connection whit the command:echo "select 1" | isql -v root-connector

The errors:
Code:
[IM002][unixODBC][Driver Manager] Data source not found, and no default driver specfied.
[ISQL]ERROR: Could not SQLConnect

What's the problem?
Thank's for your help
Last edited by pludi; 03-31-2010 at 02:00 AM.. Reason: code tags, please...
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Programming

Unable to connect mysql with php7 in Linux 7

I am getting below error on executing the code. < <?php $dbname = 'upload_ui'; $dbuser = 'nad'; $dbpass = 'nad'; $dbhost = '10.196.84.192'; $link = mysqli_connect($dbhost, $dbuser, $dbpass) or die("Unable to Connect to '$dbhost'"); } ?> -->error: < PHP Warning: PHP Startup:... (2 Replies)
Discussion started by: nadeemrafikhan
2 Replies

2. UNIX Desktop Questions & Answers

How can I replicate master master and master master MySQL databse replication and HA?

I have an application desigend in PHP and MySQl running on apache web server that I is running on a Amazon EC2 server Centos. I want to implement the master-master and master slave replication and high availability disaster recovery on this application database. For this I have created two... (0 Replies)
Discussion started by: Palak Sharma
0 Replies

3. IP Networking

Unable to connect to localhost in Debian 6?

Hello Everyone, I have unable to run the default server with localhost in my Debian machine. While trying to run Django I get: Error: That IP address can't be assigned-to. error While trying to run galaxy-dist I get this error: socket.error: Cannot assign requested address I can't telnet... (3 Replies)
Discussion started by: sachit adhikari
3 Replies

4. Debian

Connect Reliance netconnect data card in linux debian

Hi, I want to connect Reliance netconnect data card in linux - debian. I don't know which software needs to be install. can you please help me what is the software needs to be install to connect this datacard. I have connected this datacard in windows using the CD which is provided by... (3 Replies)
Discussion started by: latika
3 Replies

5. UNIX for Dummies Questions & Answers

Debian - Connect To Informix Database

Can anyone point me toward information on setting up a Debian server ODBC connection to an Informix server? I have a Windows server set up with the Informix drivers in ODBC and I'd like to do the same thing on Debian so that my Rails apps can query the database beneath our call-logging software. ... (1 Reply)
Discussion started by: badmoon75
1 Replies

6. UNIX for Dummies Questions & Answers

Connect MySQL database from Unix

How to connect a MySQL database from unix using unix shell scripting ( people are using perl scrpt to connect the same database). I want to access a MySQL database through a shell script (4 Replies)
Discussion started by: apsprabhu
4 Replies

7. Shell Programming and Scripting

connect to MySQL from Perl using DBI

Hi, I want to connect perl with the mysql to select and so on but the connection don't work code #!/usr/bin/perl BEGIN { # PERL MODULES WE WILL BE USING use DBI; $dbh = DBI->connect('DBI:mysql:C:\Program Files\MySQL\MySQL Server 5.0\data\db1','','pass') or die $DBI::errstr;} #... (1 Reply)
Discussion started by: eng_shimaa
1 Replies

8. Shell Programming and Scripting

Trying to connect MYSQL server from HP-UX

Hi everyone, I have an urgent requirement to get some table data from Linux-MYSQL server from HP-UX with oracle database.Is there any way we can get connected through Shell script from HP-UX and issue select on mysql to get some table data? Please help me out. (7 Replies)
Discussion started by: kashik786
7 Replies

9. UNIX for Advanced & Expert Users

Need a script for uploading data from unix box to mysql databse

how to upload system information(unix box) to MySql database's(running in another unix box) respective tables using a script only..i.e once script runs all the informations like hostid,hostna,disks,cpu etc get stored to respective tables of MySql database.... (2 Replies)
Discussion started by: shubhendu.pyne
2 Replies
Login or Register to Ask a Question