emi_sastra
asked on
Attach File From Folder.
Hi,
I have several sql file (mdf) (sql 2005) file in a folder.
How to attach file directly from the folder using script of vb code without have to mention filename.
Please help how to do it.
Thank you.
I have several sql file (mdf) (sql 2005) file in a folder.
How to attach file directly from the folder using script of vb code without have to mention filename.
Please help how to do it.
Thank you.
Last Comment
ASKER
Hi Steve,
That's single file attachment and we have to mention the filename.
txt = "sp_attach_db @dbname = N'Test', " & vbCrLf & _
"@filename1 = N'C:\Database\test_data.MD
"@filename2 = N'C:\Database\test_log.LDF
It use vb2003, does it work using vb2005 for the above code?
Thank you.
That's single file attachment and we have to mention the filename.
txt = "sp_attach_db @dbname = N'Test', " & vbCrLf & _
"@filename1 = N'C:\Database\test_data.MD
"@filename2 = N'C:\Database\test_log.LDF
It use vb2003, does it work using vb2005 for the above code?
Thank you.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Hi Steve,
I get it.
Thank you very much for your help.
I get it.
Thank you very much for your help.
Glad I could help :)
Visual Basic.NET
Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to Visual Basic pre-2002, it is not the same technology,
96K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
You can find a coded example on how to do this here.
http://www.a1vbcode.com/snippet-3362.asp
Regards
Steve