Vantage with an MS SQL db, still able to make OpenEdge ODBC conn

Yahoo Archive
1
I converted a bunch of ODBC reports from a Progress database (Vantage
6.1) to an SQL database (Epicor 9.05). Most of the queries were
identical but there was simple mechanical changes (eg removing the PUB
schema reference). You mention MS Access -- this is query to a linked
Progress database: "SELECT PUB_Part.PartNum, PUB_Part.PartDescription
FROM PUB_Part". You can either edit this to: "SELECT Part.PartNum,
Part.PartDescription FROM Part", or you can create lots of SQL views so
PUB_Part is the same as Part.



Because of my version change I also had schema changes to handle, but
you shouldn't encounter any of those if you're staying on the same
version. There are a couple of new columns in most tables (eg
PROGRESS_RECID) but you can ignore them.



Brian.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Clive
Sent: Thursday, May 19, 2011 12:38 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Vantage with an MS SQL db, still able to make
OpenEdge ODBC connection ?





OK.

If the new MS SQL ODBC connections use exactly the same DSN name as the
prior OpenEdge ODBC connections on the computers would any Access apps
etc work as they used to without any alterations ? (table names and
fields should be the same ?).

(In my 3 1/2 year experiance with Vantage 8.x I've very rarely used an
ODBC connection to an MS SQL server)

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
Michael Barry <mbarry@...> wrote:
>
> No, the Access apps would have to change their data source to SQL
Server. In an SQL implementation Open Edge only runs Schema Handlers
which is essentially meta data about the schema that OE uses to
communicate the data structure to the business object layer.
>
> Michael Barry
> Aspacia Systems Inc
> 866.566.9600
> 312.803.0730 fax
> http://www.aspacia.com/
>
> On May 19, 2011, at 7:39 AM, Clive wrote:
>
> > Due to a job change I've gone from working in an environment where
Vantage was using MSL SQL for storing its db to one where the db is in
Progress, and I have a question that hopefully someone can answer ?.
> >
> > If in my new environment we changed the db over to MS SQL (I know
the pros and cons), with of course OpenEdge etc still on the server, on
a client computer that has OpenEdge installed so that it could make ODBC
calls to the Progress db will this still work as expected/as it used to
?.
> >
> > Even though an MS SQL db is used your still making OpenEdge ODBC
calls to the server, so the client computers Access apps written using
OpenEdge ODBC connections will still work ?.
> >
> > Thanks.
> >
> >
>
>
>
> [Non-text portions of this message have been removed]
>



[Non-text portions of this message have been removed]
2
Due to a job change I've gone from working in an environment where Vantage was using MSL SQL for storing its db to one where the db is in Progress, and I have a question that hopefully someone can answer ?.

If in my new environment we changed the db over to MS SQL (I know the pros and cons), with of course OpenEdge etc still on the server, on a client computer that has OpenEdge installed so that it could make ODBC calls to the Progress db will this still work as expected/as it used to ?.

Even though an MS SQL db is used your still making OpenEdge ODBC calls to the server, so the client computers Access apps written using OpenEdge ODBC connections will still work ?.

Thanks.
3
No, the Access apps would have to change their data source to SQL Server. In an SQL implementation Open Edge only runs Schema Handlers which is essentially meta data about the schema that OE uses to communicate the data structure to the business object layer.

Michael Barry
Aspacia Systems Inc
866.566.9600
312.803.0730 fax
http://www.aspacia.com/

On May 19, 2011, at 7:39 AM, Clive wrote:

> Due to a job change I've gone from working in an environment where Vantage was using MSL SQL for storing its db to one where the db is in Progress, and I have a question that hopefully someone can answer ?.
>
> If in my new environment we changed the db over to MS SQL (I know the pros and cons), with of course OpenEdge etc still on the server, on a client computer that has OpenEdge installed so that it could make ODBC calls to the Progress db will this still work as expected/as it used to ?.
>
> Even though an MS SQL db is used your still making OpenEdge ODBC calls to the server, so the client computers Access apps written using OpenEdge ODBC connections will still work ?.
>
> Thanks.
>
>



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

If the new MS SQL ODBC connections use exactly the same DSN name as the prior OpenEdge ODBC connections on the computers would any Access apps etc work as they used to without any alterations ? (table names and fields should be the same ?).

(In my 3 1/2 year experiance with Vantage 8.x I've very rarely used an ODBC connection to an MS SQL server)

--- In vantage@yahoogroups.com, Michael Barry <mbarry@...> wrote:
>
> No, the Access apps would have to change their data source to SQL Server. In an SQL implementation Open Edge only runs Schema Handlers which is essentially meta data about the schema that OE uses to communicate the data structure to the business object layer.
>
> Michael Barry
> Aspacia Systems Inc
> 866.566.9600
> 312.803.0730 fax
> http://www.aspacia.com/
>
> On May 19, 2011, at 7:39 AM, Clive wrote:
>
> > Due to a job change I've gone from working in an environment where Vantage was using MSL SQL for storing its db to one where the db is in Progress, and I have a question that hopefully someone can answer ?.
> >
> > If in my new environment we changed the db over to MS SQL (I know the pros and cons), with of course OpenEdge etc still on the server, on a client computer that has OpenEdge installed so that it could make ODBC calls to the Progress db will this still work as expected/as it used to ?.
> >
> > Even though an MS SQL db is used your still making OpenEdge ODBC calls to the server, so the client computers Access apps written using OpenEdge ODBC connections will still work ?.
> >
> > Thanks.
> >
> >
>
>
>
> [Non-text portions of this message have been removed]
>