6 Years
Discussion Span
Last Post by bilal_fazlani

You could use an Access database or an Excel spreadsheet. There are connection strings available for both of these. Even CSV files as I recall.

Votes + Comments

access seems to be a solution for this. Thanks Jim.

I have one more question.

I have seen "attachdbfile= xxx" parameter in a connection string when I was using MSSQL server.

what does it exactly do ?


It specifies the actual filename of the SQL database. I have never used this parameter. I specify the server name and database name and let SQL server figure out where the file is stored.

I was a SQL db Administrator (among many other rthings) before I retired, and there were a couple of times when I had to move our database files from one disk to another. Any applications that used the attachdb parameter to connect would have failed. None of them did. I can't think of any reason you would want to use it either.

Edited by Reverend Jim: n/a

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.