Larry,
It is a System DSN, I can open it from the VFP command window. The Access, Foxpro, Oracle and SQL Server DSN all have the same tables and table structures. In the ASP page, I change the DSN only. It works for all except the SQL Server DSN.
I can display the SQL data by directly opening the DSN thru ADO in the ASP page, but the COM object will not open it.

Thanks

Abdul Ahad Khan
www.csi-pro.com

>Is the DSN entry a system entry or a user entry? For the ASP user to have access to it, it needs to be a system entry.
>
>HTH.
>
>>Hi All,
>>I have developed a COM object in VFP 6 which takes three arguments from an
>>ASP page and can display a table's record in a Table on a web page. Clicking
>>on any record's primary key brings up a new page where that record may be
>>edited and then saved.
>>
>>This COM object works perfectly with Access, Oracle or FoxPro backend
>>databases (DSN). With SQL Server 6.5 or 7, it will not open the DSN. I use
>>SQLCONNECT to open the connection.
>>Using this COM object in VFP with SQL Server backend has no problem, but in
>>an ASP web page, it will just not open the DSN.
>>
>>Anybody know whats happening?
>>
>>TIA
>>
>>Abdul Ahad
>>www.csi-pro.com