Oracle and VB

Here is one for you Oracle/VB experts.  I have an ODBC connection to an Oracle DB on a UNIX box.  In my Oracle table, I have columns setup using the NUMBER,VARCHAR2 & DATE datatypes.  Using all the Oracle tools I can perform selects on all the columns, no problem.  When I use a select from my VB app on any column with datatype NUMBER, nothing is returned.  The selects on the VARCHAR2 and DATE columns work just fine.  What's up?  I am by no means a VB or Oracle expert.  I am using Oracle 8 and VB 6.  Hopefully, I've supplied enough info.
rrh0561Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

rovermCommented:
Did have the same problem: after re-installing the oracle drivers everything worked fine !
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rrh0561Author Commented:
What do you mean by re-installing the Oracle drivers?
0
sudhi022299Commented:
which ODBC driver are you using ? Oralce or Microsoft ?

To  find out that , go to control panel and check the company name next to your datasource name.

Regards,
Sudhi.
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

rrh0561Author Commented:
It is system DSN using an Oracle ODBC Driver.
0
ZLeaderCommented:
I have seen this problem in Access when an Oracle table is indexed on a floating point number field.  Is that the case here?

If so, the problem is rooted in the way VB/Access rounds the floating point value for its use.  For some reason, the numbers are rounded/handled inconsistently causes your app to loose its way to the data...

If you do have the number indexed, and this is the problem, taking off the index would clear this up.

Good luck.  
0
ceroCommented:
I'm not sure but, I think I have a similar problem, see my question .
Q.10252839 - Oracle with Disconnected recordset.
0
rovermCommented:
I ran the setup of Oracle (8) again.
0
sudhi022299Commented:
what happened after you did it ?

in the system dsn tab look for the driver name and post whether it is using MS or Oracle ODBC driver .

Regards,
Sudhi.
0
rrh0561Author Commented:
Adjusted points to 200
0
rrh0561Author Commented:
I've tried a few things.  I re-installed the oracle client, which didn't help.  I tried an MS for Oracle DSN, that worked once, now I get an initializing provider error.  The MS driver is not my preferred method anyway.  I performed an Oracle ODBC test using the Oracle DSN , with a SELECT of the NUMBER datatype, that returned the data.  I am coming to the conclusion that it is a VB issue.  I am doubling the point value.  Does anyone have a solution?
0
rrh0561Author Commented:
Got it.  Went to oracle.com and downloaded the latest drivers.  Works great.  Thanks to all who responded.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.