ODBC Connection UID PWD Windows XP SP2

[goran.fetter@spintop.se]

Hi, Im trying to create a ODBC connection to a SQL server (System DNS) with
a SQL userid and password, using UID and PWD, but it doesnt work on Windows
XP SP2, is this a feature?, I can not save the password in the GUI either,
NEED HELP!!

[Haggis]

" >
wrote in message ...
> Hi, Im trying to create a ODBC connection to a SQL server (System DNS)
> with
> a SQL userid and password, using UID and PWD, but it doesnt work on
> Windows
> XP SP2, is this a feature?, I can not save the password in the GUI either,
> NEED HELP!!
>
>

gnPomsConnection = SQLSTRINGCONNECT('Provider=MSDASQL;DRIVER={MySQL ODBC
3.51
Driver};SERVER=???????????;DATABASE=????;UID=????; PASSWORD=????;PORT=3306;OPTION=16384;STMT=;')

here is what i use....XPProSP2 ...I have found problems with ODBC connector
above version 3.51.09 (using FDSN)