Sorry for the 2 last messages... I had problems with my keyboard !!
I'm connecting a Microsoft SQL server using the following syntax:
ChaineConnection = "driver={SQL Server}; SERVER=SERVEUR2000\SQL_SERVER; DATABASE=silo"
oConnection=CREATEOBJECT("ADODB.Connection")
WITH oConnection
.CommandTimeout = 60
.ConnectionTimeout = 30
.ConnectionString = ChaineConnection
.CursorLocation = 3 && Curseur Cote Client
.Mode = 3 && Mode Lecture Ecriture
ENDWITH
oConnection.Open(,,, 16) && Connection Asynchrone
DO WHILE oConnection.State = 2 && En Connection
WAIT WINDOW NOWAIT "EN COURS DE CONNECTION"
ENDDO
WAIT CLEAR
after that, I create a recordset using the following syntax :
recordset = oConnection.execute("SELECT * FROM Client")
Now I would like to know how to use the grid that comes with VFP with that !
Thanks in advance...