Re: MSHFlexgrid not displaying data from ADO data control
From: Nick (nick.glenisterNO_at_SPAMkeypublishing.com)
Date: 07/30/04
- Next message: Marco Krechting: "using different screen resolutions in VB"
- Previous message: NickHK: "Re: Increasing GDI Object Limits"
- In reply to: Nick: "MSHFlexgrid not displaying data from ADO data control"
- Next in thread: Jan Hyde: "Re: MSHFlexgrid not displaying data from ADO data control"
- Reply: Jan Hyde: "Re: MSHFlexgrid not displaying data from ADO data control"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 30 Jul 2004 12:32:05 +0100
Hi,
For any who are interested i've sorted the problem now thanks
"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.
>
>
- Next message: Marco Krechting: "using different screen resolutions in VB"
- Previous message: NickHK: "Re: Increasing GDI Object Limits"
- In reply to: Nick: "MSHFlexgrid not displaying data from ADO data control"
- Next in thread: Jan Hyde: "Re: MSHFlexgrid not displaying data from ADO data control"
- Reply: Jan Hyde: "Re: MSHFlexgrid not displaying data from ADO data control"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
