Vantage 8 OpenEdge Studio with MS SQL

The first -db is implied so isn't necessary.

The missing items were installing OpenEdge DataServer MS SQL Svr (along with OpenEdge Studio and OpenEdge Enterprise RDBMS) and the ODBC link with driver SQL Server.

From: eshmkh48 <eshmkh48@...>
Date: Fri Jun 30 14:42:33 CDT 2006
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Vantage 8 OpenEdge Studio with MS SQL


The only thinig I see in your parameter is the lack of -db before
the schema holder so it would look like

-db mfgtestsh -ld mfgsyssh -H server_name -S service_number
-db mfgtest80 -ld mfgsys80 ... -dt MSS
-Dsrv PRGRS_CONNECT etc

--- In vantage@yahoogroups.com, "Chris Robisch" <blue.wine@...>
wrote:
>
> OpenEdge Studio should be able to connect to the MS-SQL database
> through the Progress Schema Holder. I have too many 4GL programs
not to
> take advantage of this. But I'm getting the following error:
>
> Cannot access MSS with current CONFIG file. (1246)
> Failed to connect to the MSS database. (6142)
>
> Here's the batch file:
> set dlc=C:\Progress\OpenEdge100B
> start %dlc%\bin\prowin32.exe u:\test80\db\mfgtestsh -ld mfgsyssh -
p
> _ab.p -Mm 1024 -N TCP -H bmsmrp -S 8020 -db MfgTest80 -ld MfgSys -
dt
> MSS -Dsrv PRGRS_CONNECT,DSN=MFGTEST80,TXN_ISOLATION,1
>
> Any ideas?
>
OpenEdge Studio should be able to connect to the MS-SQL database
through the Progress Schema Holder. I have too many 4GL programs not to
take advantage of this. But I'm getting the following error:

Cannot access MSS with current CONFIG file. (1246)
Failed to connect to the MSS database. (6142)

Here's the batch file:
set dlc=C:\Progress\OpenEdge100B
start %dlc%\bin\prowin32.exe u:\test80\db\mfgtestsh -ld mfgsyssh -p
_ab.p -Mm 1024 -N TCP -H bmsmrp -S 8020 -db MfgTest80 -ld MfgSys -dt
MSS -Dsrv PRGRS_CONNECT,DSN=MFGTEST80,TXN_ISOLATION,1

Any ideas?
The only thinig I see in your parameter is the lack of -db before
the schema holder so it would look like

-db mfgtestsh -ld mfgsyssh -H server_name -S service_number
-db mfgtest80 -ld mfgsys80 ... -dt MSS
-Dsrv PRGRS_CONNECT etc

--- In vantage@yahoogroups.com, "Chris Robisch" <blue.wine@...>
wrote:
>
> OpenEdge Studio should be able to connect to the MS-SQL database
> through the Progress Schema Holder. I have too many 4GL programs
not to
> take advantage of this. But I'm getting the following error:
>
> Cannot access MSS with current CONFIG file. (1246)
> Failed to connect to the MSS database. (6142)
>
> Here's the batch file:
> set dlc=C:\Progress\OpenEdge100B
> start %dlc%\bin\prowin32.exe u:\test80\db\mfgtestsh -ld mfgsyssh -
p
> _ab.p -Mm 1024 -N TCP -H bmsmrp -S 8020 -db MfgTest80 -ld MfgSys -
dt
> MSS -Dsrv PRGRS_CONNECT,DSN=MFGTEST80,TXN_ISOLATION,1
>
> Any ideas?
>