>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

In the code above can you first create a temp database to hold views only ?