RE: Stored Procedure Limitation

To: Nawal Lodha; [EMAIL PROTECTED] Subject: Re: Stored Procedure Limitation Nawal Lodha wrote: Dear All, On executing a Stored Procedure (in MySQL 5.0.0

'mysql_real_connect' with DSN

Hi All, Can 'mysql_real_connect' be called using DSN name rather than giving hostname, database name, port no., etc ? Thanks, Nawal.

RE: 'mysql_real_connect' with DSN

: 'mysql_real_connect' with DSN In message [EMAIL PROTECTED] 'mysql_real_connect' with DSN Nawal Lodha [EMAIL PROTECTED] wrote: Can 'mysql_real_connect' be called using DSN name rather than giving hostname, database name, port no., etc ? Are you using ODBC? Data Source Name(DSN

Stored Procedure Limitation

Matthews has suggested to use the client flag 'CLIENT_MULTI_RESULTS' until we get the 'MyODBC 3.53' Release. Can someone help me in using it? I wish to Call the Stored Procedure from my C++ as well as VB code through ADO. Any input would be of immense help. Thanks, Nawal Lodha.

Stored Procedure Backup

Hi, How do we take the backup of Stored Procedures in MySQL? And, how can we restore them back? I saw that proc.myd and proc.myi are created within the MySQL Database. Copying them could be one option. Is there any built-in way to achieve the same? Thanks, Nawal Lodha

WinMySQLAdmin Invocation

someone help? Thanks, Nawal Lodha.

64 Bit Support

Can someone tell me if MySQL 4.1.3-beta supports 64 Bit Itanium 2 machines with Windows 2003? Thanks, Nawal Lodha.

RE: 64 Bit Support

@ MySQL.com (http://dev.mysql.com/downloads/mysql/4.0.html) shows a wack of Itanium binaries, so I would guess it does. David Nawal Lodha wrote: Can someone tell me if MySQL 4.1.3-beta supports 64 Bit Itanium 2 machines with Windows 2003? Thanks, Nawal Lodha. -- MySQL General Mailing List

How to Restore MySQL Database from VB?

connection and call the command \. sql_file using Execute/Open method of Connection Object. But that doesn't seem to work. Thanks, Nawal Lodha.

RE: How to Restore MySQL Database from VB?

Hi Michael, This seems to be better than executing a batch file. But still, its not efficient as large database restorations would require innumerable queries to be executed. Wish MySQL had a non-proprietary SQLDMO like API !! Regards, Nawal Lodha. -Original Message- From: Michael

Unstable Database Connection

to the default mysql database. :-( The Init DB command is called quite inconsistently and not always from the same place in the application. Kindly, suggest a solution so that I can retain my connection or avoid the init Db call. Many Thanks, Nawal Lodha. -- MySQL General Mailing List

Null value in mediumtext datytype

I create a Visual C++ COM object that makes use of ADO Recordset for database queries. I need to execute an update query in MySQL. I am using MyODBC-3.51.06 and mysql-4.1.1-alpha. My table has a field with datatype as mediumtext. One record consists the value as NULL for this field. But, the

Query takes 1703.57 sec

I have a query like - SELECT AdvElement.c_objectId , AdvElement.c_createdOn , AdvElement.c_modifiedOn , AdvElement.c_elementType , AdvElement.c_packageId , AdvElement.c_stereoTypeId , AdvElement.c_objectType , AdvElement.c_versionNumber , AdvModelElement.c_details ,

RE: Query takes 1703.57 sec

Dear Dan, Have tried that and it works. The query executes in less than 0.1 sec with indexes. Thanks for the immediate help. Nawal. -Original Message- From: Dan Nelson [mailto:[EMAIL PROTECTED] Sent: Monday, January 12, 2004 11:29 AM To: Nawal Lodha Cc: [EMAIL PROTECTED] Subject: Re