Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Select Errors

7 posts in PB Infomaker Report Writer Last posting was on 1998-09-15 23:01:45.0Z
Jim Tobin Posted on 1998-09-15 15:37:35.0Z
Newsgroups: sybase.public.infomaker.general
Date: Tue, 15 Sep 1998 11:37:35 -0400
From: Jim Tobin <jimtobin@compuserve.com>
X-Mailer: Mozilla 4.03 [en] (Win95; I)
MIME-Version: 1.0
Subject: Select Errors
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 15
Message-ID: <348_35FE89BF.DC1487CC@compuserve.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6906
Article PK: 242937

Hi!

I have a series of reports that I developed on a W95 platform for SQL
Anywhere. All these reports are working fine on my WIN95 machine. I
ported over the entire data base last weekend and several reports will
not work. The customers machine is a NT with Win95 clients. The
database is fine ( ihave the exact data the customer has).

The error I am getting is:
Select error SQLSTATE = 37000
(Sybase) ODBC Driver Syntax error: near 'to' in station_id.

I don't have a clue as to why this report works on my machine and not on
the other?

Thanks, Jim


Terry Dykstra [TeamPS] Posted on 1998-09-15 18:09:56.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra [TeamPS]" <no_spam_tdykstra@cfol.ab.ca>
Subject: Re: Select Errors
Date: Tue, 15 Sep 1998 12:09:56 -0600
Lines: 27
Organization: Canadian Forest Oil Ltd.
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Message-ID: <348_0NvdFpM49GA.151@forums.powersoft.com>
References: <348_35FE89BF.DC1487CC@compuserve.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6905
Article PK: 242935

Is everyone using the exact same SQLAnywhere client / DB, like 5.5.0.3 ? Is
the deployment kit the same level as your IM / PB version (e.g., 5.0.02) ?

--
Terry Dykstra [TeamPS]
Canadian Forest Oil Ltd.

Jim Tobin wrote in message <35FE89BF.DC1487CC@compuserve.com>...
>Hi!
>
>I have a series of reports that I developed on a W95 platform for SQL
>Anywhere. All these reports are working fine on my WIN95 machine. I
>ported over the entire data base last weekend and several reports will
>not work. The customers machine is a NT with Win95 clients. The
>database is fine ( ihave the exact data the customer has).
>
>The error I am getting is:
> Select error SQLSTATE = 37000
> (Sybase) ODBC Driver Syntax error: near 'to' in station_id.
>
>I don't have a clue as to why this report works on my machine and not on
>the other?
>
>Thanks, Jim
>


Jim Tobin Posted on 1998-09-15 19:37:39.0Z
Newsgroups: sybase.public.infomaker.general
Date: Tue, 15 Sep 1998 15:37:39 -0400
From: Jim Tobin <jimtobin@compuserve.com>
X-Mailer: Mozilla 4.03 [en] (Win95; I)
MIME-Version: 1.0
To: "Terry Dykstra [TeamPS]" <no_spam_tdykstra@cfol.ab.ca>
Subject: Re: Select Errors
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 32
Message-ID: <348_35FEC203.89E3CDA2@compuserve.com>
References: <348_35FE89BF.DC1487CC@compuserve.com> <348_0NvdFpM49GA.151@forums.powersoft.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6901
Article PK: 242930

I personally installed the clients on each machine so they are all the same. By
the deployment kit I assume that you mean all the dll's under \pwrs\sys32 ?? The
calling program is VC++, that calles each report off a button. I am not using
Powerbuilder.

Thanks, Jim

Terry Dykstra [TeamPS] wrote:

> Is everyone using the exact same SQLAnywhere client / DB, like 5.5.0.3 ? Is
> the deployment kit the same level as your IM / PB version (e.g., 5.0.02) ?
>
> --
> Terry Dykstra [TeamPS]
> Canadian Forest Oil Ltd.
>
> Jim Tobin wrote in message <35FE89BF.DC1487CC@compuserve.com>...
> >Hi!
> >
> >I have a series of reports that I developed on a W95 platform for SQL
> >Anywhere. All these reports are working fine on my WIN95 machine. I
> >ported over the entire data base last weekend and several reports will
> >not work. The customers machine is a NT with Win95 clients. The
> >database is fine ( ihave the exact data the customer has).
> >
> >The error I am getting is:
> > Select error SQLSTATE = 37000
> > (Sybase) ODBC Driver Syntax error: near 'to' in station_id.
> >
> >I don't have a clue as to why this report works on my machine and not on
> >the other?
> >
> >Thanks, Jim
> >


Terry Dykstra [TeamPS] Posted on 1998-09-15 22:22:21.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra [TeamPS]" <no_spam_tdykstra@cfol.ab.ca>
Subject: Re: Select Errors
Date: Tue, 15 Sep 1998 16:22:21 -0600
Lines: 55
Organization: Canadian Forest Oil Ltd.
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Message-ID: <348_Z5dCI2O49GA.82@forums.powersoft.com>
References: <348_35FE89BF.DC1487CC@compuserve.com> <348_0NvdFpM49GA.151@forums.powersoft.com> <348_35FEC203.89E3CDA2@compuserve.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6900
Article PK: 242931

Now I'm totally confused. Are the reports developed with VC++ or IM? Are
you using the datawindow ActiveX? You might want to repost this question
then in the power++.datawindow newsgroup.
The deployment kit contains a subset of the pwrs\sys32 dlls. It also
includes ODBC drivers and certain windows\system dlls.

--
Terry Dykstra [TeamPS]
Canadian Forest Oil Ltd.

Jim Tobin wrote in message <35FEC203.89E3CDA2@compuserve.com>...
>I personally installed the clients on each machine so they are all the
same. By
>the deployment kit I assume that you mean all the dll's under \pwrs\sys32
?? The
>calling program is VC++, that calles each report off a button. I am not
using
>Powerbuilder.
>
>Thanks, Jim
>
>Terry Dykstra [TeamPS] wrote:
>
>> Is everyone using the exact same SQLAnywhere client / DB, like 5.5.0.3 ?
Is
>> the deployment kit the same level as your IM / PB version (e.g., 5.0.02)
?
>>
>> --
>> Terry Dykstra [TeamPS]
>> Canadian Forest Oil Ltd.
>>
>> Jim Tobin wrote in message <35FE89BF.DC1487CC@compuserve.com>...
>> >Hi!
>> >
>> >I have a series of reports that I developed on a W95 platform for SQL
>> >Anywhere. All these reports are working fine on my WIN95 machine. I
>> >ported over the entire data base last weekend and several reports will
>> >not work. The customers machine is a NT with Win95 clients. The
>> >database is fine ( ihave the exact data the customer has).
>> >
>> >The error I am getting is:
>> > Select error SQLSTATE = 37000
>> > (Sybase) ODBC Driver Syntax error: near 'to' in station_id.
>> >
>> >I don't have a clue as to why this report works on my machine and not on
>> >the other?
>> >
>> >Thanks, Jim
>> >
>
>
>


Jim Tobin Posted on 1998-09-15 23:01:45.0Z
Newsgroups: sybase.public.infomaker.general
Date: Tue, 15 Sep 1998 19:01:45 -0400
From: Jim Tobin <jimtobin@compuserve.com>
X-Mailer: Mozilla 4.03 [en] (Win95; I)
MIME-Version: 1.0
To: "Terry Dykstra [TeamPS]" <no_spam_tdykstra@cfol.ab.ca>
Subject: Re: Select Errors
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 51
Message-ID: <348_35FEF1D9.6E506AE6@compuserve.com>
References: <348_35FE89BF.DC1487CC@compuserve.com> <348_0NvdFpM49GA.151@forums.powersoft.com> <348_35FEC203.89E3CDA2@compuserve.com> <348_Z5dCI2O49GA.82@forums.powersoft.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6899
Article PK: 242929

Sorry for the confusion, Terry. The report programs are in Infomaker. They are
called from a VC++ program via a button.

Jim

Terry Dykstra [TeamPS] wrote:

> Now I'm totally confused. Are the reports developed with VC++ or IM? Are
> you using the datawindow ActiveX? You might want to repost this question
> then in the power++.datawindow newsgroup.
> The deployment kit contains a subset of the pwrs\sys32 dlls. It also
> includes ODBC drivers and certain windows\system dlls.
>
> --
> Terry Dykstra [TeamPS]
> Canadian Forest Oil Ltd.
>
> Jim Tobin wrote in message <35FEC203.89E3CDA2@compuserve.com>...
> >I personally installed the clients on each machine so they are all the
> same. By
> >the deployment kit I assume that you mean all the dll's under \pwrs\sys32
> ?? The
> >calling program is VC++, that calles each report off a button. I am not
> using
> >Powerbuilder.
> >
> >Thanks, Jim
> >
> >Terry Dykstra [TeamPS] wrote:
> >
> >> Is everyone using the exact same SQLAnywhere client / DB, like 5.5.0.3 ?
> Is
> >> the deployment kit the same level as your IM / PB version (e.g., 5.0.02)
> ?
> >>
> >> --
> >> Terry Dykstra [TeamPS]
> >> Canadian Forest Oil Ltd.
> >>
> >> Jim Tobin wrote in message <35FE89BF.DC1487CC@compuserve.com>...
> >> >Hi!
> >> >
> >> >I have a series of reports that I developed on a W95 platform for SQL
> >> >Anywhere. All these reports are working fine on my WIN95 machine. I
> >> >ported over the entire data base last weekend and several reports will
> >> >not work. The customers machine is a NT with Win95 clients. The
> >> >database is fine ( ihave the exact data the customer has).
> >> >
> >> >The error I am getting is:
> >> > Select error SQLSTATE = 37000
> >> > (Sybase) ODBC Driver Syntax error: near 'to' in station_id.
> >> >
> >> >I don't have a clue as to why this report works on my machine and not on
> >> >the other?
> >> >
> >> >Thanks, Jim
> >> >
> >
> >
> >


Jim Tobin Posted on 1998-09-15 19:34:23.0Z
Newsgroups: sybase.public.infomaker.general
Date: Tue, 15 Sep 1998 15:34:23 -0400
From: Jim Tobin <jimtobin@compuserve.com>
X-Mailer: Mozilla 4.03 [en] (Win95; I)
MIME-Version: 1.0
To: "Terry Dykstra [TeamPS]" <no_spam_tdykstra@cfol.ab.ca>
Subject: Re: Select Errors
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 29
Message-ID: <348_35FEC13F.1EC407D5@compuserve.com>
References: <348_35FE89BF.DC1487CC@compuserve.com> <348_0NvdFpM49GA.151@forums.powersoft.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6902
Article PK: 242932

I personally installed the clients on each machine so they are all the same. By
the deployment kit I assume that you mean all the dll's under \pwrs\sys32 ??

Thanks, Jim

Terry Dykstra [TeamPS] wrote:

> Is everyone using the exact same SQLAnywhere client / DB, like 5.5.0.3 ? Is
> the deployment kit the same level as your IM / PB version (e.g., 5.0.02) ?
>
> --
> Terry Dykstra [TeamPS]
> Canadian Forest Oil Ltd.
>
> Jim Tobin wrote in message <35FE89BF.DC1487CC@compuserve.com>...
> >Hi!
> >
> >I have a series of reports that I developed on a W95 platform for SQL
> >Anywhere. All these reports are working fine on my WIN95 machine. I
> >ported over the entire data base last weekend and several reports will
> >not work. The customers machine is a NT with Win95 clients. The
> >database is fine ( ihave the exact data the customer has).
> >
> >The error I am getting is:
> > Select error SQLSTATE = 37000
> > (Sybase) ODBC Driver Syntax error: near 'to' in station_id.
> >
> >I don't have a clue as to why this report works on my machine and not on
> >the other?
> >
> >Thanks, Jim
> >


Jim Tobin Posted on 1998-09-15 19:34:04.0Z
Newsgroups: sybase.public.infomaker.general
Date: Tue, 15 Sep 1998 15:34:04 -0400
From: Jim Tobin <jimtobin@compuserve.com>
X-Mailer: Mozilla 4.03 [en] (Win95; I)
MIME-Version: 1.0
To: "Terry Dykstra [TeamPS]" <no_spam_tdykstra@cfol.ab.ca>
Subject: Re: Select Errors
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 29
Message-ID: <348_35FEC12B.F1F20556@compuserve.com>
References: <348_35FE89BF.DC1487CC@compuserve.com> <348_0NvdFpM49GA.151@forums.powersoft.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6903
Article PK: 242933

I personally installed the clients on each machine so they are all the same. By
the deployment kit I assume that you mean all the dll's under \pwrs\sys32 ??

Thanks, Jim

Terry Dykstra [TeamPS] wrote:

> Is everyone using the exact same SQLAnywhere client / DB, like 5.5.0.3 ? Is
> the deployment kit the same level as your IM / PB version (e.g., 5.0.02) ?
>
> --
> Terry Dykstra [TeamPS]
> Canadian Forest Oil Ltd.
>
> Jim Tobin wrote in message <35FE89BF.DC1487CC@compuserve.com>...
> >Hi!
> >
> >I have a series of reports that I developed on a W95 platform for SQL
> >Anywhere. All these reports are working fine on my WIN95 machine. I
> >ported over the entire data base last weekend and several reports will
> >not work. The customers machine is a NT with Win95 clients. The
> >database is fine ( ihave the exact data the customer has).
> >
> >The error I am getting is:
> > Select error SQLSTATE = 37000
> > (Sybase) ODBC Driver Syntax error: near 'to' in station_id.
> >
> >I don't have a clue as to why this report works on my machine and not on
> >the other?
> >
> >Thanks, Jim
> >