Vile's Q&A profile

• SQL Server Foxpro .net odbc data provider misidentifying strings as unicode

  Since my foxpro OLE driver has been rendered useless by service pack 1 for sql server 2005 I am forced to use the .net data provider for odbc. I am importing a number of tables.. each time I add the DataReader Source to the dataflow and connected it to the OLE DB Destination I get a load of the good old "cannot convert between unicode and non-unicode string data types" errors... So I'm having to do derived column transforms, for each and every column that it coughs up on. Using expressions like (DT_STR,30,1252)receivedby to convert the "recievedby" column to a DT_STR, Some of these tables have 100 string columns.. so I'm getting a bit sick of the drudgery of adding all these derivations... Is there any way to tell this ...Show All

• SQL Server return records between dates

  Hi, I need some help with this please. I have a database table which contains customer orders. I am trying to code my SQL select statement to: 1) Only return records where the record orderdate is within the last 30 days 2) Between two dates, selected from the datepicker control. With regards to issue 1, I could fill a table with all the records for the account in question and then for each record do a datediff between the records order date and the current date to determine if the number of days is within 30 days. If yes then add this record to a temp table and then set this table as the datasource for the datagridview. There must be a more efficient way With regards to issue 2) ...Show All

• Visual C# What happens when app exits and BG Thread is working on db

  Hi all, what would happen if my application exits and there is still a background thread running that is working (doing 100's of INSERTS and UPDATES) on the database from which the connection to the database was established in the application (Which is now exited). Would the queries fail to execute from the point the application exits it may well do. have you tried it sometimes it depends as the app will appear to exit but if the thread is still alive and kicking it will not exit fully (you will see it in task manager) until the processing has been complete. have you tried to see what happens :-) I guess it can "swing" either way. If the app exits, it will pretty much signal a thread abort exception to all running threads causi ...Show All

• SQL Server Import works but no data? Part 2

  Now I got a little bit further on my own. But, I have run into this issue with, "Not being able to import the data to the database". I can import the column headings, then that is were it ends. I was reading up on this and it made it seem as if you are to go back after you get the column headings. Then do the same to get all the rest of the data. But, for some reason the "Query or Copy" menu doesn't display to do the query action to import this data. Is there anyone who knows what I am talking about, please help.. I'm not able to catch if this is a continuous problem you have had previously, that helps if you can refer your old thread that was posted here. On the other hand confirm what is the edition of S ...Show All

• Visual Studio Team System How to get the users for a project in Security in TFS programmatically

  Hi as a part of TFS extensibility i need to make sure that all the projects in TFS should have only group accounts .There should not be any user account in Security.I need to check programmatically, that how many users are there in  security who don't come under any group,using TFS API.can any1 help me out in this. Thanks james for the post.But my requirement is bit different.I dont want to see for Team project's groups.Rather i want to make sure that any member in project security should be  group accounts.If we right click on a teamproject, then the secutiy option comes wherein we can add a new group or any windows users.I just want to get these Windows users for any of  my TFS projects projects. IGroupSecurityServ ...Show All

• SQL Server populate access database from a TableCollection

  Hi, I need to ask about how can I populate an access database tables directly with the tables in a TableCollection that already exist in my application. Thanks for any help, Aya. Thanks too much for the reply , but can I get some explanation about how to use the DTS. Thanks in advance, Aya. ...Show All

• Software Development for Windows Vista Works with Vista logo requirement question

  Your "Works with Windows Vista Software Logo Spec.doc" states " The application must be tested on both 32-bit and 64-bit versions of Windows Vista. " Our application is a 32-bit Windows application which works just fine on Windows Vista 32-bit OS. So if our application doesn't work "nicely" with 64-bit Vista does it mean that we will not qualify for the Works with Windows Vista Software Logo certification Thanks in advance, Bobby. I'm referring to the "waiver document" that's used for the "Certified for..." logo. If you look at the link http://microsoft.mrmpslc.com/InnovateOnWindowsVista/getstartedcert.aspx and go to the "Test and Submit" section and in subse ...Show All

• SQL Server How to recover Master database table data

  Hi all, I am working with SQL Server2000 and I have done a horrible thing here. We here have an script that delete all data from all user tables of a database, and I run it in the master DATABASE. As we don't made backups of this database, now somethings of the database aren't working. Here is the script: declare @table_name sysname declare @alter_table_statement varchar(256) declare @delete_statement varchar(256) -- definindo o cursor... declare table_name_cursor cursor local fast_forward for select name from sysobjects where xtype = 'U' and name <> 'dtproperties' -- desligando os vinculos... open table_name_cursor fetch next from table_name_cursor into @table_name select @alter_table_statement = 'alter table ' ...Show All

• .NET Development Best practice while writing C# functions

  Hi, Anyone has any idea about how to free up memory in C# functions. Does the GC collects memory after a function has executed How about setting variables to null after we are finished with them, or the GC will automatically set them to null Does setting variables to null in finally causes an overhead void TestFunc() { XmlDocument xdDoc = new XmlDocument(); try { // use xdDoc } catch { // handle catch } finally { xdDoc = null; } } Pradeep C wrote: Here is what I do : If you dont set a field to null after using it, the garbage collector cannot reclaim it (assuming a garbage collection occurs while your application is running) ...Show All

• SQL Server Sql server ODBC driver 2000.85.1117.00

  Hello All, Where can I get this drive: Sql server ODBC driver 2000.85.1117.00 Thanks The version you are referring to is from MDAC 2.8 Service Pack 1. You can download it from: http://www.microsoft.com/downloads/details.aspx FamilyID=78cac895-efc2-4f8e-a9e0-3a1afbd5922e&DisplayLang=en You can also verify the contents by looking at the release notes at: http://support.microsoft.com/kb/899456 ...Show All

• Visual Studio Team System Can not execute SQL statement

  Hello all IN CTP4 of the VSTS - Database Professionals - after export from the DB of the all database objects - Build, rebuild and deploy functions are working properly, but when I want to execute a single stored procedure or table DDL - all menu items (execute SQL, Validate Syntax, SQL CMD mode) are disabled Any ideas and suggestions are more than welcome Thanks in advance Leonid Niraev Good morning Gert Thanks for your quick and productive response, one more question - where and how all script changes are stored (for example when I changing a column length in a table - create table syntax is stored in a regular table source code, but where is a alter table statement for an upgrade purposes) Than ...Show All

• Visual C# Send mail

  Hi I want to send an email with the following code: MailMessage mail = new MailMessage(); //set the addresses mail.From = new MailAddress(" me@mycompany.com "); mail.To.Add(" you@yourcompany.com "); //set the content mail.Subject = "This is an email"; mail.Body = "this is the body content of the email."; //send the message SmtpClient smtp = new SmtpClient("127.0.0.1"); //to authenticate we set the username and password properites on the SmtpClient smtp.Send(mail); but it does not work. it will raised this error: The server rejected one or more recipient addresses. The server response was: 550 not local host yahoo.com, not a gateway You can't use a loopb ...Show All

• Visual Studio Team System CTP7 Question

  I am using schema compare to compare a database (SQL Server 2005) against my project. database is source, project is target. I got some tables where I turned the enforce foreign key contrain off. When I now compare the database, the source will look like this: -- Foreign keys ALTER TABLE [dbo].[DruckRGPObjekt] WITH NOCHECK ADD CONSTRAINT [FK_DruckRGPObjekt_Artikel] FOREIGN KEY ([Artikel]) REFERENCES [dbo].[Artikel] ([ID]) GO ALTER TABLE [dbo].[DruckRGPObjekt] NOCHECK CONSTRAINT FK_DruckRGPObjekt_Artikel GO where the target will look like this: -- Foreign keys ALTER TABLE [dbo].[DruckRGPObjekt] WITH NOCHECK ADD CONSTRAINT [FK_DruckRGPObjekt_Artikel] FOREIGN KEY ([Artikel]) REFERENCES [dbo].[Artikel] ([ID]) GO the second alter table statemen ...Show All

• SQL Server permissions granted to an application intead of a user

  I have an application that talks to an access db located on a 2000 server. I would like grant permissions to the application instead of a specific user. Any help would be great... I am including a link to a related entry in this forum where we have a detailed discussion on this topic: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=786513&SiteID=1 I hope this information will be useful. Thanks, -Raul Garcia SDE/T SQL Server Engine ...Show All

• Smart Device Development Virtual Memory

  Hi. Can you help me please I want to know is it possible from the one application to get the information how much virtual memory is runing another program . Hi , This forum is primarily monitored by Visual Studio for devices group. Please check this link for more appropriate forums for this type of queries. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=286724&SiteID=1 Thanks Srikanth Bogadapati .,- ...Show All