6.1: ODBC problems

Yahoo Archive
1
Joe,

You can create an image of the table without the indexes and that way
you can link or export it. Here are the instructions:

1. Make sure there is anyone using the database.
2. Open Progress SQL Explorer Tool (Start-Programs-Progress 9.1D, etc.).
3. Select File-Connect
4. It opens a connect window. Enter your host, tcp port, database, user
and password.
5. After connecting, type the following in the top of the split screen:
create view odbc.customer_view

as

select * from pub.customer



This command creates a "copy" of the customer table named
odbc.customer_view.
6. Press the lightining bolt to execute the command.

Now, instead to connecting directly to PUB.Customer, you are going to
connect to odbc.customer_view. If you modify your ODBC connection, you
can update the customer table in certain fields (you want certain
customers to have specific information in the 3rd line of the address,
etc.)

Do not try this again with someone connected and also, do a back up and
re-store of your database before doing any change that cannot be undone.

Good Luck!

Mario Aguirre
Lakin General Corporation, Inc.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Joe Luster
Sent: Wednesday, September 07, 2005 9:54 AM
To: vantage@yahoogroups.com
Subject: [Vantage] 6.1: ODBC problems


We are trying to pull information out of Vantage in Microsoft Access
2003 for various reasons. When trying to import or link to certain
tables such as the customer or parts tables, we get an error that says
something like too many indexes on the table. Crystal works just fine
when reporting on these tables. I have heard in this forum that
maintenance can be done on the database. Does any of this maintenance
include re-indexing or does anyone know how to fix this issue?





Thanks in advance.



Joe Luster

Network Administrator

Cold Jet, LLC

513-831-3211 ext. 308

513-831-1209 FAX



<http://www.coldjet.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




SPONSORED LINKS
Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Mem
bership+database+software&w2=Database+mortgage+software&w3=Pda+database+
software&w4=Database+management+software&w5=Database+marketing+software&
w6=Online+database+software&c=6&s=190&.sig=zumlzfMugtt6gdHbPv4SEw>
Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Membe
rship+database+software&w2=Database+mortgage+software&w3=Pda+database+so
ftware&w4=Database+management+software&w5=Database+marketing+software&w6
=Online+database+software&c=6&s=190&.sig=gjZta7wG6hZqdrJXzK2Teg>
Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Membership
+database+software&w2=Database+mortgage+software&w3=Pda+database+softwar
e&w4=Database+management+software&w5=Database+marketing+software&w6=Onli
ne+database+software&c=6&s=190&.sig=3Hn54KU1wFHab_pC8mcmQw>
Database management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Mem
bership+database+software&w2=Database+mortgage+software&w3=Pda+database+
software&w4=Database+management+software&w5=Database+marketing+software&
w6=Online+database+software&c=6&s=190&.sig=36Lz5dDq6L3dzupiJwAffg>
Database marketing software
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Memb
ership+database+software&w2=Database+mortgage+software&w3=Pda+database+s
oftware&w4=Database+management+software&w5=Database+marketing+software&w
6=Online+database+software&c=6&s=190&.sig=k5h2EoDyGba8G2MtsW5WSQ>
Online database software
<http://groups.yahoo.com/gads?t=ms&k=Online+database+software&w1=Members
hip+database+software&w2=Database+mortgage+software&w3=Pda+database+soft
ware&w4=Database+management+software&w5=Database+marketing+software&w6=O
nline+database+software&c=6&s=190&.sig=-puLLcDG0gUTIJTiT0fjEw>

________________________________

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]
2
We are trying to pull information out of Vantage in Microsoft Access
2003 for various reasons. When trying to import or link to certain
tables such as the customer or parts tables, we get an error that says
something like too many indexes on the table. Crystal works just fine
when reporting on these tables. I have heard in this forum that
maintenance can be done on the database. Does any of this maintenance
include re-indexing or does anyone know how to fix this issue?





Thanks in advance.



Joe Luster

Network Administrator

Cold Jet, LLC

513-831-3211 ext. 308

513-831-1209 FAX



<http://www.coldjet.com>







[Non-text portions of this message have been removed]
3
The following link shows various limitations with Access - Indexes per table
<= 32 as well as other issues.

http://www.georgehernandez.com/xDatabases/MSAccess/Index.htm

Hope it helps.

Charles
----- Original Message -----
From: "Joe Luster" <jluster@...>
To: <vantage@yahoogroups.com>
Sent: Wednesday, September 07, 2005 10:54 AM
Subject: [Vantage] 6.1: ODBC problems


> We are trying to pull information out of Vantage in Microsoft Access
> 2003 for various reasons. When trying to import or link to certain
> tables such as the customer or parts tables, we get an error that says
> something like too many indexes on the table. Crystal works just fine
> when reporting on these tables. I have heard in this forum that
> maintenance can be done on the database. Does any of this maintenance
> include re-indexing or does anyone know how to fix this issue?
>
>
>
>
>
> Thanks in advance.
>
>
>
> Joe Luster
>
> Network Administrator
>
> Cold Jet, LLC
>
> 513-831-3211 ext. 308
>
> 513-831-1209 FAX
>
>
>
> <http://www.coldjet.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
>
>
>
>
>
>
>
>