By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,187 Members | 1,041 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,187 IT Pros & Developers. It's quick & easy.

Data returned by SQL Server ODBC driver is not correct

P: n/a
I've a query which happily returns a full set of data when run in SQL
Studio but when I do the same query using IIS with Classic ASP
connected via ODBC's SQL Server driver (not the native one) numbers
returned to the record set are filled with 0 and strings are empty
exept for a few rows.

This is happening in IIS 5.1 and IIS 6.0 when the database is on a
seperate machine. With IIS 5.1 and SQL Server 2005 Developer Edition
on the same machine (XP Professional) the query results are as
expected.

I can't even think of what to check or search for!

David
Aug 5 '08 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On 5 Aug, 14:57, woak...@googlemail.com wrote:
I've a query which happily returns a full set of data when run in SQL
Studio but when I do the same query using IIS with Classic ASP
connected via ODBC's SQL Server driver (not the native one) numbers
returned to the record set are filled with 0 and strings are empty
exept for a few rows.

This is happening in IIS 5.1 and IIS 6.0 when the database is on a
seperate machine. *With IIS 5.1 and SQL Server 2005 Developer Edition
on the same machine (XP Professional) the query results are as
expected.

I can't even think of what to check or search for!

David
I noticed that the connection used had a transaction with deletes
pending and so I decided to create a second connection
and lo and behold the query returned the correct results.

The code was working perfectly with SQL Server 2000 so I remain very
concerned and would appreciate some help.
Aug 5 '08 #2

P: n/a
(wo*****@googlemail.com) writes:
On 5 Aug, 14:57, woak...@googlemail.com wrote:
>I've a query which happily returns a full set of data when run in SQL
Studio but when I do the same query using IIS with Classic ASP
connected via ODBC's SQL Server driver (not the native one) numbers
returned to the record set are filled with 0 and strings are empty
exept for a few rows.

This is happening in IIS 5.1 and IIS 6.0 when the database is on a
seperate machine. *With IIS 5.1 and SQL Server 2005 Developer Edition
on the same machine (XP Professional) the query results are as
expected.

I can't even think of what to check or search for!

David

I noticed that the connection used had a transaction with deletes
pending and so I decided to create a second connection
and lo and behold the query returned the correct results.

The code was working perfectly with SQL Server 2000 so I remain very
concerned and would appreciate some help.
In such case, you need to be a whole lot more specific. You could start
us showing the code that is freaking out for you. Don't forget the
connection string!
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Aug 5 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.