ConnectString property issue.
Posted: Thu 30 Aug 2007 14:32
Hi Folks!
There's a problem with the ConnectString property and passwords that contain '@' characters. Basically it's using Pos() to get the position of '@' and it needs to use something that will skip a double quoted password (which you need for passwords containing "odd" characters.) So basically the Connectstring could be something like:
scott/"pass@word"@myserver
The function will fail because it will parse out the server part as "word"@myserver"
Let me know if you have questions!
-Mark Ford
Benthic Software
There's a problem with the ConnectString property and passwords that contain '@' characters. Basically it's using Pos() to get the position of '@' and it needs to use something that will skip a double quoted password (which you need for passwords containing "odd" characters.) So basically the Connectstring could be something like:
scott/"pass@word"@myserver
The function will fail because it will parse out the server part as "word"@myserver"
Let me know if you have questions!
-Mark Ford
Benthic Software