i have excel application used several users, , input data on connection string changed code via users input.
.connection = array(array( _ "odbc;driver={" & driver & "};server=" & server &";uid=" & user & ";pwd=" & pass & ";dbq=" & server & ";dba=w;apa=t;exc=f;xsm=default;fen=t;qto=t;frc=10;fdl" _ ), array( _ "=10;lob=t;rst=t;btd=f;bnf=f;bam=ifallsuccessful;num=nls;dpm=f;mts=t;mdi=me;csr=f;fwc=f;fbs=60000;tlo=o;" _ )) my driver "oracle em oraclient11g_home2" each user can have different homes. there way code, or easy way tell users how find drivers input?
Comments
Post a Comment