how to AttachDbFilename in application's directory

How can I use AttachDbFilename in DbNameDataSet.xsd to access the database in the same directory as the exe file (i.e. the application using it)?You need to specificy AttachDBFilename=True in the connection string of the SQL Connectionsql

how to apply a sql script file on Sql server 2000 without OSql.exe

Hi guys

I need to apply a sql script file on Sql server 2000 by .net 2.0 program. but on the current running machine, there is not Osql.exe file. Do you guys know how to execute the sql file without the command? Is there any way provided in .net library ?

Thanks for you response!

This Should help.|||

Hi Ken

thanks for your response.

if my script file is long with comments,translation. if I combine all text lines in the file into one string to execute on sql, an error will be thrown out. how do you think that situation?

|||

Hi andi,

When you have installed a SQL Server instance, the osql.exe tool will always be installed. If you don't have SQL Server instance, the scripts cannot be applied to any SQL Server instance.

sql