how to access the Sql server ...

hi ,

I have the Data and log file of the pubs dataBase(pubs,pubs_log)...

Now i want access the pubs database through the C#.net without installing the Sql server in my system.. just like the Msaccess. please any body tell me.. is it possible.

Thanks & Regards,

S.Sajan

That is not possible.

You must have SQL Server installed to use the Northwind and Pubs SQL Server databases.

You can get an Access version of Northwind here:

http://www.microsoft.com/downloads/details.aspx?FamilyID=C6661372-8DBE-422B-8676-C632D66C529C&displaylang=EN

You can get an Access version of Pubs here:

http://authors.aspalliance.com/andrewmooney/53/pubs.zip

You could then use them in your C# application with the JET provider.

|||

hi Arnie Rowland,

Thanks for ur reply....my doubt is i want to deploye my project in client side.. in that time th don't see the data base... so..without installing the Sql server can access the database through the c#.net

|||

Your application can also install the SQL Server.

See these resources:

SQL Server 2005 UnAttended Installations
http://msdn2.microsoft.com/en-us/library/ms144259.aspx
http://www.devx.com/dbzone/Article/31648