[ODBC - Prgs 9.1d] DSN with Selected (limited) tables

Yahoo Archive
1
Thanks Nigel and Lynn. I just found Answerbook 3748MPS about the password part. I'll check the FTP site for the ODBC kit for 6.10 and see about setting up the selected tables part.
-Todd C.

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Lynn
Sent: Monday, November 24, 2008 9:30 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: [ODBC - Prgs 9.1d] DSN with Selected (limited) tables


AnswerBook # 5947MPS "Bypass the login ID and prompt for a Crystal
Report using an ODBC connection"

AnswerBook # 1266BRK "ODBC Instructions for setting up Progress ODBC
connection - V8.03.4xx"

Both are on the Epicor Website under "my EpicWeb"

This is the link:

https://epicweb.epicor.com/Support/MyEPICweb/Pages/SearchAnswerbooks.a
spx

Lynn

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Todd Caughey <caugheyt@...> wrote:
>
> We have implemented a 3rd party Corrective Action system that
accesses 4 tables in Vantage via ODBC. I would like to lock this
down. The current ODBC DSN is wide open. I saw mention in a message
thread here a couple weeks ago of a means to select and limit a DSN
to specific tables. Also, if possible, at the same time I would like
to bolt in, or eliminate the need for, a password. I believe there
is documentation on EpicWeb for this. Does anyone know the document
number or FTP location?
> Thanks,
> Todd Caughey
> Harvey Vogel Mfg. Co.
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
2
We have implemented a 3rd party Corrective Action system that accesses 4 tables in Vantage via ODBC. I would like to lock this down. The current ODBC DSN is wide open. I saw mention in a message thread here a couple weeks ago of a means to select and limit a DSN to specific tables. Also, if possible, at the same time I would like to bolt in, or eliminate the need for, a password. I believe there is documentation on EpicWeb for this. Does anyone know the document number or FTP location?
Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.


[Non-text portions of this message have been removed]
3
Hi Todd,

The ODBC kits give details on how to setup new users on the database
and how to give them access to tables (at least the 8.03.400 kit
does).

The kit for 6.1 can be downloaded from ftp://ftpmpls.epicor.com./
vantage/ODBC/. If it's now in that, try the .400 one.


Nigel.




--- In vantage@yahoogroups.com, Todd Caughey <caugheyt@...> wrote:
>
> We have implemented a 3rd party Corrective Action system that
accesses 4 tables in Vantage via ODBC. I would like to lock this
down. The current ODBC DSN is wide open. I saw mention in a message
thread here a couple weeks ago of a means to select and limit a DSN
to specific tables. Also, if possible, at the same time I would like
to bolt in, or eliminate the need for, a password. I believe there
is documentation on EpicWeb for this. Does anyone know the document
number or FTP location?
> Thanks,
> Todd Caughey
> Harvey Vogel Mfg. Co.
>
>
> [Non-text portions of this message have been removed]
>
4
AnswerBook # 5947MPS "Bypass the login ID and prompt for a Crystal
Report using an ODBC connection"

AnswerBook # 1266BRK "ODBC Instructions for setting up Progress ODBC
connection - V8.03.4xx"

Both are on the Epicor Website under "my EpicWeb"

This is the link:

https://epicweb.epicor.com/Support/MyEPICweb/Pages/SearchAnswerbooks.a
spx


Lynn

--- In vantage@yahoogroups.com, Todd Caughey <caugheyt@...> wrote:
>
> We have implemented a 3rd party Corrective Action system that
accesses 4 tables in Vantage via ODBC. I would like to lock this
down. The current ODBC DSN is wide open. I saw mention in a message
thread here a couple weeks ago of a means to select and limit a DSN
to specific tables. Also, if possible, at the same time I would like
to bolt in, or eliminate the need for, a password. I believe there
is documentation on EpicWeb for this. Does anyone know the document
number or FTP location?
> Thanks,
> Todd Caughey
> Harvey Vogel Mfg. Co.
>
>
> [Non-text portions of this message have been removed]
>