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.
Code:
[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.
Code:
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.