Switching ADO Connection from SQL SERVER to Oracle
Posted on 2006-05-11
I am having trouble getting data returned from my ADO connection.
My ADO connection in VB 6 looks like this:
conn.Open 'OracleDC', 'test', 'test'
Note: 'OracleDC' is an ODBC connection I've set up using the Oracle 10g driver.
The connection actually opens and sql statements can be executed on the connection however, no data is being returned when it should.
I noticed some things in my connection object which look odd to me but that could be because I'm not that familiiar with setting up ADO connections.
Provider=MSDASQL.1;Password=test;User ID=test;Data Source=OracleDC;Extended Properties="DSN=OracleDC;UID=test;PWD=test;DBQ=TESTDB;DBA=W;APA=T;EXC=F;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;BTD=F;BAM=IfAllSuccessful;NUM=NLS;DPM=F;MTS=T;MDI=F;CSR=F;FWC=F;FBS=64000;TLO=O;"
Is it correct that it's using the Provider=MSDASQL provider? If not, I don't know how to change this since i'm not setting it
Please let me know if I need to provide more information.