DSN vs SQLOLEDB
I have the following connection strings
MM_tosql_STRING = "dsn=xxxxxxx;uid=xxxxxx;pwd=xxxxxx;"
MM_tosql_STRING = "Provider=SQLOLEDB;Data Source=xxxxxx;User Id=xxxxxxx;Password=xxxxxx;"
they both work BUT
the dsn string does not display certain data the way I want it to when viewing on a webpage
and the SQLOLEDB string does not reckognize any variables from stored procedures when using repeat regions or page sets
can any one explain this and give me a solution???
as always,
Joe Mama loves you
|