RE: Two problems with prepared statements in ver 5.0.0

2004-05-12 Thread Arunachalam
Hello, I have found this trouble between documentation and real API library and quote to MySQL Team and report the BUG last 2 months back. They replied me that it's under development and it would be available to the developers from its next release on Aug 2004. The main changes happens in

Fwd: Re: New Prepared Statements !!!!!

2004-05-12 Thread Arunachalam
Note: forwarded message attached. Yahoo! India Matrimony: Find your partner online. http://yahoo.shaadi.com/india-matrimony/---BeginMessage--- At 13:08 + 3/12/04, Arunachalam wrote: Sorry to all, I found

Re: INNODB SHOW STATUS

2004-04-21 Thread Arunachalam
hi try this URL: http://www.innodb.com/ibman.php -arun. --- Emmett Bishop [EMAIL PROTECTED] wrote: Howdy all, Quick question about what I'm seeing in the BUFFER POOL AND MEMORY section... I've configured the innodb_buffer_pool_size to be 128M and when I do a show variables like

how to obtain MySQL 4.1.1 source from Bitkeeper?

2004-03-18 Thread Arunachalam
Hi, I have installed the package bk-3.0.4-x86-win32.EXE from Bitkeeper.com, to get the Mysql-4.1.1 source code for Windows 2000 box. It's installed successfully and frame the shortcuts in my Start menu -- program -- Bitkeeper with sub menus for bash shell1 bash shell2 Helptool

what to do? to get MySQL source?

2004-03-18 Thread Arunachalam
When I first mail to [EMAIL PROTECTED] they said Quick answer: you probably have an incorrect Internet Proxy setting. Test if you can connect to mysql.bkbits.net port 14690 using telnet: C:\ telnet mysql.bkbits.net 14690

reg Bitkeeper wizard parameters

2004-03-18 Thread Arunachalam
binary needs to be able to make a http connection to lease.openlogging.org at least once a month. look at 'bk help url' if you need to tell 'bk' about a proxy. * Anybody help/suggest me to attain my goal pls... Arun. --- Arunachalam

can I get MySQL Source code under Windows OS?

2004-03-16 Thread Arunachalam
Hi, I have downloaded *bk-3.0.4-x86-win32.EXE* from URL: http://www.bitmover.com/download, for windows When I try to install it ask for; *** This release of BitKeeper requires the Cygwin version 1.5.5 . If you have already installed a older cygwin release, you should upgrade to cygwin 1.5.5

Re: can MySql run over windows os?

2004-03-15 Thread Arunachalam
hi Íõ ÊË, Yes you can have MySQL for Windows OS ... visit: http://www.mysql.com/downloads/mysql-4.0.html --- Windows downloads - OK --- Íõ ÊË [EMAIL PROTECTED] wrote: Dear sir: I've used MySql for several years. It IS the best database I've used, small and efficient. However,

Got an error reading communication packets - ???

2004-03-15 Thread Arunachalam
Hi MySQLians, After such a long span (nearly 1 month) of searching the solution for the server restart while executing C API prepared statments I found that the execution met the error in the server ; 040315 17:48:55 Aborted connection 2 to db: 'test' user: '' host: `localhost' (Got an

New Prepared Statements !!!!!

2004-03-12 Thread Arunachalam
Hi, I am really astonishing when I see the sample program on the URL: http://www.mysql.com/doc/en/mysql_stmt_execute.html I am using MySQL 5.0.0 alpha Windows 2000 SP 4 VC++ 6.0 I found that the C API changes as mysql_prepare() --- mysql_stmt_prepare() mysql_bind_param() ---

Re: New Prepared Statements !!!!!

2004-03-12 Thread Arunachalam
... Arun. --- Arunachalam [EMAIL PROTECTED] wrote: Hi, I am really astonishing when I see the sample program on the URL: http://www.mysql.com/doc/en/mysql_stmt_execute.html I am using MySQL 5.0.0 alpha Windows 2000 SP 4 VC++ 6.0 I found that the C API changes as mysql_prepare

Re: MySql

2004-03-12 Thread Arunachalam
hi, When using MyISAM table, the limit will be determined by your operating system, ie. the number of files you can have in one directory. Using InnoDB tables removes that limitation by allowing multiple tables within a single datafile (tablespace). The maximum tablespace size is 4 billion

MySQL 5 C API prepared Statments errors

2004-03-10 Thread Arunachalam
Hi, As I declared that COBOL can able to communicate with MySQL via it's C API routines. Currently i have used MySQL 5.0.0-alpha and involved in the usage of prepared statement C API. When I implement this calling from COBOL shows this error and reset the MySQL server. (reset -- stop).

C API Prepared Statements under Debugging mode in MySQL 5.0.0.

2004-03-02 Thread Arunachalam
Hello MySQLians, As per debugging the sample C coding I have made some more changes and observed that the execution of all the C API is working fine, after complete execution the server become unstable and resetted. When I involved in debuging the C coding I found that it has allocated too

trouble with C API Prepared statements.

2004-02-25 Thread Arunachalam
Hai MySQLians, I have listed down the log details which shows the mysql server’s normal shutdown and improper shutdown while it got trouble from C coding. Log details from c:\mysql\data\mysql.err MySql: ready for connections. Version:

Re: Urgent: Prepared Statements C API hangup the Server - Help Urgent....

2004-02-24 Thread Arunachalam
while executing Client C API functions. thank you Expecting your valuable reply. regards, Arun. --- Arunachalam [EMAIL PROTECTED] wrote: Hi, I have written in intermediate, on the appropriate position in this discussion, please go thru in full. --- Michael Widenius [EMAIL PROTECTED

Re: Urgent: Prepared Statements C API hangup the Server - Help Urgent....

2004-02-24 Thread Arunachalam
reply with detail Thanks Arun. --- Arunachalam [EMAIL PROTECTED] wrote: hi, I wish to provide some more information too regarding MySQL Server hangup. Once after I execute the C sample program, WinMySQLAdmin tool and query commands from *mysql* console never responds. During

Re: Urgent: Prepared Statements C API hangup the Server - Help Urgent....

2004-02-23 Thread Arunachalam
Hi, I have written in intermediate, on the appropriate position in this discussion, please go thru in full. --- Michael Widenius [EMAIL PROTECTED] wrote: hi! A == Arunachalam [EMAIL PROTECTED] writes: A As per my searching I have found the right C API in libmysql.lib from A MySQL

Urgent: Prepared Statements C API hangup the Server - Help Urgent....

2004-02-18 Thread Arunachalam
Hai MySQLians!!! I have established the Successful Connection to MySQL from COBOL. Now from COBOL I can able to query the MySQL and get back the result sets using C APIs under MySQL 4.0.17-max both in windows and Linux. Note that my Client is in Windows platform... Its not enough for my

help needed reg MySQL 5.0.0a-aplha Windows

2004-02-17 Thread Arunachalam
hi all, I have installed MySQL 5.0.0a-alpha for Windows... Everday 1st time it's started using WinMySQLAdmin 1.4 tool and working on the mysql prompt, it works fine... whenever i shut down the system OR Stop the service once and restart again it started asusual, but no values displayed in

Is it correct, for DB accessing

2004-02-16 Thread Arunachalam
Hi all, I have installed the MySQL 5.0.0a-aplha for Windows Previously I have some Database in 4.0.17-max, to access those database now from current version MySQL Server, I have just Copy the C:\mysql\Data\myDB folder into current server's Data file path. Is this enough to integrate thoes

Re: AW: Is it correct, for DB accessing

2004-02-16 Thread Arunachalam
on. A better way is to pump all data from the old to the new DB. Okay, just copying will work fine, but you will distroy the history of your BIN files! Rgds, Michael Schmuck -Ursprüngliche Nachricht- Von: Arunachalam [mailto:[EMAIL PROTECTED] Gesendet: Montag, 16. Februar 2004 13:15

MySQL aplha, production release doubts...

2004-02-10 Thread Arunachalam
Hi, I have used MySQL 4.0.17-max-debug for windows in win 2K SP-4 I would like to know Is there any impacts we may have to met using Alpha release before the release of production version. why we have different types of mysqld? mysqld mysqld-opt mysqld-nt mysqld-max

reg MySQL C API Prepared statements

2004-02-09 Thread Arunachalam
Hi! MySQL C API Prepareed statements routines; mysql_prepare, mysql_bind_param, mysql_fetch, mysql_execute are present in *libmysql.lib* file - right... I have currently used MySQL 4.0.17-max I want to clarify that starting from which version, MySQL provides this?

Re: mysql 4.1.1 negative default column values doesn't work

2004-02-06 Thread Arunachalam
Table created with out any error in MySQL 4.0.17-max-debug win mysql create table foo (id int not null default -1); Query OK, 0 rows affected (0.22 sec) mysql explain foo; +---+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra |

Access denied for user: 'ODBC@localhost' (Using password: YES)

2004-02-05 Thread Arunachalam
Hi all, Is any one met with the error while connecting to MySQL Server *Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)* if so pleass let me know the remedy to resolve this error. I don't have the user named ODBC in my mysql Database. my configuration is: Windows 2000

Re: Access denied for user: 'ODBC@localhost' (Using password: YES)

2004-02-05 Thread Arunachalam
: this occures when you ommit the user name, MYSQL C API uses user ODBC as default when you ommit or enter empty string as user name when calling mysql_real_connect() - Original Message - From: Arunachalam [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 05, 2004 3:38

MySQL Connection to COBOL

2004-01-30 Thread Arunachalam
Hi MySQLians, For the last 2 months I have tried to establish connection between COBOL and MySQL. Hope I have succeeded a stage in this regard. I have used Remote server: MySQL Server 4.0.17-max in Suse Linux Client: Windows 2000 Microsoft VC++ 6.0 CA-Realia COBOL

Can't connect to MySQL server on 'localhost' (10061)- solution pls

2004-01-29 Thread Arunachalam
Hi all, I have the following settings in *my.ini* (obtined from WinMySQLadmin) #This File was made using the WinMySQLAdmin 1.4 Tool #12/11/2003 10:50:28 AM #Uncomment or Add only the keys that you know how works. #Read the MySQL Manual for instructions [mysqld] basedir=C:/Program Files/mysql

Re: porting Oracle schema to MySQL

2004-01-28 Thread Arunachalam
look at http://www.ispirer.com it provides a tool SQLWays, which is a migrating tool to migrate any DataBase to MySQL with Data. greets, Arun. --- Claire Lee [EMAIL PROTECTED] wrote: Hi, I'm a newbie working on a big project. The idea is to transport an existing Oracle database at

reg: Can't open named pipe to host: . pipe: MySQL (2)

2004-01-27 Thread Arunachalam
Hi! May I have the reason why this error occured in my Localhost. When I try to connect to MySQL on the Localhost I met the error *Can't open named pipe to host: . pipe: MySQL (2)* I have used; Windows 2000 SP 4 MySQL Server 4.0.17 max-debug Upon looking the documentation

Unknown MySQL Server Host '̞' (11001)€: Q̞(53)

2004-01-20 Thread Arunachalam
hi all! what are all the situations, which raise this error? If any one got ideas regarding this pls let me know I haven't step ahead due to this error. Unknown MySQL Server Host '̞' (11001)€: Q̞(53) thanks Arun.

Re:_Unknown_MySQL_Server_Host_'Ìz'_(11001)? :_QÌz(53)

2004-01-20 Thread Arunachalam
of put a mile stone for the support to COBOL. I would be wonder if any one read this clearly and suggest me. thanks Arun. --- Arunachalam [EMAIL PROTECTED] wrote: Hi! I am trying to connect MySQL Database to COBOL. I have made it possible to some stages by the way

Re:__Unknown_MySQL_Server_Host_'Ìz'_(11001)?_:_QÌz(53)

2004-01-20 Thread Arunachalam
--- Roger Baklund [EMAIL PROTECTED] wrote: * Arunachalam Sent: Tuesday, January 13, 2004 10:39 PM To: mySQL List Subject: Re: mysql_init function issues :Connecting MySQL to COBOL I have somehow managed to create the datatype in COBOL matching to C datatype and passed as argument

passing socket info to mysql_real_connect()

2004-01-19 Thread Arunachalam
Hi all, Herewith I want to confirm that the info passed to the Socket parameter of mysql_real_connect() is correct or not? we have C API function to handle MySQL database using C programs. MYSQL *mysql_real_connect(MYSQL *mysql, const char *host,

mysql_init function issues :Connecting MySQL to COBOL

2004-01-13 Thread Arunachalam
and suggest me. thanks Arun. --- Arunachalam [EMAIL PROTECTED] wrote: Hi! I am trying to connect MySQL Database to COBOL. I have made it possible to some stages by the way as follows; I have developed this under; Client: Microsoft Windows 2000 Service pack 4. CA-Realia COBOL Compiler

Re: mysql_init function issues :Connecting MySQL to COBOL

2004-01-13 Thread Arunachalam
a mile stone for the support to COBOL. I would be wonder if any one read this clearly and suggest me. thanks Arun. --- Arunachalam [EMAIL PROTECTED] wrote: Hi! I am trying to connect MySQL Database to COBOL. I have made it possible to some stages by the way as follows; I

Re: help about mysql_real_connect!

2004-01-08 Thread Arunachalam
Hi Li, If you want to see the implementation portion of C coding for mysql_real_connect, U can see open the mysql.h header file in any C++ editor. I don't know Why do you want to see those iplementation? libmysql.lib is a library file used to permit dynamic calls from it's clients.

Re: COBOL Syntax of calling MySQL's C API

2004-01-02 Thread Arunachalam
: Arunachalam [EMAIL PROTECTED] To: Patrick Sherrill [EMAIL PROTECTED] Sent: Wednesday, December 31, 2003 4:22 AM Subject: Re: COBOL Syntax of calling MySQL's C API hi, From COBOL I have tried to Connect to MySQL using the C API functions given by MySQL. Finally I struck up

reg MySQL connetion to COBOL

2003-12-30 Thread Arunachalam
Hi, I am having responsibility to connect MySQL to COBOL. after such a long analysing I found there are some C API function to connect to MySQL provided by itself. In COBOL I have the option to CALL external programs written in other languages. I follow this way to made connection to MySQL

Re: reg C API from MySQL

2003-12-16 Thread P Arunachalam
, FL 33904 - Original Message - From: P Arunachalam [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 11, 2003 4:31 AM Subject: reg C API from MySQL Yahoo! India Mobile: Download

Re: reg C API from MySQL

2003-12-16 Thread P Arunachalam
, FL 33904 - Original Message - From: P Arunachalam [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 11, 2003 4:31 AM Subject: reg C API from MySQL Yahoo! India Mobile: Download

Bug in mysql.h header file

2003-12-16 Thread P Arunachalam
ISP 825 SE 47th Terrace Cape Coral, FL 33904 - Original Message - From: P Arunachalam [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 11, 2003 4:31 AM Subject: reg C API from MySQL

Re: Bug in mysql.h header file

2003-12-16 Thread P Arunachalam
in the 'Additional library path:' field. Pat... - Original Message - From: P Arunachalam [EMAIL PROTECTED] To: Patrick Sherrill [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 6:36 AM Subject: Bug in mysql.h header file I was trying to establish

reg connecting COBOL to MySQL via ODBC

2003-12-03 Thread P Arunachalam
explain me in detail those facilities. expecting your valuable reply... thanks regards Arunachalam. Yahoo! India Mobile: Download the latest polyphonic ringtones. Go to http://in.mobile.yahoo.com -- MySQL General Mailing

Problem in installing Mysql

2001-09-21 Thread Kasi Viswanthan Arunachalam
Hi, I need some help in installing MySQL.I did the following things 1) Downloaded the mysql version 3.23.36-pc-linux-gnu-i686.tar.gz 2) tar -zxvf mysql-version 3) ln -s /usr/local/mysql-version mysql 4) adduser mysql 5) passwd mysql 6) chown -R mysql mysql-vesion mysql 7) chgrp -R root

Bug in installing mysql

2001-09-20 Thread Kasi Viswanthan Arunachalam
I need some help in installing MySQL. I did the following things 1) Downloaded the mysql version 3.23.36-pc-linux-gnu-i686.tar.gz 2) tar -zxvf mysql-version 3) ln -s /usr/local/mysql-version mysql 4) adduser mysql 5) passwd mysql 6) chown -R mysql mysql-vesion mysql 7) chgrp -R root