I am creating a VFP COM server whose main task will be to access a Firebird database.

I have created an ODBC data source to the Firebird database using a Firebird ODBC driver.

Both the client, the COM server, and the database are on the same computer.

When I use the following statement in the VFP COM server:

CREATE SQL VIEW vPatients CONNECTION odbcdsname ;
	AS SELECT PATIENTS.PatientNo, PATIENTS.NAME, PATIENTS.PatientID ;
	FROM Patients PATIENTS ;
	ORDER BY PATIENTS.NAME

I get an OLE IDispatch error #1570 saying that the database is read-only, and the view does not get created.

However, if I issue the same statement in a command window, it works; I get the view.

Thanks in advance for your help.
Jim