ODBC Connection to the Customer Table

Thanks for the suggestions guys. I really appreciate the quick feedback.

I needed to mass update a few fields in preparation for our go-live and
found that I could just connect using the SQL explorer tool to execute the
updates to the appropriate fields in the customer table. Worked out just
fine.

Thanks again!



________________________
Jim Kennedy
Manager, Information Technologies
Firstmark Aerospace
921 Holloway St.
Durham, North Carolina 27701
Office: (919) 956-4264
Main: (919) 956-4200
Cell: (919) 697-9410
jkennedy@...
www.firstmarkaerospace.com

-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Friday, March 11, 2005 9:51 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] ODBC Connection to the Customer Table


From what I understood, it isn't connecting via odbc that is the problem, it
is too many indexes on the customer table that some programs (like MS
Access, etc.) couldn't handle. I was told by support (but couldn't test b/c
I don't have it) that if you use another program (like SQL server) instead
of access, you will not have this problem.

Anyway, we use MS access with odbc for most of our Vantage reporting and I
got around this by using a little progress routine that exports the customer
table into an excel file and then my access db connects to the excel file.
I have a macro in my access file that automatically runs the progress
routine on start-up, so it is always up to date. This is very easy for us,
though, b/c we only have about 50 customers so it is very quick (totally
seamless to the users).

I know there were other workarounds also. Support had sent me one, but the
above solution was so easy and painless that I didn't even look into the one
that support sent.




-----Original Message-----
From: Kennedy, Jim [mailto:jkennedy@...]
Sent: March 11, 2005 9:46 AM
To: vantage@yahoogroups.com
Subject: [Vantage] ODBC Connection to the Customer Table


I know this is a taboo topic but...
Has anyone figured out how to connect to the customer table via ODBC?

Any suggestions would be greatly appreciated.

Thanks.


________________________
Jim Kennedy
Manager, Information Technologies
Firstmark Aerospace
921 Holloway St.
Durham, North Carolina 27701
Office: (919) 956-4264
Main: (919) 956-4200
Cell: (919) 697-9410
jkennedy@... <mailto:jkennedy@...>
www.firstmarkaerospace.com <http://www.firstmarkaerospace.com/>



[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








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
I know this is a taboo topic but...
Has anyone figured out how to connect to the customer table via ODBC?

Any suggestions would be greatly appreciated.

Thanks.


________________________
Jim Kennedy
Manager, Information Technologies
Firstmark Aerospace
921 Holloway St.
Durham, North Carolina 27701
Office: (919) 956-4264
Main: (919) 956-4200
Cell: (919) 697-9410
jkennedy@... <mailto:jkennedy@...>
www.firstmarkaerospace.com <http://www.firstmarkaerospace.com/>



[Non-text portions of this message have been removed]
From what I understood, it isn't connecting via odbc that is the problem, it
is too many indexes on the customer table that some programs (like MS
Access, etc.) couldn't handle. I was told by support (but couldn't test b/c
I don't have it) that if you use another program (like SQL server) instead
of access, you will not have this problem.

Anyway, we use MS access with odbc for most of our Vantage reporting and I
got around this by using a little progress routine that exports the customer
table into an excel file and then my access db connects to the excel file.
I have a macro in my access file that automatically runs the progress
routine on start-up, so it is always up to date. This is very easy for us,
though, b/c we only have about 50 customers so it is very quick (totally
seamless to the users).

I know there were other workarounds also. Support had sent me one, but the
above solution was so easy and painless that I didn't even look into the one
that support sent.




-----Original Message-----
From: Kennedy, Jim [mailto:jkennedy@...]
Sent: March 11, 2005 9:46 AM
To: vantage@yahoogroups.com
Subject: [Vantage] ODBC Connection to the Customer Table


I know this is a taboo topic but...
Has anyone figured out how to connect to the customer table via ODBC?

Any suggestions would be greatly appreciated.

Thanks.


________________________
Jim Kennedy
Manager, Information Technologies
Firstmark Aerospace
921 Holloway St.
Durham, North Carolina 27701
Office: (919) 956-4264
Main: (919) 956-4200
Cell: (919) 697-9410
jkennedy@... <mailto:jkennedy@...>
www.firstmarkaerospace.com <http://www.firstmarkaerospace.com/>



[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
We went the MSSQL Server route.

You can also create a View in the Progress database. Support can send you
the directions or you can look them up online.

Thanks
Jeremy


[Non-text portions of this message have been removed]
We use the view option that Jeremy mentioned to use the Customer
Table in Access. Works fine, not that hard to set up. We do a ton
of reporting in Access with ODBC.

Brian Stenglein
Clow Stamping Company


--- In vantage@yahoogroups.com, "Kennedy, Jim" <jkennedy@f...> wrote:
> I know this is a taboo topic but...
> Has anyone figured out how to connect to the customer table via
ODBC?
>
> Any suggestions would be greatly appreciated.
>
> Thanks.
>
>
> ________________________
> Jim Kennedy
> Manager, Information Technologies
> Firstmark Aerospace
> 921 Holloway St.
> Durham, North Carolina 27701
> Office: (919) 956-4264
> Main: (919) 956-4200
> Cell: (919) 697-9410
> jkennedy@f... <mailto:jkennedy@f...>
> www.firstmarkaerospace.com <http://www.firstmarkaerospace.com/>
>
>
>
> [Non-text portions of this message have been removed]