What authentication method dsnAccounts DSN specifies (WIndows or Sql Server)?
>Hi All,
>
>I have created a COM DLL in VFP6. it connects to SQL Server 2000 thru the
>following lines
>
> nH = SQLCONNECT('dsnAccounts')
> if nH = -1
> return "Sorry could not connect"
> endif
>
>After compiling it and invoking it thru VFP or VB, it works perfectly. But
>when I invoke it thru ASP, it does not connect to SQL server.
>
>The connection handle returns -1 i.e. nH = -1
>
>Why?
>
>my ASP code is
>
>set obj = server.createobject("cross.Accounts")
>cRet = obj.myReport
>response.write(cRet)
>
>it never connects in ASP
>
>Please help
>
>TIA
>
>Abdul Ahad Khan
--sb--