I can't Import Data from My DB using Ms Query (Excel) under Ingres 2010

[suze]

hello
sinc installing ingres 10 I can't import data using Excel (MS Query).
in Ingres 2006 it was possible default. there no configuration to do?

[bilgihan]

Which Ingres 10 release is being used for this purpose?
See file version.rel

[suze]

II 10.0.0 (a64.lnx/125)NPTL

in the same occasion i want to know if there is updats or patchs for this release .
thanks

[bilgihan]

For community version, there is no patch ,fixes.

Some detail question.
1st: Which steps you try doing?
2nd: What messages, errors you see?

[suze]

excuse me sir
there is no error in the errorlog . its work if the table is not big (no lot of raws) .

[bilgihan]

Could it be, that your data contains some unicode character?
If yes you may create a database supporting this:
createdb -i <database-name>
And try loading your data into this.

[suze]

thank you for the answer
first i can't create agunst the data base because .
i don't think that my data base containe a unicode data but why it works normely under Ingres 2006 ?

[suze]

hello
I tried to create a database using createdb -i
but I still have the same problem
it is impossible to access a table that contains multiple record query using ms / ms odbc

[bilgihan]

Ok, this seems to be not relevant with unicode.
Thank for checking.

Could you please supply some info and screen shot:
- How do you import step by step?
- Did you try reducing amount of data?
... hat is the max number of rows which you can import?
- What you mention with "impossible to access a table ..."?
... Any specific query and any error message?

[suze]

hello
excuse me sir
i have lot of difficults to upload screen shot
i give you this link
screen shot.zip - 4shared.com - online file sharing and storage - download - sdsd sdsd
thanks