Posted on 2002-06-20
Last Modified: 2012-05-04

I have created a database project in VC++ 6.0. I selected an odbc DSN name from the list. Now when i go to the database tab and tried to expand the "table" , VC++ creates "MSDEV_TRAIL_TABLE" table in the database. for view, it creates "MSDEV_TRAIL_VIEW". If they are already there, it creates "MSDEV_TRAIL_TABLE1" and "MSDEV_TRAIL_VIEW1" in the database. How to avoid this temp. tables/views ? Is there any way to tell VC++ not to create those items in the database? I am using SQL Server 2000

Sankar S.
Question by:sankars98
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
LVL 49

Expert Comment

ID: 7099769
Are you sure of the spelling?  I read the it creates
This text string can be found in the file DEVDTG.PKG It may be related to the need to verify that it can create a SP, View, or Table so that it can complete its functions.

-- Dan

Author Comment

ID: 7105530

   Thanks for the response. You are right. It is MSDEV_TRIAL_TABLE. I dont understand the remaining parts in your post. Could you please explain it? Is there anyway to not to create these tables/views in the db?

Sankar S.
LVL 49

Accepted Solution

DanRollins earned 150 total points
ID: 7105664
I could find no direct information.  But it would make some sense if the Wizard needed to try to create a new table as part of its setup (so it could dim out controls and so forth).  

It might use a name like "Trial Table" because a "trial" is when you "try" something.  So why doesn't it just delete the tables after verifying that it could create them?  That could be a bug.  

>>Is there anyway to not to create these tables/views in the db?

Have you installed the latest service pack update?

If so, then you might need to just delete the tables manually.  Be careful... I could be wrong in my guess that they are purely for temporary purposes.

-- Dan

Author Comment

ID: 7107629
What happend to my comment... ???

Author Comment

ID: 7107651

 Thanks for your response DanRollins. Yes, I was also expecting that those tables will get deleted when i close VC++ or if i open another project in VC++. But it didnt happen. Like you said, it could be a bug. I couldnt find any information about this table in msdn or in the net. Now I am manually deleting those tables/views/sps. Thas for trying to help me.

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Written by John Humphreys C++ Threading and the POSIX Library This article will cover the basic information that you need to know in order to make use of the POSIX threading library available for C and C++ on UNIX and most Linux systems.   [s…
Introduction This article is a continuation of the C/C++ Visual Studio Express debugger series. Part 1 provided a quick start guide in using the debugger. Part 2 focused on additional topics in breakpoints. As your assignments become a little more …
The viewer will learn how to pass data into a function in C++. This is one step further in using functions. Instead of only printing text onto the console, the function will be able to perform calculations with argumentents given by the user.
The viewer will be introduced to the member functions push_back and pop_back of the vector class. The video will teach the difference between the two as well as how to use each one along with its functionality.

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question