SQL Error
I am working on a program that uses SQL server 6.5 and connects using RDO.
Under win95, all works fine. Under Win2K and some cases of Win98, it gives this error:
37000: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open a cursor on a stored procedure that has anything other than a single select statement in it
The stored procedure looks like this:
SELECT * FROM tblCustomers
I've looked around an found some articles saying that the cursorengine must be set to rdoUseODBC to avoid this error, but other say that when the table returns a field of the type text, I should use rdoUseServer. Anyway, i've tried them all, and none of them succeeded. Also, we still have that Win95 versus Win98/2k issue.
Has anybody ever seen this before, and how must I solve this?
Tom Cannaerts
slisse@planetinternet.be
Programming today is a race between software engineers striving to build bigger and better idot-proof programs, and the universe trying to produce bigger and better idiots. So far, the universe is winning -- Rich Cook
[1101 byte] By [
Cakkie] at [2007-11-15 16:17:34]
# 1 Re: SQL Error
Cannot update to sqlServer 7 svpk 2?
Special thanks to Lothar "the Great" Haensler, Tom Archer, Chris Eastwood,
Bruno Paris and all the other wonderful people who made and make dev-archive
a great place.
Come back soon, you Gurus.
# 2 Re: SQL Error
Now that is a problem, I can't upgrade the server, or at least that is not an option now (maybe later, not now), and if I upgraded, I would most definitly go for SQL2000 in stead of 7. Also, going from RDO to ADO isn't an option either, cause that would result in me having to recode the entire project (100+ forms, not kidding) and reports (300+, also not kidding).
Tom Cannaerts
slisse@planetinternet.be
Programming today is a race between software engineers striving to build bigger and better idot-proof programs, and the universe trying to produce bigger and better idiots. So far, the universe is winning -- Rich Cook
Cakkie at 2007-11-10 1:00:01 >
# 4 Re: SQL Error
Dunno, will try that first thing monday morning. Take a bit long to compile the program (about 5 minutes), ok that aint so long, but if you are waiting on it, and the sun is shining, and the weekend awaitens you, and you are hungry, and... ok, going to stop now.
Thanx for the reply
Tom Cannaerts
slisse@planetinternet.be
Programming today is a race between software engineers striving to build bigger and better idot-proof programs, and the universe trying to produce bigger and better idiots. So far, the universe is winning -- Rich Cook
Cakkie at 2007-11-10 1:02:07 >
