Semicolon in Connection String

[wqweto]

You can also use apostrophes as string delimiters in a connection string.

This

cn.Open "Provider=SQLOLEDB;Data Source=UCSDB;User ID=test;Password='test;123'"

bombs out with

Format of the initialization string does not conform to the OLE DB specification.

so it turns out single quotes cannot be used to escape semicolons inside values because single quotes can be used to escape double quotes inside value only.

Edit: Reading again the quoted reply I'm not sure what "string delimiters" actually means.

cheers,
</wqw>