headers
Ray Wurlod | 3 Jan 2005 00:01
Favicon

RE: [U2] BCI Connect

A couple of small things.

You didn't need SQLNumResultCols, because you already knew - from your SELECT statement - that there would
be three columns in the result set.

And you didn't need to unbind variables; this will happen anyway when you use SQLFreeStmt with SQL.DROP as
the second argument.

I would have liked to have seen your CHECK.STATUS subroutine; this is usually the critical part. 
Similarly, your main (fetch) loop does not exit on error - you really want it to do so.

ErrCode = SQLFetch(hStmt)
LOOP
WHILE ErrCode <> SQL.NO.DATA.FOUND AND ErrCODE <> SQL.ERROR
   CRT SQLDATA(1) : " " : SQLDATA(2) : " " : SQLDATA(3)
   ErrCode = SQLFetch(hStmt)
REPEAT
IF ErrCode = SQL.ERROR THEN GOSUB CHECK.STATUS

Hope this helps; I've deliberately top-posted so that you can compare what I've suggested with your
admittedly working code.

----- Original Message -----
From: graham.forbes <at> syntegra.com
To: u2-users <at> listserver.u2ug.org
Subject: RE: [U2] BCI Connect
Date: Fri, 31 Dec 2004 07:55:00 -0000

> 
> Ray & Richard
(Continue reading)

Permalink | Reply | 0 comments |
headers
Mike Dallaire | 3 Jan 2005 20:50
Favicon

[U2] printer error

UV 10.1.3
Windows 2003 server

We have a customer just going live and they are having problems getting
UniVerse to recognize the printers.  When we run SPOOL -LIST we get an error
"EnumPrinters failed with error 87."  The error seems to occur as soon as it
hits one of their branch office printers.  (All the printers are set up as
network printers on the UniVerse server)   Printers at their home office are
being found ok.

I have tried finding something on this error, without any luck.  It appears
IBM is only available for down systems today.  So, if any one is out there
today (it has been pretty quiet) and has any ideas or experience with this,
I would greatly appreciate hearing from you.

Thanks in advance,

Mike Dallaire
Mortgage Builder Software Inc.
(248) 208-3223 ext. 103
miked <at> mortgagebuilder.com
www.mortgagebuilder.com
-------
u2-users mailing list
u2-users <at> listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
Permalink | Reply | 2 comments |
headers
karlp | 3 Jan 2005 21:41

Re: [U2] printer error

<quote who="Mike Dallaire">
> UV 10.1.3
> Windows 2003 server
>
> We have a customer just going live and they are having problems getting
> UniVerse to recognize the printers.  When we run SPOOL -LIST we get an
> error
> "EnumPrinters failed with error 87."  The error seems to occur as soon as
> it
> hits one of their branch office printers.  (All the printers are set up as
> network printers on the UniVerse server)   Printers at their home office
> are
> being found ok.

I have seen similar errors when the remote printers are setup as 'remote'
printers on the server. Try setting them up as local printers by 'creating
a port' for them using the TCP/IP option. If that's how they are setup
now, try creating a shortcut to one of the printers and then list that
printer in uniVerse. It's been a while since I worked on any Microsoft
iteration of U2, so my memory may be foggier than I would like to admit...
50 years old in a week and feeling it.

Karl

>
> I have tried finding something on this error, without any luck.  It
> appears
> IBM is only available for down systems today.  So, if any one is out there
> today (it has been pretty quiet) and has any ideas or experience with
> this,
(Continue reading)

Permalink | Reply | 1 comment |
headers
GarryS | 3 Jan 2005 22:11

RE: [U2] printer error

How is the remote office connected? It sounds like a network routing
problem. Can you ping your printers? 

> -----Original Message-----
> From:	Mike Dallaire [SMTP:miked <at> mortgagebuilder.com]
> Sent:	Monday, January 03, 2005 11:50 AM
> To:	U2 Users List (E-mail)
> Subject:	[U2] printer error
> 
> UV 10.1.3
> Windows 2003 server
> 
> We have a customer just going live and they are having problems getting
> UniVerse to recognize the printers.  When we run SPOOL -LIST we get an
> error
> "EnumPrinters failed with error 87."  The error seems to occur as soon as
> it
> hits one of their branch office printers.  (All the printers are set up as
> network printers on the UniVerse server)   Printers at their home office
> are
> being found ok.
> 
> I have tried finding something on this error, without any luck.  It
> appears
> IBM is only available for down systems today.  So, if any one is out there
> today (it has been pretty quiet) and has any ideas or experience with
> this,
> I would greatly appreciate hearing from you.
> 
> Thanks in advance,
(Continue reading)

Permalink | Reply | 1 comment |
headers
Mike Dallaire | 3 Jan 2005 23:02
Favicon

RE: [U2] printer error

Karl,
I was going to try that earlier, but they have the operating system
restricted to only allow network printers.  They are changing it for me, but
I have to wait until tomorrow (they can't reboot until later tonight).  I
will let you know if it makes a difference.
Mike

-----Original Message-----
From: owner-u2-users <at> listserver.u2ug.org
[mailto:owner-u2-users <at> listserver.u2ug.org]On Behalf Of
karlp <at> atsindustrial.com
Sent: Monday, January 03, 2005 3:42 PM
To: u2-users <at> listserver.u2ug.org
Subject: Re: [U2] printer error

<quote who="Mike Dallaire">
> UV 10.1.3
> Windows 2003 server
>
> We have a customer just going live and they are having problems getting
> UniVerse to recognize the printers.  When we run SPOOL -LIST we get an
> error
> "EnumPrinters failed with error 87."  The error seems to occur as soon as
> it
> hits one of their branch office printers.  (All the printers are set up as
> network printers on the UniVerse server)   Printers at their home office
> are
> being found ok.

I have seen similar errors when the remote printers are setup as 'remote'
(Continue reading)

Permalink | Reply | 0 comments |
headers
Mike Dallaire | 3 Jan 2005 23:00
Favicon

RE: [U2] printer error

The branches are connected using router to router vpn connections.  I can
ping the printers and I can print word docs to them, from the UniVerse
server.  My first thought was a network issue also, but now I am not so
sure.  The printers seem to work fine outside of UniVerse and according to
the techs at our customer's site.  These printers were working earlier in
the day.

Is there some unknown limit to the number of printers UniVerse can handle?

-----Original Message-----
From: owner-u2-users <at> listserver.u2ug.org
[mailto:owner-u2-users <at> listserver.u2ug.org]On Behalf Of
GarryS <at> CharlesMcMurray.com
Sent: Monday, January 03, 2005 4:12 PM
To: u2-users <at> listserver.u2ug.org
Subject: RE: [U2] printer error

How is the remote office connected? It sounds like a network routing
problem. Can you ping your printers?

> -----Original Message-----
> From:	Mike Dallaire [SMTP:miked <at> mortgagebuilder.com]
> Sent:	Monday, January 03, 2005 11:50 AM
> To:	U2 Users List (E-mail)
> Subject:	[U2] printer error
>
> UV 10.1.3
> Windows 2003 server
>
> We have a customer just going live and they are having problems getting
(Continue reading)

Permalink | Reply | 0 comments |
headers
Marilyn Hilb | 3 Jan 2005 22:57

RE: [U2] printer error

I recall when on Windows 2000 the printer name could not have spaces in it when talking to it via Unidata. I
don't recall if it was just the share name or the actual printer name. 

Thanks,

Marilyn A. Hilb 
Value Part, Inc
Direct: 847-918-6099
Fax: 847-367-1892
hilbmarilyn <at> valuepart.com
www.valuepart.com

 -----Original Message-----
From: 	GarryS <at> CharlesMcMurray.com [mailto:GarryS <at> CharlesMcMurray.com] 
Sent:	Monday, January 03, 2005 3:12 PM
To:	u2-users <at> listserver.u2ug.org
Subject:	RE: [U2] printer error

How is the remote office connected? It sounds like a network routing
problem. Can you ping your printers? 

> -----Original Message-----
> From:	Mike Dallaire [SMTP:miked <at> mortgagebuilder.com]
> Sent:	Monday, January 03, 2005 11:50 AM
> To:	U2 Users List (E-mail)
> Subject:	[U2] printer error
> 
> UV 10.1.3
> Windows 2003 server
>
(Continue reading)

Permalink | Reply | 1 comment |
headers
Mike Dallaire | 3 Jan 2005 23:34
Favicon

RE: [U2] printer error

It is the same for UniVerse.  However, it is not even getting to the point
where it might throw an error on the remote printers.  It errors out as soon
as it comes to the first one.
Mike

-----Original Message-----
From: owner-u2-users <at> listserver.u2ug.org
[mailto:owner-u2-users <at> listserver.u2ug.org]On Behalf Of Marilyn Hilb
Sent: Monday, January 03, 2005 4:57 PM
To: u2-users <at> listserver.u2ug.org
Subject: RE: [U2] printer error

I recall when on Windows 2000 the printer name could not have spaces in it
when talking to it via Unidata. I don't recall if it was just the share name
or the actual printer name.

Thanks,

Marilyn A. Hilb
Value Part, Inc
Direct: 847-918-6099
Fax: 847-367-1892
hilbmarilyn <at> valuepart.com
www.valuepart.com

 -----Original Message-----
From: 	GarryS <at> CharlesMcMurray.com [mailto:GarryS <at> CharlesMcMurray.com]
Sent:	Monday, January 03, 2005 3:12 PM
To:	u2-users <at> listserver.u2ug.org
Subject:	RE: [U2] printer error
(Continue reading)

Permalink | Reply | 0 comments |
headers
Simon Adams | 4 Jan 2005 05:47
Picon
Favicon

[U2] free txt-to-pdf converter

Does anyone know of a FREE txt-to-pdf converter that can be run from a command
line?
I'm wanting to convert files in the &PH& to a PDF format.
(Running UniVerse 10 on Windows)

*****************************************************************************
******
This e-mail, including any attachments to it, may contain confidential and/or
personal information.
If you have received this e-mail in error, you must not copy, distribute, or
disclose it, use or take any action
based on the information contained within it.

Please notify the sender immediately by return e-mail of the error and then
delete the original e-mail.

The information contained within this e-mail may be solely the opinion of the
sender and may not necessarily
reflect the position, beliefs or opinions of Salmat on any issue.

This email has been swept for the presence of computer viruses known to
Salmat's anti-virus systems.

For more information, visit our website at  www.salmat.com.au.
*****************************************************************************
******
-------
u2-users mailing list
u2-users <at> listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
(Continue reading)

Permalink | Reply | 1 comment |
headers
Bruce Nichol | 4 Jan 2005 07:12
Picon

Re: [U2] free txt-to-pdf converter

Goo'day, Simon,

Have a look at PrimoPDF (www.primopdf.com)   This sets up as  a printer 
under any 32bit Windows

At 15:47 04/01/05 +1100, you wrote:

>Does anyone know of a FREE txt-to-pdf converter that can be run from a command
>line?
>I'm wanting to convert files in the &PH& to a PDF format.
>(Running UniVerse 10 on Windows)
>
>--
>No virus found in this incoming message.
>Checked by AVG Anti-Virus.
>Version: 7.0.299 / Virus Database: 265.6.8 - Release Date: 03/01/05

Regards,

Bruce Nichol
Talon Computer Services
ALBURY        NSW     2640
Australia

http://www.taloncs.com.au

Tel: +61 (0)411149636
Fax: +61 (0)260232119

If it ain't broke, fix it till it is!
(Continue reading)

Permalink | Reply | 0 comments |

Gmane