Phil Gould's Q&A profile

• SQL Server SQL-DMO

  I bought a book on SQL-DMO one of things im trying to accomplish is seeing a list of available servers on the network.... using VB script. The work machine I have doesn't have visual studio or a environment that I can use to use a full blown language. What are some helpful tips and advice using SQL-DMO through the command prompt(vbscript) or what freeware or apps to download to use ...Show All

• SQL Server Installing SQL Server Express & remote connections on XP Home

  My target market includes Micro-SMEs (i.e. 1 to 2 person business). This users often have multiple computers, but tend to run XP Home edition. Hence I need to set up a SQL Server Express on one of the machines and allow the other machines to access it. So far I realise: XP machines must be SP2ed ( http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=379560&SiteID=1 ) XP Home machines need to be in the same work group (am I right ) I have to Open up the MS Firewall on each of the machines for TCP ports 1433 and 1434 (see http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=511441&SiteID=1 ) On the machine hosting the SQL Server Express instance, start the "Browser" Service (again http://forums.microsof ...Show All

• .NET Development difficulty accessing Excel spreadsheet via ODBC

  trying to access a spreadsheet on a network share. ODBC connection string: "Driver={Microsoft Excel Driver (*.xls)};DriverId=790;DefaultDir=\\sdi-fs2\Bypass\4ANAMEDONOTDELETE;DBQ=\\\sdi-fs2\Bypass\4ANAMEDONOTDELETE\0e89da37-180c-4214-af37-632cce8dc476.xls" Produces the following error: ERROR [HY000] [Microsoft][ODBC Excel Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x7b4 Thread 0xabc DBC 0x348274 Excel'. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR [HY000] [Microsoft][ODBC Excel Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x7b4 Thread 0xabc DBC 0x348274 Excel'. ERROR [HY000] [Microsoft][ ...Show All

• Visual FoxPro sys(6) or otrher means to know what selected printer device is.

  Hi; How can I know what is the current printer Sys(6) often returns either nothing or sometimes it would return a path to the server where the app is installed. Thx. Try: Set ("Printer", 3 ) HTH ...Show All

• SQL Server Is ProcessAdd done within a transaction mode?

  Is ProcessAdd done within a transaction mode This question is very basic. When you do a ProcessAdd, is it within a transaciton mode I mean, if the ProcessAdd fault and stop when it meets a mistake, the records before the midstake will still be in the cube or not. Thanks. That will meet the same situation. If you start transaction in Analysis Service, not in Sql Server, the transaction will NOT rollback the tasks deal with the Sql Server. ...Show All

• Visual C++ Asynchronous Sockets in C++?

  Hello, I want to use asynchronous sockets in pure C++. Is there anyone to tell me how to do it or at least show me a basic example The external libraries are appreciated too. Thanks... yabansu wrote: I mean, Unmanaged C++... I mean, not using the .NET Framework... See You can explain it unambigous. In this case you have two options: use windows API for sockets (which BTW is written in C) or the MFC wrapping of that API. ...Show All

• Visual C++ DLL load issue in 64bit

  Hi, We are building our DLL using Visual Studio 2005 for 64bit OS. We have specified the "Entry Point" (/ENTRY) as _DllMainCRTStartup@12 . This is giving compile-time error when we build for 64bit, if we remove "@12" from the entry point name, there is no compile-time error.But the DLL doesn't get loaded. How do we correctly specify the entry point in 64bit DLLs This works correctly for 32bit OS. Thanks... Dipti ...Show All

• Visual C++ Pass a delegate from VB to C++

  Hello, I want to pass a function pointer from my VB GUI code to my C++ class. The function is a callback, now defined as a delegate (as I understand it), where the C++ code would call the callback function located in the VB code if triggered. I have seen lots of examples of passing callback pointers from managed code to an old Win32 DLL, but nothing of passing a callback pointer from VB to C++, both managed. Please let me know if there are any examples I could reference. Thanks. It should be something like this (not tested, can contain minor mistakes): // C++/CLI library public delegate void SampleDelegate(Object^ data); public ref class SampleClass { ... public: void SampleFunction(Sampl ...Show All

• Visual C++ error C2665: 'operator new' : none of the 5 overloads can convert parameter 1 from type 'const char [71]'

  When I try to compile the programe in VC7, I got some errors mensioned below, how to resolve them, suggest me. c:\Program Files\Microsoft Visual Studio .NET 2003\Vc7\include\xmemory(34) : error C2665: 'operator new' : none of the 5 overloads can convert parameter 1 from type 'const char [71]' c:\Program Files\Microsoft Visual Studio .NET 2003\Vc7\include\new.h(100): could be 'void *operator new(size_t,const std::nothrow_t &) throw()' c:\Program Files\Microsoft Visual Studio .NET 2003\Vc7\include\new.h(108): or 'void *operator new(size_t,void *)' while trying to match the argument list '(const char [71], int)' c:\Program Files\Microsoft Visual Studio .NET 2003\Vc7\include\xmemory(137) : see reference to function te ...Show All

• Visual Basic Folder View I think

  beginer::: I need help on how to make the folder i select show up as buttons and the name of the folders be there also. I am new to code and would like to learn more. I am trying to build a photo view, so when i click on the tree view that folder shows up and the files that are in the folder the name shows. Thanks. notdoutt, According to your question, I recommend you to ge more information on the TreeView control. Then I suggest you to read an article titled Implementing a Folder View. Unlike the tree view, Microsoft Windows Explorer does not manage the contents of a folder view. Instead, the folder view window hosts a child window that is provided by the folder object. The folder object is respons ...Show All

• Visual FoxPro where condition too complex?

  Hi, Basically I have a where statement in my code that is similar to this: "where productcode in ('0001','0002','0003'.....'0020')" and Foxpro is telling me that the SQL code is too complex. The output file is an Excel file so I suppose I could just extract the particular product codes that I need in Excel but I was just wondering if there was a way to bypass this "SQL Code is too complex" conondrum and just grab the numerous product codes that I need. Thanks! :) Put the values you want to match in a cursor and JOIN that cursor in the query. That way, no matter how many are in the list, you won't ever bump against any limits. Tamar ...Show All

• .NET Development Client/server application

  I want to build a windows forms 2.0 client application that accesses and modifies data from an access database on a server. I'm not sure how to get started with this, since I'm only used to building client applications. Does anyone know any good articles on the subject, or maybe a place where I can see some samples I just need a kick in the right direction... Thanks \Soeren Well if you want to use SQL Server Express, it will make your application much easier to develop. You will just use the SQLServer client libraries to connect to that database directly without sharing a folder. Here's a website with a lot of information reguarding client\server application development http://www.extensibles.com/ind ...Show All

• .NET Development Binary serializing an object which composites an interface field without serializing the interface implementor

  I want to serialize an object which composites an interface. While serializing the actual class, I do not want to serialize the object that implements this interface. I just want to keep its reference and pass it to the serialized class. Here is an example [ Serializable ] public class Sample { private string _name; private IInterface _sampleImplementation; public Sample(IInterface interface) { _sampleImplementation = interface; } } When I use custom serialization by implementing ISerializable, in the GetObjectData method anything I add to the SerializationInfo gets serialized automatically. I just want to keep the reference of the object that implements the IInterface and pass it to ...Show All

• SQL Server Delay in package starting when running from SQL Agent

  Hi, I wonder if anybody can shed any light on this problem. I have a SQL Agent job which has three steps, each step runs an SSIS package. The job is scheduled to start at 11.00 pm, which is does successfully. However, it has been taking between 2 and 3 hours to run, which is way longer than it should. When I've looked at the logging, I've found that the although the job starts at 11.00 pm, the first package (in job step 1) does not start executing until about 11.30. It finishes in about 5 minutes, there is then about an hour delay before the second package (in job step 2) starts. This finishes in about 10 minutes, then there is another hour delay before the third package (in job step 3) starts. I've tried configuring the steps ...Show All

• Software Development for Windows Vista Writing to Global Shared memory from an Application in Vista.

  Hi all, Global shared memory is created by a service which is used by my user mode application to communicate with the service through global mutexes and events. This as of now works well in Vista RC1. 1) Are there any restrictions that an application should not write to global shared memory already created by service This application does not has any elevated privileges. 2) Can application created global named objects like event and mutex Again the application is running under a standard user privilege and not as admin. 3) Can a 32bit application on a 64bit machine get interfaces to a 64bit Local server COM object Is there any special processing required in the 32bit app or in the 64bit local server COM object. Regards, ...Show All