I'm using ASP and MySQL for a db.
I'm inserting a record and need to know what the id of the last inserted record was.
I looked up MySQL documentation and supposedly "SELECT LAST_INSERT_ID()" takes care of that, it does work in actual MySQL.
But it doesn't want to work with DNS-less connection, here is the code, followed by the error.
set rs=conn.execute("SELECT LAST_INSERT_ID()")
looks fine but i'm getting this error
Microsoft OLE DB Provider for ODBC Drivers error '80020009'
[Microsoft][ODBC Driver Manager] Driver does not support this parameter
Please, help me out.