Hi!
Please somebody help me!!!
I have a VB Activex user control that's called from an ASP on a production
server using a client, I use a RDS connection to a SQLServer DB from a VB
6.0 program.
I have the following code :
strServer = "http://server
ip"
Set ADS = CreateObject("RDS.DataSpace")
Set oCN = ADS.CreateObject("RDSServer.DataFactory", strServer)
Set oRS = oCN.Query(DSNServidor, Query)
Last week the control (.ocx) was working ok, but today fails to connect to
the DB and the VB err object sent me the following message : "Internet
Server Error".
I have been looking for this error in the Internet and the solution to
this is to configure IIS and MSADC, I followed all the steps to do so but
the problem persists (on three environments: develop, test and production
server).
* I tested the MSADC with the ADCTEST.ASP example and it works ok on a
localhost,
* I configured the MSDFMAP.INI file
* etc
The develop server has installed IIS 5.0 and SQLServer 7 (both running on
the server) and works ok. When I execute the Activex Control on Visual
Studio (and debug it) the connection works ok but when I access to Web
application and the ASP calls the Control Activex that's send me the
message : "Internet Server Error".
This is same to de test server (Both the IIS and SQLServer are running on
the same server) and the error is equal.
The production server has the IIS 5.0 installed but the SQLServer DB is on
another server and the message is equal
I donīt known what is the problem, the RDS has been configurated
propertly, but the error persists...
Please help me, thank you
**********************************************************************
Sent via Fuzzy Software @[EMAIL PROTECTED]
http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP &
ASP.NET resources...
|
