|
-
Jun 22nd, 2006, 05:34 AM
#1
Thread Starter
Fanatic Member
RE: Transactions in SQl Server
Hi,
going to be changing a conente management system that used dynamic queries to transactions within its structure, and would like to ask the following.
When using the ADO commandset object in Visual Basic, whats best to retrieve these SQl fiels that contain the transction, file or virtual?
file
VB Code:
CNNcommandSet = "H:\CMS\QUERIES\T-SQLstoredtrans.sql"
Or
VB Code:
CNNcommandSet = Server.MapPath("//Queries/T-SQLstoredProc.sql")
Any ideas or does anybody have a better way of doing this?
Ta
Kai
Last edited by kaihirst; Jun 22nd, 2006 at 05:34 AM.
Reason: incorrect spelling
As the information I give is useful in its nature, consider using the RATE POST feature located on the bottom left of this post please..
A few things that make a good Developer a Great One.
 Methodical and a thorough approach to research and design inevitably leads to success.
Forward thinking is the key to Flow of control.
Never test in the design environment, always test in real time, you get the REAL results.
CBSE & OOSE are the same animal, they just require different techniques, and thinking.
SEO is a globe of objectives, SE rankings is an end to a means for these objectives, not part of them.
The key to good design is explicit attention to both detail and response.
Think Freely out of the "Box" you're in..... You will soar to better heights.
Kai Hirst - MSCE, MCDBA, MCSD, MCP, MCAP, MSCT
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote