'Select error: SQLSTATE = 37000 [Microsoft][ODBC SQL Server Driver]Syntax

This is a cross post. Sorry, but I realized that this is most likely a
PowerBuilder issue.

EAS 3.61 C2 with PB 7.03 components, datawindows and nvo's.  Powerdynamo
3.5.2. ODBC connection cache that works.

This is an application port from a NT 4.0 server to a Window 2000 Server.

The whole application works fine, through CORBA and 7 NVO's  with at least
20 other datawindows that I have tested.

The  ONLY offending datawindow causing

'Select error: SQLSTATE = 37000 [Microsoft][ODBC SQL Server Driver]Syntax
error or access violation '

 is called from a browser
****************************************************************************
*********
  dwBrowse = createObject("rtlweb/CollectionHTMLDW");
  dwBrowse.setdwobject("", "d_specimen_browse");
  dwBrowse.of_setpagehdr();
  dwBrowse.setpagesize(i_page_size) ;
  dwBrowse.setcolumnlink("identification", "SpecimenZoom.htm","specimen_id =
'specimen_id'|status_code='string(status_code)'", "");
  dwBrowse.setcolumnlink("external_specimen_id",
"SpecimenZoom.htm","specimen_id =
'specimen_id'|status_code='string(status_code)'", "");
  dwBrowse.setweight(false, false, true, true, false) ;
  agency_group_id = psSession.GetValue("agency_group_id");
  htmlDW_str = dwBrowse.onetripex("BrowseDW", agency_group_id,
GetBrowserName(), GetSelfLink(), "", GetPageAction("BrowseDW"),
GetPageContext("BrowseDW"));
  writeData(htmlDW_str);
****************************************************************************
*********

Following the asterisks below is the offending datawindow in its entirety.
(Sorry) The select statement follows the datawindow code.


Thanks,
_Greg Hazzard

****************************************************************************
*********
$PBExportHeader$d_specimen_browse.srd
release 7;
datawindow(units=0 timer_interval=0 color=16777215 processing=0 HTMLDW=yes
print.documentname="" print.orientation = 0 print.margin.left = 110
print.margin.right = 110 print.margin.top = 96 print.margin.bottom = 96
print.paper.source = 0 print.paper.size = 0 print.prompt=no print.buttons=no
print.preview.buttons=no )
header(height=208 color="536870912" )
summary(height=0 color="536870912" )
footer(height=0 color="536870912" )
detail(height=72 color="536870912" )
table(column=(type=char(16) update=yes updatewhereclause=yes
name=specimen_id dbname="tbl_specimen.specimen_id" )
 column=(type=char(16) update=yes updatewhereclause=yes name=agency_id
dbname="tbl_specimen.agency_id" )
 column=(type=long update=yes updatewhereclause=yes name=specimen_type
dbname="tbl_specimen.specimen_type" )
 column=(type=char(50) update=yes updatewhereclause=yes name=identification
dbname="tbl_specimen.identification" )
 column=(type=char(40) update=yes updatewhereclause=yes name=tests
dbname="tbl_specimen.tests" )
 column=(type=char(10) update=yes updatewhereclause=yes name=reason_type
dbname="tbl_specimen.reason_type" )
 column=(type=datetime update=yes updatewhereclause=yes name=accession_dttm
dbname="tbl_specimen.accession_dttm" )
 column=(type=long update=yes updatewhereclause=yes name=accession_num
dbname="tbl_specimen.accession_num" )
 column=(type=char(16) update=yes updatewhereclause=yes name=patient_id
dbname="tbl_specimen.patient_id" )
 column=(type=datetime update=yes updatewhereclause=yes name=collected_dttm
dbname="tbl_specimen.collected_dttm" )
 column=(type=datetime update=yes updatewhereclause=yes name=discarded_date
dbname="tbl_specimen.discarded_date" )
 column=(type=long update=yes updatewhereclause=yes name=status_code
dbname="tbl_specimen.status_code" )
 column=(type=char(255) update=yes updatewhereclause=yes
name=specimen_comment dbname="tbl_specimen.specimen_comment" )
 column=(type=decimal(4) update=yes updatewhereclause=yes
name=amount_received dbname="tbl_specimen.amount_received" )
 column=(type=char(25) update=yes updatewhereclause=yes name=collected_by
dbname="tbl_specimen.collected_by" )
 column=(type=char(10) update=yes updatewhereclause=yes name=collected_by_id
dbname="tbl_specimen.collected_by_id" )
 column=(type=char(16) update=yes updatewhereclause=yes
name=external_specimen_id dbname="tbl_specimen.external_specimen_id" )
 column=(type=char(10) update=yes updatewhereclause=yes
name=last_update_userid dbname="tbl_specimen.last_update_userid" )
 column=(type=datetime update=yes updatewhereclause=yes
name=last_update_dttm dbname="tbl_specimen.last_update_dttm" )
 column=(type=char(80) update=yes updatewhereclause=yes
name=external_patient_id dbname="tbl_specimen.external_patient_id" )
 column=(type=char(1) update=yes updatewhereclause=yes
name=confirm_prefix_code dbname="tbl_specimen.confirm_prefix_code" )
 column=(type=long update=yes updatewhereclause=yes name=confirmation_num
dbname="tbl_specimen.confirmation_num" )
 column=(type=datetime update=yes updatewhereclause=yes name=stored_date
dbname="tbl_specimen.stored_date" )
 column=(type=char(255) update=yes updatewhereclause=yes name=report_comment
dbname="tbl_specimen.report_comment" )
 column=(type=datetime update=yes updatewhereclause=yes name=report_dttm
dbname="tbl_specimen.report_dttm" )
 column=(type=datetime update=yes updatewhereclause=yes name=received_dttm
dbname="tbl_specimen.received_dttm" )
 column=(type=long update=yes updatewhereclause=yes name=result_flag
dbname="tbl_specimen.result_flag" )
 column=(type=long update=yes updatewhereclause=yes name=results_status
dbname="tbl_specimen.results_status" )
 column=(type=datetime update=yes updatewhereclause=yes
name=results_load_dttm dbname="tbl_specimen.results_load_dttm" )
 column=(type=datetime update=yes updatewhereclause=yes name=results_load_dt
dbname="tbl_specimen.results_load_dt" )
 column=(type=datetime update=yes updatewhereclause=yes name=collected_dt
dbname="tbl_specimen.collected_dt" )
 column=(type=long update=yes updatewhereclause=yes name=collected_mth
dbname="tbl_specimen.collected_mth" )
 column=(type=long update=yes updatewhereclause=yes name=collected_yr
dbname="tbl_specimen.collected_yr" )
 column=(type=long update=yes updatewhereclause=yes name=agency_code
dbname="tbl_specimen.agency_code" )
 column=(type=long updatewhereclause=yes name=agency_code
dbname="tbl_agency.agency_code" )
 column=(type=char(80) updatewhereclause=yes name=agency_name
dbname="tbl_agency.agency_name" )
 column=(type=char(25) updatewhereclause=yes name=agency_patient_id
dbname="tbl_patient.agency_patient_id" )
 retrieve="PBSELECT( VERSION(400) TABLE(NAME=~"tbl_specimen~" )
TABLE(NAME=~"tbl_agency~" )  TABLE(NAME=~"tbl_patient~" )
TABLE(NAME=~"tbl_agency_group_member~" )
COLUMN(NAME=~"tbl_specimen.specimen_id~")
COLUMN(NAME=~"tbl_specimen.agency_id~")
COLUMN(NAME=~"tbl_specimen.specimen_type~")
COLUMN(NAME=~"tbl_specimen.identification~")
COLUMN(NAME=~"tbl_specimen.tests~")
COLUMN(NAME=~"tbl_specimen.reason_type~")
COLUMN(NAME=~"tbl_specimen.accession_dttm~")
COLUMN(NAME=~"tbl_specimen.accession_num~")
COLUMN(NAME=~"tbl_specimen.patient_id~")
COLUMN(NAME=~"tbl_specimen.collected_dttm~")
COLUMN(NAME=~"tbl_specimen.discarded_date~")
COLUMN(NAME=~"tbl_specimen.status_code~")
COLUMN(NAME=~"tbl_specimen.specimen_comment~")
COLUMN(NAME=~"tbl_specimen.amount_received~")
COLUMN(NAME=~"tbl_specimen.collected_by~")
COLUMN(NAME=~"tbl_specimen.collected_by_id~")
COLUMN(NAME=~"tbl_specimen.external_specimen_id~")
COLUMN(NAME=~"tbl_specimen.last_update_userid~")
COLUMN(NAME=~"tbl_specimen.last_update_dttm~")
COLUMN(NAME=~"tbl_specimen.external_patient_id~")
COLUMN(NAME=~"tbl_specimen.confirm_prefix_code~")
COLUMN(NAME=~"tbl_specimen.confirmation_num~")
COLUMN(NAME=~"tbl_specimen.stored_date~")
COLUMN(NAME=~"tbl_specimen.report_comment~")
COLUMN(NAME=~"tbl_specimen.report_dttm~")
COLUMN(NAME=~"tbl_specimen.received_dttm~")
COLUMN(NAME=~"tbl_specimen.result_flag~")
COLUMN(NAME=~"tbl_specimen.results_status~")
COLUMN(NAME=~"tbl_specimen.results_load_dttm~")
COLUMN(NAME=~"tbl_specimen.results_load_dt~")
COLUMN(NAME=~"tbl_specimen.collected_dt~")
COLUMN(NAME=~"tbl_specimen.collected_mth~")
COLUMN(NAME=~"tbl_specimen.collected_yr~")
COLUMN(NAME=~"tbl_specimen.agency_code~")
COLUMN(NAME=~"tbl_agency.agency_code~")
COLUMN(NAME=~"tbl_agency.agency_name~")
COLUMN(NAME=~"tbl_patient.agency_patient_id~")    JOIN
(LEFT=~"tbl_patient.patient_id~"    OP
=~"=~"RIGHT=~"tbl_specimen.patient_id~"    OUTER2
=~"tbl_specimen.patient_id~" )    JOIN (LEFT=~"tbl_agency.agency_id~"    OP
=~"=~"RIGHT=~"tbl_specimen.agency_id~" )    JOIN
(LEFT=~"tbl_agency_group_member.agency_id~"    OP
=~"=~"RIGHT=~"tbl_agency.agency_id~" )WHERE(    EXP1
=~"tbl_agency_group_member.agency_group_id~"   OP =~"=~"    EXP2
=~":as_agency_group_id~"    LOGIC =~"and~" ) WHERE(    EXP1
=~"tbl_specimen.status_code~"   OP =~"in~"    EXP2 =~"(1, 2)~" ) ) ARG(NAME
= ~"as_agency_group_id~" TYPE = string) " arguments=(("as_agency_group_id",
string))  sort="collected_dttm D " )
text(band=header alignment="2" text="Specimen OutBox" border="0"
color="8388608" x="1376" y="12" height="100" width="1070"  name=t_4
font.face="Arial" font.height="-16" font.weight="400"  font.family="2"
font.pitch="2" font.charset="0" background.mode="2"
background.color="16777215" )
compute(band=detail alignment="0" expression="case(  result_flag when 1 then
RGB(255, 0, 0) when 2 then RGB(0,0,0) when 3 then RGB(119, 28, 193) )
"border="0" color="0" x="4133" y="4" height="60" width="82"
format="[GENERAL]"  name=color_code visible="1~t0"  font.face="Arial"
font.height="-8" font.weight="400"  font.family="2" font.pitch="2"
font.charset="0" background.mode="2" background.color="16777215" )
compute(band=detail alignment="0" expression="RGB(128, 0, 100)"border="0"
color="0" x="4325" y="8" height="56" width="82" format="[GENERAL]"
name=unshipped_color visible="1~t0"  font.face="Arial" font.height="-8"
font.weight="400"  font.family="2" font.pitch="2" font.charset="0"
background.mode="2" background.color="16777215" )
compute(band=detail alignment="0" expression="case(  result_flag  when 1
then 700 when 2 then 400 when 3 then 700 )  "border="0" color="0" x="4229"
y="8" height="56" width="82" format="[GENERAL]"  name=weight_code
visible="1~t0"  font.face="Arial" font.height="-8" font.weight="400"
font.family="2" font.pitch="2" font.charset="0" background.mode="2"
background.color="16777215" )
text(band=header alignment="0" text="Identification" border="0"
color="16777215" x="23" y="152" height="52" width="823"
name=identification_t  font.face="MS Sans Serif" font.height="-8"
font.weight="700"  font.family="2" font.pitch="2" font.charset="0"
background.mode="2" background.color="8388608" )
text(band=header alignment="0" text="SID" border="0" color="16777215"
x="859" y="152" height="52" width="311"  name=external_specimen_id_t
font.face="MS Sans Serif" font.height="-8" font.weight="700"
font.family="2" font.pitch="2" font.charset="0" background.mode="2"
background.color="8388608" )
text(band=header alignment="0" text="Agency#" border="0" color="16777215"
x="1184" y="152" height="52" width="261"  name=agency_code_t  font.face="MS
Sans Serif" font.height="-8" font.weight="700"  font.family="2"
font.pitch="2" font.charset="0" background.mode="2"
background.color="8388608" )
column(band=detail id=17 alignment="0" tabsequence=32766 border="0"
color="0~tcase(   status_code when 1 then rgb(0,0,255) when 2 then
rgb(0,0,255)
when -1 then rgb(128,128,128) when -2 then rgb(128,128,128) else
color_code)" x="859" y="4" height="64" width="311" format="[general]"
name=external_specimen_id edit.limit=16 edit.case=any edit.autoselect=yes
edit.autohscroll=yes  font.face="MS Sans Serif" font.height="-8"
font.weight="400~tweight_code"  font.family="2" font.pitch="2"
font.charset="0" background.mode="2" background.color="16777215" )
column(band=detail id=35 alignment="0" tabsequence=32766 border="0"
color="0~tcase(   status_code when 1 then rgb(0,0,255) when 2 then
rgb(0,0,255)
when -1 then rgb(128,128,128) when -2 then rgb(128,128,128) else
color_code)" x="1184" y="4" height="64" width="261" format="[general]"
name=agency_code edit.limit=0 edit.case=any edit.autoselect=yes
font.face="MS Sans Serif" font.height="-8" font.weight="400~tweight_code"
font.family="2" font.pitch="2" font.charset="0" background.mode="2"
background.color="16777215" )
column(band=detail id=4 alignment="0" tabsequence=32766 border="0"
color="0~tcase(   status_code when 1 then rgb(0,0,255) when 2 then
rgb(0,0,255)
when -1 then rgb(128,128,128) when -2 then rgb(128,128,128) else
color_code)" x="23" y="4" height="64" width="823" format="[general]"
html.link="" html.linkargs=""  name=identification edit.limit=50
edit.case=any edit.autoselect=yes edit.autohscroll=yes  font.face="Arial"
font.height="-8~tif (len(identification) > 20, -7, -8)" font.weight="400"
font.family="2" font.pitch="2" font.charset="0" background.mode="2"
background.color="16777215" )
text(band=header alignment="0" text="Tests" border="0" color="16777215"
x="2409" y="152" height="52" width="695"  name=tests_t  font.face="MS Sans
Serif" font.height="-8" font.weight="700"  font.family="2" font.pitch="2"
font.charset="0" background.mode="2" background.color="8388608" )
text(band=header alignment="0" text="Collected Date" border="0"
color="16777215" x="3113" y="152" height="52" width="485"
name=collected_dttm_t  font.face="MS Sans Serif" font.height="-8"
font.weight="700"  font.family="2" font.pitch="2" font.charset="0"
background.mode="2" background.color="8388608" )
text(band=header alignment="0" text="Collected By" border="0"
color="16777215" x="3607" y="152" height="52" width="443"
name=collected_by_t  font.face="MS Sans Serif" font.height="-8"
font.weight="700"  font.family="2" font.pitch="2" font.charset="0"
background.mode="2" background.color="8388608" )
column(band=detail id=5 alignment="0" tabsequence=32766 border="0"
color="0~tcase(   status_code when 1 then rgb(0,0,255) when 2 then
rgb(0,0,255)
when -1 then rgb(128,128,128) when -2 then rgb(128,128,128) else
color_code)" x="2409" y="4" height="64" width="695" format="[general]"
name=tests edit.limit=40 edit.case=any edit.autoselect=yes
edit.autohscroll=yes  font.face="MS Sans Serif" font.height="-8"
font.weight="400~tweight_code"  font.family="2" font.pitch="2"
font.charset="0" background.mode="2" background.color="16777215" )
column(band=detail id=10 alignment="0" tabsequence=32766 border="0"
color="0~tcase(   status_code when 1 then rgb(0,0,255) when 2 then
rgb(0,0,255)
when -1 then rgb(128,128,128) when -2 then rgb(128,128,128) else
color_code)" x="3113" y="4" height="64" width="485" format="[shortdate]
[time]"  name=collected_dttm editmask.mask="mm/dd/yyyy hh:mm"
editmask.focusrectangle=no  font.face="MS Sans Serif" font.height="-8"
font.weight="400"  font.family="2" font.pitch="2" font.charset="0"
background.mode="2" background.color="16777215" )
column(band=detail id=15 alignment="0" tabsequence=32766 border="0"
color="0~tcase(   status_code when 1 then rgb(0,0,255) when 2 then
rgb(0,0,255)
when -1 then rgb(128,128,128) when -2 then rgb(128,128,128) else
color_code)" x="3607" y="4" height="64" width="443" format="[general]"
name=collected_by edit.limit=25 edit.case=any edit.autoselect=yes
edit.autohscroll=yes  font.face="MS Sans Serif" font.height="-8"
font.weight="400"  font.family="2" font.pitch="2" font.charset="0"
background.mode="2" background.color="16777215" )
text(band=header alignment="0" text="Agency Name" border="0"
color="16777215" x="1454" y="152" height="52" width="942"
name=agency_name_t  font.face="MS Sans Serif" font.height="-8"
font.weight="700"  font.family="2" font.pitch="2" font.charset="0"
background.mode="2" background.color="8388608" )
column(band=detail id=36 alignment="0" tabsequence=32766 border="0"
color="0~tcase(   status_code when 1 then rgb(0,0,255) when 2 then
rgb(0,0,255)
when -1 then rgb(128,128,128) when -2 then rgb(128,128,128) else
color_code)" x="1454" y="4" height="64" width="942" format="[general]"
name=agency_name edit.limit=0 edit.case=any edit.autoselect=yes
font.face="MS Sans Serif" font.height="-8" font.weight="400~tweight_code"
font.family="2" font.pitch="2" font.charset="0" background.mode="2"
background.color="16777215" )
htmltable(border="1" )
htmlgen(clientevents="0" clientvalidation="0" clientcomputedfields="0"
clientformatting="0" clientscriptable="0" generatejavascript="0"
pagesize="10" browser="Mozilla/4.0 (compatible; MSIE 5.x;) : Microsoft
Internet Exlorer 5.0" )

****************************************************************************
************
Easier view of  Select Statement
  SELECT tbl_specimen.specimen_id,
         tbl_specimen.agency_id,
         tbl_specimen.specimen_type,
         tbl_specimen.identification,
         tbl_specimen.tests,
         tbl_specimen.reason_type,
         tbl_specimen.accession_dttm,
         tbl_specimen.accession_num,
         tbl_specimen.patient_id,
         tbl_specimen.collected_dttm,
         tbl_specimen.discarded_date,
         tbl_specimen.status_code,
         tbl_specimen.specimen_comment,
         tbl_specimen.amount_received,
         tbl_specimen.collected_by,
         tbl_specimen.collected_by_id,
         tbl_specimen.external_specimen_id,
         tbl_specimen.last_update_userid,
         tbl_specimen.last_update_dttm,
         tbl_specimen.external_patient_id,
         tbl_specimen.confirm_prefix_code,
         tbl_specimen.confirmation_num,
         tbl_specimen.stored_date,
         tbl_specimen.report_comment,
         tbl_specimen.report_dttm,
         tbl_specimen.received_dttm,
         tbl_specimen.result_flag,
         tbl_specimen.results_status,
         tbl_specimen.results_load_dttm,
         tbl_specimen.results_load_dt,
         tbl_specimen.collected_dt,
         tbl_specimen.collected_mth,
         tbl_specimen.collected_yr,
         tbl_specimen.agency_code,
         tbl_agency.agency_code,
         tbl_agency.agency_name,
         tbl_patient.agency_patient_id
    FROM tbl_specimen,
         tbl_agency,
         tbl_patient,
         tbl_agency_group_member
   WHERE ( tbl_patient.patient_id  =* tbl_specimen.patient_id) and
         ( tbl_agency.agency_id = tbl_specimen.agency_id ) and
         ( tbl_agency_group_member.agency_id = tbl_agency.agency_id ) and
         ( ( tbl_agency_group_member.agency_group_id = :as_agency_group_id )
AND
         ( tbl_specimen.status_code in (1, 2) ) )

****************************************************************************
***********

int wxDb::DB_STATUS
DB_ERR_SYNTAX_ERROR_OR_ACCESS_VIOL         // SqlState = '37000'
wxDb
 A wxDb instance is a connection to an ODBC datasource which may be opened,
closed, and re-opened an unlimited number of times.  A database connection
allows function to be performed directly on the datasource, as well as
allowing access to any tables/views defined in the datasource to which the
user has sufficient privileges.







0
Greg
12/12/2001 1:26:10 AM
sybase.easerver.powerbuilder 3902 articles. 0 followers. Follow

2 Replies
948 Views

Similar Articles

[PageSpeed] 5

I would work with the datawindow in a pure PB environment first - I'm
assuming it fails there too?  The ODBC driver is a bit more picky with
syntax than the native driver, and I've seen this error on subselect
and when you use a retrieval argument in a SELECT list, but I'm not
sure where the problem lies in this particular case.  You could try
adding a DBParm of DisableBind=1 for this datawindow retrieval and see
if that works as a potential workaround.

On Tue, 11 Dec 2001 17:26:10 -0800, "Greg Hazzard"
<greg@redwoodtoxicology.com> wrote:

>This is a cross post. Sorry, but I realized that this is most likely a
>PowerBuilder issue.
>
>EAS 3.61 C2 with PB 7.03 components, datawindows and nvo's.  Powerdynamo
>3.5.2. ODBC connection cache that works.
>
>This is an application port from a NT 4.0 server to a Window 2000 Server.
>
>The whole application works fine, through CORBA and 7 NVO's  with at least
>20 other datawindows that I have tested.
>
>The  ONLY offending datawindow causing
>
>'Select error: SQLSTATE = 37000 [Microsoft][ODBC SQL Server Driver]Syntax
>error or access violation '
>
> is called from a browser
>****************************************************************************
>*********
>  dwBrowse = createObject("rtlweb/CollectionHTMLDW");
>  dwBrowse.setdwobject("", "d_specimen_browse");
>  dwBrowse.of_setpagehdr();
>  dwBrowse.setpagesize(i_page_size) ;
>  dwBrowse.setcolumnlink("identification", "SpecimenZoom.htm","specimen_id =
>'specimen_id'|status_code='string(status_code)'", "");
>  dwBrowse.setcolumnlink("external_specimen_id",
>"SpecimenZoom.htm","specimen_id =
>'specimen_id'|status_code='string(status_code)'", "");
>  dwBrowse.setweight(false, false, true, true, false) ;
>  agency_group_id = psSession.GetValue("agency_group_id");
>  htmlDW_str = dwBrowse.onetripex("BrowseDW", agency_group_id,
>GetBrowserName(), GetSelfLink(), "", GetPageAction("BrowseDW"),
>GetPageContext("BrowseDW"));
>  writeData(htmlDW_str);
>****************************************************************************
>*********
>
>Following the asterisks below is the offending datawindow in its entirety.
>(Sorry) The select statement follows the datawindow code.
>
>
>Thanks,
>_Greg Hazzard
>
>****************************************************************************
>*********
>$PBExportHeader$d_specimen_browse.srd
>release 7;
>datawindow(units=0 timer_interval=0 color=16777215 processing=0 HTMLDW=yes
>print.documentname="" print.orientation = 0 print.margin.left = 110
>print.margin.right = 110 print.margin.top = 96 print.margin.bottom = 96
>print.paper.source = 0 print.paper.size = 0 print.prompt=no print.buttons=no
>print.preview.buttons=no )
>header(height=208 color="536870912" )
>summary(height=0 color="536870912" )
>footer(height=0 color="536870912" )
>detail(height=72 color="536870912" )
>table(column=(type=char(16) update=yes updatewhereclause=yes
>name=specimen_id dbname="tbl_specimen.specimen_id" )
> column=(type=char(16) update=yes updatewhereclause=yes name=agency_id
>dbname="tbl_specimen.agency_id" )
> column=(type=long update=yes updatewhereclause=yes name=specimen_type
>dbname="tbl_specimen.specimen_type" )
> column=(type=char(50) update=yes updatewhereclause=yes name=identification
>dbname="tbl_specimen.identification" )
> column=(type=char(40) update=yes updatewhereclause=yes name=tests
>dbname="tbl_specimen.tests" )
> column=(type=char(10) update=yes updatewhereclause=yes name=reason_type
>dbname="tbl_specimen.reason_type" )
> column=(type=datetime update=yes updatewhereclause=yes name=accession_dttm
>dbname="tbl_specimen.accession_dttm" )
> column=(type=long update=yes updatewhereclause=yes name=accession_num
>dbname="tbl_specimen.accession_num" )
> column=(type=char(16) update=yes updatewhereclause=yes name=patient_id
>dbname="tbl_specimen.patient_id" )
> column=(type=datetime update=yes updatewhereclause=yes name=collected_dttm
>dbname="tbl_specimen.collected_dttm" )
> column=(type=datetime update=yes updatewhereclause=yes name=discarded_date
>dbname="tbl_specimen.discarded_date" )
> column=(type=long update=yes updatewhereclause=yes name=status_code
>dbname="tbl_specimen.status_code" )
> column=(type=char(255) update=yes updatewhereclause=yes
>name=specimen_comment dbname="tbl_specimen.specimen_comment" )
> column=(type=decimal(4) update=yes updatewhereclause=yes
>name=amount_received dbname="tbl_specimen.amount_received" )
> column=(type=char(25) update=yes updatewhereclause=yes name=collected_by
>dbname="tbl_specimen.collected_by" )
> column=(type=char(10) update=yes updatewhereclause=yes name=collected_by_id
>dbname="tbl_specimen.collected_by_id" )
> column=(type=char(16) update=yes updatewhereclause=yes
>name=external_specimen_id dbname="tbl_specimen.external_specimen_id" )
> column=(type=char(10) update=yes updatewhereclause=yes
>name=last_update_userid dbname="tbl_specimen.last_update_userid" )
> column=(type=datetime update=yes updatewhereclause=yes
>name=last_update_dttm dbname="tbl_specimen.last_update_dttm" )
> column=(type=char(80) update=yes updatewhereclause=yes
>name=external_patient_id dbname="tbl_specimen.external_patient_id" )
> column=(type=char(1) update=yes updatewhereclause=yes
>name=confirm_prefix_code dbname="tbl_specimen.confirm_prefix_code" )
> column=(type=long update=yes updatewhereclause=yes name=confirmation_num
>dbname="tbl_specimen.confirmation_num" )
> column=(type=datetime update=yes updatewhereclause=yes name=stored_date
>dbname="tbl_specimen.stored_date" )
> column=(type=char(255) update=yes updatewhereclause=yes name=report_comment
>dbname="tbl_specimen.report_comment" )
> column=(type=datetime update=yes updatewhereclause=yes name=report_dttm
>dbname="tbl_specimen.report_dttm" )
> column=(type=datetime update=yes updatewhereclause=yes name=received_dttm
>dbname="tbl_specimen.received_dttm" )
> column=(type=long update=yes updatewhereclause=yes name=result_flag
>dbname="tbl_specimen.result_flag" )
> column=(type=long update=yes updatewhereclause=yes name=results_status
>dbname="tbl_specimen.results_status" )
> column=(type=datetime update=yes updatewhereclause=yes
>name=results_load_dttm dbname="tbl_specimen.results_load_dttm" )
> column=(type=datetime update=yes updatewhereclause=yes name=results_load_dt
>dbname="tbl_specimen.results_load_dt" )
> column=(type=datetime update=yes updatewhereclause=yes name=collected_dt
>dbname="tbl_specimen.collected_dt" )
> column=(type=long update=yes updatewhereclause=yes name=collected_mth
>dbname="tbl_specimen.collected_mth" )
> column=(type=long update=yes updatewhereclause=yes name=collected_yr
>dbname="tbl_specimen.collected_yr" )
> column=(type=long update=yes updatewhereclause=yes name=agency_code
>dbname="tbl_specimen.agency_code" )
> column=(type=long updatewhereclause=yes name=agency_code
>dbname="tbl_agency.agency_code" )
> column=(type=char(80) updatewhereclause=yes name=agency_name
>dbname="tbl_agency.agency_name" )
> column=(type=char(25) updatewhereclause=yes name=agency_patient_id
>dbname="tbl_patient.agency_patient_id" )
> retrieve="PBSELECT( VERSION(400) TABLE(NAME=~"tbl_specimen~" )
>TABLE(NAME=~"tbl_agency~" )  TABLE(NAME=~"tbl_patient~" )
>TABLE(NAME=~"tbl_agency_group_member~" )
>COLUMN(NAME=~"tbl_specimen.specimen_id~")
>COLUMN(NAME=~"tbl_specimen.agency_id~")
>COLUMN(NAME=~"tbl_specimen.specimen_type~")
>COLUMN(NAME=~"tbl_specimen.identification~")
>COLUMN(NAME=~"tbl_specimen.tests~")
>COLUMN(NAME=~"tbl_specimen.reason_type~")
>COLUMN(NAME=~"tbl_specimen.accession_dttm~")
>COLUMN(NAME=~"tbl_specimen.accession_num~")
>COLUMN(NAME=~"tbl_specimen.patient_id~")
>COLUMN(NAME=~"tbl_specimen.collected_dttm~")
>COLUMN(NAME=~"tbl_specimen.discarded_date~")
>COLUMN(NAME=~"tbl_specimen.status_code~")
>COLUMN(NAME=~"tbl_specimen.specimen_comment~")
>COLUMN(NAME=~"tbl_specimen.amount_received~")
>COLUMN(NAME=~"tbl_specimen.collected_by~")
>COLUMN(NAME=~"tbl_specimen.collected_by_id~")
>COLUMN(NAME=~"tbl_specimen.external_specimen_id~")
>COLUMN(NAME=~"tbl_specimen.last_update_userid~")
>COLUMN(NAME=~"tbl_specimen.last_update_dttm~")
>COLUMN(NAME=~"tbl_specimen.external_patient_id~")
>COLUMN(NAME=~"tbl_specimen.confirm_prefix_code~")
>COLUMN(NAME=~"tbl_specimen.confirmation_num~")
>COLUMN(NAME=~"tbl_specimen.stored_date~")
>COLUMN(NAME=~"tbl_specimen.report_comment~")
>COLUMN(NAME=~"tbl_specimen.report_dttm~")
>COLUMN(NAME=~"tbl_specimen.received_dttm~")
>COLUMN(NAME=~"tbl_specimen.result_flag~")
>COLUMN(NAME=~"tbl_specimen.results_status~")
>COLUMN(NAME=~"tbl_specimen.results_load_dttm~")
>COLUMN(NAME=~"tbl_specimen.results_load_dt~")
>COLUMN(NAME=~"tbl_specimen.collected_dt~")
>COLUMN(NAME=~"tbl_specimen.collected_mth~")
>COLUMN(NAME=~"tbl_specimen.collected_yr~")
>COLUMN(NAME=~"tbl_specimen.agency_code~")
>COLUMN(NAME=~"tbl_agency.agency_code~")
>COLUMN(NAME=~"tbl_agency.agency_name~")
>COLUMN(NAME=~"tbl_patient.agency_patient_id~")    JOIN
>(LEFT=~"tbl_patient.patient_id~"    OP
>=~"=~"RIGHT=~"tbl_specimen.patient_id~"    OUTER2
>=~"tbl_specimen.patient_id~" )    JOIN (LEFT=~"tbl_agency.agency_id~"    OP
>=~"=~"RIGHT=~"tbl_specimen.agency_id~" )    JOIN
>(LEFT=~"tbl_agency_group_member.agency_id~"    OP
>=~"=~"RIGHT=~"tbl_agency.agency_id~" )WHERE(    EXP1
>=~"tbl_agency_group_member.agency_group_id~"   OP =~"=~"    EXP2
>=~":as_agency_group_id~"    LOGIC =~"and~" ) WHERE(    EXP1
>=~"tbl_specimen.status_code~"   OP =~"in~"    EXP2 =~"(1, 2)~" ) ) ARG(NAME
>= ~"as_agency_group_id~" TYPE = string) " arguments=(("as_agency_group_id",
>string))  sort="collected_dttm D " )
>text(band=header alignment="2" text="Specimen OutBox" border="0"
>color="8388608" x="1376" y="12" height="100" width="1070"  name=t_4
>font.face="Arial" font.height="-16" font.weight="400"  font.family="2"
>font.pitch="2" font.charset="0" background.mode="2"
>background.color="16777215" )
>compute(band=detail alignment="0" expression="case(  result_flag when 1 then
>RGB(255, 0, 0) when 2 then RGB(0,0,0) when 3 then RGB(119, 28, 193) )
>"border="0" color="0" x="4133" y="4" height="60" width="82"
>format="[GENERAL]"  name=color_code visible="1~t0"  font.face="Arial"
>font.height="-8" font.weight="400"  font.family="2" font.pitch="2"
>font.charset="0" background.mode="2" background.color="16777215" )
>compute(band=detail alignment="0" expression="RGB(128, 0, 100)"border="0"
>color="0" x="4325" y="8" height="56" width="82" format="[GENERAL]"
>name=unshipped_color visible="1~t0"  font.face="Arial" font.height="-8"
>font.weight="400"  font.family="2" font.pitch="2" font.charset="0"
>background.mode="2" background.color="16777215" )
>compute(band=detail alignment="0" expression="case(  result_flag  when 1
>then 700 when 2 then 400 when 3 then 700 )  "border="0" color="0" x="4229"
>y="8" height="56" width="82" format="[GENERAL]"  name=weight_code
>visible="1~t0"  font.face="Arial" font.height="-8" font.weight="400"
>font.family="2" font.pitch="2" font.charset="0" background.mode="2"
>background.color="16777215" )
>text(band=header alignment="0" text="Identification" border="0"
>color="16777215" x="23" y="152" height="52" width="823"
>name=identification_t  font.face="MS Sans Serif" font.height="-8"
>font.weight="700"  font.family="2" font.pitch="2" font.charset="0"
>background.mode="2" background.color="8388608" )
>text(band=header alignment="0" text="SID" border="0" color="16777215"
>x="859" y="152" height="52" width="311"  name=external_specimen_id_t
>font.face="MS Sans Serif" font.height="-8" font.weight="700"
>font.family="2" font.pitch="2" font.charset="0" background.mode="2"
>background.color="8388608" )
>text(band=header alignment="0" text="Agency#" border="0" color="16777215"
>x="1184" y="152" height="52" width="261"  name=agency_code_t  font.face="MS
>Sans Serif" font.height="-8" font.weight="700"  font.family="2"
>font.pitch="2" font.charset="0" background.mode="2"
>background.color="8388608" )
>column(band=detail id=17 alignment="0" tabsequence=32766 border="0"
>color="0~tcase(   status_code when 1 then rgb(0,0,255) when 2 then
>rgb(0,0,255)
>when -1 then rgb(128,128,128) when -2 then rgb(128,128,128) else
>color_code)" x="859" y="4" height="64" width="311" format="[general]"
>name=external_specimen_id edit.limit=16 edit.case=any edit.autoselect=yes
>edit.autohscroll=yes  font.face="MS Sans Serif" font.height="-8"
>font.weight="400~tweight_code"  font.family="2" font.pitch="2"
>font.charset="0" background.mode="2" background.color="16777215" )
>column(band=detail id=35 alignment="0" tabsequence=32766 border="0"
>color="0~tcase(   status_code when 1 then rgb(0,0,255) when 2 then
>rgb(0,0,255)
>when -1 then rgb(128,128,128) when -2 then rgb(128,128,128) else
>color_code)" x="1184" y="4" height="64" width="261" format="[general]"
>name=agency_code edit.limit=0 edit.case=any edit.autoselect=yes
>font.face="MS Sans Serif" font.height="-8" font.weight="400~tweight_code"
>font.family="2" font.pitch="2" font.charset="0" background.mode="2"
>background.color="16777215" )
>column(band=detail id=4 alignment="0" tabsequence=32766 border="0"
>color="0~tcase(   status_code when 1 then rgb(0,0,255) when 2 then
>rgb(0,0,255)
>when -1 then rgb(128,128,128) when -2 then rgb(128,128,128) else
>color_code)" x="23" y="4" height="64" width="823" format="[general]"
>html.link="" html.linkargs=""  name=identification edit.limit=50
>edit.case=any edit.autoselect=yes edit.autohscroll=yes  font.face="Arial"
>font.height="-8~tif (len(identification) > 20, -7, -8)" font.weight="400"
>font.family="2" font.pitch="2" font.charset="0" background.mode="2"
>background.color="16777215" )
>text(band=header alignment="0" text="Tests" border="0" color="16777215"
>x="2409" y="152" height="52" width="695"  name=tests_t  font.face="MS Sans
>Serif" font.height="-8" font.weight="700"  font.family="2" font.pitch="2"
>font.charset="0" background.mode="2" background.color="8388608" )
>text(band=header alignment="0" text="Collected Date" border="0"
>color="16777215" x="3113" y="152" height="52" width="485"
>name=collected_dttm_t  font.face="MS Sans Serif" font.height="-8"
>font.weight="700"  font.family="2" font.pitch="2" font.charset="0"
>background.mode="2" background.color="8388608" )
>text(band=header alignment="0" text="Collected By" border="0"
>color="16777215" x="3607" y="152" height="52" width="443"
>name=collected_by_t  font.face="MS Sans Serif" font.height="-8"
>font.weight="700"  font.family="2" font.pitch="2" font.charset="0"
>background.mode="2" background.color="8388608" )
>column(band=detail id=5 alignment="0" tabsequence=32766 border="0"
>color="0~tcase(   status_code when 1 then rgb(0,0,255) when 2 then
>rgb(0,0,255)
>when -1 then rgb(128,128,128) when -2 then rgb(128,128,128) else
>color_code)" x="2409" y="4" height="64" width="695" format="[general]"
>name=tests edit.limit=40 edit.case=any edit.autoselect=yes
>edit.autohscroll=yes  font.face="MS Sans Serif" font.height="-8"
>font.weight="400~tweight_code"  font.family="2" font.pitch="2"
>font.charset="0" background.mode="2" background.color="16777215" )
>column(band=detail id=10 alignment="0" tabsequence=32766 border="0"
>color="0~tcase(   status_code when 1 then rgb(0,0,255) when 2 then
>rgb(0,0,255)
>when -1 then rgb(128,128,128) when -2 then rgb(128,128,128) else
>color_code)" x="3113" y="4" height="64" width="485" format="[shortdate]
>[time]"  name=collected_dttm editmask.mask="mm/dd/yyyy hh:mm"
>editmask.focusrectangle=no  font.face="MS Sans Serif" font.height="-8"
>font.weight="400"  font.family="2" font.pitch="2" font.charset="0"
>background.mode="2" background.color="16777215" )
>column(band=detail id=15 alignment="0" tabsequence=32766 border="0"
>color="0~tcase(   status_code when 1 then rgb(0,0,255) when 2 then
>rgb(0,0,255)
>when -1 then rgb(128,128,128) when -2 then rgb(128,128,128) else
>color_code)" x="3607" y="4" height="64" width="443" format="[general]"
>name=collected_by edit.limit=25 edit.case=any edit.autoselect=yes
>edit.autohscroll=yes  font.face="MS Sans Serif" font.height="-8"
>font.weight="400"  font.family="2" font.pitch="2" font.charset="0"
>background.mode="2" background.color="16777215" )
>text(band=header alignment="0" text="Agency Name" border="0"
>color="16777215" x="1454" y="152" height="52" width="942"
>name=agency_name_t  font.face="MS Sans Serif" font.height="-8"
>font.weight="700"  font.family="2" font.pitch="2" font.charset="0"
>background.mode="2" background.color="8388608" )
>column(band=detail id=36 alignment="0" tabsequence=32766 border="0"
>color="0~tcase(   status_code when 1 then rgb(0,0,255) when 2 then
>rgb(0,0,255)
>when -1 then rgb(128,128,128) when -2 then rgb(128,128,128) else
>color_code)" x="1454" y="4" height="64" width="942" format="[general]"
>name=agency_name edit.limit=0 edit.case=any edit.autoselect=yes
>font.face="MS Sans Serif" font.height="-8" font.weight="400~tweight_code"
>font.family="2" font.pitch="2" font.charset="0" background.mode="2"
>background.color="16777215" )
>htmltable(border="1" )
>htmlgen(clientevents="0" clientvalidation="0" clientcomputedfields="0"
>clientformatting="0" clientscriptable="0" generatejavascript="0"
>pagesize="10" browser="Mozilla/4.0 (compatible; MSIE 5.x;) : Microsoft
>Internet Exlorer 5.0" )
>
>****************************************************************************
>************
>Easier view of  Select Statement
>  SELECT tbl_specimen.specimen_id,
>         tbl_specimen.agency_id,
>         tbl_specimen.specimen_type,
>         tbl_specimen.identification,
>         tbl_specimen.tests,
>         tbl_specimen.reason_type,
>         tbl_specimen.accession_dttm,
>         tbl_specimen.accession_num,
>         tbl_specimen.patient_id,
>         tbl_specimen.collected_dttm,
>         tbl_specimen.discarded_date,
>         tbl_specimen.status_code,
>         tbl_specimen.specimen_comment,
>         tbl_specimen.amount_received,
>         tbl_specimen.collected_by,
>         tbl_specimen.collected_by_id,
>         tbl_specimen.external_specimen_id,
>         tbl_specimen.last_update_userid,
>         tbl_specimen.last_update_dttm,
>         tbl_specimen.external_patient_id,
>         tbl_specimen.confirm_prefix_code,
>         tbl_specimen.confirmation_num,
>         tbl_specimen.stored_date,
>         tbl_specimen.report_comment,
>         tbl_specimen.report_dttm,
>         tbl_specimen.received_dttm,
>         tbl_specimen.result_flag,
>         tbl_specimen.results_status,
>         tbl_specimen.results_load_dttm,
>         tbl_specimen.results_load_dt,
>         tbl_specimen.collected_dt,
>         tbl_specimen.collected_mth,
>         tbl_specimen.collected_yr,
>         tbl_specimen.agency_code,
>         tbl_agency.agency_code,
>         tbl_agency.agency_name,
>         tbl_patient.agency_patient_id
>    FROM tbl_specimen,
>         tbl_agency,
>         tbl_patient,
>         tbl_agency_group_member
>   WHERE ( tbl_patient.patient_id  =* tbl_specimen.patient_id) and
>         ( tbl_agency.agency_id = tbl_specimen.agency_id ) and
>         ( tbl_agency_group_member.agency_id = tbl_agency.agency_id ) and
>         ( ( tbl_agency_group_member.agency_group_id = :as_agency_group_id )
>AND
>         ( tbl_specimen.status_code in (1, 2) ) )
>
>****************************************************************************
>***********
>
>int wxDb::DB_STATUS
>DB_ERR_SYNTAX_ERROR_OR_ACCESS_VIOL         // SqlState = '37000'
>wxDb
> A wxDb instance is a connection to an ODBC datasource which may be opened,
>closed, and re-opened an unlimited number of times.  A database connection
>allows function to be performed directly on the datasource, as well as
>allowing access to any tables/views defined in the datasource to which the
>user has sufficient privileges.
>
>
>
>
>
>
>

0
joneil
12/12/2001 3:40:13 PM
Thank you for your response, Jim.

Problem solved.
This was previously solved in Sybase Case ID 41063434
Saving datawindow in graphics mode as opposed to converting to syntax caused
this problem.
It worked ok on win2k pro and nt 4.0 in those environs, but not on win2k
server. it is not clear to me why it occured at this point, but time to move
on. this problem was solved per above id on 3/13/2000, prior to win2k.

I really appreciate your response Jim. I saw that solution mentioned in
other postings. And sorry for cross-posting in this special case. This was
too strange and my boss was breathing down my neck on this one. I had
already swapped out odbc driver dll's from the environments on which this
problem did not occur. That hadn't solved the problem. I was grasping for
straws.

Thanks again Jim,
_Greg


_Greg Hazzard
"Jim O'Neil [Sybase]" <joneil@sybase.com> wrote in message
news:3c1779d6.8501804@forums.sybase.com...
> I would work with the datawindow in a pure PB environment first - I'm
> assuming it fails there too?  The ODBC driver is a bit more picky with
> syntax than the native driver, and I've seen this error on subselect
> and when you use a retrieval argument in a SELECT list, but I'm not
> sure where the problem lies in this particular case.  You could try
> adding a DBParm of DisableBind=1 for this datawindow retrieval and see
> if that works as a potential workaround.
>
> On Tue, 11 Dec 2001 17:26:10 -0800, "Greg Hazzard"
> <greg@redwoodtoxicology.com> wrote:
>
> >This is a cross post. Sorry, but I realized that this is most likely a
> >PowerBuilder issue.
> >
> >EAS 3.61 C2 with PB 7.03 components, datawindows and nvo's.  Powerdynamo
> >3.5.2. ODBC connection cache that works.
> >
> >This is an application port from a NT 4.0 server to a Window 2000 Server.
> >
> >The whole application works fine, through CORBA and 7 NVO's  with at
least
> >20 other datawindows that I have tested.
> >
> >The  ONLY offending datawindow causing
> >
> >'Select error: SQLSTATE = 37000 [Microsoft][ODBC SQL Server Driver]Syntax
> >error or access violation '
> >
> > is called from a browser
>
>***************************************************************************
*
> >*********
> >  dwBrowse = createObject("rtlweb/CollectionHTMLDW");
> >  dwBrowse.setdwobject("", "d_specimen_browse");
> >  dwBrowse.of_setpagehdr();
> >  dwBrowse.setpagesize(i_page_size) ;
> >  dwBrowse.setcolumnlink("identification",
"SpecimenZoom.htm","specimen_id =
> >'specimen_id'|status_code='string(status_code)'", "");
> >  dwBrowse.setcolumnlink("external_specimen_id",
> >"SpecimenZoom.htm","specimen_id =
> >'specimen_id'|status_code='string(status_code)'", "");
> >  dwBrowse.setweight(false, false, true, true, false) ;
> >  agency_group_id = psSession.GetValue("agency_group_id");
> >  htmlDW_str = dwBrowse.onetripex("BrowseDW", agency_group_id,
> >GetBrowserName(), GetSelfLink(), "", GetPageAction("BrowseDW"),
> >GetPageContext("BrowseDW"));
> >  writeData(htmlDW_str);
>
>***************************************************************************
*
> >*********
> >
> >Following the asterisks below is the offending datawindow in its
entirety.
> >(Sorry) The select statement follows the datawindow code.
> >
> >
> >Thanks,
> >_Greg Hazzard
> >
>
>***************************************************************************
*
> >*********
> >$PBExportHeader$d_specimen_browse.srd
> >release 7;
> >datawindow(units=0 timer_interval=0 color=16777215 processing=0
HTMLDW=yes
> >print.documentname="" print.orientation = 0 print.margin.left = 110
> >print.margin.right = 110 print.margin.top = 96 print.margin.bottom = 96
> >print.paper.source = 0 print.paper.size = 0 print.prompt=no
print.buttons=no
> >print.preview.buttons=no )
> >header(height=208 color="536870912" )
> >summary(height=0 color="536870912" )
> >footer(height=0 color="536870912" )
> >detail(height=72 color="536870912" )
> >table(column=(type=char(16) update=yes updatewhereclause=yes
> >name=specimen_id dbname="tbl_specimen.specimen_id" )
> > column=(type=char(16) update=yes updatewhereclause=yes name=agency_id
> >dbname="tbl_specimen.agency_id" )
> > column=(type=long update=yes updatewhereclause=yes name=specimen_type
> >dbname="tbl_specimen.specimen_type" )
> > column=(type=char(50) update=yes updatewhereclause=yes
name=identification
> >dbname="tbl_specimen.identification" )
> > column=(type=char(40) update=yes updatewhereclause=yes name=tests
> >dbname="tbl_specimen.tests" )
> > column=(type=char(10) update=yes updatewhereclause=yes name=reason_type
> >dbname="tbl_specimen.reason_type" )
> > column=(type=datetime update=yes updatewhereclause=yes
name=accession_dttm
> >dbname="tbl_specimen.accession_dttm" )
> > column=(type=long update=yes updatewhereclause=yes name=accession_num
> >dbname="tbl_specimen.accession_num" )
> > column=(type=char(16) update=yes updatewhereclause=yes name=patient_id
> >dbname="tbl_specimen.patient_id" )
> > column=(type=datetime update=yes updatewhereclause=yes
name=collected_dttm
> >dbname="tbl_specimen.collected_dttm" )
> > column=(type=datetime update=yes updatewhereclause=yes
name=discarded_date
> >dbname="tbl_specimen.discarded_date" )
> > column=(type=long update=yes updatewhereclause=yes name=status_code
> >dbname="tbl_specimen.status_code" )
> > column=(type=char(255) update=yes updatewhereclause=yes
> >name=specimen_comment dbname="tbl_specimen.specimen_comment" )
> > column=(type=decimal(4) update=yes updatewhereclause=yes
> >name=amount_received dbname="tbl_specimen.amount_received" )
> > column=(type=char(25) update=yes updatewhereclause=yes name=collected_by
> >dbname="tbl_specimen.collected_by" )
> > column=(type=char(10) update=yes updatewhereclause=yes
name=collected_by_id
> >dbname="tbl_specimen.collected_by_id" )
> > column=(type=char(16) update=yes updatewhereclause=yes
> >name=external_specimen_id dbname="tbl_specimen.external_specimen_id" )
> > column=(type=char(10) update=yes updatewhereclause=yes
> >name=last_update_userid dbname="tbl_specimen.last_update_userid" )
> > column=(type=datetime update=yes updatewhereclause=yes
> >name=last_update_dttm dbname="tbl_specimen.last_update_dttm" )
> > column=(type=char(80) update=yes updatewhereclause=yes
> >name=external_patient_id dbname="tbl_specimen.external_patient_id" )
> > column=(type=char(1) update=yes updatewhereclause=yes
> >name=confirm_prefix_code dbname="tbl_specimen.confirm_prefix_code" )
> > column=(type=long update=yes updatewhereclause=yes name=confirmation_num
> >dbname="tbl_specimen.confirmation_num" )
> > column=(type=datetime update=yes updatewhereclause=yes name=stored_date
> >dbname="tbl_specimen.stored_date" )
> > column=(type=char(255) update=yes updatewhereclause=yes
name=report_comment
> >dbname="tbl_specimen.report_comment" )
> > column=(type=datetime update=yes updatewhereclause=yes name=report_dttm
> >dbname="tbl_specimen.report_dttm" )
> > column=(type=datetime update=yes updatewhereclause=yes
name=received_dttm
> >dbname="tbl_specimen.received_dttm" )
> > column=(type=long update=yes updatewhereclause=yes name=result_flag
> >dbname="tbl_specimen.result_flag" )
> > column=(type=long update=yes updatewhereclause=yes name=results_status
> >dbname="tbl_specimen.results_status" )
> > column=(type=datetime update=yes updatewhereclause=yes
> >name=results_load_dttm dbname="tbl_specimen.results_load_dttm" )
> > column=(type=datetime update=yes updatewhereclause=yes
name=results_load_dt
> >dbname="tbl_specimen.results_load_dt" )
> > column=(type=datetime update=yes updatewhereclause=yes name=collected_dt
> >dbname="tbl_specimen.collected_dt" )
> > column=(type=long update=yes updatewhereclause=yes name=collected_mth
> >dbname="tbl_specimen.collected_mth" )
> > column=(type=long update=yes updatewhereclause=yes name=collected_yr
> >dbname="tbl_specimen.collected_yr" )
> > column=(type=long update=yes updatewhereclause=yes name=agency_code
> >dbname="tbl_specimen.agency_code" )
> > column=(type=long updatewhereclause=yes name=agency_code
> >dbname="tbl_agency.agency_code" )
> > column=(type=char(80) updatewhereclause=yes name=agency_name
> >dbname="tbl_agency.agency_name" )
> > column=(type=char(25) updatewhereclause=yes name=agency_patient_id
> >dbname="tbl_patient.agency_patient_id" )
> > retrieve="PBSELECT( VERSION(400) TABLE(NAME=~"tbl_specimen~" )
> >TABLE(NAME=~"tbl_agency~" )  TABLE(NAME=~"tbl_patient~" )
> >TABLE(NAME=~"tbl_agency_group_member~" )
> >COLUMN(NAME=~"tbl_specimen.specimen_id~")
> >COLUMN(NAME=~"tbl_specimen.agency_id~")
> >COLUMN(NAME=~"tbl_specimen.specimen_type~")
> >COLUMN(NAME=~"tbl_specimen.identification~")
> >COLUMN(NAME=~"tbl_specimen.tests~")
> >COLUMN(NAME=~"tbl_specimen.reason_type~")
> >COLUMN(NAME=~"tbl_specimen.accession_dttm~")
> >COLUMN(NAME=~"tbl_specimen.accession_num~")
> >COLUMN(NAME=~"tbl_specimen.patient_id~")
> >COLUMN(NAME=~"tbl_specimen.collected_dttm~")
> >COLUMN(NAME=~"tbl_specimen.discarded_date~")
> >COLUMN(NAME=~"tbl_specimen.status_code~")
> >COLUMN(NAME=~"tbl_specimen.specimen_comment~")
> >COLUMN(NAME=~"tbl_specimen.amount_received~")
> >COLUMN(NAME=~"tbl_specimen.collected_by~")
> >COLUMN(NAME=~"tbl_specimen.collected_by_id~")
> >COLUMN(NAME=~"tbl_specimen.external_specimen_id~")
> >COLUMN(NAME=~"tbl_specimen.last_update_userid~")
> >COLUMN(NAME=~"tbl_specimen.last_update_dttm~")
> >COLUMN(NAME=~"tbl_specimen.external_patient_id~")
> >COLUMN(NAME=~"tbl_specimen.confirm_prefix_code~")
> >COLUMN(NAME=~"tbl_specimen.confirmation_num~")
> >COLUMN(NAME=~"tbl_specimen.stored_date~")
> >COLUMN(NAME=~"tbl_specimen.report_comment~")
> >COLUMN(NAME=~"tbl_specimen.report_dttm~")
> >COLUMN(NAME=~"tbl_specimen.received_dttm~")
> >COLUMN(NAME=~"tbl_specimen.result_flag~")
> >COLUMN(NAME=~"tbl_specimen.results_status~")
> >COLUMN(NAME=~"tbl_specimen.results_load_dttm~")
> >COLUMN(NAME=~"tbl_specimen.results_load_dt~")
> >COLUMN(NAME=~"tbl_specimen.collected_dt~")
> >COLUMN(NAME=~"tbl_specimen.collected_mth~")
> >COLUMN(NAME=~"tbl_specimen.collected_yr~")
> >COLUMN(NAME=~"tbl_specimen.agency_code~")
> >COLUMN(NAME=~"tbl_agency.agency_code~")
> >COLUMN(NAME=~"tbl_agency.agency_name~")
> >COLUMN(NAME=~"tbl_patient.agency_patient_id~")    JOIN
> >(LEFT=~"tbl_patient.patient_id~"    OP
> >=~"=~"RIGHT=~"tbl_specimen.patient_id~"    OUTER2
> >=~"tbl_specimen.patient_id~" )    JOIN (LEFT=~"tbl_agency.agency_id~"
OP
> >=~"=~"RIGHT=~"tbl_specimen.agency_id~" )    JOIN
> >(LEFT=~"tbl_agency_group_member.agency_id~"    OP
> >=~"=~"RIGHT=~"tbl_agency.agency_id~" )WHERE(    EXP1
> >=~"tbl_agency_group_member.agency_group_id~"   OP =~"=~"    EXP2
> >=~":as_agency_group_id~"    LOGIC =~"and~" ) WHERE(    EXP1
> >=~"tbl_specimen.status_code~"   OP =~"in~"    EXP2 =~"(1, 2)~" ) )
ARG(NAME
> >= ~"as_agency_group_id~" TYPE = string) "
arguments=(("as_agency_group_id",
> >string))  sort="collected_dttm D " )
> >text(band=header alignment="2" text="Specimen OutBox" border="0"
> >color="8388608" x="1376" y="12" height="100" width="1070"  name=t_4
> >font.face="Arial" font.height="-16" font.weight="400"  font.family="2"
> >font.pitch="2" font.charset="0" background.mode="2"
> >background.color="16777215" )
> >compute(band=detail alignment="0" expression="case(  result_flag when 1
then
> >RGB(255, 0, 0) when 2 then RGB(0,0,0) when 3 then RGB(119, 28, 193) )
> >"border="0" color="0" x="4133" y="4" height="60" width="82"
> >format="[GENERAL]"  name=color_code visible="1~t0"  font.face="Arial"
> >font.height="-8" font.weight="400"  font.family="2" font.pitch="2"
> >font.charset="0" background.mode="2" background.color="16777215" )
> >compute(band=detail alignment="0" expression="RGB(128, 0, 100)"border="0"
> >color="0" x="4325" y="8" height="56" width="82" format="[GENERAL]"
> >name=unshipped_color visible="1~t0"  font.face="Arial" font.height="-8"
> >font.weight="400"  font.family="2" font.pitch="2" font.charset="0"
> >background.mode="2" background.color="16777215" )
> >compute(band=detail alignment="0" expression="case(  result_flag  when 1
> >then 700 when 2 then 400 when 3 then 700 )  "border="0" color="0"
x="4229"
> >y="8" height="56" width="82" format="[GENERAL]"  name=weight_code
> >visible="1~t0"  font.face="Arial" font.height="-8" font.weight="400"
> >font.family="2" font.pitch="2" font.charset="0" background.mode="2"
> >background.color="16777215" )
> >text(band=header alignment="0" text="Identification" border="0"
> >color="16777215" x="23" y="152" height="52" width="823"
> >name=identification_t  font.face="MS Sans Serif" font.height="-8"
> >font.weight="700"  font.family="2" font.pitch="2" font.charset="0"
> >background.mode="2" background.color="8388608" )
> >text(band=header alignment="0" text="SID" border="0" color="16777215"
> >x="859" y="152" height="52" width="311"  name=external_specimen_id_t
> >font.face="MS Sans Serif" font.height="-8" font.weight="700"
> >font.family="2" font.pitch="2" font.charset="0" background.mode="2"
> >background.color="8388608" )
> >text(band=header alignment="0" text="Agency#" border="0" color="16777215"
> >x="1184" y="152" height="52" width="261"  name=agency_code_t
font.face="MS
> >Sans Serif" font.height="-8" font.weight="700"  font.family="2"
> >font.pitch="2" font.charset="0" background.mode="2"
> >background.color="8388608" )
> >column(band=detail id=17 alignment="0" tabsequence=32766 border="0"
> >color="0~tcase(   status_code when 1 then rgb(0,0,255) when 2 then
> >rgb(0,0,255)
> >when -1 then rgb(128,128,128) when -2 then rgb(128,128,128) else
> >color_code)" x="859" y="4" height="64" width="311" format="[general]"
> >name=external_specimen_id edit.limit=16 edit.case=any edit.autoselect=yes
> >edit.autohscroll=yes  font.face="MS Sans Serif" font.height="-8"
> >font.weight="400~tweight_code"  font.family="2" font.pitch="2"
> >font.charset="0" background.mode="2" background.color="16777215" )
> >column(band=detail id=35 alignment="0" tabsequence=32766 border="0"
> >color="0~tcase(   status_code when 1 then rgb(0,0,255) when 2 then
> >rgb(0,0,255)
> >when -1 then rgb(128,128,128) when -2 then rgb(128,128,128) else
> >color_code)" x="1184" y="4" height="64" width="261" format="[general]"
> >name=agency_code edit.limit=0 edit.case=any edit.autoselect=yes
> >font.face="MS Sans Serif" font.height="-8" font.weight="400~tweight_code"
> >font.family="2" font.pitch="2" font.charset="0" background.mode="2"
> >background.color="16777215" )
> >column(band=detail id=4 alignment="0" tabsequence=32766 border="0"
> >color="0~tcase(   status_code when 1 then rgb(0,0,255) when 2 then
> >rgb(0,0,255)
> >when -1 then rgb(128,128,128) when -2 then rgb(128,128,128) else
> >color_code)" x="23" y="4" height="64" width="823" format="[general]"
> >html.link="" html.linkargs=""  name=identification edit.limit=50
> >edit.case=any edit.autoselect=yes edit.autohscroll=yes  font.face="Arial"
> >font.height="-8~tif (len(identification) > 20, -7, -8)" font.weight="400"
> >font.family="2" font.pitch="2" font.charset="0" background.mode="2"
> >background.color="16777215" )
> >text(band=header alignment="0" text="Tests" border="0" color="16777215"
> >x="2409" y="152" height="52" width="695"  name=tests_t  font.face="MS
Sans
> >Serif" font.height="-8" font.weight="700"  font.family="2" font.pitch="2"
> >font.charset="0" background.mode="2" background.color="8388608" )
> >text(band=header alignment="0" text="Collected Date" border="0"
> >color="16777215" x="3113" y="152" height="52" width="485"
> >name=collected_dttm_t  font.face="MS Sans Serif" font.height="-8"
> >font.weight="700"  font.family="2" font.pitch="2" font.charset="0"
> >background.mode="2" background.color="8388608" )
> >text(band=header alignment="0" text="Collected By" border="0"
> >color="16777215" x="3607" y="152" height="52" width="443"
> >name=collected_by_t  font.face="MS Sans Serif" font.height="-8"
> >font.weight="700"  font.family="2" font.pitch="2" font.charset="0"
> >background.mode="2" background.color="8388608" )
> >column(band=detail id=5 alignment="0" tabsequence=32766 border="0"
> >color="0~tcase(   status_code when 1 then rgb(0,0,255) when 2 then
> >rgb(0,0,255)
> >when -1 then rgb(128,128,128) when -2 then rgb(128,128,128) else
> >color_code)" x="2409" y="4" height="64" width="695" format="[general]"
> >name=tests edit.limit=40 edit.case=any edit.autoselect=yes
> >edit.autohscroll=yes  font.face="MS Sans Serif" font.height="-8"
> >font.weight="400~tweight_code"  font.family="2" font.pitch="2"
> >font.charset="0" background.mode="2" background.color="16777215" )
> >column(band=detail id=10 alignment="0" tabsequence=32766 border="0"
> >color="0~tcase(   status_code when 1 then rgb(0,0,255) when 2 then
> >rgb(0,0,255)
> >when -1 then rgb(128,128,128) when -2 then rgb(128,128,128) else
> >color_code)" x="3113" y="4" height="64" width="485" format="[shortdate]
> >[time]"  name=collected_dttm editmask.mask="mm/dd/yyyy hh:mm"
> >editmask.focusrectangle=no  font.face="MS Sans Serif" font.height="-8"
> >font.weight="400"  font.family="2" font.pitch="2" font.charset="0"
> >background.mode="2" background.color="16777215" )
> >column(band=detail id=15 alignment="0" tabsequence=32766 border="0"
> >color="0~tcase(   status_code when 1 then rgb(0,0,255) when 2 then
> >rgb(0,0,255)
> >when -1 then rgb(128,128,128) when -2 then rgb(128,128,128) else
> >color_code)" x="3607" y="4" height="64" width="443" format="[general]"
> >name=collected_by edit.limit=25 edit.case=any edit.autoselect=yes
> >edit.autohscroll=yes  font.face="MS Sans Serif" font.height="-8"
> >font.weight="400"  font.family="2" font.pitch="2" font.charset="0"
> >background.mode="2" background.color="16777215" )
> >text(band=header alignment="0" text="Agency Name" border="0"
> >color="16777215" x="1454" y="152" height="52" width="942"
> >name=agency_name_t  font.face="MS Sans Serif" font.height="-8"
> >font.weight="700"  font.family="2" font.pitch="2" font.charset="0"
> >background.mode="2" background.color="8388608" )
> >column(band=detail id=36 alignment="0" tabsequence=32766 border="0"
> >color="0~tcase(   status_code when 1 then rgb(0,0,255) when 2 then
> >rgb(0,0,255)
> >when -1 then rgb(128,128,128) when -2 then rgb(128,128,128) else
> >color_code)" x="1454" y="4" height="64" width="942" format="[general]"
> >name=agency_name edit.limit=0 edit.case=any edit.autoselect=yes
> >font.face="MS Sans Serif" font.height="-8" font.weight="400~tweight_code"
> >font.family="2" font.pitch="2" font.charset="0" background.mode="2"
> >background.color="16777215" )
> >htmltable(border="1" )
> >htmlgen(clientevents="0" clientvalidation="0" clientcomputedfields="0"
> >clientformatting="0" clientscriptable="0" generatejavascript="0"
> >pagesize="10" browser="Mozilla/4.0 (compatible; MSIE 5.x;) : Microsoft
> >Internet Exlorer 5.0" )
> >
>
>***************************************************************************
*
> >************
> >Easier view of  Select Statement
> >  SELECT tbl_specimen.specimen_id,
> >         tbl_specimen.agency_id,
> >         tbl_specimen.specimen_type,
> >         tbl_specimen.identification,
> >         tbl_specimen.tests,
> >         tbl_specimen.reason_type,
> >         tbl_specimen.accession_dttm,
> >         tbl_specimen.accession_num,
> >         tbl_specimen.patient_id,
> >         tbl_specimen.collected_dttm,
> >         tbl_specimen.discarded_date,
> >         tbl_specimen.status_code,
> >         tbl_specimen.specimen_comment,
> >         tbl_specimen.amount_received,
> >         tbl_specimen.collected_by,
> >         tbl_specimen.collected_by_id,
> >         tbl_specimen.external_specimen_id,
> >         tbl_specimen.last_update_userid,
> >         tbl_specimen.last_update_dttm,
> >         tbl_specimen.external_patient_id,
> >         tbl_specimen.confirm_prefix_code,
> >         tbl_specimen.confirmation_num,
> >         tbl_specimen.stored_date,
> >         tbl_specimen.report_comment,
> >         tbl_specimen.report_dttm,
> >         tbl_specimen.received_dttm,
> >         tbl_specimen.result_flag,
> >         tbl_specimen.results_status,
> >         tbl_specimen.results_load_dttm,
> >         tbl_specimen.results_load_dt,
> >         tbl_specimen.collected_dt,
> >         tbl_specimen.collected_mth,
> >         tbl_specimen.collected_yr,
> >         tbl_specimen.agency_code,
> >         tbl_agency.agency_code,
> >         tbl_agency.agency_name,
> >         tbl_patient.agency_patient_id
> >    FROM tbl_specimen,
> >         tbl_agency,
> >         tbl_patient,
> >         tbl_agency_group_member
> >   WHERE ( tbl_patient.patient_id  =* tbl_specimen.patient_id) and
> >         ( tbl_agency.agency_id = tbl_specimen.agency_id ) and
> >         ( tbl_agency_group_member.agency_id = tbl_agency.agency_id ) and
> >         ( ( tbl_agency_group_member.agency_group_id =
:as_agency_group_id )
> >AND
> >         ( tbl_specimen.status_code in (1, 2) ) )
> >
>
>***************************************************************************
*
> >***********
> >
> >int wxDb::DB_STATUS
> >DB_ERR_SYNTAX_ERROR_OR_ACCESS_VIOL         // SqlState = '37000'
> >wxDb
> > A wxDb instance is a connection to an ODBC datasource which may be
opened,
> >closed, and re-opened an unlimited number of times.  A database
connection
> >allows function to be performed directly on the datasource, as well as
> >allowing access to any tables/views defined in the datasource to which
the
> >user has sufficient privileges.
> >
> >
> >
> >
> >
> >
> >
>


0
Greg
12/12/2001 4:51:05 PM
Reply:

Similar Artilces:

Select error: SQLSTATE = 37000 [Microsoft][ODBC SQL Server Driver]Syntax error or access violation
EAS 3.61 C2 with PB 7.03 components, datawindows and nvo's. Powerdynamo 3.5.2. ODBC connection cache that works. This is an application port from a NT 4.0 server to a Window 2000 Server. The whole application works fine, through CORBA and 7 NVO's with at least 20 other datawindows that I have tested. The ONLY offending datawindow causing 'Select error: SQLSTATE = 37000 [Microsoft][ODBC SQL Server Driver]Syntax error or access violation ' is called from a browser **************************************************************************** ********* dwB...

wegconfig connectionstring ADODB System.Data.Odbc error is [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'TSQL'
    <add name="MYADODBCUSTOMERCONNECTIONSTRING" connectionString="Driver={SQL Server};Server=xxx.xxx.xxx.xxx;Database=myDbname;Uid=xxxxx;Pwd=xxxxx" providerName="System.Data.Odbc" />   [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'TSQL'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Runtime.InteropServices.COMException: [Micros...

Why does a simple select query in Microsoft Access return the error [Intersolv][ODBC SQL Server Driver][SQL Server]ct_results(): user api layer: internal client library error: Read from the server has
I have applied the information from support document 10447954 but that does not solve the problem. I am running a simple select query with one criteria from one table. Thanks. ...

ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'IP Address of the server'(10048) ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'IP of the server' (10
Hi, I am randomly getting the following error message in my application. ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'IP Address of the server'(10048) ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'IP of the server' (10048) I am using .Net 2.0 with VS2005 having ODBC 3.51.14 Driver.  Can any body point out the core reasons of the above error message? Thanks. Nouman Khawaja. I do have the same problem, help me out. Thanks  If the going seems easy, You are going DownHill... When I was writing ...

Microsoft.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]
Hi Everybody, On localhost this application works fine but when I put on remote server. I am getting following errors. For both localhost and server, I am using same remote sql 2000. I will appreciate any help. Thanks, Arif Server Error in '/' Application. -------------------------------------------------------------------------------- ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more i...

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Hello All, I'm Getting the following error when calling a dll from my vb.net application. [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. The dll was written in vb6 and accesses a sql db using the following connection string. Public Const GLOBAL_DNS As String = "DSN=TransSrvFinal;UID=sa;PWD=admin;" This DLL works fine when called from other Windows Apps. However I'm now trying to call this dll from with in an asp.net application. I'm using vb.net as the codebehind. I'm a...

[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database requested in login 'WinFM SQL PFS'. Login fails.
HiASP pages were properly connecting to SQL DB until I restored from a backup DB.  As soon as I finished restoring from the backup DB, I am getting the following error message.   I did not make any changes on ASP side.  IIS Server and SQL 2K Server is running on a WIN2K Server Box.Please help.Thank you.HTTP 500.100 - Internal Server Error - ASP errorInternet Information ServicesTechnical Information (for support personnel)Error Type:Microsoft OLE DB Provider for ODBC Drivers (0x80004005)[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database requested in login...

Why does a simple select query in MS Access return the error: [Intersolv][ODBC SQL Server Driver][SQL Server]ct_results(): user api layer: internal client library error: Read from the server has timed
I have applied the information contained in support document 10447954. That did not resolve the problem. I am running a simple query with one criteria and one table Thanks. Hi Bill, The doc refers to a different ODBC driver (for DirectConnect product) so you might have a completely different problem. The message implies you are using ODBC 12.0 (Client Library based) or prior since the message indicates CtLib info. You might want to post more details involved with getting to this error. You also might want to post exact versions of ASE and ODBC driver, including Open ...

Error using OdbcDataReader.ExecuteReader and Parameters...ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the variable
This seems to be a common problem but I have not seen any answers yet on this board.   I am porting over to using odbc because I have no choice with my Hosting company,  I was using basically the same code with the SQLDataReader and SQLCommand object and it was fine.  The below code will generate the error.  Help !! Unexpected exception: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the variable '@Role'.. string sql = String.Empty ;sql = "Select * from Associate where Role=@Role and Exit_Date > @Exit_Date";string connString = getConn...

Microsoft OLE DB Provider for SQL Server error '80004005'. SQL Server does not exist or access denied.
Hi,I have a asp web application, where i use sql server 2005 as backend. This application generates reports . Before i was using SQL Server 2000, now its migrated to 2005. When i generate report for small date range then it works fine. But when the date range is big then around half of the report is generated and the following error is thrown. Microsoft OLE DB Provider for SQL Server error '80004005' [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. ...out.asp, line 405  Am sure the webcode is working fine and am connecting to the Da...

Why I get this error:Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
When i run the web site in Windows 2003 Server,and I click on the "view" hyperlink to view customer infor,I got the error message as below: Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '/'. /bc/cust_info.asp, line 132 and the SQL statement in line 132 is as below: strsql1 = "select sum(unit_price*qty) as SubTotal from dailySchedule where customer_code='" & request.QueryString("login") & _              "' and [date]=" &...

ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to
Hello all, I'm a newbie in ASP. I wrote a C# app to access an MS Access database placed in the c:\inetpub\wwroots\databases folder. Everything works fine. When I am trying to access the same database through my ASP web application, I keep on getting: "ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.\r\nERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed\r\nERROR [HY000] [Microsof...

error in connecting to oracle:Microsoft OLE DB Provider for ODBC Drivers error '80004005'
i am trying to connect to oracle using the following connection string..but a get the following error what should i do. this is the function to make connection to DB which i am using Private Function GetDBConnection Const cConnection = "SERVER=LPTEXT;driver={Microsoft ODBC for Oracle};UID=scott;PWD=tiger;" Dim objConnection '* Create the connection object Set objConnection = Server.CreateObject("ADODB.Connection") objConnection.ConnectionString = cConnection objConnection.CursorLocation = 3 '* adUseClient objC...

Login page has this error: ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
I am building my first ASP.net Login page this page accesses a dns file the was created in MS Access. When I enter the login page required fields and attempt to check against the database I get the following error.  Any thoughts on how to fix this problem I am completely at a loss for what to do. Thank You, RucaduluERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where ...

Web resources about - 'Select error: SQLSTATE = 37000 [Microsoft][ODBC SQL Server Driver]Syntax - sybase.easerver.powerbuilder

Resources last updated: 2/12/2016 1:06:09 AM