You need to get the ODBC kit from Epicor and follow those instructions.
Thanks
Jeremy
[Non-text portions of this message have been removed]
Thanks
Jeremy
[Non-text portions of this message have been removed]
I'm new to this e-mail group, so if this has been covered before, sorry.
I'm trying to get access to our Vantage 5.2 Progress DB via SQL. I have
set up the Vantage client's just fine, the ODBC drivers, etc. and those
all seem to be working. From within simple tools like Microsoft Query
or SQL DTS jobs I can access the Vantage tables without a problem;
although what I really want to do is to access them via SQL directly.
I've tried the OpenRowSet command within SQL and tried to create a Link
Server within SQL and I must be missing (screwing up) the syntax
somehow. Can someone please provide me a sample SQL script to do this?
Any help would be greatly appreciated. Thanks, Don.
[Non-text portions of this message have been removed]
I'm trying to get access to our Vantage 5.2 Progress DB via SQL. I have
set up the Vantage client's just fine, the ODBC drivers, etc. and those
all seem to be working. From within simple tools like Microsoft Query
or SQL DTS jobs I can access the Vantage tables without a problem;
although what I really want to do is to access them via SQL directly.
I've tried the OpenRowSet command within SQL and tried to create a Link
Server within SQL and I must be missing (screwing up) the syntax
somehow. Can someone please provide me a sample SQL script to do this?
Any help would be greatly appreciated. Thanks, Don.
[Non-text portions of this message have been removed]
Select Jobnum, PartNum from OpenQuery([VANTAGE],'Select JobNum, PartNum from
pub.jobhead where company=''MFS'' and JobNum=''S010020''')
Its a select inside a select. Replace the name VANTAGE with your Linked
server name.
Also not that the strings are enclosed within two SINGLE quotes and not
double quotes.
Limit the 2nd Select statement as much as possible by adding as many where
clauses as possible and doing as much linking there instead of in the main
select body. This causes the recordsets to be selected and linked on the Progress
side rather than the SQL side.
HTH
Jeremy
[Non-text portions of this message have been removed]
pub.jobhead where company=''MFS'' and JobNum=''S010020''')
Its a select inside a select. Replace the name VANTAGE with your Linked
server name.
Also not that the strings are enclosed within two SINGLE quotes and not
double quotes.
Limit the 2nd Select statement as much as possible by adding as many where
clauses as possible and doing as much linking there instead of in the main
select body. This causes the recordsets to be selected and linked on the Progress
side rather than the SQL side.
HTH
Jeremy
[Non-text portions of this message have been removed]
Jeremy, thanks for the info, but can you please tell me what/how your
linked server is configured?
Don
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of jeremyrleonard@...
Sent: Monday, June 06, 2005 5:12 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] OpenRowSet or Linked Server
Select Jobnum, PartNum from OpenQuery([VANTAGE],'Select JobNum, PartNum
from
pub.jobhead where company=''MFS'' and JobNum=''S010020''')
Its a select inside a select. Replace the name VANTAGE with your Linked
server name.
Also not that the strings are enclosed within two SINGLE quotes and not
double quotes.
Limit the 2nd Select statement as much as possible by adding as many
where
clauses as possible and doing as much linking there instead of in the
main
select body. This causes the recordsets to be selected and linked on
the Progress
side rather than the SQL side.
HTH
Jeremy
[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
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
linked server is configured?
Don
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of jeremyrleonard@...
Sent: Monday, June 06, 2005 5:12 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] OpenRowSet or Linked Server
Select Jobnum, PartNum from OpenQuery([VANTAGE],'Select JobNum, PartNum
from
pub.jobhead where company=''MFS'' and JobNum=''S010020''')
Its a select inside a select. Replace the name VANTAGE with your Linked
server name.
Also not that the strings are enclosed within two SINGLE quotes and not
double quotes.
Limit the 2nd Select statement as much as possible by adding as many
where
clauses as possible and doing as much linking there instead of in the
main
select body. This causes the recordsets to be selected and linked on
the Progress
side rather than the SQL side.
HTH
Jeremy
[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
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
On the General Tab:
Provider Name=Microsoft OLE DB Provider for ODBC Driver
DateSource= {INSERT THE NAME OF YOUR ODBC DSN}
On the Security Tab:
Select "be made with this security context:"
Remote Login: sysprogress or odbcuser depending on how you have odbc
configured
With Password: sysprogress or odbcuser depending on how you have odbc
configured
[Non-text portions of this message have been removed]
Provider Name=Microsoft OLE DB Provider for ODBC Driver
DateSource= {INSERT THE NAME OF YOUR ODBC DSN}
On the Security Tab:
Select "be made with this security context:"
Remote Login: sysprogress or odbcuser depending on how you have odbc
configured
With Password: sysprogress or odbcuser depending on how you have odbc
configured
[Non-text portions of this message have been removed]
OK, this may be getting to the root cause of my problem. How do I
determine exactly how my ODBC is configured from the server standpoint?
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of jeremyrleonard@...
Sent: Tuesday, June 07, 2005 8:02 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] OpenRowSet or Linked Server
On the General Tab:
Provider Name=Microsoft OLE DB Provider for ODBC Driver
DateSource= {INSERT THE NAME OF YOUR ODBC DSN}
On the Security Tab:
Select "be made with this security context:"
Remote Login: sysprogress or odbcuser depending on how you have odbc
configured
With Password: sysprogress or odbcuser depending on how you have odbc
configured
[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
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
determine exactly how my ODBC is configured from the server standpoint?
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of jeremyrleonard@...
Sent: Tuesday, June 07, 2005 8:02 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] OpenRowSet or Linked Server
On the General Tab:
Provider Name=Microsoft OLE DB Provider for ODBC Driver
DateSource= {INSERT THE NAME OF YOUR ODBC DSN}
On the Security Tab:
Select "be made with this security context:"
Remote Login: sysprogress or odbcuser depending on how you have odbc
configured
With Password: sysprogress or odbcuser depending on how you have odbc
configured
[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
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
Set it up just like you would on a client PC.
These are my values:
DataSourceName: ProgressODBC
Host Name: MAASS04 (Vantage server name)
Port Number: 6150 (Vantage Server Port)
Database Name: mfgsys
UserID: sysprogress
Default Isolation Level: Read Uncommited
Fetch Array Size: 5000
One other piece of advice. Run the Vantage and SQL Server on the same box if
possible or directly connect them with a GB card in each server and a cross
over cable. This will dramatically increase speed. If the Vantage database
and SQL Server are not on the same machine then you will have to install the
Progress Client on the SQL Server to get the ODBC Drivers. Another piece of
advice would be to use the Merant 4.1 ODBC Drivers. If you don't already have
them you can find them in the TEMP directory that Progress uses to install a
database patch.
HTH
Jeremy
[Non-text portions of this message have been removed]
These are my values:
DataSourceName: ProgressODBC
Host Name: MAASS04 (Vantage server name)
Port Number: 6150 (Vantage Server Port)
Database Name: mfgsys
UserID: sysprogress
Default Isolation Level: Read Uncommited
Fetch Array Size: 5000
One other piece of advice. Run the Vantage and SQL Server on the same box if
possible or directly connect them with a GB card in each server and a cross
over cable. This will dramatically increase speed. If the Vantage database
and SQL Server are not on the same machine then you will have to install the
Progress Client on the SQL Server to get the ODBC Drivers. Another piece of
advice would be to use the Merant 4.1 ODBC Drivers. If you don't already have
them you can find them in the TEMP directory that Progress uses to install a
database patch.
HTH
Jeremy
[Non-text portions of this message have been removed]
Thanks for the info, but there is something different in this
environment (by the way I'm new to this environment).
The client ODBC uses a blank user id/password, so I can't specify one
for the SQL linked server. That's my problem.
Understand what your saying about having Vantage and SQL on the same
machine, although I won't have that; although they are connected via a
Gig connection. Let me know if you need more info from my side.
Thanks, Don
[Non-text portions of this message have been removed]
environment (by the way I'm new to this environment).
The client ODBC uses a blank user id/password, so I can't specify one
for the SQL linked server. That's my problem.
Understand what your saying about having Vantage and SQL on the same
machine, although I won't have that; although they are connected via a
Gig connection. Let me know if you need more info from my side.
Thanks, Don
[Non-text portions of this message have been removed]
Have you setup ODBC properly with Epicors ODBC kit? If not, you will first
need to do that. Your ODBC connection to Vantage can not/should not work with
a blank username and password.
Thanks
Jeremy
[Non-text portions of this message have been removed]
need to do that. Your ODBC connection to Vantage can not/should not work with
a blank username and password.
Thanks
Jeremy
[Non-text portions of this message have been removed]
I'll say, I don't know. From a client side I haven't, we're using the
Merant 4.0 driver. It does work. I can access any of the tables, etc.
with Microsoft query, etc. just not from within SQL; so I know the ODBC
configuration is valid on the client (where SQL is installed) and on the
server. I do know that there is a difference in what driver you use. I
know that some drivers require a user id and password and that the 4.0
(and maybe earlier versions) do not. Not sure if that helps, but that's
some more info for you.
[Non-text portions of this message have been removed]
Merant 4.0 driver. It does work. I can access any of the tables, etc.
with Microsoft query, etc. just not from within SQL; so I know the ODBC
configuration is valid on the client (where SQL is installed) and on the
server. I do know that there is a difference in what driver you use. I
know that some drivers require a user id and password and that the 4.0
(and maybe earlier versions) do not. Not sure if that helps, but that's
some more info for you.
[Non-text portions of this message have been removed]