FillSchema works on one machine but not another???
From: Gerry (gerry_at_pairofdocs.net)
Date: 01/07/05
- Next message: Curtis Justus: "Re: Storing data in DB field as XML (varchar field)"
- Previous message: VM: "DateTime <-> DbTimeStamp"
- Next in thread: Marina: "Re: FillSchema works on one machine but not another???"
- Reply: Marina: "Re: FillSchema works on one machine but not another???"
- Messages sorted by: [ date ] [ thread ]
Date: 7 Jan 2005 09:55:49 -0800
I develop my ASP.NET application on a Windows XP (SP2) computer with
MSDE (SP3)
My application server is a Windows 2000 Server (SP3) computer with MS
SQL 2000 (SP3)
My code looks like this:
Dim daRoom As New SqlDataAdapter("Room_Select", myConn)
daRoom.SelectCommand.CommandType = CommandType.StoredProcedure
daRoom.SelectCommand.Parameters.Add("@Action", "All")
daRoom.FillSchema(dsReport, SchemaType.Mapped, "Room")
daRoom.Fill(dsReport, "Room")
My stored procedure is setup like this:
ALTER PROCEDURE dbo.Room_Select
@Action nvarchar(20)
AS
SET NOCOUNT ON
if @Action = 'All'
SELECT *
FROM Room
ORDER BY Room
if @Action = 'ChargedRooms'
SELECT *
FROM Room
WHERE ChargeType <> 'None'
ORDER BY Room
-- couple of more if clauses
I use Red Gate Software SQL comparison tools and have verified that the
table structures, stored procedures, permissions, etc., on both
machines are identical.
I have verified using a file comparison tool that all .aspx, .dll, etc.
files on both machines are identical.
The application on both machines runs as the ASPNET user, and it is
configured the same on both machines.
SO:
Why does this application work perfectly on the development machine,
but on the server, I get:
Table doesn't have a primary key.
when I try doing a dsUsage.Tables("Client").Rows.Find(RoomID)??????
- Next message: Curtis Justus: "Re: Storing data in DB field as XML (varchar field)"
- Previous message: VM: "DateTime <-> DbTimeStamp"
- Next in thread: Marina: "Re: FillSchema works on one machine but not another???"
- Reply: Marina: "Re: FillSchema works on one machine but not another???"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
