Data access

system · January 13, 2006, 12:24pm

I think that you can connect to progress using VB.Net.

Although I did not try this VB.NET, I wrote a program in VB6 that
connects to progress db using ODBC.

The connection string is "Provider=MSDASQL.1;Persist Security
Info=False;User ID=sysprogress;Password=sysprogress;Data
Source=Your_DataSource_In_ODBC

-----Original Message-----
From: Mike Haynes [mailto:mikeh@...]
Sent: Friday, January 13, 2006 12:08 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Data access

Yes, I did. But, VB.NET will only connect to SQL and JET
databases. Must be some kind of internal restriction. I guess they
want you to pony up for the full Visual Studio product.

Mike

--- In vantage@yahoogroups.com, "Gerard Wadman" <gwadman@s...> wrote:
>
> Did you try using a DSN connection string in VB.Net?
>
> Ie:
>
DSN=Vantage;HOST=servername;PORT=####;DB=mfgsys;UID=username;PWD=pass
wor
> d
>
>
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of mikehaynes99
> Sent: Thursday, January 12, 2006 10:47 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Data access
>
>
>
> More on my problem. I have a fair amount of experience using
Access
> to view/manipulate data so getting to the Vantage tables isn't
much
> of a problem. Yes, I did run into the > 32 indexes on the
customer
> file. I'll look into the suggestion of a 'view'. My original
> problem which I wrote about here was that I couldn't view the
table
> data from the invchead and invcdet tables. I kept getting an ODBC
> fail message when I tried to peek into the table data with
a 'select
> *' statement. With much experimentation I've determined that
there
> is a field within the table that causes the error. If I stay away
> from the repsplit field then I can select and view all other
fields
> in the header table, at least. I've not tried that in the
detail.
> Since I've discovered that I can get to 99% of the data I can
finish
> my project which is developing an Access application to track and
> pay commissions to our salespeople. Vantage doesn't work for us
in
> that area. I also tried to use VB .NET but was disappointed to
> learn that that product will only access SQL and Jet databases.
> Does anyone know if the full Visual Studio .NET product would
> connect to Progress via ODBC?
> Thanks to all who responded.
>
> Mike
> Sure Alloy Steel Corp.
>
>
>
> --- In vantage@yahoogroups.com, "Brian Stenglein"
<bstenglein@c...>
> wrote:
> >
> > Mike,
> >
> > Welcome to the board. We are still using 6.1, but I use Access
a
> > lot. We had problems with using the Customer Table, because of
> too
> > many indexes, so we had to create a view, as mentioned
> previously.
> > I'm not sure if this is the problem you are having, but if it
is,
> > Tech Support will have instructions for you on setting up the
> view,
> > it was pretty easy at least it was for 6.1.
> >
> > If the problem you are having is not due to too many indexes,
can
> you
> > elaborate on the error? Have you talked to support about it?
I'm
> > really interested in hearing more about the problem and solution
> that
> > you come up with.
> >
> > Thanks,
> >
> > Brian Stenglein
> > Clow Stamping Co.
> >
> >
> > --- In vantage@yahoogroups.com, "mikehaynes99" <mikeh@s...>
wrote:
> > >
> > > Hello All,
> > > First time poster and brand new 8.0 user here. I have only
> > recently
> > > discovered this resource and I have lots of Vantage questions
> but
> > the
> > > one most pressing for me right now is how do all of you (if
any
> of
> > you
> > > do) get to your Vantage tables outside of Vantage? I have
used
> > > Microsoft Access to view some table data but this doesn't work
> for
> > all
> > > the tables. Specifically, I need to get to the Invoice Header
> and
> > > Detail tables but due to some peculiar data structure I get an
> > error
> > > when I try to link to these tables.
> > >
> > > Maybe I already have the necessary tools and I just don't know
> it
> > > because our administrator back office type training was non-
> > existant.
> > > Can anybody help me with this and/or be willing to talk to me
> about
> > > how this can be done?
> > >
> > > Thanks,
> > > Mike Haynes
> > > Sure Alloy Steel Corp.
> > >
> >
>
>
>
>
>
>
> 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/>
> <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
>
>
>
> * Visit your group "vantage
> <http://groups.yahoo.com/group/vantage> " on the web.
>
> * 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]
>

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

* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.

* 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]

system · January 10, 2006, 1:54pm

Hello All,
First time poster and brand new 8.0 user here. I have only recently
discovered this resource and I have lots of Vantage questions but the
one most pressing for me right now is how do all of you (if any of you
do) get to your Vantage tables outside of Vantage? I have used
Microsoft Access to view some table data but this doesn't work for all
the tables. Specifically, I need to get to the Invoice Header and
Detail tables but due to some peculiar data structure I get an error
when I try to link to these tables.

Maybe I already have the necessary tools and I just don't know it
because our administrator back office type training was non-existant.
Can anybody help me with this and/or be willing to talk to me about
how this can be done?

Thanks,
Mike Haynes
Sure Alloy Steel Corp.

system · January 10, 2006, 2:01pm

Try OpenOffice. OpenOffice 2.0 has a decent database program called Base.
Unlike access, it doesn't have restrictions on the number of indexes per
table. It isn't perfect, and not quite as pretty as Access, but very
functional for designing queries.

http://www.openoffice.org/

We use it for our Progress and MySQL databases.

Chris Gitzlaff
Major Industries, Inc.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
mikehaynes99
Sent: Tuesday, January 10, 2006 12:51 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Data access

Hello All,
First time poster and brand new 8.0 user here. I have only recently
discovered this resource and I have lots of Vantage questions but the
one most pressing for me right now is how do all of you (if any of you
do) get to your Vantage tables outside of Vantage? I have used
Microsoft Access to view some table data but this doesn't work for all
the tables. Specifically, I need to get to the Invoice Header and
Detail tables but due to some peculiar data structure I get an error
when I try to link to these tables.

Maybe I already have the necessary tools and I just don't know it
because our administrator back office type training was non-existant.
Can anybody help me with this and/or be willing to talk to me about
how this can be done?

Thanks,
Mike Haynes
Sure Alloy Steel Corp.

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

system · January 10, 2006, 2:16pm

I would created a sql pass through query in access. If you can link a table
you should be able to created a pass through query. Use your same odbc
connection like you did when you connected to the database and on the query
type EX. "select * from pub.part" (assuming you have a progress db). The
.part is the table. In your case you would want something like "select *
from pub.Invchead" This should return all records in the DB. Large Tables
can take awhile.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
mikehaynes99
Sent: Tuesday, January 10, 2006 12:51 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Data access

Hello All,
First time poster and brand new 8.0 user here. I have only recently
discovered this resource and I have lots of Vantage questions but the
one most pressing for me right now is how do all of you (if any of you
do) get to your Vantage tables outside of Vantage? I have used
Microsoft Access to view some table data but this doesn't work for all
the tables. Specifically, I need to get to the Invoice Header and
Detail tables but due to some peculiar data structure I get an error
when I try to link to these tables.

Maybe I already have the necessary tools and I just don't know it
because our administrator back office type training was non-existant.
Can anybody help me with this and/or be willing to talk to me about
how this can be done?

Thanks,
Mike Haynes
Sure Alloy Steel Corp.

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
<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
<http://groups.yahoo.com/group/vantage/links>

SPONSORED LINKS
Manufacturing software Membership database software Database mortgage
software
Pda database software Database management software Database marketing
software

_____

YAHOO! GROUPS LINKS

* Visit your group " vantage <http://groups.yahoo.com/group/vantage>
" on the web.

* 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]

system · January 10, 2006, 5:11pm

You can also create a "view" in the progress database. Someone here
recommended this before and it worked great with Access! How I
understand views, is that they are basically a consolidated table of the
data you actually want. Someone here can probably explain them better.
The problem I had is that Access could not look at a table with more
than 32 indexes. The view solved this problem and also alerted us to
another issue with our row sizes being too long! It must have happened
when we used VB Forms to insert extensive notes. You can create views
using the SQL Explorer Tool. You also have to know a little of the SQL
language as well.

Joe Luster

Network Administrator

Cold Jet, LLC

513-831-3211 ext. 308

513-831-1209 FAX

<http://www.coldjet.com>

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Olson, Brian
Sent: Tuesday, January 10, 2006 2:09 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Data access

I would created a sql pass through query in access. If you can link a
table
you should be able to created a pass through query. Use your same odbc
connection like you did when you connected to the database and on the
query
type EX. "select * from pub.part" (assuming you have a progress db). The
.part is the table. In your case you would want something like "select *
from pub.Invchead" This should return all records in the DB. Large
Tables
can take awhile.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of
mikehaynes99
Sent: Tuesday, January 10, 2006 12:51 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Data access

Hello All,
First time poster and brand new 8.0 user here. I have only recently
discovered this resource and I have lots of Vantage questions but the
one most pressing for me right now is how do all of you (if any of you
do) get to your Vantage tables outside of Vantage? I have used
Microsoft Access to view some table data but this doesn't work for all
the tables. Specifically, I need to get to the Invoice Header and
Detail tables but due to some peculiar data structure I get an error
when I try to link to these tables.

Maybe I already have the necessary tools and I just don't know it
because our administrator back office type training was non-existant.
Can anybody help me with this and/or be willing to talk to me about
how this can be done?

Thanks,
Mike Haynes
Sure Alloy Steel Corp.

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/>
<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
<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
<http://groups.yahoo.com/group/vantage/links>

SPONSORED LINKS
Manufacturing software Membership database software Database
mortgage
software
Pda database software Database management software Database
marketing
software

_____

YAHOO! GROUPS LINKS

* Visit your group " vantage <
http://groups.yahoo.com/group/vantage>
" on the web.

* 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]

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

* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.

* 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]

system · January 11, 2006, 8:51am

Mike,

Welcome to the board. We are still using 6.1, but I use Access a
lot. We had problems with using the Customer Table, because of too
many indexes, so we had to create a view, as mentioned previously.
I'm not sure if this is the problem you are having, but if it is,
Tech Support will have instructions for you on setting up the view,
it was pretty easy at least it was for 6.1.

If the problem you are having is not due to too many indexes, can you
elaborate on the error? Have you talked to support about it? I'm
really interested in hearing more about the problem and solution that
you come up with.

Thanks,

Brian Stenglein
Clow Stamping Co.

--- In vantage@yahoogroups.com, "mikehaynes99" <mikeh@s...> wrote:
>
> Hello All,
> First time poster and brand new 8.0 user here. I have only
recently
> discovered this resource and I have lots of Vantage questions but
the
> one most pressing for me right now is how do all of you (if any of
you
> do) get to your Vantage tables outside of Vantage? I have used
> Microsoft Access to view some table data but this doesn't work for
all
> the tables. Specifically, I need to get to the Invoice Header and
> Detail tables but due to some peculiar data structure I get an
error
> when I try to link to these tables.
>
> Maybe I already have the necessary tools and I just don't know it
> because our administrator back office type training was non-
existant.
> Can anybody help me with this and/or be willing to talk to me about
> how this can be done?
>
> Thanks,
> Mike Haynes
> Sure Alloy Steel Corp.
>

system · January 12, 2006, 10:48am

More on my problem. I have a fair amount of experience using Access
to view/manipulate data so getting to the Vantage tables isn't much
of a problem. Yes, I did run into the > 32 indexes on the customer
file. I'll look into the suggestion of a 'view'. My original
problem which I wrote about here was that I couldn't view the table
data from the invchead and invcdet tables. I kept getting an ODBC
fail message when I tried to peek into the table data with a 'select
*' statement. With much experimentation I've determined that there
is a field within the table that causes the error. If I stay away
from the repsplit field then I can select and view all other fields
in the header table, at least. I've not tried that in the detail.
Since I've discovered that I can get to 99% of the data I can finish
my project which is developing an Access application to track and
pay commissions to our salespeople. Vantage doesn't work for us in
that area. I also tried to use VB .NET but was disappointed to
learn that that product will only access SQL and Jet databases.
Does anyone know if the full Visual Studio .NET product would
connect to Progress via ODBC?
Thanks to all who responded.

Mike
Sure Alloy Steel Corp.

--- In vantage@yahoogroups.com, "Brian Stenglein" <bstenglein@c...>
wrote:

>
> Mike,
>
> Welcome to the board. We are still using 6.1, but I use Access a
> lot. We had problems with using the Customer Table, because of

too

> many indexes, so we had to create a view, as mentioned

previously.

> I'm not sure if this is the problem you are having, but if it is,
> Tech Support will have instructions for you on setting up the

view,

> it was pretty easy at least it was for 6.1.
>
> If the problem you are having is not due to too many indexes, can

you

> elaborate on the error? Have you talked to support about it? I'm
> really interested in hearing more about the problem and solution

that

> you come up with.
>
> Thanks,
>
> Brian Stenglein
> Clow Stamping Co.
>
>
> --- In vantage@yahoogroups.com, "mikehaynes99" <mikeh@s...> wrote:
> >
> > Hello All,
> > First time poster and brand new 8.0 user here. I have only
> recently
> > discovered this resource and I have lots of Vantage questions

but

> the
> > one most pressing for me right now is how do all of you (if any

of

> you
> > do) get to your Vantage tables outside of Vantage? I have used
> > Microsoft Access to view some table data but this doesn't work

for

> all
> > the tables. Specifically, I need to get to the Invoice Header

and

> > Detail tables but due to some peculiar data structure I get an
> error
> > when I try to link to these tables.
> >
> > Maybe I already have the necessary tools and I just don't know

it

> > because our administrator back office type training was non-
> existant.
> > Can anybody help me with this and/or be willing to talk to me

about

> > how this can be done?
> >
> > Thanks,
> > Mike Haynes
> > Sure Alloy Steel Corp.
> >
>

system · January 12, 2006, 12:22pm

Mike,

VS.NET will access any data source addressable from all things MDAC (read
ODBC, DAO, ADO, etc...) including Progress. It's also accessible from JDBC
for free...

Michael

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

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
mikehaynes99
Sent: Thursday, January 12, 2006 7:47 AM
To: vantage@yahoogroups.com
Subject: Spam [Vantage] Re: Data access

More on my problem. I have a fair amount of experience using Access to
view/manipulate data so getting to the Vantage tables isn't much of a
problem. Yes, I did run into the > 32 indexes on the customer file. I'll
look into the suggestion of a 'view'. My original problem which I wrote
about here was that I couldn't view the table data from the invchead and
invcdet tables. I kept getting an ODBC fail message when I tried to peek
into the table data with a 'select *' statement. With much experimentation
I've determined that there is a field within the table that causes the
error. If I stay away from the repsplit field then I can select and view
all other fields in the header table, at least. I've not tried that in the
detail.
Since I've discovered that I can get to 99% of the data I can finish my
project which is developing an Access application to track and pay
commissions to our salespeople. Vantage doesn't work for us in that area.
I also tried to use VB .NET but was disappointed to learn that that product
will only access SQL and Jet databases.
Does anyone know if the full Visual Studio .NET product would connect to
Progress via ODBC?
Thanks to all who responded.

Mike
Sure Alloy Steel Corp.

--- In vantage@yahoogroups.com, "Brian Stenglein" <bstenglein@c...>
wrote:

>
> Mike,
>
> Welcome to the board. We are still using 6.1, but I use Access a lot.
> We had problems with using the Customer Table, because of

too

> many indexes, so we had to create a view, as mentioned

previously.

> I'm not sure if this is the problem you are having, but if it is, Tech
> Support will have instructions for you on setting up the

view,

> it was pretty easy at least it was for 6.1.
>
> If the problem you are having is not due to too many indexes, can

you

> elaborate on the error? Have you talked to support about it? I'm
> really interested in hearing more about the problem and solution

that

> you come up with.
>
> Thanks,
>
> Brian Stenglein
> Clow Stamping Co.
>
>
> --- In vantage@yahoogroups.com, "mikehaynes99" <mikeh@s...> wrote:
> >
> > Hello All,
> > First time poster and brand new 8.0 user here. I have only
> recently
> > discovered this resource and I have lots of Vantage questions

but

> the
> > one most pressing for me right now is how do all of you (if any

of

> you
> > do) get to your Vantage tables outside of Vantage? I have used
> > Microsoft Access to view some table data but this doesn't work

for

> all
> > the tables. Specifically, I need to get to the Invoice Header

and

> > Detail tables but due to some peculiar data structure I get an
> error
> > when I try to link to these tables.
> >
> > Maybe I already have the necessary tools and I just don't know

it

> > because our administrator back office type training was non-
> existant.
> > Can anybody help me with this and/or be willing to talk to me

about

> > how this can be done?
> >
> > Thanks,
> > Mike Haynes
> > Sure Alloy Steel Corp.
> >
>

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

system · January 12, 2006, 12:27pm

The "repsplit" column in the OrfHed table causes the same problem in
Access, DB Visualizer and in SQL Viewer.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Michael Barry
Sent: Thursday, January 12, 2006 12:22 PM
To: vantage@yahoogroups.com
Subject: RE: Spam [Vantage] Re: Data access

Mike,

VS.NET will access any data source addressable from all things MDAC
(read
ODBC, DAO, ADO, etc...) including Progress. It's also accessible from
JDBC
for free...

Michael

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

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of
mikehaynes99
Sent: Thursday, January 12, 2006 7:47 AM
To: vantage@yahoogroups.com
Subject: Spam [Vantage] Re: Data access

More on my problem. I have a fair amount of experience using Access to
view/manipulate data so getting to the Vantage tables isn't much of a
problem. Yes, I did run into the > 32 indexes on the customer file.
I'll
look into the suggestion of a 'view'. My original problem which I wrote
about here was that I couldn't view the table data from the invchead and
invcdet tables. I kept getting an ODBC fail message when I tried to
peek
into the table data with a 'select *' statement. With much
experimentation
I've determined that there is a field within the table that causes the
error. If I stay away from the repsplit field then I can select and
view
all other fields in the header table, at least. I've not tried that in
the
detail.
Since I've discovered that I can get to 99% of the data I can finish my
project which is developing an Access application to track and pay
commissions to our salespeople. Vantage doesn't work for us in that
area.
I also tried to use VB .NET but was disappointed to learn that that
product
will only access SQL and Jet databases.
Does anyone know if the full Visual Studio .NET product would connect to
Progress via ODBC?
Thanks to all who responded.

Mike
Sure Alloy Steel Corp.

--- In vantage@yahoogroups.com, "Brian Stenglein" <bstenglein@c...>
wrote:

>
> Mike,
>
> Welcome to the board. We are still using 6.1, but I use Access a lot.

> We had problems with using the Customer Table, because of

too

> many indexes, so we had to create a view, as mentioned

previously.

> I'm not sure if this is the problem you are having, but if it is, Tech

> Support will have instructions for you on setting up the

view,

> it was pretty easy at least it was for 6.1.
>
> If the problem you are having is not due to too many indexes, can

you

> elaborate on the error? Have you talked to support about it? I'm
> really interested in hearing more about the problem and solution

that

> you come up with.
>
> Thanks,
>
> Brian Stenglein
> Clow Stamping Co.
>
>
> --- In vantage@yahoogroups.com, "mikehaynes99" <mikeh@s...> wrote:
> >
> > Hello All,
> > First time poster and brand new 8.0 user here. I have only
> recently
> > discovered this resource and I have lots of Vantage questions

but

> the
> > one most pressing for me right now is how do all of you (if any

of

> you
> > do) get to your Vantage tables outside of Vantage? I have used
> > Microsoft Access to view some table data but this doesn't work

for

> all
> > the tables. Specifically, I need to get to the Invoice Header

and

> > Detail tables but due to some peculiar data structure I get an
> error
> > when I try to link to these tables.
> >
> > Maybe I already have the necessary tools and I just don't know

it

> > because our administrator back office type training was non-
> existant.
> > Can anybody help me with this and/or be willing to talk to me

about

> > how this can be done?
> >
> > Thanks,
> > Mike Haynes
> > Sure Alloy Steel Corp.
> >
>

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

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

SPONSORED LINKS

Manufacturing software
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Database
+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA>

Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ>

Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Data
base+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A>

Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Database+
marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg>

Database management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw>

Database marketing software
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manu
facturing+software&w2=Membership+database+software&w3=Database+mortgage+
software&w4=Pda+database+software&w5=Database+management+software&w6=Dat
abase+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw>

________________________________

YAHOO! GROUPS LINKS

* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.

* 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]

system · January 12, 2006, 1:47pm

What is JDBC?

Mike

--- In vantage@yahoogroups.com, "Michael Barry" <mbarry@b...> wrote:
>
> Mike,
>
> VS.NET will access any data source addressable from all things
MDAC (read
> ODBC, DAO, ADO, etc...) including Progress. It's also accessible
from JDBC
> for free...
>
> Michael
>
> Michael Barry
> Aspacia Systems Inc
> 866.566.9600
> 312.803.0730 fax
> http://www.aspacia.com/
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> mikehaynes99
> Sent: Thursday, January 12, 2006 7:47 AM
> To: vantage@yahoogroups.com
> Subject: Spam [Vantage] Re: Data access
>
> More on my problem. I have a fair amount of experience using
Access to
> view/manipulate data so getting to the Vantage tables isn't much
of a
> problem. Yes, I did run into the > 32 indexes on the customer
file. I'll
> look into the suggestion of a 'view'. My original problem which I
wrote
> about here was that I couldn't view the table data from the
invchead and
> invcdet tables. I kept getting an ODBC fail message when I tried
to peek
> into the table data with a 'select *' statement. With much
experimentation
> I've determined that there is a field within the table that causes
the
> error. If I stay away from the repsplit field then I can select
and view
> all other fields in the header table, at least. I've not tried
that in the
> detail.
> Since I've discovered that I can get to 99% of the data I can
finish my
> project which is developing an Access application to track and pay
> commissions to our salespeople. Vantage doesn't work for us in
that area.
> I also tried to use VB .NET but was disappointed to learn that
that product
> will only access SQL and Jet databases.
> Does anyone know if the full Visual Studio .NET product would
connect to
> Progress via ODBC?
> Thanks to all who responded.
>
> Mike
> Sure Alloy Steel Corp.
>
>
>
> --- In vantage@yahoogroups.com, "Brian Stenglein" <bstenglein@c...>
> wrote:
> >
> > Mike,
> >
> > Welcome to the board. We are still using 6.1, but I use Access
a lot.
> > We had problems with using the Customer Table, because of
> too
> > many indexes, so we had to create a view, as mentioned
> previously.
> > I'm not sure if this is the problem you are having, but if it
is, Tech
> > Support will have instructions for you on setting up the
> view,
> > it was pretty easy at least it was for 6.1.
> >
> > If the problem you are having is not due to too many indexes, can
> you
> > elaborate on the error? Have you talked to support about it?
I'm
> > really interested in hearing more about the problem and solution
> that
> > you come up with.
> >
> > Thanks,
> >
> > Brian Stenglein
> > Clow Stamping Co.
> >
> >
> > --- In vantage@yahoogroups.com, "mikehaynes99" <mikeh@s...>
wrote:
> > >
> > > Hello All,
> > > First time poster and brand new 8.0 user here. I have only
> > recently
> > > discovered this resource and I have lots of Vantage questions
> but
> > the
> > > one most pressing for me right now is how do all of you (if any
> of
> > you
> > > do) get to your Vantage tables outside of Vantage? I have
used
> > > Microsoft Access to view some table data but this doesn't work
> for
> > all
> > > the tables. Specifically, I need to get to the Invoice Header
> and
> > > Detail tables but due to some peculiar data structure I get an
> > error
> > > when I try to link to these tables.
> > >
> > > Maybe I already have the necessary tools and I just don't know
> it
> > > because our administrator back office type training was non-
> > existant.
> > > Can anybody help me with this and/or be willing to talk to me
> about
> > > how this can be done?
> > >
> > > Thanks,
> > > Mike Haynes
> > > Sure Alloy Steel Corp.
> > >
> >
>
>
>
>
>
>
> 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
>

system · January 12, 2006, 3:57pm

> What is JDBC?

http://java.sun.com/products/jdbc/

Think ODBC for Java. Well, except that JDBC can use ODBC sources too...

system · January 13, 2006, 8:18am

Did you try using a DSN connection string in VB.Net?

Ie:
DSN=Vantage;HOST=servername;PORT=####;DB=mfgsys;UID=username;PWD=passwor
d

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of mikehaynes99
Sent: Thursday, January 12, 2006 10:47 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Data access

More on my problem. I have a fair amount of experience using Access
to view/manipulate data so getting to the Vantage tables isn't much
of a problem. Yes, I did run into the > 32 indexes on the customer
file. I'll look into the suggestion of a 'view'. My original
problem which I wrote about here was that I couldn't view the table
data from the invchead and invcdet tables. I kept getting an ODBC
fail message when I tried to peek into the table data with a 'select
*' statement. With much experimentation I've determined that there
is a field within the table that causes the error. If I stay away
from the repsplit field then I can select and view all other fields
in the header table, at least. I've not tried that in the detail.
Since I've discovered that I can get to 99% of the data I can finish
my project which is developing an Access application to track and
pay commissions to our salespeople. Vantage doesn't work for us in
that area. I also tried to use VB .NET but was disappointed to
learn that that product will only access SQL and Jet databases.
Does anyone know if the full Visual Studio .NET product would
connect to Progress via ODBC?
Thanks to all who responded.

Mike
Sure Alloy Steel Corp.

--- In vantage@yahoogroups.com, "Brian Stenglein" <bstenglein@c...>
wrote:

>
> Mike,
>
> Welcome to the board. We are still using 6.1, but I use Access a
> lot. We had problems with using the Customer Table, because of

too

> many indexes, so we had to create a view, as mentioned

previously.

> I'm not sure if this is the problem you are having, but if it is,
> Tech Support will have instructions for you on setting up the

view,

> it was pretty easy at least it was for 6.1.
>
> If the problem you are having is not due to too many indexes, can

you

> elaborate on the error? Have you talked to support about it? I'm
> really interested in hearing more about the problem and solution

that

> you come up with.
>
> Thanks,
>
> Brian Stenglein
> Clow Stamping Co.
>
>
> --- In vantage@yahoogroups.com, "mikehaynes99" <mikeh@s...> wrote:
> >
> > Hello All,
> > First time poster and brand new 8.0 user here. I have only
> recently
> > discovered this resource and I have lots of Vantage questions

but

> the
> > one most pressing for me right now is how do all of you (if any

of

> you
> > do) get to your Vantage tables outside of Vantage? I have used
> > Microsoft Access to view some table data but this doesn't work

for

> all
> > the tables. Specifically, I need to get to the Invoice Header

and

> > Detail tables but due to some peculiar data structure I get an
> error
> > when I try to link to these tables.
> >
> > Maybe I already have the necessary tools and I just don't know

it

> > because our administrator back office type training was non-
> existant.
> > Can anybody help me with this and/or be willing to talk to me

about

> > how this can be done?
> >
> > Thanks,
> > Mike Haynes
> > Sure Alloy Steel Corp.
> >
>

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

* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.

* 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]

system · January 13, 2006, 12:08pm

Yes, I did. But, VB.NET will only connect to SQL and JET
databases. Must be some kind of internal restriction. I guess they
want you to pony up for the full Visual Studio product.

Mike

--- In vantage@yahoogroups.com, "Gerard Wadman" <gwadman@s...> wrote:
>
> Did you try using a DSN connection string in VB.Net?
>
> Ie:
>
DSN=Vantage;HOST=servername;PORT=####;DB=mfgsys;UID=username;PWD=pass
wor
> d
>
>
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of mikehaynes99
> Sent: Thursday, January 12, 2006 10:47 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Data access
>
>
>
> More on my problem. I have a fair amount of experience using
Access
> to view/manipulate data so getting to the Vantage tables isn't
much
> of a problem. Yes, I did run into the > 32 indexes on the
customer
> file. I'll look into the suggestion of a 'view'. My original
> problem which I wrote about here was that I couldn't view the
table
> data from the invchead and invcdet tables. I kept getting an ODBC
> fail message when I tried to peek into the table data with
a 'select
> *' statement. With much experimentation I've determined that
there
> is a field within the table that causes the error. If I stay away
> from the repsplit field then I can select and view all other
fields
> in the header table, at least. I've not tried that in the
detail.
> Since I've discovered that I can get to 99% of the data I can
finish
> my project which is developing an Access application to track and
> pay commissions to our salespeople. Vantage doesn't work for us
in
> that area. I also tried to use VB .NET but was disappointed to
> learn that that product will only access SQL and Jet databases.
> Does anyone know if the full Visual Studio .NET product would
> connect to Progress via ODBC?
> Thanks to all who responded.
>
> Mike
> Sure Alloy Steel Corp.
>
>
>
> --- In vantage@yahoogroups.com, "Brian Stenglein"
<bstenglein@c...>
> wrote:
> >
> > Mike,
> >
> > Welcome to the board. We are still using 6.1, but I use Access
a
> > lot. We had problems with using the Customer Table, because of
> too
> > many indexes, so we had to create a view, as mentioned
> previously.
> > I'm not sure if this is the problem you are having, but if it
is,
> > Tech Support will have instructions for you on setting up the
> view,
> > it was pretty easy at least it was for 6.1.
> >
> > If the problem you are having is not due to too many indexes,
can
> you
> > elaborate on the error? Have you talked to support about it?
I'm
> > really interested in hearing more about the problem and solution
> that
> > you come up with.
> >
> > Thanks,
> >
> > Brian Stenglein
> > Clow Stamping Co.
> >
> >
> > --- In vantage@yahoogroups.com, "mikehaynes99" <mikeh@s...>
wrote:
> > >
> > > Hello All,
> > > First time poster and brand new 8.0 user here. I have only
> > recently
> > > discovered this resource and I have lots of Vantage questions
> but
> > the
> > > one most pressing for me right now is how do all of you (if
any
> of
> > you
> > > do) get to your Vantage tables outside of Vantage? I have
used
> > > Microsoft Access to view some table data but this doesn't work
> for
> > all
> > > the tables. Specifically, I need to get to the Invoice Header
> and
> > > Detail tables but due to some peculiar data structure I get an
> > error
> > > when I try to link to these tables.
> > >
> > > Maybe I already have the necessary tools and I just don't know
> it
> > > because our administrator back office type training was non-
> > existant.
> > > Can anybody help me with this and/or be willing to talk to me
> about
> > > how this can be done?
> > >
> > > Thanks,
> > > Mike Haynes
> > > Sure Alloy Steel Corp.
> > >
> >
>
>
>
>
>
>
> 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
>
>
>
> * Visit your group "vantage
> <http://groups.yahoo.com/group/vantage> " on the web.
>
> * 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]
>