?
Solved

Classic ASP - SQL Server connection problem Part 2!

Posted on 2016-08-01
3
Medium Priority
?
75 Views
Last Modified: 2016-08-03
This was fixed by an earlier question, but that only fixed a problem with SELECT statement.

My hosting company has migrated my site to a new server with MSSQL 2012. Since then the attached code does not work.

I get this error:
Microsoft OLE DB Provider for SQL Server error '80040e4d'

Invalid authorization specification

/database/add_visit.asp, line 214

This is my connection string:
conn.ConnectionString = "provider=sqloledb;uid=#######;pwd=#######;connection timeout=620;database=###SQL;DataTypeCompatibility=80"

It only produces the error when I try to INSERT a record
0
Comment
Question by:rick_danger
[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
3 Comments
 
LVL 33

Accepted Solution

by:
Big Monty earned 1000 total points
ID: 41737880
chances are the user you're using in your connection string does have INSERT access to the table you're trying to write to
0
 
LVL 84

Assisted Solution

by:Dave Baldwin
Dave Baldwin earned 1000 total points
ID: 41737882
I agree with Big Monty.  In MS SQL, you can set permissions (or block them) on just about every individual function.  Sounds like maybe they have given you Read only access.
0
 

Author Closing Comment

by:rick_danger
ID: 41740724
Thanks for your comments
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

764 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