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_ebbyloc.php on line 23

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

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

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

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

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

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

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

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

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

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

Warning: odbc_close() expects parameter 1 to be resource, boolean given in C:\webroot\erpcommon\ajax_ebbyloc.php on line 122
[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 from .dbo.ebloc ts where ts.itemid= and ts.locationid= 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 h.date >= '0-1-01' and l.itemid= and ((h.locationid=) or (h.clocationid=)) [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) 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 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 where h.locationid= [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) select h.date,rtrim(d.no)+'-'+rtrim(h.no),h.supplierid,t.sign*-1,l.qty,null,l.delwhen,'RLI',l.id,h.locationid,l.addby,l.addwhen,l.delby,l.perunit,l.trndisc 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 where h.clocationid=;