That's what I am working on right now and I am encountering errors in the program like if I am openning a view, it's not letting, otherwise everythings working. The connection string on the property page is below, maybe you can help me figure out what I can strike out from the connection string.

objConnOracle = "DRIVER={ORACLE ODBC DRIVER};SERVER=HFIRE_PRD;UID=ID_NAME;PWD=PASSWORD; DBQ=HFIRE_PRD;DBA=W;APA=T;FEN=T;QTO=T;FRC=10;FDL=1 0;LOB=T;RST=T;FRL=F;MTS=F;CSR=F;PFC=10;TLO=O;"

I get a run-time error 91;
Object variable or With block variable not set.

This is the error message I get. Once we get this resolved I will use this connection string for all Oracle connections. Thanks for your help.

I was wrong in pressuming that I get this error only when I access a view. I decided to use a table and it gave me the same error message. It seems like when there is no record in the table it gives me this error. I validate the recordset by with

If not recordset.eof then
   update ACCESS table
End if

Where am I going wrong?

Thanks,
Judy

Okay, I finally got it to work. I had to try different connection strings. I ended up using the following connection string:

objConnOracle = "DRIVER={Microsoft ODBC for Oracle};UID=[MY_USERID];PWD=[MY_PASSWORD];SERVER=[SERVER_NAME];"


Thanks for your help. I appreciate all the suggestions you gave me. That got me started to experiment.


Cheers,
Judy

hi,

the error msg is : Run-time Error '3706'
Provider cannot be found. It may not be properly installed.




I am having problem with my VB application. I was using sql server 2000 local on my pc with VB and it was working fine. NOw I have sql server 2005 express on a network pc.

when I changed the connection string for that, I am getting the above error

here is my connection string:

Dim cn As ADODB.Connection
    Set cn = New Connection
    cn.ConnectionString = "Provider=SQLNCLI.1;Integrated Security=SSPI;" & _
        "Persist Security Info=False;" & _
        "AttachDBFileName=" & App.Path & "\xstar_Data.mdf;Data Source=starsql\sqlexpress"
    cn.Open



please help me.

I try installing the latest mdac_tpe and vbrun60sp5.exe for VB

but no help.


please help?????????

***************


***************