No updates, deletes or inserts are allowed in SQLPrepare

[Kendel]

I'm trying to insert a record to a db and I got this error.

Set con = Server.CreateObject("ADODB.Connection")
con.Open "DSN=MyDB;uid=myuid;pwd=mypwd"
con.Execute("insert into myTable values (...,...,blab,blab)")

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[CA][ODBC CA-Datacom/DB Driver] No updates, deletes or inserts are allowed in SQLPrepare

The Select statement works just fine. Does anyone know what the problem is? Thanks.

 

[DotNetGnat]

Make sure you have write permissions on the database...

-DNG

 

[Kendel]

No, it's not the permission issue. I'm switching from EDBC to ODBC driver using the same DB. Didn't have any problem with EDBC.

P.S. It's good to see you are still in this forum. It's been a long time.

 

[foxbox]

i think it has to do with your connection string.
try adding "Initial Catalog=<yourdatabase>"
and fiddle with "integrated security="

 

[Kendel]

Like this:

"Initial Catalog=<myDB>;DSN=myDSN;uid=myUid;pwd=myPwd;integrated security="

 

[foxbox]

integrated security=SSPI;

i never ever saw that SQLPrepare error so i'm just guessing here. I do not know "CA-Datacom/DB". Is it possible to login as "myuid" via DSN=MyDB and fire
("insert into myTable values (...,...,blab,blab)") ?

In DBMS systems like Oracle and MSSQL it is possible to define permissions (SELECT, INSERT, UPDATE, etc) on table level.

So check the permissions of myUid on the database side.
If that looks good, then the connection string maybe the problem.

Maybe this URL is helpfull:
[link]

http://www.connectionstrings.com/

[/url]