* Michael Higgins <[EMAIL PROTECTED]> [071029 15:10]: > On Wed, 17 Oct 2007 12:44:42 -0700 Marc Mims <[EMAIL PROTECTED]> > > > > What does $schema->storage->dbh->get_info(17) return? > > Marc, it returns "Microsoft SQL Server" > > > > > Assuming get_info(17) returns something useful, what's needed is a > > trivial little module based on that name that provides > > _dbh_last_insert_id and _sql_maker_opts. See the source for > > DBIx::Class::Storage::DBI::ODBC::DB2_400_SQL as an example. > > > > If you're not up to writing the module, I'd be happy to put one > > together you can test. > > Well, as I say above, I'm not really up to these kind of tasks. If you > make something to fix up this glitch, I'd be glad to test it -- > provided you tell me how I'm supposed to use it in my application.
I created a module, attached, using 'SELECT SCOPE_IDENTITY()', which,
after reading the MSFT docs seems to be the most appropriate identity
function.
I sent the module off-list assuming there was no need to reply here
until you had a chance to test it. But I haven't heard from you. Spam
filters, being what they are, I assume its possible you've never seen my
message. So I'll reply here to guard against that possibility. (Not
trying to hurry you---just want to make sure you get the module.)
Anyone else using Microsoft SQL Server? Care to test this small
DBIx::Class storage class to ensure PK::Auto and SQLA Limit syntax work
over and ODBC connection?
-Marc
dbic-odbc-msft.tar.gz
Description: Binary data
_______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/[EMAIL PROTECTED]
