🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.lang.basic.visual.misc
Article #293

Re: Scheduling a VB app as a NT AT job?

#293
From: Jeffrey S. Kirkham
Date: Tue, 28 Nov 1995 00:00
38 lines
2238 bytes
In article <49emv6$cqr@stella.tip.net> orjan.esperi@boab.se (Orjan Esperi) writes:
>From: orjan.esperi@boab.se (Orjan Esperi)
>Subject: Re: Scheduling a VB app as a NT AT job?
>Date: Tue, 28 Nov 1995 10:06:56 GMT

>Jeffrey, thank you for responding!

>> Check the ODBC source. The problem maybe your 16bit app attempting to connect 
>> to a 16bit ODBC sorce not a 32bit ODBC source. You didn't say if the 16bit app 
>> works WITHOUT sheduler.

>The app works fine when run interactively (without Schedule). It's
>using a 32-bit ODBC source (sql server).

>The app starts when run using Schedule (System account). But it can't
>connect to the ODBC source.

>The app won't even start when using Schedule (User account).

>My problem seem to be rather unique or there is noone out there having
>a solution to it.

>I will post my solution, if I find one...

>-- Orjan
>Orjan Esperi
>Business Objects AB
>Zachaus Grans 7
>S-451 30 UDDEVALLA
>SWEDEN

I'm not giving up that easy. Remember ODBC sources are stored under the 
current user. Make sure the scheduler user has the same ODBC source setup. 
Also, How are you handling security on the SQL server? IS the app hardcoded 
with password in the connect property?

Keep in touch with me on this. I want to solve it to.
JK
Technical Details
Message-ID: <kirkham.62.0060AE00@kirkham.seanet.com>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <499u21$svi@stella.tip.net> <kirkham.47.00322740@kirkham.seanet.com> <49emv6$cqr@stella.tip.net>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 110e3b,23ffa10f67a85e66
X-Google-Attributes: gid110e3b,public
X-Google-Thread: 105df1,23ffa10f67a85e66
X-Google-Attributes: gid105df1,public
X-Google-Thread: 10dffc,23ffa10f67a85e66
X-Google-Attributes: gid10dffc,public
X-Google-Thread: 113dfb,23ffa10f67a85e66
X-Google-Attributes: gid113dfb,public
X-Google-Thread: 1614a4,23ffa10f67a85e66
X-Google-Attributes: gid1614a4,public
From: kirkham@kirkham.seanet.com (Jeffrey S. Kirkham)
Subject: Re: Scheduling a VB app as a NT AT job?
Date: 1995/11/28
Message-ID: <kirkham.62.0060AE00@kirkham.seanet.com>
X-Deja-AN: 120392035
references: <499u21$svi@stella.tip.net> <kirkham.47.00322740@kirkham.seanet.com> <49emv6$cqr@stella.tip.net>
organization: OSD, Inc.
newsgroups: comp.lang.basic.visual.misc,cern.windows-nt,comp.os.ms-windows.programmer.misc,comp.os.ms-windows.programmer.win32,fj.os.windows.nt.prog