katti205961's Q&A profile

• Visual Studio Team System Can you copy the CA Rules from one Team Project to another Team Project.

  Can anyone tell me if it is possible to copy the CA Rules from one Team Project to another Team Project. Also, it is possible to export CA Rules from a Team Project I'm trying to find out if you can copy the CA Rules from one TEAM PROJECT to another TEAM PROJECT. Not from a TEAM PROJECT to a project. I'll look into the vbproj (<CodeAnalysisRules> node). Thanks. ...Show All

• SQL Server inserting ascii data into SQL database

  Hi everyone, I need to save the ascii data in my sql express 2005 database in one table and in 2 coloums in this table using VB express... Can I do it by datareader or with bulk insert t-sql command I tried it this way but it gives error like "connection property is not initialised" it is on executenonquery row in the code... Dim cmd = New SqlCommand( "BULK INSERT RFID.dbo.stock(material_number,total) FROM 'C:\can1.txt' " & _ "WITH FIELDTERMINATOR = ',', ROWTERMINATOR = '\n' " ) connection.Open() cmd.executenonquery() connection.Close() I hope some can help with this problem.... How did you initialize your connection object and ...Show All

• Visual C++ bioskey() equivalent in VC++

  Hi... Can anybody let me know, what is the bioskey(int cmd) quivalent in VC++. bioskey(int cmd) is the fuction in borland c++ in bios.h fine. Thanks, I think _getch() won't work but I am not sure. There many functions in the Windows API that are for console io. The Windows API is off-topic for this forum so I hope you do not mind asking about that in a Windows SDK newsgroup. I am not sure what MK_FP does but I can guess. It probably is for making a far pointer. In 32-bit, such a thing is not needed. I am also not sure what the lc1 function requires and I am also not sure what dp_addr is but my guess is that you need to use: SDLC_F_LoopController lc1( dp_addr, dp_size ); ...Show All

• Visual C# CursorConverter Error

  I am getting the following Error very often.. "CursorConverter' is unable to convert 'System.Windows.Forms.Cursor' to 'System.ComponentModel.Design.Serialization.InstanceDescriptor" Also that when i tried to rename a control (which is copied from the same screen) i will get the error - "property name is not valid" and details part of the error shows the reason as same as above error... i checked and there is no redundant references... can anyone help Thanks in advance. Am using VS 2005 Pro Edition version - 8.0.50727.42 in Win XP Pro. I get this error in the following contexts.. 1. When i try to save the form when the design view window is active ... error will be ...Show All

• Visual Studio Team System is this the place for adfs questions?

  Is anyone using adfs in the Web SSO scenario (not federated web sso or federated web sso with forest trust... just plain 'ol Web SSO) I want to look into deploying this for single sign on capability for all of our web application within our organization. Currently we only have two applications that would use this (three if we can add web outlook to this), but I see 2-3 more in the near future. I'm just looking to see if anyone has tried this and if it went well, horribly, suggestions, cautions, etc. What resources would you recommend etc Thank you for your help! Sorry this forum is also for Team Foundation server, better try on the web development forums http://forums.asp.net/ or any technet rel ...Show All

• Visual Studio Tools for Office What is good way for handling about .pst(schedule, task)?

  Hi~ Nowaday, i'm trying to handle(insert or update..etc) about .pst file(outlook2003). But, still in now, i can't decide in two way. One is Automation and the other is mapix(mapi interface). Can someone tell me what is best way with reason Have a nice day~ Dear Mohit Gupta. Firstly, Thanks for your reply. From now on, I am trying to post my question in office developer forum. Have a nice day~ ...Show All

• Visual C# devenv crashes (when opening designer)

  Hi all, My Visual Studio 2005 Windows Forms Designer crashes when i opens specific form in Designer mode. "The exception unknown software exception (0x40000015) occured in the application at location 0x7813461a." The project was formerly a 2003 project and has been successfully converted into 2005 format. the project is bound via VSS to our source safe database. I had this in the past, which was solved by deleting bin and obj folders and doing a rebuild. But still two forms stay quite hard in this vs crashing mode. I tried to disable and even uninstall the only add-in i had. I tried removing source-safe binding fully. This issue shows up on more than one computers (including a fresh installed xp sp2 and vs2005 pro), so it must be linked t ...Show All

• SQL Server Advice???

  hellooo I have an Accounting system(vb.net 2003, SQL server 2000), every new year data is cleared, but i may use some data from previous years (such as liabilities) whats the best way to that -Shall I create programmatically a new clone DB every year (new DB with same structure as previous year) OR -Shall I add a "year field" for tables in DB knowing that data will keep growing every year whats the best solution, knowing that i dont want the end user of my application to do anything manually, such as creating DB ...... Thank you I dont wanna delete anything, I want at each beginning year to create a new DB(same structure as previous year) and may use some Data from pre ...Show All

• SQL Server SSIS does not recognize CRLF as the en of line

  Hi all, I'm having a strange behavior here, or maybe I'm doing something wrong, I'm not sure. Anyway, I have a csv file, the Flat File Connection Manager is configured like this: Row delimiter: {CR}{LF} Column delimiter: {;} For some rows in my file the last two columns are empty and the there is no semicolon for these empty rows but these rows are still ended by a CRLF but SSIS does not consider the CRLF as the end of the row, it consider the first 2 columns of the next row as the last 2 columns of the current row. Sample: CSV file: Col 1;Col 2;Col 3;Col 4;Col 5 AAAA;BBB;CCC;; AAA1;BBB1;CCC1;; AAA2;BBB2;CCC2 AAA3;BBB3;CCC3 Imported rows in SSIS: Col 1 Col 2 Col 3 Col 4 Col 5 AAAA BBB CCC AAA1 BBB1 CCC1 AAA ...Show All

• SQL Server Linked Servers Error Microsoft SQL Server, Error: 7411

  1. Replication Transactional between two servers -- SQL Server 2005 as Distributors and Subscribers ---SQL Server 2000 as Publishers 2. Linked Servers errors: " Server (Publication Server) is not configured for DATA ACCESS. (Microsoft SQL Server, Error: 7411)" Did anyone familiar with this problem Thankssss TJ_1 My Server 2005 'repl_distributor is not configured for DATA ACCESS. I run the a script of use master exec sp_serveroption 'server name' , 'data access' , 'true' go Go back to relp_distributor and test the connection. Still got the same error. ...Show All

• Windows Forms Refreshing a read-only datagrid

  .NET 1.1 Windows Forms DataGrid I have a read-only DataGrid on my main form which is bound to a DataSet. I am creating and opening a connection (let's call it connection A) to an Access database in the form's constructor, and binding in the following manner: dgRepsAdapter = new OleDbDataAdapter(@"SELECT blah blah blah", conn); dgRepsDataSet = new DataSet(); dgRepsAdapter.Fill(dgRepsDataSet, "Reps"); this.dgReps.SetDataBinding(dgRepsDataSet, "Reps"); I also have a button on my main form. In this case it shows a dialog through which the user can add a record to the relevant table in the database. This is done directly, ie: I am not allowing the user to make any changes through the datagrid. This is a straight ...Show All

• SQL Server choose from SQLDMO /SMO

  in my classic ASP 3.0 application I would like to back up and restore SQL Express database. Should I use SQLDMO or SMO Whats the difference Thanks for your answer.I am using SQLDMO for backing up and restoring Sql Express database. While Restoring if i have any users connected to db ,restore fails.. Whats the solution for the problem Do i need to Stop SQL Server ,restore and start again ...Show All

• SQL Server File and Spreadsheet Frustration

  Hi, Two problems / questions I could do with some help on please...... 1). How do you clear a spreadsheet before loading it I am sending a spreadsheet by Email on a regual basis. Each time I run my SSIS package the data is appended to that of the previous run. I need just the contents of this data load to populate the spreadsheet each time. I have tried various methods / techniques for achieveing this so I just need to know the accepted method. Sorry if this is very basic ( as it should be !) but I seem to be missing the point somewhere. 2). I have tried to resolve issue 1 above by having an empty 'template' spreadsheet and copying that one over the top of the previously populated one. I get an error saying that the source spreads ...Show All

• SQL Server scheduling sql sp needing to access mapped network drives

  How to make network drives accessible to a stored procedure Currently the sp works only if I open a session on the server and execute the sp with SQL Server Management Studio on the server. If you want to use ressources within the network you will need appropiate permissions either for the service account SQL Server Service is running with or the service account SQL Server Agent is running with (if you do that within a scheduled job). An alternative would be to setup a proxy account for the service [1] [1] http://www.databasejournal.com/features/mssql/article.php/1580041 In SQL Server 2005 proxy accounts can also be configured through the Configuration interface which you will find in the program c ...Show All

• SQL Server SQL Server Management Studio and SQLCompact

  Hi, just wondering if there are any plans to have SQLServer Management Studio Express connect to SQLCompact databases - given express and compact are both free products it would seem to make sense. Or am I missing some configuration setting that already allows SSMSE to do this - dont seem to be able to connect to a non SQLExpress datasource thanks, Roger Hi Roger, This is in our plan and we are working on it. With the release of SQL Server 2005 SP2, it will be integrated with SSMS express. Thanks Sachin ...Show All