?
Solved

Login script for ASP on IIS7/Server 2008 64-bit?

Posted on 2010-11-30
10
Medium Priority
?
396 Views
Last Modified: 2012-05-10
I have a web page that is guarded with a simple login script. the username and login are stored in an access database of the server, and the script calls this through a DSN mapping. This worked great in Windows Server 2003 but I can't get it to work on 2008 64-bit even though I finally figured out how to run ODBC manager in 32-bit mode to add the access databse as a system DSN.

the script has a few different files to it. i have attached the file below that access the DSN and errors out.

Does anyone have a simple script that can do this on server 2008 64-bit?


thanks,
bobby
<%
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = "DSN=tmlogindb" 
objConn.Open


' to prevent SQL and XSS Injection against your database and your site
' updated: January, 7th 2010
Function ProtectSQL(SQLString)
SQLString = Replace(SQLString, "'", "''") ' replace single Quotes with Double Quotes
SQLString = Replace(SQLString, ">", "&gt;") ' replace > with &gt;
SQLString = Replace(SQLString, "<", "&lt;") ' replace < with &lt;
SQLString = Replace(SQLString, "(","&#40;") ' replace ( with &#40;
SQLString = Replace(SQLString, ")","&#41;") ' replace ) with &#41;
SQLString = Trim(SQLString)
ProtectSQL = SQLString
End Function
%>

Open in new window

0
Comment
Question by:ob1_
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 5
10 Comments
 
LVL 29

Expert Comment

by:sammySeltzer
ID: 34238763
Try something much simpler and get same result:

Function SQLTextV(val)
    SQLTextV = "'" & Replace(val,"'","''") & "'"
End Function

Open in new window


To use it,

Assuming you are updating a record or something:

Then

sql="Update your table " & _
"set & myfieldName=" & SQLTextV(myfieldName)  " & _
etc

You don't say exactly what error you are getting though
0
 
LVL 6

Author Comment

by:ob1_
ID: 34239208
oh hmm that is a good question. it was a pre-packaged login script that someone else wrote so i am not sure how it exactly works. I will try updating the code and see if that helps. here is the error I am getting:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

/downloads/adocon.asp, line 4
0
 
LVL 6

Author Comment

by:ob1_
ID: 34239500
i still get the same error. i had to run the exe in the file system for the 32-bit versio of ODBC manager since the one in control panel would not give me the option to add an access data source. could this be the problem?
0
Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

 
LVL 29

Expert Comment

by:sammySeltzer
ID: 34240028
yes, if your system is 64bit version, then you would need to run 64bit exe.

Someone had similar problem yesterday.

I will look for the info I sent to him. I don't know if it worked for him though since I don't think I got any feedback.
0
 
LVL 29

Assisted Solution

by:sammySeltzer
sammySeltzer earned 2000 total points
ID: 34240041
Check this thread out.

Are you still using Access 2003?

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_26644964.html

0
 
LVL 6

Author Comment

by:ob1_
ID: 34240049
the only problem is that the ms access driver does not seem to be available in the 64 bit version. i have googled far and wide for that fix and it does not seem to be available. perhaps i have missed something.
0
 
LVL 6

Author Comment

by:ob1_
ID: 34240073
ok thanks i will check out the thread and let you know.
0
 
LVL 29

Accepted Solution

by:
sammySeltzer earned 2000 total points
ID: 34241938
Another thing you could try is to enable 32bit aplication to True.

This way, even though you are running 64bit version, it will allow you to run your on 32bit mode.

See this link on how to do it:
http://stackoverflow.com/questions/637326/how-to-guide-for-getting-a-classic-asp-application-working-under-iis-7-0

0
 
LVL 6

Author Closing Comment

by:ob1_
ID: 34395446
that was it thank -  i had to create a new app pool and force into 32 bit mode so i could use the 32 bit version of the drivers.

through the other link i found information for downloading 64 bit versions of the access drivers through Office 2010 - this also would have bit an option except there is an app on the server incompatible with Office 2010 64 bit.

thanks for the help!!!!!
0
 
LVL 29

Expert Comment

by:sammySeltzer
ID: 34396870
Grea, congrats.

Thanks a lot for the points and grade.

--sammy
0

Featured Post

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A procedure for exporting installed hotfix details of remote computers using powershell
After seeing many questions for JRNL_WRAP_ERROR for replication failure, I thought it would be useful to write this article.
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Suggested Courses

800 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question