ODBC Connection / connectin string in web.config
Hi Everyone
I have connection strings in web.config file pointing to DB but no ODBC connection configured on the server. How the application can connect to the database. in the connection strings , sql client is defined as provider method , does it means that I have to install SQL client on the App server ? I used to create ODBC connection on the APP server for it to connect to SQL when I used to work before with app migration 7 years ago. I clearly remember creating odbc connections, This seems different.
I have connection strings in web.config file pointing to DB but no ODBC connection configured on the server. How the application can connect to the database. in the connection strings , sql client is defined as provider method , does it means that I have to install SQL client on the App server ? I used to create ODBC connection on the APP server for it to connect to SQL when I used to work before with app migration 7 years ago. I clearly remember creating odbc connections, This seems different.
ASKER
Hi Ryan
Thanks
All .Net frame work already installed on the server. So it is enough, then there is no reason to install extra stuff on the server . Why is it so that if .Net Frame work installed , SQL client is not needed ?
and when i look at the ODBC creation ( see attached ) , I see SQL under driver section even if you don't install anything. Is this not for SQL connection ? do you still need to install SQL client , providing that there is no .Net Framework installed as you mentioned
ODBC.JPG
Thanks
All .Net frame work already installed on the server. So it is enough, then there is no reason to install extra stuff on the server . Why is it so that if .Net Frame work installed , SQL client is not needed ?
and when i look at the ODBC creation ( see attached ) , I see SQL under driver section even if you don't install anything. Is this not for SQL connection ? do you still need to install SQL client , providing that there is no .Net Framework installed as you mentioned
ODBC.JPG
I could be missed out but you may also need to download and install ODBC .NET Provider
https://support.microsoft.com/en-sg/kb/310988#bookmark-2
https://support.microsoft.com/en-sg/kb/310988#bookmark-2
ASKER
Probably.. Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
not necessarily, what you need is to install the .NET framework into your App Server.
but it's got if you have SQL client (like SSMS) so that you can querying and setup up your database when necessary.