Solved

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

Posted on 2010-11-30
10
390 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_
  • 5
  • 5
10 Comments
 
LVL 28

Expert Comment

by:sammySeltzer
Comment Utility
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_
Comment Utility
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_
Comment Utility
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
 
LVL 28

Expert Comment

by:sammySeltzer
Comment Utility
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 28

Assisted Solution

by:sammySeltzer
sammySeltzer earned 500 total points
Comment Utility
Check this thread out.

Are you still using Access 2003?

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

0
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 
LVL 6

Author Comment

by:ob1_
Comment Utility
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_
Comment Utility
ok thanks i will check out the thread and let you know.
0
 
LVL 28

Accepted Solution

by:
sammySeltzer earned 500 total points
Comment Utility
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_
Comment Utility
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 28

Expert Comment

by:sammySeltzer
Comment Utility
Grea, congrats.

Thanks a lot for the points and grade.

--sammy
0

Featured Post

Wish Marketing would stop bothering you?

Is your marketing department constantly asking for new email signature updates? Are they requesting a different design for every department? Do they need yet another banner added? Don’t let it get you down! There is an easy way to manage all of these requests...

Join & Write a Comment

Prologue It is often required to host multiple websites on a single instance of IIS, mostly in development environments instead of on production servers. I am sure it is not much a preferred solution on production servers but this is at least a pos…
If you don't have the right permissions set for your WordPress location in IIS, you won't be able to perform automatic updates. Here's how to fix the problem.
This tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…

763 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now