Hi Folks, hope this is the right list, as I didn't see a
nantcontrib-users list. I'm seeing strange behaviour when using the sql
task and the myoledb (http://sourceforge.net/projects/myoledb/) provider
- If a run a statement that gives more that 1 result it fails but with
one result it succeeds.
For example:
<sql connstring="Provider=MySQLProv;Data Source=mysql;User
Id=user;Password=passwd;Location=localhost"
delimiter=";"
delimstyle="Normal"
print="true"
transaction="false"
source="test.sql" />
When test.sql contains:
"SELECT * FROM user;"
fails with message: 'MySQLProv' failed with no error message available,
result code: DB_E_ERRORSINCOMMAND(0x80040E14).
"SELECT * FROM user LIMIT 1;"
succeeds
Now, admittedly it looks like a provider issue and I wouldn't trouble
the list normally but this is so fundamental that I wondered if there
could be a problem with my nant setup, maybe some version
inconsistencies? I'm using nant-contrib 0.85, nant 0.85, mysql
4.1.21-community-nt, myoledb 3.9.6, win xp sp2 (client), win Server 2003
SP1 (server).
Thanks
Dave
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
NAntContrib-Developer mailing list
NAntContrib-Developer@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nantcontrib-developer
