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
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao