Vantage 5/Merant 3.5

Yahoo Archive
1
The settings on the local OBDC-DSN have to read tables uncommitted as well.
Otherwise, you will lock up a lot of tables and generate endless errors on
vantage (in case you have not set this yet).

Mario Aguirre
Lakin General


-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Monday, January 21, 2002 2:33 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Vantage 5/Merant 3.5

If you have the user "Import" the information each time (just for the Part
table for instance), then it seems to work. It won't "Link" is the problem.
Another option is the "auto export" using a simple progress program. Then
you can link in Access to the .csv file. But then the data's not quite
"fresh".

Troy Funte
Liberty Electronics



----- Original Message -----
From: Brian Boyes
To: 'vantage@yahoogroups.com'
Sent: Monday, January 21, 2002 3:17 PM
Subject: RE: [Vantage] Vantage 5/Merant 3.5


That was it exactly. So it doesn't work in 3.5 either? Guess we will have
to
look for some other way of getting the information.

Thanks all!
Brian

> -----Original Message-----
> From: Troy Funte [mailto:tfunte@...]
> Sent: Monday, January 21, 2002 3:07 PM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Vantage 5/Merant 3.5
>
>
> Brian,
> We are using Merant 3.5. I use it fine with Access 2000.
> I tried getting one user up on Access 97 and we ran into
> troubles on certain tables, so I gave up. I know that
> doesn't help you, but going to 3.5 may not be the answer. It
> seems to me that the PartDescription in particular gives
> Access 97 trouble, even if the field has been shortened to
> 250 characters. You can Import that field, but not link to
> it. Other tables work fine.
>
> Troy Funte
> Liberty Electronics
>
> ----- Original Message -----
> From: Brian Boyes
> To: Vantage List (E-mail)
> Sent: Monday, January 21, 2002 10:59 AM
> Subject: [Vantage] Vantage 5/Merant 3.5
>
>
> Just a quick backstory here, it seems that the Merant 3.6
> driver doesn't
> work with Access 97, although it will work with 2000. In
> any case, out
> standard here is 97, so we have to try and find some other way of
> implementing ODBC.
>
> So, I am trying to set up the Merant 3.5 driver to work
> with Vantage 5.0.
> Would like to talk to anyone else using this setup to see
> how they did it
> and how well it works (if at all).
>
> Thanks
> Brian Boyes,
> Systems Administrator,
> Precision Resource Canada Ltd.
> <http://www.precisionresource.com>
> <mailto:brianb@...>
>
>
>
> 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
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service.
>
>
>
> [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/links
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>

Yahoo! Groups Sponsor
ADVERTISEMENT




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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[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/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
2
Just a quick backstory here, it seems that the Merant 3.6 driver doesn't
work with Access 97, although it will work with 2000. In any case, out
standard here is 97, so we have to try and find some other way of
implementing ODBC.

So, I am trying to set up the Merant 3.5 driver to work with Vantage 5.0.
Would like to talk to anyone else using this setup to see how they did it
and how well it works (if at all).

Thanks
Brian Boyes,
Systems Administrator,
Precision Resource Canada Ltd.
<http://www.precisionresource.com>
<mailto:brianb@...>
3
Brian,

We are using Merant 3.6 with Vantage 5.0 and Access 97. It does
work. What problems are you experiencing?

Brian Stenglein
Clow Stamping Company


--- In vantage@y..., Brian Boyes <brianb@p...> wrote:
> Just a quick backstory here, it seems that the Merant 3.6 driver
doesn't
> work with Access 97, although it will work with 2000. In any case,
out
> standard here is 97, so we have to try and find some other way of
> implementing ODBC.
>
> So, I am trying to set up the Merant 3.5 driver to work with
Vantage 5.0.
> Would like to talk to anyone else using this setup to see how they
did it
> and how well it works (if at all).
>
> Thanks
> Brian Boyes,
> Systems Administrator,
> Precision Resource Canada Ltd.
> <http://www.precisionresource.com>
> <mailto:brianb@p...>
4
I guess I should not have said that it doesn't work. Its more that there are
some issues where the field length gets set to a value larger than Access 97
can handle. Thus, it doesn't work for our purposes. From what I was told, it
has something to do with the Merant 3.6 driver. That's why I wanted to try
the 3.5 driver instead.

I know there are some patches that resolve some of the problems. We went
through this a couple of months ago and the patches fixed some of the
errors. However, according to Epicor, our situation is not unique and what
we are experiencing is a know issue when using Access 97.

Brian

> -----Original Message-----
> From: B_Stinger [mailto:bstenglein@...]
> Sent: Monday, January 21, 2002 11:59 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Vantage 5/Merant 3.5
>
>
> Brian,
>
> We are using Merant 3.6 with Vantage 5.0 and Access 97. It does
> work. What problems are you experiencing?
>
> Brian Stenglein
> Clow Stamping Company
>
>
> --- In vantage@y..., Brian Boyes <brianb@p...> wrote:
> > Just a quick backstory here, it seems that the Merant 3.6 driver
> doesn't
> > work with Access 97, although it will work with 2000. In any case,
> out
> > standard here is 97, so we have to try and find some other way of
> > implementing ODBC.
> >
> > So, I am trying to set up the Merant 3.5 driver to work with
> Vantage 5.0.
> > Would like to talk to anyone else using this setup to see how they
> did it
> > and how well it works (if at all).
> >
> > Thanks
> > Brian Boyes,
> > Systems Administrator,
> > Precision Resource Canada Ltd.
> > <http://www.precisionresource.com>
> > <mailto:brianb@p...>
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-->
> Sponsored by VeriSign - The Value of Trust
> When building an e-commerce site, you want to start with a
> secure foundation. Learn how with VeriSign's FREE Guide.
> http://us.click.yahoo.com/oCuuSA/XdiDAA/yigFAA/PhFolB/TM
> --------------------------------------------------------------
> -------~->
>
> 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

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
5
Brian,
We are using Merant 3.5. I use it fine with Access 2000. I tried getting one user up on Access 97 and we ran into troubles on certain tables, so I gave up. I know that doesn't help you, but going to 3.5 may not be the answer. It seems to me that the PartDescription in particular gives Access 97 trouble, even if the field has been shortened to 250 characters. You can Import that field, but not link to it. Other tables work fine.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Brian Boyes
To: Vantage List (E-mail)
Sent: Monday, January 21, 2002 10:59 AM
Subject: [Vantage] Vantage 5/Merant 3.5


Just a quick backstory here, it seems that the Merant 3.6 driver doesn't
work with Access 97, although it will work with 2000. In any case, out
standard here is 97, so we have to try and find some other way of
implementing ODBC.

So, I am trying to set up the Merant 3.5 driver to work with Vantage 5.0.
Would like to talk to anyone else using this setup to see how they did it
and how well it works (if at all).

Thanks
Brian Boyes,
Systems Administrator,
Precision Resource Canada Ltd.
<http://www.precisionresource.com>
<mailto:brianb@...>



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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
6
That was it exactly. So it doesn't work in 3.5 either? Guess we will have to
look for some other way of getting the information.

Thanks all!
Brian

> -----Original Message-----
> From: Troy Funte [mailto:tfunte@...]
> Sent: Monday, January 21, 2002 3:07 PM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Vantage 5/Merant 3.5
>
>
> Brian,
> We are using Merant 3.5. I use it fine with Access 2000.
> I tried getting one user up on Access 97 and we ran into
> troubles on certain tables, so I gave up. I know that
> doesn't help you, but going to 3.5 may not be the answer. It
> seems to me that the PartDescription in particular gives
> Access 97 trouble, even if the field has been shortened to
> 250 characters. You can Import that field, but not link to
> it. Other tables work fine.
>
> Troy Funte
> Liberty Electronics
>
> ----- Original Message -----
> From: Brian Boyes
> To: Vantage List (E-mail)
> Sent: Monday, January 21, 2002 10:59 AM
> Subject: [Vantage] Vantage 5/Merant 3.5
>
>
> Just a quick backstory here, it seems that the Merant 3.6
> driver doesn't
> work with Access 97, although it will work with 2000. In
> any case, out
> standard here is 97, so we have to try and find some other way of
> implementing ODBC.
>
> So, I am trying to set up the Merant 3.5 driver to work
> with Vantage 5.0.
> Would like to talk to anyone else using this setup to see
> how they did it
> and how well it works (if at all).
>
> Thanks
> Brian Boyes,
> Systems Administrator,
> Precision Resource Canada Ltd.
> <http://www.precisionresource.com>
> <mailto:brianb@...>
>
>
>
> 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
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service.
>
>
>
> [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/links
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>
7
If you have the user "Import" the information each time (just for the Part table for instance), then it seems to work. It won't "Link" is the problem. Another option is the "auto export" using a simple progress program. Then you can link in Access to the .csv file. But then the data's not quite "fresh".

Troy Funte
Liberty Electronics



----- Original Message -----
From: Brian Boyes
To: 'vantage@yahoogroups.com'
Sent: Monday, January 21, 2002 3:17 PM
Subject: RE: [Vantage] Vantage 5/Merant 3.5


That was it exactly. So it doesn't work in 3.5 either? Guess we will have to
look for some other way of getting the information.

Thanks all!
Brian

> -----Original Message-----
> From: Troy Funte [mailto:tfunte@...]
> Sent: Monday, January 21, 2002 3:07 PM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Vantage 5/Merant 3.5
>
>
> Brian,
> We are using Merant 3.5. I use it fine with Access 2000.
> I tried getting one user up on Access 97 and we ran into
> troubles on certain tables, so I gave up. I know that
> doesn't help you, but going to 3.5 may not be the answer. It
> seems to me that the PartDescription in particular gives
> Access 97 trouble, even if the field has been shortened to
> 250 characters. You can Import that field, but not link to
> it. Other tables work fine.
>
> Troy Funte
> Liberty Electronics
>
> ----- Original Message -----
> From: Brian Boyes
> To: Vantage List (E-mail)
> Sent: Monday, January 21, 2002 10:59 AM
> Subject: [Vantage] Vantage 5/Merant 3.5
>
>
> Just a quick backstory here, it seems that the Merant 3.6
> driver doesn't
> work with Access 97, although it will work with 2000. In
> any case, out
> standard here is 97, so we have to try and find some other way of
> implementing ODBC.
>
> So, I am trying to set up the Merant 3.5 driver to work
> with Vantage 5.0.
> Would like to talk to anyone else using this setup to see
> how they did it
> and how well it works (if at all).
>
> Thanks
> Brian Boyes,
> Systems Administrator,
> Precision Resource Canada Ltd.
> <http://www.precisionresource.com>
> <mailto:brianb@...>
>
>
>
> 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
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service.
>
>
>
> [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/links
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>

Yahoo! Groups Sponsor
ADVERTISEMENT




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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



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