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/--- Begin Message --- At 13:08 + 3/12/04, Arunachalam wrote: Sorry to all, I found that

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 Prepa

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 lik

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

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

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

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 *WARN

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 er

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

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 dat

Re: New Prepared Statements !!!!!

2004-03-12 Thread Arunachalam
.. thanks... 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 >V

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() --->

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

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 much

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: '5.0.0-

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

2004-02-24 Thread Arunachalam
mory buffers? Pls 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

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

2004-02-24 Thread Arunachalam
e or hangup 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. >

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&

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 applicat

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 Envi

Re: AW: Is it correct, for DB accessing

2004-02-16 Thread Arunachalam
idn't have the create statements of the tabels and so 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

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 Databa

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 mysqld-m

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? t

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

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

2004-02-05 Thread Arunachalam
ECTED]> wrote: > 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 PROTECT

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

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 Compile

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

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 fro

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 dat

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

2004-01-20 Thread Arunachalam
t_used_slave; > struct st_mysql* last_used_con; > } MYSQL; > > - I want to confirm that Is this much lengthy decalration of pointer needed? (OR) > - We can just find the length and given it to COBOL pointer declaration? > - Incase Length does the needs how to fix the length fo

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.

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,

Re: mysql_init function issues :Connecting MySQL to COBOL

2004-01-13 Thread Arunachalam
> struct st_mysql* last_used_con; > } MYSQL; > > - I want to confirm that Is this much lengthy decalration of pointer needed? (OR) > - We can just find the length and given it to COBOL pointer declaration? > - Incase Length does the needs how to fix the length for each data

mysql_init function issues :Connecting MySQL to COBOL

2004-01-13 Thread Arunachalam
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 have developed this under;

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

Conneting MySQL to COBOL

2004-01-07 Thread Arunachalam
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 Version 6.0.45 Microsoft (R) Incremental Linker Version 6.00.8168 MySQL server 4.

Re: COBOL Syntax of calling MySQL's C API

2004-01-02 Thread Arunachalam
ULL is not zero). > > Pat... > > > - Original Message - > From: "Arunachalam" <[EMAIL PROTECTED]> > To: "Patrick Sherrill" <[EMAIL PROTECTED]> > Sent: Wednesday, December 31, 2003 4:22 AM > Subject: Re: COBOL Syntax of callin

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 fro

Re: Bug in mysql.h header file

2003-12-16 Thread P Arunachalam
> added in the 'Object/library module' field separated > by spaces (e.g. > 'wsock32.lib mysqlclient.lib'). Don't forget to add > the path to the > mysqlclient library in the 'Additional library > path:' field. > > Pat... > > > - Or

Bug in mysql.h header file

2003-12-16 Thread P Arunachalam
27;*' c:\mysql\include\mysql.h(284) : error C2059: syntax error : ')' c:\mysql\include\mysql.h(285) : error C2143: syntax error : missing ')' before '*' c:\mysql\include\mysql.h(285) : error C2143: syntax error : missing '{' befor

Re: reg C API from MySQL

2003-12-16 Thread P Arunachalam
gt; > [EMAIL PROTECTED] > CocoNet Corporation > SW Florida's First ISP > 825 SE 47th Terrace > Cape Coral, FL 33904 > > > > > > - Original Message - > From: "P Arunacha

Re: reg C API from MySQL

2003-12-16 Thread P Arunachalam
gt; > [EMAIL PROTECTED] > CocoNet Corporation > SW Florida's First ISP > 825 SE 47th Terrace > Cape Coral, FL 33904 > > > > > > - Original Message - > From: "P Arunacha

reg C API from MySQL

2003-12-11 Thread P Arunachalam
I am in a position to connect MySQL into COBOL. I have properly downloaded the MyODBC from your website. I have tried to Establish connection from COBOL through the C API it have. For that I have to link certain run time library for C API given by MySQL. like 'mysqlclient.lib', ... I want to clar

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 my

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 mysql-ve