I have changed my vb 6.0 apps so they can connect to SQL Server 2005.
I changed the provider from MDAC to SQLNCLI.
This is because i want to have full access to the new functionalities of SQL Server 2005.
What about VB.net ? people at the company use a connection string like this:
"Data Source=servername;Initial Catalog=databasename;Integrated Security=True"
Can they take full advantage of SQL Server 2005 new functionalitites? or they have to change anything like i did in vb 6.0?
P.S - They (developers) say that they are using the class "SQLClient" to connect.