Changing Vantage Server to use Remote MSSQL Database

system · October 7, 2009, 9:16am

Yes, just setup a new DSN, change your mfgsys.pf file.

Joe Luster
Network Administrator
Cold Jet, LLC
455 Wards Corner Road
Loveland, Ohio 45140
USA
+1 513-831-3211 x308 (office)
+1 513-831-1209 (fax)
www.coldjet.com<http://www.coldjet.com>
[cid:image001.jpg@...9FB720]
Setting industry standards in dry ice technology and solutions for over 20 years.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Brian W. Spolarich
Sent: Wednesday, October 07, 2009 9:02 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] RE: Changing Vantage Server to use Remote MSSQL Database

Right, but once I've identified the DSN I could change it to point to a different server, right?

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
bspolarich@...<mailto:bspolarich%40advancedphotonix.com> ~ 734-864-5618 ~ www.advancedphotonix.com

-----Original Message-----
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Joe Luster
Sent: Wednesday, October 07, 2009 8:55 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] RE: Changing Vantage Server to use Remote MSSQL Database

The DSN name needs to be the same as the one referenced in your mfgsys.pf file. See below:

-Dsrv skip_schema_check,PRGRS_CONNECT,DSN=MFGSYS803,TXN_ISOLATION,1

Joe Luster
Network Administrator
Cold Jet, LLC
455 Wards Corner Road
Loveland, Ohio 45140
USA
+1 513-831-3211 x308 (office)
+1 513-831-1209 (fax)
www.coldjet.com<http://www.coldjet.com>
[cid:image001.jpg@01CA472A.F8532EC0<mailto:image001.jpg%4001CA472A.F8532EC0>]
Setting industry standards in dry ice technology and solutions for over 20 years.

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Brian W. Spolarich
Sent: Wednesday, October 07, 2009 8:31 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Changing Vantage Server to use Remote MSSQL Database

Am I correct in understanding that the link between the Progress
schema holder database and MSSQL is via the System DSN with the same
name as the database? i.e. the MfgSys803 System DSN tells Progress how
to talk to the 'real' database?

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@...<mailto:bspolarich%40advancedphotonix.com><mailto:bspolarich%40advancedphotonix.com>
<mailto:bspolarich@...<mailto:bspolarich%40advancedphotonix.com><mailto:bspolarich%40advancedphotonix.com>> ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>

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

[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/linksYahoo! Groups Links

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

system · October 7, 2009, 8:31am

Am I correct in understanding that the link between the Progress
schema holder database and MSSQL is via the System DSN with the same
name as the database? i.e. the MfgSys803 System DSN tells Progress how
to talk to the 'real' database?

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@...
<mailto:bspolarich@...> ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>

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

system · October 7, 2009, 8:54am

The DSN name needs to be the same as the one referenced in your mfgsys.pf file. See below:

-Dsrv skip_schema_check,PRGRS_CONNECT,DSN=MFGSYS803,TXN_ISOLATION,1

Joe Luster
Network Administrator
Cold Jet, LLC
455 Wards Corner Road
Loveland, Ohio 45140
USA
+1 513-831-3211 x308 (office)
+1 513-831-1209 (fax)
www.coldjet.com<http://www.coldjet.com>
[cid:image001.jpg@01CA472A.F8532EC0]
Setting industry standards in dry ice technology and solutions for over 20 years.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Brian W. Spolarich
Sent: Wednesday, October 07, 2009 8:31 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Changing Vantage Server to use Remote MSSQL Database

Am I correct in understanding that the link between the Progress
schema holder database and MSSQL is via the System DSN with the same
name as the database? i.e. the MfgSys803 System DSN tells Progress how
to talk to the 'real' database?

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@...<mailto:bspolarich%40advancedphotonix.com>
<mailto:bspolarich@...<mailto:bspolarich%40advancedphotonix.com>> ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>

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

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

system · October 7, 2009, 9:02am

Right, but once I've identified the DSN I could change it to point to a different server, right?

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
Â Â Â Â bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Joe Luster
Sent: Wednesday, October 07, 2009 8:55 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Changing Vantage Server to use Remote MSSQL Database

The DSN name needs to be the same as the one referenced in your mfgsys.pf file. See below:

-Dsrv skip_schema_check,PRGRS_CONNECT,DSN=MFGSYS803,TXN_ISOLATION,1

Joe Luster
Network Administrator
Cold Jet, LLC
455 Wards Corner Road
Loveland, Ohio 45140
USA
+1 513-831-3211 x308 (office)
+1 513-831-1209 (fax)
www.coldjet.com<http://www.coldjet.com>
[cid:image001.jpg@01CA472A.F8532EC0]
Setting industry standards in dry ice technology and solutions for over 20 years.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Brian W. Spolarich
Sent: Wednesday, October 07, 2009 8:31 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Changing Vantage Server to use Remote MSSQL Database

Am I correct in understanding that the link between the Progress
schema holder database and MSSQL is via the System DSN with the same
name as the database? i.e. the MfgSys803 System DSN tells Progress how
to talk to the 'real' database?

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@...<mailto:bspolarich%40advancedphotonix.com>
<mailto:bspolarich@...<mailto:bspolarich%40advancedphotonix.com>> ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>

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

[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/linksYahoo! Groups Links