spga's Q&A profile

• Visual Studio Crystal Reports Error Code where can I find them?

  I have had numeruos error codes over the years as well as other developers I have talk to. Does Business Objects publish a PDF or any thing that explains what these errors are.. Error Codes -2147206463 -2147216454 -2147467259 -2147217843 -2147467259 -2147217843 Hello, A listing for these error codes does not exist but you can try searching the Business Objects knowledge base on these error codes: http://support.businessobjects.com/search/default.asp ref=default.asp_shortcuts I tried a few and articles were returned. If you do a Google search on them you will notice that they are not Crystal Reports specific. Keith - Busi ...Show All

• Windows Forms ForeignKeyConstraint problem...

  Hi, I'm using a dataset to manage an MS Access db. I create two tables, I fill them with data, and I relate two fields: Table1:                Table2: CustomerID         ProductID (AutoNumber)      (Number) But when I try to add something to table2, the child, I get this error: "ForeignKeyConstraint Rel ...Show All

• SQL Server Metadata Definition ?

  Hello, i would like to know if it's possible to generate automatically a word document or an excel document that will contain all the metadata definition, for example containing the source columns names, their datatype, and the destination with their datatypes, so that it would easy to create a data dictionnary . Thank you in advance. Microsoft have talked about a tool called "SQL Dcoumenter" that will do this. No news about when it will be released though.   -Jamie   ...Show All

• Visual Studio Express Editions Structure in a list(of "Structure Name")

  Hi folks, I am having an issue with using a Structure object that I have contained in an list(of object. The issue is using the indexof feature of the list(of object. I need to query the list array for a field that is contained in the structure, once found then i will be able to use the index to gain access to the other fields. Hope this makes sense. Here is the test code I am tiring to make work, the code in the button1 is where the issue is currently at. Cheers Sentinal visual basic code: The following will show you an getting the index of the items in the list. Private Sub Button1_Click(ByVal sender As System.Object, ByVal e ...Show All

• SQL Server Join filter failure

  Hello there, I'm experiencing a really weird problem: I have a SqlCE subscriber connecting via IIS to a SQL Server 2005 database. The database publisher/distributor and the web server are on different machines (IIS being in a DMZ) and I want to avoid the use of Kerberos delegation to share priviledges on the snapshot folder. I configured the web synchronization to accept basic authentication and obviously the subscriber sends @internetlogin and @internetpassword. Plus, I used a DB authentication on the SQL Server database. First problem, if i disable on the publisher configuration the anonymous authentication, replication fails (I expected ...Show All

• .NET Development SAP BW NetWeaver web services

  Hi, Has anyone done any integration of a .NET app with SAP BW through web services I’m talking about retrieving data defined on the BW side and then using it for whatever needs, all through web services. I've successfully created a web service on the BW side, but could not find any information on how to consume the web service in .NET, since most people seem to prefer the .NET connector or direct ODBC connection. Any references/documents are much appreciated. By the way - I know how to create a web reference, proxy class, etc. It's just that I don't really know how to use the WS istself. ...Show All

• Visual C# Add events for dynamically generated DropDownList control

  This is what I have done so far: In Page_Load() ............ dd1 = new DropDownList(); this.dd1.SelectedIndexChanged += new EventHandler(this.dd1_SelectedIndexChanged); int listIndex = 0; dd1.Items.Insert(listIndex, new ListItem("MY SETTINGS", "TestDD.aspx")); dd1.Font.Name = "Verdana"; dd1.Font.Bold = true; dd1.Font.Size = 7; dd1.ForeColor = System.Drawing.Color.Navy; ....... fill it with some data from an ArrayList ...... dd1.DataBind(); Panel1.Controls.Add(dd1); ........ protected vo ...Show All

• SQL Server Move data from backroom to frontroom

  I need to know the quickest way of moving/copying data from a backroom/import/qualitycheck database to the production environment. The databases reside on the same server instance, the tablestructure is identical and I'd preferably like to use T-SQL procedures, rather than DTS/ETL. Can I make use of bulk loading, openrowset or ... from one table to another Luckily I'm not in the need of update procedures. All data from the backroom that is accepted as productiondata will be accumulated in the production environment. We're doing the transition to SQL Server 2005, so I think we'll have a go with the SSIS ETL ...Show All

• SQL Server LIMIT Clause

  It seems current version of SQL Server doesn't support LIMIT clause in SELECT statement. Will future version of SQL Server support it Thx. Maximilian, I don't know if the keyword LIMIT will be supported, but even in the current version, you should be able to get the same functionality with the enhanced TOP syntax and/or the new ranking functions. For example, to delete just 10 rows: delete top (10) from ... and to select rows 50-59 in some order: with T as ( select row_number() over (order by someColumn) as rn, * from someTable ) select * from T where rn >= 50 and rn It seems current version of SQ ...Show All

• Visual Studio Team System my last trial - pleae help!

  eyooo, well i guess from all my post everyone knows my config already :-) Windows 2003 server, SP1 all patches, office 2003 SP1 + patches, sql 2005. .net framework 2.0, IIS 6.0, sharepoint services 2.0 SP1 + patch, all in a active directory domain usin this server as domain contoller...... well, i edited the ...\ roots\web.config , reportserver\web.config , reportmanager\web.config , made sure that the securtiylevel in rsreporterserver.config is 0, runned the stsadm for rerports and reportserver, created 2 domain-admin accounts tfssetup and tfsservice who r local admins too... gave em ALL access in the sql database.... config from IIS worke ...Show All

• Visual C++ set_terminate doesn't work (VS2005 beta 2)

  I have a program which is generating an exception somewhere and terminating, but I don't know where.  In order to find our, I added a call to set_terminate(), but it doesn't work.  To test it, I am doing this: set_terminate(TerminateHandler); throw "Test"; I understand that set_terminate does not work if the process is being debugged (which is very impractical and frustrating, BTW), so I am testing without the debugger present.  When I run my program, I get a message box like this at the point I call throw: Microsoft Visual C++ Runtime Library Runtime Error! Program: This application has requested the Runtime to termina ...Show All

• Visual Basic data binding and sorting controls

    I have the following code: Try     OleDbConnection1.Open()     DsFirefighterData1.Clear()     NumberInDatabase = OleDbDataAdapter1.Fill(DsFirefighterData1)     OleDbConnection1.Close()  Catch ex As Exception       MessageBox.Show(ex.Message, "Firefighter Info Server Error")   End Try On the form I have a combo box that is bound to one column that contains 3 digit numbers. What code do I need to add to have the numbers in the combo box sorted Any help would be appreciated. Thanks, Barry Great Solution, m ...Show All

• SQL Server Dynamically creating cube

  Hi guys I'm investigating whether if its possible to Dynamically create a cube. Then Process this cube before exporting it to a .cub file. I know that DTS in sqlserver is able to process a cube given at a scheduled time interval. But I'm not sure how I can export a cube to a offline .cub file dynamically. The only way that i know to create a .cub file is via PivotTable in Excel. Any help in pointing me to the right direction is appreciated. Thankyou  Tom The reason I ask is because I need to generate sales data to various company however each company requries different sets of cube data be ...Show All

• SQL Server Sql Job failing with MSDTC has canceled the distributed transaction.

  I have a sql job which has to pull some data from a remote server. This job is running fine last few days and suddenly failing to execute with the following error. The same job is running fine in other servers. Executed as user: NT AUTHORITY\NETWORK SERVICE. The Microsoft Distributed Transaction Coordinator (MS DTC) has cancelled the distributed transaction. [SQLSTATE 42000] (Error 1206). The step failed. Note: The steps I have already done : 1. Verified the MSDTC configurations and restarted the MS DTC 2. Restarted the Sql Server 3. Restarted the machine. Any help will be highly appreciated. ...Show All

• Visual Basic Playing a sound file

  This may have been answered before i am not sure, i am running Visual Studio 2005 beta, i would like to know how i can play a sound file in the background when someone opens a form. Any ideas I am using the my.computer.audio.play function to play an alert. The alert is the result of checking a database for new entries every 10 seconds. If there is a new entry that the software has not seen yet, it uses the VBPower Tools Notification Window to pop-up a message. What I want this to do is play the audio at that same time. My problem is, I am unable to get audio to play inside of a timer's tick event handler. Does anyone ...Show All