Sponsored Content
Operating Systems Linux Debian Connect MySQL databse to debian Post 302408885 by linux31 on Tuesday 30th of March 2010 06:43:49 PM
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...
 

9 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

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. 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

7. 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

8. 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

9. 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
zap(1)								  MySQL database							    zap(1)

NAME
zap - a perl script used to kill processes USAGE
/usr/bin/mysql_zap [-signal] [-?Ift] pattern SYNOPSIS
zap [-I|-?] [-f] [-t] DESCRIPTION
zap supports by executing -I|-? info -f force -t test NOTE
If -f isn't given, ask user for confirmation for each process to kill. If signal isn't given, try first with signal 15 and after that with signal 9. If -t is given the processes is only shown on stdout. SEE ALSO
isamchk(1), isamlog(1), mysql(1), mysqlaccess(1), mysqladmin(1), mysqld(1), mysqld_multi(1), mysqld_safe(1), mysqldump(1), mysql_fix_privi- lege_tables(1), mysqlshow(1), perror(1), replace(1) For more information please refer to the MySQL reference manual, which may already be installed locally and which is also available online at http://www.mysql.com/doc/en/ BUGS
Please refer to http://bugs.mysql.com/ to report bugs. AUTHOR
Ver 1.0, distribution 4.0.24 Michael (Monty) Widenius (monty@mysql.com), MySQL AB (http://www.mysql.com/). This software comes with no war- ranty. Manual page by L. (Kill-9) Pedersen (kill-9@kill-9.dk), Mercurmedia Data Model Architect / system developer (http://www.mercurme- dia.com) ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +--------------------+------------------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +--------------------+------------------------------------+ |Availability | SUNWmysqlr, SUNWmysqlu, SUNWmysqlt | +--------------------+------------------------------------+ |Interface Stability | External | +--------------------+------------------------------------+ NOTES
Source for mysql is available on http://opensolaris.org. MySQL 4.0 19 December 2000 zap(1)
All times are GMT -4. The time now is 11:31 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy