Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
COM Object not Connecting in ASP
Message
 
 
To
12/06/2003 08:32:15
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00799297
Message ID:
00799327
Views:
21
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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform