Hi,

I´m trying to using ODBC Conection to acces the SQLServer DataBase but when i´m using the connection string in the WEB:CONFIG like that

<add name="SiteSqlServer" providerName="System.Data.Odbc" connectionString="Driver=SQL Native Client;server=DNN_WEBFOSYGA;"/>

it that not work ... the error is that Driver it´s  Keyword not supported: 'driver'.

the same is when i use dsn

DNN support ODBC Connections?

IT doesn't work ... i try like

<add name="SiteSqlServer" connectionString="Driver=DNN_ODBC;Server=DPSWDB09;" providerName="System.Data.Odbc" />

I'm not sure if DNN support ODBC Conecctions i was looking for System.Data.Odbc in the folder bin but i did not find it.

What can i do? I need to do a conecciont string where i did not send the userid and password.

System.Data.Odbc will not be in the bin folder - it should be in the GAC... Also, the SQL version is built using the Enterprise Library (specifically the dll in the bin folder named Microsoft.ApplicationBlocks.Data.dll. I don't remember if the particular version in the bin folder supported ODBC or not but you're better off using the native SQL client that is configured with DNN... 
I just took a cursory glance at ApplicationBlocks and I believe it builds off System.Data.SqlClient which is NOT the same as the ODBC drivers...

If you are concerned about the user id and password can't you encrypt your user id and password?

Sanjay