Marc Mims wrote: > * 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
I have MSSQL at work, although I've never ever tried to hooking perl/DBIC up to it. I'd be happy to test it if you could supply some details. Are you on *nix connecting to an MSSQL server via FreeTDS, or on windows machine connecting to an MSSQL server via ODBC?
signature.asc
Description: OpenPGP digital signature
_______________________________________________ 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]
