Given the following string, I need to write a code that would return
“MYDATABASENAME” (the part between “;DB=” and the next “;”)
**************
ODBC;DSN=MyDSNName;SRVR=MyServerName;DB=MYDATABASENAME;UID=ID;PWD=password
**************
How would I use the InStr, Left&, Right$, and Len functions to accomplish
this?
THANKS!