DerekT
2008-09-16 08:48:43 UTC
Hi Folks,
I have been asked to work on an old program in VB6 and convert its database
from Access to SQL Server. It uses a Data control and a data bound grid.
I have changed the Data control to access the SQL Server data source via
ODBC and I can confirm that it works by stepping through the data and
showing it in text boxes. Problem is that the DBGrid is now not showing the
bound data.
I have tried setting its data source to Data1, I have tried Data1.Recordset
but nothing I do will make it show data. However when Date used to be using
Jet on an Access database the grid showed data just fine.
Any ideas?
Many thanks,
Derek
I have been asked to work on an old program in VB6 and convert its database
from Access to SQL Server. It uses a Data control and a data bound grid.
I have changed the Data control to access the SQL Server data source via
ODBC and I can confirm that it works by stepping through the data and
showing it in text boxes. Problem is that the DBGrid is now not showing the
bound data.
I have tried setting its data source to Data1, I have tried Data1.Recordset
but nothing I do will make it show data. However when Date used to be using
Jet on an Access database the grid showed data just fine.
Any ideas?
Many thanks,
Derek