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