How can I stop the Progress login when I use ODBC

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


--- 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
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]
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@...>


-----Original Message-----
From: H. Dale Puls [mailto:DPuls@...]
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
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@...]
Sent: Tuesday, January 30, 2001 3:46 PM
To: vantage@yahoogroups.com
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@...>


-----Original Message-----
From: H. Dale Puls [mailto:DPuls@...]
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