I use Standard Report Wizard in Crystal Report 11 , when i connect to the native database with ODBC, some Table I can select it but some Table I cannot select it (such as Sales Header).
The error is "Database Connector Error : '22003:[Microsoft Business Solution Aps][Microsoft Business Solution-Navision ODBC Driver]Out of Range [Database Vendor Code: 1011]' "
So I had to test it, And I found that Table Sales Header has more Column or Field. If the table has only 30 columns or fields, The Crystal Report can select the table.
Do you have any idea for solving my problem?
Thanks
P o N
0
Comments
My Vendor table has 118 fields - access no problem
1)create a blank report
2)create a new connection
3)ODBC (RDO)
4)Select data source (you should see the source you created with c/odbc)
5)Login & you tables should appear.
I have also setup my c/odbc setup options as
commit cache ->YES
DBMS Cache (KB) 100000
Enable Blob Fields->YES
Identifiers->All Except DOT
Option Field Type->TEXT
Language->Auto
Query Time Out->NO
Query Time Out->"Blank"
Read Only->NO
Tmp Path->"Blank"
Closing Date Support->No
Use Regional Decimal Symbol->No
http://www.BiloBeauty.com
http://www.autismspeaks.org
and i am still getting the connector error vedor 1011 when i set up ODBC like above
please advise
I use the ODBC (RDO) but that works for me.
Try the OLE DB (ADO) is you have problems as suggested above.
see pic
http://savatage99.googlepages.com/Cryst ... ctions.JPG
(enlarge for clarity)
Your C/odbc or n/odbc should be setup normally - the connection change is in Crystal not in the odbc setups
http://www.BiloBeauty.com
http://www.autismspeaks.org
thats were i was trying to do it, and i was gettin my error
this is what i am doing, onec i get to that screen you should me
i select Microsoft OLE DB provider for ODBC drivers
i select the ODBC connection I have set up to Navision
this is the error i get, its long
logon faild
details ADO error code: 0x
source Microsoft OLE DB Provider for ODBC Drivers
Description : [Navision a/s][Navision attain ODBC Driver]data source rejected establishment of connection SQL State: 08004
Native Error: [database vendor code: 1058]
http://www.BiloBeauty.com
http://www.autismspeaks.org
Tools->License Information
Else you can't use it.
I never had problems with the regualr c/odbc setup so I never tried the Ole DB path.
But as I look at it - you double click on OLE DB(ADO) it should give you a list of providers. Try choosing "Microsoft OLD DB Provider for ODBC Drivers" then when you hit NEXT it should bring you to your c/odbc driver you setup! Select & hit next - ender your User ID - hit finish.
I can connect that way too.
http://www.BiloBeauty.com
http://www.autismspeaks.org
i can connect with the ODBC connection in the database wizard but i get this when i try to connect to the G/L Account table
"Database Connector Error : '22003:[Microsoft Business Solution Aps][Microsoft Business Solution-Navision ODBC Driver]Out of Range [Database Vendor Code: 1011]' "
Thats why i tried the other. I can connect to other tables, but i get the above error on some tables.
frustrating eh?
install the c/odbc in UserDSN & System DSN identically - see if that helps :-k
http://www.BiloBeauty.com
http://www.autismspeaks.org
that didnt work either ](*,)
It sounds like you're in the ballpark but one thing isn't setup correctly ](*,)
http://www.BiloBeauty.com
http://www.autismspeaks.org
like i said, i can run a report on some tables, but some of them i get the error from the first post in this thread.
and i can not do the OLE DB (ADO) like mabu did.
really ODD!!! ](*,)
Well the last thing I can think of is follow the C/odbc setup doc that comes with on the product cd and see if you missed something.
Is it just the huge tables that you have trouble with?
what version of crystal are you using - & did you get all the updates & hotfixes?
http://www.BiloBeauty.com
http://www.autismspeaks.org
if i get this working i am buying it ASAP
i will try that!
i might give up for the day and try and post again tomorrow, thank you
rj
should i be looking server side?
i am really ](*,)
this is what i had to do
when i set up the ODBC, i did not set up as a User DSN, but as a System DSN only.
under options, I left EVERYTHING as default EXCEPT identifiers set as: a-s,A-Z,0-9_
after that, i connected thru the data wizard as OLE DB (ADO)
BINGO! i was able to connect to the large table as i was trying to do before.
Hopefully this helps others too!
rj
\:D/
http://www.BiloBeauty.com
http://www.autismspeaks.org