5 messages in com.mysql.lists.win32RE: Problem with last_insert_id()
FromSent OnAttachments
"Juan F. Capristán W."02 Jun 2003 04:40 
Public Folder: MySQL02 Jun 2003 06:20 
"Juan F. Capristán W."02 Jun 2003 06:33 
Public Folder: MySQL02 Jun 2003 06:44 
"Juan F. Capristán W."04 Jun 2003 04:21 
Subject:RE: Problem with last_insert_id()
From:Public Folder: MySQL (ml.m@in-genius.com)
Date:06/02/2003 06:44:59 AM
List:com.mysql.lists.win32

nope, Kevin. I followed your suggestions but the answer is the same : 0 Anyway, I don't use ODBC, but OLEDB. Perhaps using ODBC would solve the problem? isn't it slower? I understand that using ODBC requires a query to system registry that is not needed with a connection string.

I dunno. This method always works for me.

I use MyODBC 3.51.x without problems.

As I understand it, you can skip the registry calls by using a connection string (like you are already doing) that passes the required properties. I believe it's when you use a DSN that it needs to access the registry.

Connection string: Driver={MyODBC 3.51};Server=myserver;UID=root;PWD=mypass;OPTION=16401;

-Kevin