Hey Guys:
I saw something once that said that if the UserID and/or Password are
blank, it will prompt you... but if you put in a space, then it
doesn't prompt. Give that a shot.
D. Smith
I saw something once that said that if the UserID and/or Password are
blank, it will prompt you... but if you put in a space, then it
doesn't prompt. Give that a shot.
D. Smith
--- In vantage@y..., "H. Dale Puls" <DPuls@P...> wrote:
> John,
>
> I must be doing several things wrong. I have written a query that
works
> under Access (though I must initially go through the Progress login
when I
> first fire Access up). The query ran fine. I then changed it to a
> pass-through query and linked it to the Merant driver and logged
into
> Progress. I now get an "ODBC -call failed" when I try to run the
query.
>
> Perhaps I'm in need of a step by step to get this setup properly,
>
> Dale
>
> -----Original Message-----
> From: John [mailto:JYohann@b...]
> Sent: Tuesday, January 30, 2001 3:46 PM
> To: vantage@y...
> Subject: RE: [Vantage] How can I stop the Progress login when I use
ODBC
>
>
> Yes. You can get the Progress logon information to pass
automatically
> without the logon promt appearing by one of two methods. Method
one is a
> passthru query. You will have to enter query in SQL and set the
property
> for the ODBC link. Save the login and password info when
prompted. You
> really only need a VERY simple query to pass this info when the
Access
> session is started. After the logon info is passed you can run
queries or
> run code to link to the progress DB.
>
> The second method is to Code the link entirely. I'm not sure of the
> specifics but we did get it to work but it was more complex and time
> consuming than the first method.
>
> I am using Access 97, Merant ODBC driver 3.50, Progress 9b, Vantage
4.
>
> Feel free to email me if you have any specific questions regaurding
this
> feature.
>
> John Yohannan
> MIS, Bracalente Mfg. Co., inc.
> 215-536-3077
> <mailto:JYohann@B...>
>
>
> -----Original Message-----
> From: H. Dale Puls [mailto:DPuls@P...]
> Sent: Tuesday, January 30, 2001 1:23 PM
> To: Vantage (E-mail)
> Subject: [Vantage] How can I stop the Progress login when I use ODBC
>
>
> I am trying to automate a current stock level snapshot during an
overnight
> process. I can easily setup an Access query that would append
records to an
> external database if I could schedule the ODBC operation. When I
attempt
> the first connection I am faced with a "Logon to PROGRESS" screen
with the
> "Database" defaulted to DCDV7 instead of VANTAGE as was specified
in the
> version 4 installation. I then must select "Options" and ender "OK"
> (without making any changes on the options screen) before I can
click the
> "OK" on the "Logon to PROGRESS" screen to establish the ODBC link.
This is
> obviously not workable. Is there a way to disable the Progress
login
> procedure? My "User Name" and "Password" are blank.
>
> H. Dale Puls
>
>
> [Non-text portions of this message have been removed]
>
>
>
> To unsubscribe from this group, send an email to:
> vantage-unsubscribe@egroups.com
>
>
>
>
>
>
> To unsubscribe from this group, send an email to:
> vantage-unsubscribe@egroups.com