DID you grant your user the ability to INSERT into the MSSQL db? I have asterisk inserting easily Just a privileges issue Regards
-----Original Message----- From: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of Neeraj Chand Sent: Sunday, September 26, 2010 9:09 PM To: asterisk-users@lists.digium.com Subject: Re: [asterisk-users] Asterisk ODBC Insert issue Hi guys, Having issues with doing an insert statement using ast 1.4.24: [START] dsn=mssql-asterisk write=INSERT INTO testdb (callarrival,callerid) VALUES ('${VAL1}','${VAL2}') SET(ODBC_START()${TIMESTAMP},${CALLERID(num)}) No errors pop up on execute, but nothing gets inserted. Read and update work fine, Wondering where I'm going off track with this, Thanks, -- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users -- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users