473,472 Members | 2,145 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

IIS6, ActiveX, and database access

I'm migrating a legacy intranet site from an IIS5 to IIS6 server. The
site uses ActiveX DLLs to access a SQL database. The problem is that
everything runs fine when hitting localhost from the server, but the
database access appears not to work.

Each page gets the Windows logon name and converts it to an ID:

-----
set obj = server.CreateObject("TN.CClassName")

strUserName = Request.ServerVariables("LOGON_USER")
lngUserID = Session("UserID")

if lngUserID = "" or lngUserID = 0 then

lngUserID = obj.GetUserID(strUserName)
Session("UserID") = lngUserID

if lngUserID = 0 then
Response.Redirect "Errors/UnknownUser.asp?User=" & strUserName
end if

end if
-----

Since a remote request always winds up on the UnknownUser page, I'm
assuming that the DLL is fine but can't get to the database (since the
CreateObject call didn't fail, and since all is well from localhost).

It's obviously a permissions issue, but where?

Thanks,
David
Aug 23 '06 #1
0 1050

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: Newbie | last post by:
Hi all, I have some activeX code that I use to get the local computer name. (I don't think this is possible using ASP from my research). The rest of my code is ASP. I'd like to know how to...
0
by: inoculator | last post by:
Hi all, somehow I'm going nuts with this authentications inside IIS6, but from the beginning: We have a W2k3 Server running IIS6 with an application running as NetworkService. The...
4
by: rufus | last post by:
Hi, On the project I am working on we need to encapsulate all data and business logic in an activex dll. My question is: How do I do this? How can I access the form objects ie text boxes,...
2
by: postings | last post by:
Hi I was under the mistaken impression that Application variables could be shared by websites running under the same IIS process. Looking at the documentation this isn't true. So what is the...
14
by: Mark B | last post by:
Our webhost (www.usbusinessweb.net) had a W2K IIS5 server crash after a scheduled hard-boot occurred during a ms-security patch install overnight. They couldn't get the server working again so they...
1
by: RedStain | last post by:
CONTENTS summary setup error messages compensation attempts comment SUMMARY I have an IIS6.0 server which has recently been upgraded to ASP 2.0 as a result of some of the patch requirements...
5
by: Jaime Palli | last post by:
I have developed a Visual Basic 6.0 ActiveX DLL to help to interact with some ASP pages. I have copied the compiled DLL in C:\INETPUB\WWWROOT in my XP Pro machine. After making some configuracion...
3
by: tuvman | last post by:
We are developing a web application. Our web app is a heavy client- our existing .net app exposed as an activex control running in IE. We need the activex to be able to access our remote database...
0
by: Vincent | last post by:
We have used Crystal Report Web Viewer on ASP pages (using ActiveX), and it works perfectly on Windows 2000 machine with IIS 5 and SQL 2K. Now we already migrated the applications to Windows Server...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
1
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.