Learn how to a build a cloud-first strategyRegister Now


oracle odbc & oledb driver problems

Posted on 2005-04-30
Medium Priority
Last Modified: 2010-05-02
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

Cn.Open "DSN=oracle;UID=temp;Password=temp;SERVER=server1;"

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

Question by:pak_slm
  • 3
  • 2
LVL 14

Expert Comment

by:Shiju Sasidharan
ID: 13900154
have a look at this

LVL 14

Expert Comment

by:Shiju Sasidharan
ID: 13900165
try this
 Cn.Open "Provider=MSDAORA;Data Source=server1;user id=temp;Password=pswd;","temp",pswd"
 'if Sql is sql statement
            Rs.Open Sql, Cn, adOpenKeyset, adLockPessimistic, adCmdText
 'if Sql is table name
          '  Rs.Open Sql, Cn, adOpenKeyset, adLockPessimistic, adCmdTable


Author Comment

ID: 13900255
Cn.Open "Provider=MSDAORA;Data Source=server1;user id=temp;Password=pswd;","temp",pswd"

this line giving systax error
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

LVL 14

Expert Comment

by:Shiju Sasidharan
ID: 13900278
sorry missed quotes

Cn.Open "Provider=MSDAORA;Data Source=server1;user id=temp;Password=pswd;","temp","pswd"

Author Comment

ID: 14001527
i have understand correct the problem myself

Actually when i use

Cn.Open "Provider=OraOLEDB.Oracle;Data Source=server1;user id=temp;Password=temp;"

OraOLEDB use date format like '2005-05-13 12:42:10'

when i change the date format then the problem solved

so please delete this question and refund my points.


Accepted Solution

modulo earned 0 total points
ID: 14419000
PAQed with points refunded (125)

Community Support Moderator

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Suggested Courses
Course of the Month20 days, 15 hours left to enroll

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question