RE: 'mysql_real_connect' with DSN

ubject: Re: '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

'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: Stored Procedure Limitation

4, 2004 5:07 AM To: Nawal Lodha; [EMAIL PROTECTED] Subject: Re: Stored Procedure Limitation Nawal Lodha wrote: Dear All, On executing a Stored Procedure

Stored Procedure Limitation

658 Mark 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

d be the reason? Can someone help? 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. > >

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

How to Restore MySQL Database from VB?

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

Unstable Database Connection

onnects my application 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 Mailin

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

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

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 , AdvModel