Greetings,

Chapter 8, p. 276, 4th paragraph:
"...If you want to use SQL Server, you can simply replace OleDb with SqlClient in the object names; just change the connection string, and continue working."

All well and good, except that the text is not explicit about what you're supposed to change the connection string *to*...

Figuring out the path for the "Data Source" argument is easy enough, but what about the "Provider" argument? Presumably it's not "Microsoft.Jet.OLEDB.4.0"...

Some help?

Hi there,

Take a look here: http://www.connectionstrings.com/

Under SQL Server| SqlConnection you'll find the proper syntax. You shouldn't set the Data Source to a file path (to the .mdf) but to the server's (instance) name.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Thanks for the reply, I also found this in another Wrox book when I was hanging out at Borders yesterday. But shouldn't the paragraph I cited read as follows?:

"...If you want to use SQL Server, you can simply replace OleDb with SqlClient in the object names; just import the System.Data.SqlClient namespace, change the connection string
to "Server=myservername;Database=mydatabase;Trusted_C onnection=True | False"
 and continue working."
--
'bonehead
-------------------------
"The most likely way for the world to end,
 most experts agree, is by accident.
 That's where we come in.
 We're computer professionals.
 We cause accidents."
 Nathaniel Borenstein, Senior Computer Scientist, IBM

Yeah, I think so. Your version of it provides more and more accurate detail, which a novice reader really needs....

Imar

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.