Informix connection string ADO without DSN

[jimrward]

trying to setup a connection to unix informix database, i can do it with a DSN but would prefer to do it with a connection string for auditing purposes

keep getting run time error -2147467259, driver manager error data source name not found and no default driver found, using same parameters as supplied to system DSN, but it does not want to bite grrrr

i have edited below to desensitise the settings

StrDriver = "DRIVER={INFORMIX 3.82 32 BIT}; " & _
"DB=sysjim; HOST=jim_3;" & _
" SRVR=jim_tcp; SERV=jim_tcp; PRO=onsoctcp; " & _
" UID=jimwa; PWD=jimpw; "

objConnection.Open StrDriver

 

[jimrward]

cracked the code carruthers

stand down eveyone