Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Converting from Access to Oracle Data source

Status
Not open for further replies.
rmangel

rmangel

Technical User
Apr 8, 2002
9
CA
When converting reports written on a temporary Access data source to the actual Oracle Data Source I am encountering the following Error: ODBC error: [Oracle][ODBC][Ora]ORA-01722:invalid number.

I have been receiving this repeatedly and have found no information as to the cause or preventative solution.

Is there a way to prevent this error when converting data from a Access source to an Oracle data source?

Is there a way to correct it in the reports that are currently creating the error?
 
Status
Not open for further replies.

Similar threads

JustMe24
  • Locked
  • Question
How to select from 2 rows in a table
Replies
1
Views
158
SoftwareRT
SoftwareRT
David Richardson
  • Locked
  • Question
Adding BLOB Fields to Reports in Crystal Reports Professional 8.5
Replies
7
Views
272
hilfy
hilfy
anandm19
  • Locked
  • Question
Crystal report byte array data to Unicode data format export issue
Replies
0
Views
150
anandm19
anandm19
tlbrown88
  • Locked
  • Question
How to duplicate data from main report lines for sorting purposes
Replies
2
Views
158
lbass
lbass
rwwagner
  • Locked
  • Question
Passing date range formula from main report to sub report
Replies
2
Views
229
lbass
lbass

Part and Inventory Search

Sponsor

Back
Top