Warning: odbc_connect(): SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in C:\webroot\erpcommon\ajax_eball.php on line 22

Warning: odbc_exec() expects parameter 1 to be resource, boolean given in C:\webroot\erpcommon\ajax_eball.php on line 32

Warning: odbc_exec() expects parameter 1 to be resource, boolean given in C:\webroot\erpcommon\ajax_eball.php on line 40

Warning: odbc_result() expects parameter 1 to be resource, null given in C:\webroot\erpcommon\ajax_eball.php on line 41

Warning: odbc_exec() expects parameter 1 to be resource, boolean given in C:\webroot\erpcommon\ajax_eball.php on line 56

Warning: odbc_result() expects parameter 1 to be resource, null given in C:\webroot\erpcommon\ajax_eball.php on line 62

Warning: odbc_result() expects parameter 1 to be resource, null given in C:\webroot\erpcommon\ajax_eball.php on line 63

Warning: odbc_result() expects parameter 1 to be resource, null given in C:\webroot\erpcommon\ajax_eball.php on line 65

Warning: odbc_exec() expects parameter 1 to be resource, boolean given in C:\webroot\erpcommon\ajax_eball.php on line 70

Warning: odbc_exec() expects parameter 1 to be resource, boolean given in C:\webroot\erpcommon\ajax_eball.php on line 78

Warning: odbc_exec() expects parameter 1 to be resource, boolean given in C:\webroot\erpcommon\ajax_eball.php on line 106

Warning: odbc_close() expects parameter 1 to be resource, boolean given in C:\webroot\erpcommon\ajax_eball.php on line 112
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified delete [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified select ts.itemid as itemid,ts.qty,ts.value from .dbo.eball ts where ts.itemid= and ts.speriodid= '' [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified insert #tline (trnlid) select l.id from .dbo.trnl l left join .dbo.trnh h on h.id = l.trnhid left join .dbo.document d on d.id = h.documentid left join .dbo.trntype t on t.id = d.trntypeid where l.itemid= and h.date >= '0-1-01' and t.no <> 'ILO' and l.delby is null [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified insert (date,documentno,supplierid,sign,qty,refno,delwhen,trntype,lineid,locationid,addby,addwhen,delby,perunit,discount,trnvalue) select h.date,rtrim(d.no)+'-'+rtrim(h.no),h.supplierid,t.sign,l.qty,case when h.supplierid is null then convert(varchar(250),h.remark) else h.refdocno end,l.delwhen,t.no,l.id,h.clocationid,l.addby,l.addwhen,l.delby,l.perunit,l.trndisc,l.trnvalue from #tline tp left join .dbo.trnl l on l.id = tp.trnlid left join .dbo.trnh h on h.id = l.trnhid left join .dbo.document d on d.id = h.documentid left join .dbo.trntype t on t.id = d.trntypeid