oracle odbc & oledb driver problems
Posted on 2005-04-30
i want to make connectivity oracle database with vb 6.
i make a server by using Net8 Configration Assistant
for this purpose i use following procedure
the programm running fine but on MSHFlexGrid control giving problem Script out of Range on
.TextMatrix(0, 1) = "Code"
and ODBC driver does not support the requested properties on
Rs.Open Sql, Cn, adOpenStatic, adLockReadOnly
When i use following procedure
Cn.Open "Provider=OraOLEDB.Oracle;Data Source=server1;user id=temp;Password=temp;"
then MSHFlexGrid control problem solved but giving other problem like
- not make recordset properly
- when i insert date like 30-Apr-05 it goes in table like 05-apr-30
please help me with a better procedure