Re: SQL Server + ADO = empty fields

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Aaron [SQL Server MVP] (ten.xoc_at_dnartreb.noraa)
Date: 06/02/04 

Date: Wed, 2 Jun 2004 09:43:42 -0400

Could you consider showing us the DDL for the table, some sample data, the
stored procedure, and the VB code that causes the issue?
http://www.aspfaq.com/5006 

-- 
http://www.aspfaq.com/
(Reverse address to reply.)
"rc" <no@email.com> wrote in message
news:#Qp73cKSEHA.2520@TK2MSFTNGP11.phx.gbl...
> Hello,
>
>
>
> Back end - SQL Server 2000
>
> Front end - Access 2000
>
>
>
>
>
> I have a basic table with about 20 columns. I retrieve data via a stored
> procedure. If I run the stored procedure (the select statement) in Query
> Analyzer, the data returned is exactly what I requested.
>
>
>
> In Access, I'm using unbound forms and connecting to SQL Server via ADO.
If
> I try to fill a recordset with the same stored procedure, some fields come
> back as "empty".
>
>
>
> For example, I have one column with a bit data type (1 or 0). I know that
> each row contains a "1" in the column. However, debugging the VB code in
> access, I find that these columns are returning as "empty" (I've confirmed
> this by coding an "if isempty()" function into the code that fills the
> recordset).
>
>
>
> Now, the strange thing, if I rearrange the order of columns via the
"Design
> Table" in SQL Server (e.g. Moving the column to the top), everything works
> fine. The recordset is filled with correct data.
>
>
>
> This work a round does seem to work, but is this really necessary?
>
>
>
> Anyone know why this happens??
>
>
>
>
>
> Any insight would be helpful.
>
>
>
>
>
> Thank You
>
>

Relevant Pages

  • Re: How to get list of EventClasses in MSSQLServer2000
    ... statement inside a stored procedure has completed.') ... SQL Server statement or stored procedure.') ... Plan','Displays the plan tree of the Transact-SQL statement executed.') ... Login','Occurs when a SQL Server login is added or removed; ...
    (microsoft.public.sqlserver.security)
  • Re: Requery method
    ... Don't use .Requery - do a full execution again?? ... recordset by using stored procedure with one parameter. ... there is an error when I run the application against SQL Server Express ...
    (microsoft.public.sqlserver.server)
  • Re: Accessing FoxPro Free Table
    ... which the SQL Server service is running. ... account, ... > If you are creating a stored procedure and you want> to make sure that the procedure definition cannot be> viewed by other users, you can use the WITH ENCRYPTION> clause. ... The procedure definition is then stored in an> unreadable form. ...
    (microsoft.public.data.odbc)
  • Re: Adding date to parameter
    ... SqlClient provider which is specifically written for SQL Server. ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ... I made the assumption that the stored procedure went by the ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Problem with the Legacy ASP files and the Sql Server Express
    ... table, if another inserting occurs at the nearly exactly the same moment, ... SQL Server will pass it a default value. ... assume that you do have a connection that can reach SQL Server Express. ... unless your stored procedure has some thing that only works ...
    (microsoft.public.dotnet.framework.aspnet)