Hi Oscar,

Maybe you have different versions of MDAC or VFP OLE DB provider installed on those PC's? I would also try to use ADO Command object to execute commands.

oCom = CREATEOBJECT("adodb.command")
oCom.ActiveConnection = oCon
oCom.CommandType = 1 	&& adCmdText
oCom.CommandText = "insert into shippers (company_name) values ('New Company')"

>Hi Sergey
>
>Once again thanks a lot for your reply. I surely found a lot of valuable information which will make my life easier.
>
>In my case I’m issuing and insert-SQL or delete-SQL statement through the Execute of the connection like state on message # 618251.
>
>Trying this with the Tastrade database:
>
>Set Conn = server.createObject("ADODB.Connection")
>conn.provider="vfpoledb.1"
>Conn.Open("dsn=TasTrade")
>SQL = "insert into shippers (company_name) values ('New Company')"
>Conn.Execute(SQL)
>Conn.Close
>
>What is very strange is that this very same code works perfectly on a Notebook with Windows XP Pro, but shows the error when tried at a PC with W2000.
>
>I made a very exhaustive revision for the connection variables and all of them contain the same values, then a I assume that it has nothing to do with the connection.
>
>What could it be that makes the ADO insert-SQL work only one machine?
>
>Oscar
>