.NET Developer's Q&A profile

• SQL Server Linked Server with Oracle

  I installed the Oracle client on my computer, and I can connect to oracle databases using SqlPlus, however when I try setting up the linked server I get the following error after I try executing a query. OLE DB provider 'MSDAORA' reported an error.  [OLE/DB provider returned message: ORA-12560: TNS:protocol adapter error ] OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005:   ]. This looks more like a protocol adapter error. This indicates that Oracle client does not know what instance to connect to or what TNS alias to use. Try fixing the tnsname.ora file so that it points to the correct instance ...Show All

• SQL Server The attempt to add a row to the Data Flow task buffer failed

  Hi, I am trying to transfer the data from flat file to sql server.When I am running the package on local server(network server) it works fine.But when I use it to transfer the data to online server it starts and shows 2771 rows transfered and remains on that only, dosent stop or give a error. When i stop the execution I get the following errors: [DTS.Pipeline] Error: The pipeline received a request to cancel and is shutting down. [Loose Diamond File [1]] Error: The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020. [DTS.Pipeline] Error: The PrimeOutput method on component "Loose Diamond File" (1) returned error code 0xC02020C4. The component returned a failure code whe ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Content Pipeline

  Hi, I haven't really used the Content Pipeline seriously yet but I've seen the official tutorials on it and understand them. Now, I'm thinking - what if I want to load a certain model/effect or anything else that the Content Pipeline supports - BUT I want to load it dynamically/at run-time, e.g. I have a certain filename that my code wants to use to load content, but I don't know it until runtime. Is there some sort of dynamic way of using what otherwise seems to be a static Content Pipeline Thanks... Ah, this helps clarify things, thanks! Now, could I ask you a brief question on how you would do this certain thing Let's say I had a text file, with 50 lines, each line containing the path/filename of a c ...Show All

• .NET Development building Webservices - Class won't go away

  Hi everyone, Just would like to let you know that you guys are my last resort before I play frisbee with my laptop. Here's my situation: I have made a Webservice for an application I'm building. In this Webservice I've made a class with the same name as a class in another project(clsZaal). (accidently). Now I've deleted this class in the webservice afterwards. I've cleaned and rebuild the webservice. Now I use the service in a PDA application, with a webreference to this webservice (which I have updated also). Now in my PDA application I want to use the clsZaal class but it keeps mixing the normal one with the one in the webservice... which I have deleted. I know that webservices work through a class called reference.cs w ...Show All

• Visual Studio Express Editions Subroutine finding name of caller sub/function

  Boy, I sure am asking a lot of questions lately. You wouldn't know it by the amount of my questions but I actually do search the forum before I post, honest! There's got to be an easy answer to this question. I want to write a subroutine that will print out the name of the sub/function that called it. I'm writing a custom debug sub and I want it to print the name of the sub or function that called it. So, if Sub A calles Sub Debugger, I want Sub Debugger to print a message that says it was being called by Sub A . Thanks! Check out the GetCallerName routine in this thread ... ...Show All

• Visual Studio All lines cut in half

  I currently have report that is formatted as a sheet of Avery 5160 Labels. The report data source is a Data Set. What is happening is that all the text is cut in half, and only shows the bottom half. There is no objects or anything that would be covering up the top half. I tried creating a regular table style report and the same issue occurs. I'm using VS2005 Pro with the CR for VS2005 Any Ideas on how to remedey this would be appreciated. Ed Thanks Dave for the answer. Unfortunately this didn't help. The report shows fine in preview mode in the IDE, but it gets live data it just fudges out. I have abandoned CR, in favor of a differnt reporting package. Thanks Again Ed ...Show All

• Visual C++ First Execution Only...

  Hi, I've been trying to tell my new program to check for a specific condition (whether it is the first execution or not), but I'm having quite a bit of trouble. In fact, it's driving me insane. I spent almost all of last night trying to get this right, but it simply will not work the way I want it to. I've asked a huge number of people for help on message boards across the net, and nobody has been willing to help me fix it. So this is my last chance. PLEASE help me. Anyways, here's what I have so far, see if you can fix it and point out what I'm doing wrong: Prototype : int Config (int firstrun); Cut from main() : int firstrun; Config(firstrun); int temp1 = 1; int temp2 = 0; if (firstrun == temp1) { cou ...Show All

• SQL Server how to update a table w/o adding to an existing transaction

  Hey folks, I have a problem that I'm hoping to get some advice on how to best fix it.  Sorry for the long post, but the problem is a bit complex and I want to shout out the ideas I've already though of to get some feedback. I have a legacy system which have multiple entitiy types (which for the most part map 1:1 to tables) and each table has a unique ObjectID which is generated by all of the Add stored procs for each entity.  There is a single table containing a single row which represents the next objectID to be used, and during each Add stored proc this value is queried, bumped, and updated via a GetNextObjID stored proc.  Pretty simple.  Pretty horrible. Obviously this has major transactional throughput issu ...Show All

• Visual C++ OpenMP vcomp.dll problem

  Hi everyone, I have just bought and installed Visual Studio 2005 Pro, and I have a problem with its OpenMP support. I have been using the Beta 2 before, and wrote code that uses OpenMP. As you might know, vcomp.dll is required when using OpenMP. The files can be found inside some redist folder of VS 2005. So I copy this file to the executable folder, and try to start the exe. I get an error which says that it tries to load vcomp.dll wrong. However, I don't control the loading myself, so I assume this is a bug. Also it worked fine with the Beta. The Beta 2 vcomp.dll does work. But it causes some hang/lockup/deadlock somewhere, which didn't happen in the Beta. Does anyone know what I should do Is it possible that they shipped a wrong DLL fi ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Getting the DepthBuffer is possible?

  How can i get the DepthBuffer and put it into a texture at any time while drawing meshes   Is that possible   And a quite peculiar question too: Is there any way to, for example, assign the Alpha channel in and RGBA texture (multiplied by a factor) as a value for the z-depth of a concrete part of a mesh while drawing it This means... is there any way to assign the z-depth value per pixel inside the pixel shader function   Thanks. There is no way to convert the GPU depth buffer into a texture in XNA. That is possible on some hardware, but not on all, and works in quite different ways on different cards, so we decided not to expose it at least for this first releas ...Show All

• SQL Server Query to another server

  Hi, I'm trying to do a query from ine server to another, something like this: " SELECT * FROM FILESERVER . SharePointConnectingDB . dbo . vDepartmentsNames" where FILESERVER is the other SQL server name, SharePointConnectingDB is the the DB in the other server, etc. as a return i get the following error (in spanish becuse the server is in spanish): in El proveedor OLE DB "SQLNCLI" para el servidor vinculado "FILESERVER" devolvio el mensaje "Especificacion de autorizacion no valida". Msg 7399, Level 16, State 1, Line 1 El proveedor OLE DB "SQLNCLI" para el servidor vinculado "FILESERVER" informo de un error. Error de autenticacion. ...Show All

• Visual Basic The Basics about SQL Server: JUST the Basics

  For now I don't anticipate needing large database storage from SQL Server (Express 2005), and based on my programming aspirations I doubt I will ever need a large database. All I need SQL Server for is to store a few settings. As of now I want to store just a few text items in SQL Server. (I've already done .txt files but that seems to take extra work and is less unorganized, and I need several txt files). What command would I use to write one piece of text and retrieve that same piece of text Is there anything else thats important that I should know before going about this I'm guessing something like this: My.Computer.FileSystem.Writealltext(database.mdf, "textbox1.text", False) But I would need to refer to a specific row and ...Show All

• Windows Forms inherited form constructor not found warning message

  I've seen one other post about this and it was never replied to, so I'm assuming this problem could be universal. When using a form that's a base class to be inherited by other forms that has a constructor with parameters, I consistently get a warning about the constructor not being found, and I can't use the designer on any of the inherited forms. Granted everything compiles and works just fine, but I always get a warning message, and I can't use the designer for any of the inherited forms. The designer for the base class works fine however. If I add a parameterless constructor on the base class that calls InitalizeComponent(), everything works correctly. But this is an entirely useless constructor that's used only to get the des ...Show All

• Visual Studio Express Editions ntdll.dll error only when exe file is ran.

  Hi, I have very strange situation with running c++ application. When I build project using debug mode everything is OK, but when I build application in release mode or just run exe file either in debug or release folder I get the following error in ntdll.dll file. "Exception Information Code: 0xc0000005 Flags: 0x00000000 Record: 0x000000...000 Address: 0x000000007c93426d" This is information from windows message. Here is information from building log: 'archiveEditor.exe': Loaded 'C:\Projects\archiveEditor\release\archiveEditor.exe', Symbols loaded. 'archiveEditor.exe': Loaded 'C:\WINDOWS\system32\ntdll.dll', No symbols loaded. 'archiveEditor.exe': Loaded 'C:\WINDOWS\system32\kernel32.dll ...Show All

• Visual C# Unable to copy file during build

  When I try to build my solution I often get this error: Unable to copy file "obj\Debug\MyProjectXXX.dll" to "bin\Debug\MyProjectXXX.dll". The process cannot access the file 'bin\Debug\MyProjectXXX.dll' because it is being used by another process. The project it's trying to build is a class library referenced by a couple of other projects in the solution. The solution builds fine the first one or two times after opening Visual Studio, but after that the only way I can get it to build is to restart Visual Studio. Any ideas what's wrong Thanks I'll be totally honest: I'm not exactly sure. I'm just passing on something that was passed on to me. My best guess is that&nbs ...Show All