>>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 ?

I have included an empty database in the COM server, and opened it just before the create sql view statement. I neglected to mention that in my original post.

Thanks,
Jim