Connecting to Vantage Database using ODBC

Yahoo Archive
1
If you are serious about modifing data in vantage use probuilder and
4GL not ODBC. Progress does not have an ODBC driver that you can
trust to modify your data. Hardcore Progress user will tell you
that the ODBC driver was written to provide open access for other
applications not as a primary way to add and remove data.

--- In vantage@yahoogroups.com, "Susan Iverson" <siverson@j...>
wrote:
> We would like to connect to the Vantage database using ODBC so we
can
> make some changes - does anyone know how to do this?
>
>
>
> Thank you,
>
> Sue
>
>
>
> [Non-text portions of this message have been removed]
2
We would like to connect to the Vantage database using ODBC so we can
make some changes - does anyone know how to do this?



Thank you,

Sue



[Non-text portions of this message have been removed]
3
Support has a document detailing how to setup ODBC that they can email to you. I just went thru it recently for 6.0. We used to use the old Merant 3.5 ODBC but the newer DirectConnect(Merant) 3.6 SQL92 version with working well now. Part of the instructions detail how to setup a user version that prevents them from changing data so you may be able to reverse engineer to allow changes. BUT!!!!! Dangerous territory, tread carefully or you can really corrupt the database. Always try it out on a TEST database you can afford to lose. Also, if you go messing around and break something Epicor support will probably not help you fix it. Certain fields like user fields and VB form fields ought to be relatively safe but still test first.
-Todd C.

-----Original Message-----
From: Susan Iverson [mailto:siverson@...]
Sent: Tuesday, April 20, 2004 12:59 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Connecting to Vantage Database using ODBC


We would like to connect to the Vantage database using ODBC so we can
make some changes - does anyone know how to do this?



Thank you,

Sue



[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



_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


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