ASP pgm runs on local server, but it crashes remotely

Asked By noellepineda 0 points N/A Posted on - 02/12/2012

Hello,

I am running an ASP program on server, but it is having problems when running statement.

“Set oRecordset = oConnection.Execute(strQuery)".

This happens when I try to run it using IE 7 on my desktop.

I can run it successfully from http://localhost/, but it fails on http://testserver:80/. I don't know the reason for it. The code is for both of them is the same. See below:

Set oConnection = CreateObject("ADODB.Connection")

Set oRecordset = CreateObject("ADODB.Recordset")

oConnection.Provider = "ADsDSOObject" 'The ADSI OLE-DB provider

oConnection.Open "Active Directory Provider"

strQuery = "<LDAP://DC=gpo,DC=gov>;(&(objectClass=*)(cn=*" & strUID &"*)

(!(userAccountControl:1.2.840.113556.1.4.803:=2)));

ADsPath,physicalDeliveryOfficeName,company,department,title,sn,cn,name,givenname,mail,mailNickname,

telephoneNumber,OtherTelephone,extensionAttribute1,extensionAttribute2,extensionAttribute3,

extensionAttribute4;subtree"

Set oRecordset = oConnection.Execute(strQuery)

I wish I could get any help from someone. Thanks in advance.

• Status: Open
• Question Views: 1562
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Programming

Answered By Iamexpert 0 points N/A #96363

ASP pgm runs on local server, but it crashes remotely

 

Hi

 

The problem you are discussing is with your MySQL database due to which your program crashes due to which you are facing this problem. 

 

You need to check the database version you are using as a server of MySQL is fine with the server you are using or not. This is one of the big problem with MySQL check whether the MySQL database is compatible with the server version.

 

Like if you are using asp then it should compatible with the asp version you are using otherwise you need to check which version of MySQL database is useful for the asp version you are using.

 

This is how you can solve this problem and you will able to solve this problem if you trying and check as the problem with your asp programming is not basically with the code.

 

It is basically with your server or your database and you should have to check is your code feeling comfortable with your database and also with the server. Hope this solution will help you getting out of this problem.

About Iamexpert

Questions
0

Answers
195

Best Answers
34

• Vote Up 0 Vote Down

• Posted on - 02/13/2012
• Question Category: MS Programming