Re: MSHFlexgrid not displaying data from ADO data control

From: Jan Hyde (StellaDrinker_at_REMOVE.ME.uboot.com)
Date: 07/30/04 

Date: Fri, 30 Jul 2004 13:13:20 +0100

"Nick" <nick.glenisterNO@SPAMkeypublishing.com>'s wild
thoughts were released on Fri, 30 Jul 2004 12:32:05 +0100
bearing the following fruit:

>Hi,
>
>For any who are interested i've sorted the problem now thanks
>

You might want to post your solution in case anyone has the
same problem.

J

>
>"Nick" <nick.glenister@keypublishing.com> wrote in message
>news:OrduS9KdEHA.1652@TK2MSFTNGP09.phx.gbl...
>> Hi,
>>
>> I'm having a very hard time figuring this out, and I'm going to have an
>even
>> harder time explaining the problem.
>>
>> I have a large program that displays customer details along with purchase
>> details etc... on my development machine my program runs perfectly well
>but
>> if I put it onto a clients machine none (and I mean none) of the
>> MSHflexgrids display any data.
>>
>> The MSHflexgrids data sources are ADO data controls which are
>> programmatically assigned a connection string to an SQL 7 Server through
>> ODBC. When the customer is searched for, each of these ADO controls
>> recordsets is populated with an SQL string to display the customers
>> purchases etc... in the form of:
>>
>> sqlstr = "SELECT * FROM Orders WHERE CustNum = 123456"
>> data1.recordsource = SQLStr
>> data1.refresh
>>
>> The data is displayed exactly how i want it on my machine (Windows XP
>> professional with Visual Studio 6 and SQL server 7 running locally). I can
>> connect my laptop to the network and run the compiled program from this
>and
>> it too works perfectly, but neither of the two client machines (one
>Windows
>> XP professional and the other Windows 2000 Professional) I have tried
>> display any data in the MSHFlexGrids even though connection to the SQL
>> server is sound and the customers detail (which are not displayed in an
>> MSHFlexGrid) are returned.
>>
>> The SQL Server uses windows network authentication to allow access and I
>> have tried logging in as the user and as myself etc... still won't display
>> any data.
>>
>> I have tried replacing the MSHflexgrid with data grids but these too
>remain
>> empty. I've checked the recordsources of the data controls and there are
>the
>> SQL strings I expect to see.
>>
>> I have fully updated Windows, installed the latest MDAC, Jet 4 SP8, VB6
>> Runtime and the client files from the SQL server 7 desktop version onto
>the
>> client machine but still I see no data.
>>
>> I don't understand why it works on some computers and not others. I
>> convinced the problem lies with either the way the SQL Server is set up or
>> something on the client computers is missing.
>>
>> If anyone has any suggestions on what to try PLEASE let me know because
>this
>> is utter madness.
>>
>>
>

Jan Hyde (VB MVP) 

-- 
A friend of mine just had her 11th baby. Everyone says she's overbearing
(Megan Waves) 
[Abolish the TV License - http://www.tvlicensing.biz/]

Relevant Pages

  • Re: ODBC Timeout problems but very hard to pin down
    ... APP 1: Access 2000 database ... I ran SQL Profiler to capture the ... validated by SQL Server. ... As it happens, the default display contains ...
    (microsoft.public.dotnet.framework.aspnet)
  • MSHFlexgrid not displaying data from ADO data control
    ... if I put it onto a clients machine none of the ... MSHflexgrids display any data. ... The MSHflexgrids data sources are ADO data controls which are ... The SQL Server uses windows network authentication to allow access and I ...
    (microsoft.public.vb.general.discussion)
  • Re: MSHFlexgrid not displaying data from ADO data control
    ... > MSHflexgrids display any data. ... > The MSHflexgrids data sources are ADO data controls which are ... > programmatically assigned a connection string to an SQL 7 Server through ... > The SQL Server uses windows network authentication to allow access and I ...
    (microsoft.public.vb.general.discussion)
  • Re: strategies for paging
    ... tiered architecture is that display is done in the front end and never ... This is a more basic programming principle than just ... SQL and RDBMS. ... Do you not think it makes more resource sense to select just the page of results you need and pass that back from the SQL Server instead? ...
    (comp.databases.ms-sqlserver)
  • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
    ... I moved every table I was able to move to the SQL ... closed connections - but all of these errors are in the version which used ... the SQL Server 2000 and everything worked ... communication between ODBC (OLEDB and Native Client, ...
    (microsoft.public.sqlserver.connect)
Loading