Linking to an Oracle Back End Part 2

[Paul H]

I posted a related thread last year which you can find here.



https://www.accessforums.net/showthr...242#post396242

I have linked to an Oracle backend using a file DSN with this connection string.

[ODBC]
DRIVER=Oracle in OraClient11g_home1_32bit
UID=
TSZ=8192
ODA=F
MLD=0
TLO=O
FBS=60000
FWC=F
CSR=F
MDI=Me
MTS=T
DPM=F
NUM=NLS
BAM=IfAllSuccessful
BNF=F
BTD=F
RST=T
LOB=T
FDL=10
FRC=10
QTO=T
FEN=T
XSM=Default
EXC=F
APA=T
DBA=W
DBQ=TPDPROD.WORLD
SERVER=TPDPROD.WORLD

I learned from the earlier post that this connection string would be embedded in the tables and I wouldn't need to distribute or use a DSN. This seemed to work, but I tried another user and encountered this error when the Database was loading.
This is the code that caused the error. This same code works perfectly on my machine.

        conStr = "Driver={Oracle in OraClient11g_home1_32bit};Server=" & OraTPDDataSource & ";UID=" & TPDOraUserName & ";PWD=" & TPDOraUserPassword & _
        ";TSZ=8192;ODA=F;MLD=0;TLO=O;FBS=60000;FWC=F;CSR=F;MDI=Me;MTS=T;DPM=F;num=NLS;BAM=IfAllSuccessful;BNF=F;BTD=F;rst=T;LOB=T;FDL=10;FRC=10;QTO=T;FEN=T;XSM=Default;EXC=F;APA=T;DBA=W;DBQ=" & OraTPDDataSource
    
        conTPD.Open conStr

We received this error when we simply tried to open a table.




That's about it. I'll wait for your feedback.

[Gicu]

Hi Paul,

i don't think there is a problem with the connection string, but with the actual driver; all of the machines running your application have to have the same Oracle driver installed (in your case "Oracle in OraClient11g_home1_32bit"). The connection string is providing the required info but it is the driver software that actually connects to your be.

Cheers,
Vlad

[Paul H]

Am I correct in thinking that the tables would link automatically without the File DSN if they had the correct driver?

[Gicu]

Yes, they will "stay" linked and open OK if the right driver was installed and the right permissions were in place (I assume you used database authentication with user ID and password).

Cheers,
Vlad