Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CGI SQL queries fail after upgrade

Status
Not open for further replies.
mrnoisy

mrnoisy

Programmer
Mar 1, 2003
78
AU
I have created a CGI script using perl(Win32::ODBC) to view/add/update a MSAccess database. Since upgrading the web server to a Windows 2003 server, my SQL query to insert a record is failing with an error saying 'Operation must use an updateable query'. If you run the same query from command line it works fine.

I have 2 web server services running on this server. The primary is IIS running SSL and the other is Apache without SSL. The script works fine under apache but not IIS.
 
Status
Not open for further replies.

Similar threads

c0deM0nK424
  • Locked
  • Question
Re-Directing BACK to Company Website after Company Youtube Video Finishes - can it be done ? 3
Replies
3
Views
157
SamBones
SamBones
Orgios
  • Locked
  • Question
Web access for my Customers to my sql server?
Replies
3
Views
88
jpadie
jpadie
lifesupport
  • Locked
  • Question
Web design with Access front end and SQL back end 1
Replies
1
Views
31
johnwm
johnwm
1gbram
  • Locked
  • Question
File upload, but no cgi, php ect.
Replies
5
Views
52
1gbram
1gbram
kjv1611
  • Locked
  • Question
Backup Copy of Website on Different Server? FailOver? 3
Replies
5
Views
75
kjv1611
kjv1611

Part and Inventory Search

Sponsor

Back
Top