ADO.NET Behavior

  • Thread starter Thread starter Nathan Truhan
  • Start date Start date
N

Nathan Truhan

Hello,

I am developing a web-based application for filtering rows
of data in a datagrid and am running into a problem with
deployment of the app.

The application has a DropDownList that is populated from
an SQLReader from a SQL 2000 Database. Once an item is
selected from the DropDownList, the web site performs a
postback then populates a DataGrid from another SQLReader
that is filtered on the SelectedItem.value from the
DropDownList. It is a fairly simple application and it
works fine on my test box. However, when I copy the
project to the server and try to execute it, the
DropDownList does not populate, it is just blank, I do not
get any warnings, errors, etc...

My Machine is a 3.2Ghz, 1GB Ram, Windows XP Pro SP1 with
Visual Studio .NET 2003, Framework 1.1. It also has an
installation of Macromedia ColdFusion 5 Server, but that
is not used often. It also has VirusScan 7.1 Enterprise
for Scanning.

The server is Dual 1Ghz with 2GB Ram, Windows 2000
server, .NET Framework 1.1, and ColdFusion 5 Server.
Unlike my box, this version of ColdFuction is highly
utilized. It also has VirusScan 4.5.1 for Scanning.

I am stumped since the configurations are so similar.
Also both boxes are at the latest system patches and have
ADO 2.7 SP1 and the Microsoft SQL 2000 Client tools
installed.

If anyone has any ideas, I would greatly appriciate any
input.

Thanks in advance,
Nathan

The server
 
I bet there is something wrong with data accessing.
You might put some logging information after connection.Open, after
ExecuteReader, etc so you will know which line causes problem.
 
I put in some logging, and have found that the results
from the SQLReader returns the schema with the fields for
the data, but no data. The HasRows returns False, but
the FieldCount returns 7, which is correct. And I also
checked the Connection State which returs Open.

Nathan
 
Now, the obvious question: Is there any data to retrieve?
I mean, you are probably connecting to different database?
 
Of Course. There is one record for the Drop Down, and
just shy of 50 records for the datagrid, like I
mentioned, it pulls back correctly on my test machine.
That's why it is confusing, same .NET, different results.
Ahhhh :)

Thank you,
Nathan
 
Back
Top