VB Forum / General / July 2004

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.