Search found 2 matches

INSERT INTO messages (user,pin,message,carrier,date_time_requested,frm,sent,error,ascii_file,mail_file,lock,scheduled,station,transaction) VALUES ('MRHappy','','Woof! Test SMS sent from PRIME','OPTUS','" & Now & "', 'Administrator',0,0,'','',0,0,10,51)

Msgs are stuck in pending when I use this script but they work fine with GuiClient

Am I missing something? Version 6.0.0.16
Set conn = CreateObject("ADODB.Connection")
conn.open "PageGate" '"Driver={SQL Server};Database=BlaBla;server=SuperBla;Connect Timeout=10;User Id=tx;Password=passwd;"
sql="INSERT INTO messages (user,pin,message,carrier,date_time_requested,frm,sent,error,ascii_file,mail_file,lock,scheduled,station,transaction) "
sql=sql + "VALUES ('MRHappy','','Woof! Test SMS sent from PRIME','OPTUS','" & Now & "', 'Administrator',0,0,'','',0,0,10,51)"
on error resume next

Author	Message
Topic: Stuck in Pending
tackland Replies: 3 Views: 12481	Forum: PageGate Support Posted: Sun Dec 15, 2013 9:41 pm Subject: Stuck in Pending
tackland Replies: 3 Views: 12481	INSERT INTO messages (user,pin,message,carrier,date_time_requested,frm,sent,error,ascii_file,mail_file,lock,scheduled,station,transaction) VALUES ('MRHappy','','Woof! Test SMS sent from PRIME','OPTUS','" & Now & "', 'Administrator',0,0,'','',0,0,10,51)
Topic: Stuck in Pending
tackland Replies: 3 Views: 12481	Forum: PageGate Support Posted: Sat Dec 14, 2013 7:25 am Subject: Stuck in Pending
tackland Replies: 3 Views: 12481	Msgs are stuck in pending when I use this script but they work fine with GuiClient Am I missing something? Version 6.0.0.16 Set conn = CreateObject("ADODB.Connection") conn.open "PageGate" '"Driver={SQL Server};Database=BlaBla;server=SuperBla;Connect Timeout=10;User Id=tx;Password=passwd;" sql="INSERT INTO messages (user,pin,message,carrier,date_time_requested,frm,sent,error,ascii_file,mail_file,lock,scheduled,station,transaction) " sql=sql + "VALUES ('MRHappy','','Woof! Test SMS sent from PRIME','OPTUS','" & Now & "', 'Administrator',0,0,'','',0,0,10,51)" on error resume next