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?

[Webinar] Streamline your web hosting managementRegister Today

x
 
rovermConnect With a Mentor Commented:
Did have the same problem: after re-installing the oracle drivers everything worked fine !
0
 
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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
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
All Courses

From novice to tech pro — start learning today.