farang's Q&A profile

• SQL Server DataReader Source and ODBC connection to PostgresSQL

  Hi, I am trying to use the DataReader Source to import a table from a PostgresSQL database into a new table in SQL 2005 database. It works for all tables except one, which has over 80,000 records with long text columns. When I limit the import to fraction of records (3,000 to 4,000 records) it works fine but when I try to get all it generates the following errors: Source: DataReader using ADO.NET and ODBC driver to access PostgresSQL table Destination: OLE DB Destination - new table in SQL 2005 (BTW - successful import with DTS packagein SQL 2000) ---Errors Error: 0x80070050 at Import File, DTS.Pipeline: The file exists. Err ...Show All

• SQL Server a generic error occurred in gdi+

  I'm receiving "a generic error occurred in gdi+" processing error while running a preview of my report inside visual studio. When this report is opened by a client, their browser will just hang (Not Responding). Other reports don't have error. The report will not render any chart although thousands of record will be need to output. Hope anyone can help. Thanks! When Drawing an Image from a Stream, make sure that the Stream has been re-positioned back to the beginning if it has been accessed before. GDI+ is very powerful; too bad it doesn't have a more robust error message interface. Are t ...Show All

• Visual Studio Express Editions why can't I exist the application?

  hi, I have a listbox and a few textboxes that have databinding with an ACCESS db, when an item is selected in the listbox, the texboxes will show the details of the corresponding record (certain texbox shows data for a certain column). when I run the application, click on "close" at the begining, it works, i.e. the application exits. However, if i try to exit the application after a few clicks inside the listbox, it stops working, the application won't close/exit, and basically everything on the form will stop working except the listbox itself.... tried this in some other projects, same problem happens, plz help hi, restart you a ...Show All

• SQL Server OLEDB provider error.

  Hi: I have created a cube and deployed in sql server. I am trying to connect to analysis services to access cube with linked server. I am getting this error...how do i fix this. OLE DB provider "MSOLAP" for linked server "(null)" returned message "Errors in the OLE DB provider. The Extended Properties property is set to a value that is not supported.". Msg 7373, Level 16, State 2, Line 1 Cannot set the initialization properties for OLE DB provider "MSOLAP" for linked server "(null)". Thanks, Pramod Xinwei: This is the query i am using... SELECT a .* FROM ...Show All

• Visual Studio Express Editions Problem with free ebooks

  I complete the activation process, two weeks ago, but i don't receive any e-mail with information about how to download the ebooks, if any have the same problem and know any email where i can get more information please let me know The instructions don't work. When I Click the activate product under Help to activate the product, it says, " the product has already been activated" ( a pop up window" thanks ...Show All

• Visual Studio Team System TFS on same server as Project Server?

  We have a dedicated server that has Project Server 2003 running on it. It has extra capacity so we would like to install TFS on it if possible. In reading the installation instructions for it, there are a couple of concerns I have as to whether this is possible. SQL Server - Project Server is not using the default SQL instance. It seems like TFS expects to use the default instance. In this case, they do not seem to conflict. Is this correct WSS - WSS is running on this box for Project Server. It uses a db called STS_boxname_1 that is not on the default SQL Server instance. The install instructions for TFS (WSS portion) ask not to pr ...Show All

• Windows Search Technologies Outlook 2000 crashes on exit with WDS installed

  I ran into 2 problems with WDS version 2.06.0000.2083. I have just installed WDS for the first time on XP SP2. I don't have MSN Search Toolbar installed. My Outlook setup doesn't use Exchange and just connects to my ISP to retrieve email. The problem I have is that Outlook crashes on exit. I can post memory dump if necessary. Additionally, if I let WDS finish indexing while Outlook is up, WDS doesn't ever find anything in the email messages. Kind of defeats the purpose of Outlook integration. Are these known issues that I ran into If so, when should we expect to have a new version out that addresses Outlook 2000 integration Thanks. ...Show All

• Visual Studio Team System How to get code coverage from Web Tests?

  Hi, I'd like to get code coverage information from Web Tests. I configure the testo configuration in order to instrument the Web Site. I Run my web test but no coverage information was generated. Is there any additional Step Thanks Hello MunjalD, Unfortunately, when I attempt to follow your example in #1 above, I get the result that was originally reported. I have a solution with a Web Service project and a test project. The unit test I am running is a data driven unit test. I enabled Code Coverage in a new test configuration and set it as the one to be run. I ticked the checkbox for the Web Service in the list of assemblies. When&nbs ...Show All

• Windows Forms event on scaning barcode

  hi , i am using vb.net 2003 and i want to scan barcodes with the scaner i want if the scaner completes the scaning doesn't matter what the length is the next textbox is focused i tried it on different events but could not find the proper event  can any body help me  best regards ali shah The problem appears to be with the&nb ...Show All

• Microsoft ISV Community Center Forums Can I get Micorsoft.RuleEngine.dll ?

  Hi Ihave a question on Microsoft.RuleEngine.dll used in Biztalk server 2004 core: Can developer buy a stand-alone licence of Microsoft.RuleEngine.dll (without the development FrameWork :Deployment wizard, Business rule Composer,.. ) thank you ;) Per our support engineer: Base on my understanding, our buddy wants to buy BizTalk rule engine instead of whole BizTalk package. We may ask our buddy refer to http://www.microsoft.com/biztalk/howtobuy/default.mspx for the detail information. I think our buddy can not only have the rule engine separately. If our buddy wants t ...Show All

• Windows Forms BindingSource + Object + nulls = problems

  Ok, so we have a business object, and there's a grid bound to the binding source that holds the objects.  If you clear a string field and move to another row you get an error about not being able to convert DBNull.value to a string. First of all, why isn't the grid saving string.empty instead of null Second, I tried using string for the property but got this error message: Error    1    The type 'string' must be a non-nullable value type in order to use it as parameter 'T' in the generic type or method 'System.Nullable<T>' A. I don't understand what it's saying, and B, how do I get around this so ...Show All

• Microsoft ISV Community Center Forums How to preserve the date format while reading Excel cell (Date) in to combobox?

  Hi, How can i display a range of date values from a sheet (A1:A200) in a combobox and preserve the format. When i set the RowSource property to A1:A200 in the combobox, and click on the dropdown arrow it displays the the date values in the correct format, but after i pick a certain value, it chnages it into a number. - Srini. This appears to be a known problem from Excel 97 and still not fixed in Excel 2003. For a workaround see ms support article 170442: XL97: ActiveX Controls May Not Display Formatted Numeric Data There are a two other workarounds if using a userform: 1. Del ...Show All

• Visual Basic Smaller Database

  I have an application in VB 2005 Express with a SQL Server database.  I added large amounts of data for debugging purposes.  However, I want to ship an empty database, so I deleted all of my data, yet the database did not go back to its original smaller size.  Is there a reason for this, or anyway to correct it   Thanks -Aviatordave That sounds like it would probably work, except I have no idea how to do that, and I couldn't find anything in the documentation. Can anyone stear me in the right direction on how to do that Or have any other ideas. Thanks! Aviatordave ...Show All

• Visual Studio Express Editions How to set a date field to null

  I have a bound text box showing a date field and I can enter a date into this no problem and save the changes. I have spent the past two days trying to find a way to allow the user to delete the date i.e. set the field back to null! I have found several articles on the net but nothing that provides an answer or explains why something that should be simple should be so hard!! DateTime is not a nullable type. If it's nullable in your db, you need to allow it to be set that way in your UI, and use DBNull.Value as what you pass into the DB if that condition exists, instead of a datetime. ...Show All

• Visual Basic What has replaced ---CopyArray--- function is Visual Basic Express Beta 2

  Apparently, the new version of Visual Basic Express 2005 Beta 2 has removed the CopyArray Function---What has replaced CopyArray Dim Arr1 As String () Dim Arr2 As String () ReDim Arr1(1) Arr1(0) = "Hi" Arr1(1) = "There" Arr2 = Arr1.Clone MsgBox(Arr2(0) & " " & Arr2(1)) ...Show All