| A list of ODBC driver specific attributes needed to recreate the ODBC DSN | |
| Syntax: | String = object.DSNAttributes |
| Description: | This list of attributes is in the form of
name=value pairs and are delimited by semicolon. The entire list is
terminated with a semicolon (i.e. two semicolons at the end). When
using ODBC installer functions, such as SQLConfigDataSource, it
will be necessary to replace the semicolons with null bytes. You
will also need to add an attribute containing the name of the DSN
you wish to configure. Example: ...'Add temporary DSN NAME to the list of attributesAttribs = "DSN=MYDSN;" +
oCimDbapTableDSNResponse.DSNAttributes'Attributes are delimited by semicolon. Replace each with
Null byteAttribs = Replace(Attribs, ";", Chr$(0)) 'Attempt to create the ODBC DatasourcehaveDSN = SQLConfigDataSource(0, ODBC_ADD_DSN,
oCimDbapTableDSNResponse.ODBCDriverName, Attribs)...'Helper function to replace one delimiter with
anotherPublic Function Replace$(Haystack$, Needle$,
Replacement$)Dim s$Dim i&s = HaystackWhile InStr(s, Needle) > 0i = InStr(s, Needle)If i = 1 Thens = Replacement & Mid$(s, i + Len(Needle))Elses = Left$(s, i - 1) & Replacement & Mid$(s, i +
Len(Needle))End IfWendReplace = sEnd Function |