Solved

Classic ASP - SQL Server connection problem Part 2!

Posted on 2016-08-01
3
52 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
3 Comments
 
LVL 32

Accepted Solution

by:
Big Monty earned 250 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 83

Assisted Solution

by:Dave Baldwin
Dave Baldwin earned 250 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Leverage browser caching 2 55
An ASP query I cannot work out... 2 46
How to get statistic's from a competitors website?! 1 86
is this a cms? 8 34
I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:  The Exchange of information …
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

912 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

20 Experts available now in Live!

Get 1:1 Help Now