strDataSourceName="Provider=SQLNCLI;Server=(local);Database=dbname;UID=uuu;PWD=zzz;"
...Try that one.