OT Linking SQL Server to Vantage

Yahoo Archive
1
Thanks for the info, I'll give that a whirl.

Martin Horton
Assistant Group IT Manager
PRD Holdings Ltd
DDI: 01902 639187


-----Original Message-----
From: Leonard, Jeremy [mailto:jleonard@...]
Sent: 23 April 2004 15:12
To: vantage@yahoogroups.com
Subject: RE: [Vantage] OT Linking SQL Server to Vantage


Under the General Tab:
Server Type:=Other
Provider Name: Microsoft OLE DB Provider for ODBC Driver
DataSource: "Insert the name of your ODBC DSN Here"
All other fields on this tab can be left blank.

On the security tab choose "Be made using this security context"
Then enter your ODBC username and password. For us, its the default
sysprogress/sysprogress.

Hope that helps.
Jeremy



-----Original Message-----
From: Martin Horton [mailto:martinh@...]
Sent: Friday, April 23, 2004 8:49 AM
To: Vantage (E-mail)
Subject: [Vantage] OT Linking SQL Server to Vantage


Good afternoon all.

Recently I noticed that somebody posted that they were using SQL server's
Linked Server option to connect to Vantage. I've been struggling getting
the options correct to enable me to access the progress database. Could
anyone tell me the correct settings that should be entered in order for this
to work?

TIA

Martin Horton
Assistant Group IT Manager
PRD Holdings Ltd
DDI: 01902 639187




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








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







[Non-text portions of this message have been removed]
2
Good afternoon all.

Recently I noticed that somebody posted that they were using SQL server's
Linked Server option to connect to Vantage. I've been struggling getting
the options correct to enable me to access the progress database. Could
anyone tell me the correct settings that should be entered in order for this
to work?

TIA

Martin Horton
Assistant Group IT Manager
PRD Holdings Ltd
DDI: 01902 639187
3
Under the General Tab:
Server Type:=Other
Provider Name: Microsoft OLE DB Provider for ODBC Driver
DataSource: "Insert the name of your ODBC DSN Here"
All other fields on this tab can be left blank.

On the security tab choose "Be made using this security context"
Then enter your ODBC username and password. For us, its the default sysprogress/sysprogress.

Hope that helps.
Jeremy



-----Original Message-----
From: Martin Horton [mailto:martinh@...]
Sent: Friday, April 23, 2004 8:49 AM
To: Vantage (E-mail)
Subject: [Vantage] OT Linking SQL Server to Vantage


Good afternoon all.

Recently I noticed that somebody posted that they were using SQL server's
Linked Server option to connect to Vantage. I've been struggling getting
the options correct to enable me to access the progress database. Could
anyone tell me the correct settings that should be entered in order for this
to work?

TIA

Martin Horton
Assistant Group IT Manager
PRD Holdings Ltd
DDI: 01902 639187




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