Classic ASP - SQL Server connection problem Part 2!

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
rick_dangerAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Big MontyConnect With a Mentor Senior Web Developer / CEO of ExchangeTree.org Commented:
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
 
Dave BaldwinConnect With a Mentor Fixer of ProblemsCommented:
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
 
rick_dangerAuthor Commented:
Thanks for your comments
0
All Courses

From novice to tech pro — start learning today.