MyOLEDB and Stored Procedures

2004-08-13 Thread Naresh Sadhnani
Hi, Just wanted to check if anyone would know if the MyOLEDB / myODBC has been updated to support stored procedures / functions in MySQL server version 5.0.0 alpha. I am getting error DB_E_ERRORSOCCURRED(0x80040E21) when trying to execute Non Query from ADO.NET (OLEDB provider MyOLEDB).

Auto Increment Column

2004-08-12 Thread Naresh Sadhnani
Hi, Does anyone know how to extract only the Auto_Increment column from the command results of SHOW TABLE STATUS Regards Naresh -- This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have

RE: Auto Increment Column

2004-08-12 Thread Naresh Sadhnani
: 12 August 2004 13:25 To: Naresh Sadhnani; [EMAIL PROTECTED] Subject: Re: Auto Increment Column | Subject: Auto Increment Column | | Hi, | | Does anyone know how to extract only the Auto_Increment column from | the command results of SHOW TABLE STATUS Do you mean that you want a command

RE: Where are the Foreign Keys?

2004-08-06 Thread Naresh Sadhnani
You could also try SHOW KEYS FROM dbname.tablename Should work. Naresh -Original Message- From: Martijn Tonies [mailto:[EMAIL PROTECTED] Sent: 06 August 2004 14:06 To: [EMAIL PROTECTED] Subject: Re: Where are the Foreign Keys? Hi Ralf, as far as i know, there is only 1 way to

Stored Procedures in 5.0.0-alpha

2004-08-04 Thread Naresh Sadhnani
Hi There, I was wondering if anyone has used the Stored Procedures in MySQL version 5.0.0-alpha. I have setup a MySQL server version 5.0 alpha and was trying out the stored procedures. I noticed some strange behaviour in using some of the function calls from within the stored procedures. I am