Have you check your client ODBC driver settings? If you are reading Vantage
records with a default isolation level of "COMMITTED", the ODBC client
connection will break if it encounters a record used by another Vantage
user. Also, like another user group member posted, I rather import all the
tables and work from Access. Linking to Vantage tables has the tendency to
break specially when running complex queries.
Mario Aguirre
Information Systems Manager
Lakin General
2865 N. Paulina
Chicago, IL 60657
Ph: 773-871-9631
Fx: 773-871-1265
-----Original Message-----
From: Heisey, Lois [mailto:lheisey@...]
Sent: Tuesday, September 23, 2003 8:37 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Re: ODBC Errors
YES, this has been working for over a year and now has decided to give me
grief for no reason I am aware of.
-----Original Message-----
From: meco_inc_paris [mailto:admin@...]
Sent: Tuesday, September 23, 2003 8:39 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: ODBC Errors
DO you have your progress configured to allow ODBC COnnections?
I had to reconfigure my server when I wanted to allow ODBC Connections
thru Crystal and Access
records with a default isolation level of "COMMITTED", the ODBC client
connection will break if it encounters a record used by another Vantage
user. Also, like another user group member posted, I rather import all the
tables and work from Access. Linking to Vantage tables has the tendency to
break specially when running complex queries.
Mario Aguirre
Information Systems Manager
Lakin General
2865 N. Paulina
Chicago, IL 60657
Ph: 773-871-9631
Fx: 773-871-1265
-----Original Message-----
From: Heisey, Lois [mailto:lheisey@...]
Sent: Tuesday, September 23, 2003 8:37 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Re: ODBC Errors
YES, this has been working for over a year and now has decided to give me
grief for no reason I am aware of.
-----Original Message-----
From: meco_inc_paris [mailto:admin@...]
Sent: Tuesday, September 23, 2003 8:39 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: ODBC Errors
DO you have your progress configured to allow ODBC COnnections?
I had to reconfigure my server when I wanted to allow ODBC Connections
thru Crystal and Access
--- In vantage@yahoogroups.com, "lois_heisey" <lheisey@m...> wrote:
> In my continued search...
> When opening a report in Access that uses ODBC to interrogate Vantage
> I get this error: Reserved error (-2029) there is no message for
> this error. Any clues?
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>
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/>
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/M=194081.3897168.5135684.1261774/D=egroupweb/S=17050071
83:HM/A=1732163/R=0/SIG=11n0nglqg/*http:/www.ediets.com/start.cfm?code=30510
&media=zone> click here
<http://us.adserver.yahoo.com/l?M=194081.3897168.5135684.1261774/D=egroupmai
l/S=:HM/A=1732163/rand=495092191>
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>
Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.
[Non-text portions of this message have been removed]