Sorry for the poorly worded question. I have a requirement coming from a non-technical person that I need to understand. I basically said, "Use 'Driver={SQL Server};Server=SERVERNAME\INSTANCENAME;Database=DATABASENAME;Uid=UNAME;Pwd=PASSWORD;';here and use here Server=SERVERNAME\INSTANCENAME;Database=DATABASENAME;Uid=UNAME;Pwd=PASSWORD;';.
I do not get any extra help here.
Although this seems to miraculously fix the error, I want to understand what it is that I am changing, so I can leave a comment for the next developer, plus I can structure the code and name variables differently, depending on the meaning of the change.
Work is underway around ASP.net, reporting, SQL Server 2008.
Please give me some examples when you will use one connection string over another. Feel free to edit the question if you see a way to improve it.
When can you lose 'Driver={SQL Server};?
Thank.
EDIT: SQL Server 2008 is the target database, but others may be used ... or may be used in the future.
source
share