Charles Lawrence wrote:
Gentlemen,
I'm hoping you can answer a question for me.
I am using an XP Pro platform accessing an MSSQL 2000 server. I use
ActivePerl 5.8.4 to access my database via ODBC. The latest versions of
the DBI and DBD-ODBC modules are installed. When I attempt to use
placeholders in my script, NOTHING HAPPENS. The script runs to
completion with no errors, but no data is stored. If I do the same
thing with a MySQL database, it all works OK. Am I missing something or
what? Does the MS SQL Server ODBC driver 3.8.5.1117 that my DSN uses
actually support placeholder use? It would appear that it does not, but
does not complain either. Below is a code snippet. Thanks in advance
for any help. In the meantime, I have abandoned the placeholder concept
with its inherent efficiency in loops, and now use a DBI do command
instead. It works, but...
I'm relatively new at this, but from what I can see, you've turned off
autocommit, but you aren't committing your transaction. Is that right?
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
