ODBC connection (Access)

Assuming you have the ODBC user setup in Progress, go to Control Panel
--> Admin Tools --> Data Sources (ODBC) --> System DSN tab, click "Add".



Data Source Name: MFGSYS61

Description: MFGSYS61 (or whatever you want)

Host Name: servername

Port Number: 6150 (for the main DB)

Database Name: mfgsys

User ID: sysprogress (or odbcuser or whatever you have setup for your
Progress user name)



Be sure to go to the "Advanced" tab and select "READ UNCOMMITTED" and I
believe someone mentioned changing the Fetch Array to 2000.



Epicor support has a nice ODBC setup documentation available if you have
that option.





________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Chris Crosta
Sent: Wednesday, November 15, 2006 2:10 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] ODBC connection (Access)



I have tried to connect through "External Data" but when I select the
ODBC connection Access closes the screen. I think there is something
that needs to be set in the data sources either file or system DSN. I
have the Merant drivers installed and configured for Crystal and
everything works fine.

Chris

_____

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of sarah.vareschi@... <mailto:sarah.vareschi%40nypromold.com>
Sent: Wednesday, November 15, 2006 11:00 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] ODBC connection (Access)

To link to the vantage data and assuming ODBC is already set-up:

Within Access db go to 'File' -> 'Get External Data' -> 'Link Tables'
The browse will open -> at the bottom under 'files of type' -> change
this to "ODBC databases" -> then your ODBC data sources will open and
you select the one you created for vantage.

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Chris Crosta
Sent: Wednesday, November 15, 2006 1:51 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] ODBC connection (Access)

How do I make an ODBC connection to Vantage through Access? I did this
a couple of months ago on a test machine and can't remember the
connection procedure.

Vantage 6.1.533

Access 2003

TIA

Chris

[Non-text portions of this message have been removed]

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/
<http://groups.yahoo.com/group/vantage/files/> >
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
<http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages> >
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>
<http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links> >
Yahoo! Groups Links

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
How do I make an ODBC connection to Vantage through Access? I did this
a couple of months ago on a test machine and can't remember the
connection procedure.



Vantage 6.1.533

Access 2003



TIA

Chris



[Non-text portions of this message have been removed]
To link to the vantage data and assuming ODBC is already set-up:

Within Access db go to 'File' -> 'Get External Data' -> 'Link Tables'
The browse will open -> at the bottom under 'files of type' -> change
this to "ODBC databases" -> then your ODBC data sources will open and
you select the one you created for vantage.


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Chris Crosta
Sent: Wednesday, November 15, 2006 1:51 PM
To: vantage@yahoogroups.com
Subject: [Vantage] ODBC connection (Access)

How do I make an ODBC connection to Vantage through Access? I did this
a couple of months ago on a test machine and can't remember the
connection procedure.



Vantage 6.1.533

Access 2003



TIA

Chris



[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
I have tried to connect through "External Data" but when I select the
ODBC connection Access closes the screen. I think there is something
that needs to be set in the data sources either file or system DSN. I
have the Merant drivers installed and configured for Crystal and
everything works fine.



Chris



_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of sarah.vareschi@...
Sent: Wednesday, November 15, 2006 11:00 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] ODBC connection (Access)



To link to the vantage data and assuming ODBC is already set-up:

Within Access db go to 'File' -> 'Get External Data' -> 'Link Tables'
The browse will open -> at the bottom under 'files of type' -> change
this to "ODBC databases" -> then your ODBC data sources will open and
you select the one you created for vantage.

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Chris Crosta
Sent: Wednesday, November 15, 2006 1:51 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] ODBC connection (Access)

How do I make an ODBC connection to Vantage through Access? I did this
a couple of months ago on a test machine and can't remember the
connection procedure.

Vantage 6.1.533

Access 2003

TIA

Chris

[Non-text portions of this message have been removed]

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>
Yahoo! Groups Links





[Non-text portions of this message have been removed]
You can create a macro that links to Vantage, extract with query (or if
you dare - update Vantage), clear the link and work with the data
extracted. Here is the macro:

Setwarnings = off to avoid messages
Transfer Database = Within this option:
TransferType = Import or Link
DatabaseType = ODBC
DatabaseName = ODBC;DSN=mfgsys61;HOST=[Server Name];PORT=[ODBC
Port];DB=vantage;UID=sysprogress;PWD=[your odbc password]
ObjectType = Table
Source = PUB.part
Destination = PUB_part
StructureOnly = Yes - no data No - includes data.
With these options, you are importing or linking the Part table.
OpenQuery - to extract data from the table to another table, etc.
DeleteObject = PUB_part to clean the link-import.
msgbox = Complete! Click OK.
Setwarnings = on

You can associate this macro with a button and your final user does not
need to enter passwords, etc. - just click the button to extract and
work with Vantage data. I have done a lot of neat databases even to
modify data in Vantage (using committed). This works with Access 2002.

Good luck!

Mario E. Aguirre - IT Manager
Lakin General Corporation, Inc.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Chris Crosta
Sent: Wednesday, November 15, 2006 12:51 PM
To: vantage@yahoogroups.com
Subject: [Vantage] ODBC connection (Access)



How do I make an ODBC connection to Vantage through Access? I did this
a couple of months ago on a test machine and can't remember the
connection procedure.

Vantage 6.1.533

Access 2003

TIA

Chris

[Non-text portions of this message have been removed]






[Non-text portions of this message have been removed]