Search results for query: *

hi Christiaan Problem solved. For some reason the project reference was invalid, although the path to the reference was correct. I removed the reference entirely from the solution and then added it back and rebuilt the whole solution again, which then compiled without any problems. Thank you...

hi Christiaan Had already tried that, but have rebuilt the offending project and checked that the dll in the bin\ folder has had its date modified date correctly updated. Even deleted it and built the project again. the function can still be seen within object explorer and is still scoped as...

hi I have inherited several VB.Net projects which are wrapped up in a solution. In one of the projects (DLL) i have added a new public function to an existing class. Then within a windows form, I then create an instance of the object.class and then proceed to call the newly created function...

thanks Crowley16 - that worked at treat - what part exactly does SET NOCOUNT ON actually play?

hi Im trying to get a simple recordset back from a sql server stored procedure. The content of the sp can be seen below: CREATE Procedure usp_GetSecondaryOwnersByUserID ( @SecOwnerId int ) AS IF NOT EXISTS (select * from sysobjects where id = object_id('dbo.SecondaryOwners')) BEGIN CREATE...

thanks for the link. As you said earlier the SQLConfigDataSource does not support the UID and PWD attributes. I have seen applications that prompt for info to create an ODBC DSN and maintain both the SQL username and password as I would like to do. Looks like I'll have to try another...

hi this is a code snippet ' ODBC API ' -- ODBC Commands Public Const ODBC_ADD_DSN = 1& Public Const ODBC_CONFIG_DSN = 2& Public Const ODBC_REMOVE_DSN = 3& Public Const ODBC_ADD_SYS_DSN = 4& Public Const ODBC_CONFIG_SYS_DSN = 5& Public Const ODBC_REMOVE_SYS_DSN = 6& Public Const...

hi yes amongst many others as well! Why cant the dsn accept the password and uid without failing?

hi I have been trying to programmatically create a System DSN entry using VB6. I have managed to do this but without being able to supply the password for the SQLserver user. Can anyone suggest why this might be? I am using the: Private Declare Function SQLConfigDataSource Lib "odbccp32.dll"...

thanks tsuji for the quick response. Assuming that the <root> node is named <ControlledList> then the solution would then become. var xmlDoc = new ActiveXObject("Msxml2.DOMDocument"); var matchedNodes; xmlDoc.async = false; xmlDoc.load("lgcs.xml"); //select those nodes that do not have a...

Hi I have an xml file that has various nodes within each section. What I would like to be able to do using xpath queries is to select all <item> nodes that dont have a specific child node of <broaderItem>. Example snippet: <Item Id="1" ConceptId="1" Obsolete="false" AddedInVersion="2.00"...

hi The reports are not being printed in the sense that they are being sent to a printer device, but there are supposed to be 'sent' to a file instead. The code recieves a report name from the macro call. The report name is used to decipher which report to run and to build an SQL Where clause...

hi I have an access database which is used to run automated reports from a scheduled task using a macro to call vba code. The vba code uses the DoCmd.OpenReport and also uses DoCmd.OutPutTo. Recently the DoCmd.OutputTo has been failing to create the reports at the specified location and yet...

Hi Can anyone give any pointers as to how I can get hold of a driver or information on connecting to an INGRES 2.6 database (INGRES SPARK POLARIS VERSION II - 2.6/0305) from SQL Server 2000? thanks to anyone offering help.

thanks for the reply. The answer was spot on, as I had just found it on microsoft tech net site. http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part2/c0761.mspx strange this is though I found it within an ASP page that is making calls to a SQL Server database!! Cheers anyway.

Hi Can anyone offer advice as to what the (+) entry within the following sql syntax is actually doing please? strSQL = "SELECT * FROM customers, cust_titles, cust_addr,cust_codes" strSQL = strSQL & " WHERE custcodes=code(+)" strSQL = strSQL & " AND title=titleid(+)" strSQL = strSQL &...

Hi Thanks for the feedback. Unfortunately the input source file is not sorted by the application that creates it, and would need to be done by ourselves beforehand - pre-processed. However, the SAX parser cannot update the document in the same way that using the XMLDOM can. I agree that...

thanks for the reply. I too have suggested using a database to achieve this, but apparently it has to be done this way!?? When you mention XML blobs - is this something that Ms SQL server supports? I would have thought that storing xml as binary would defeat the object. Are XML blobs within...

Hi I have written a small exe in vb6 that reads in a text file one line at a time. Using two of the fields (accountref and propertyref) from the text file the program queries an XML document, for the presence of an <account> element with an acctref attribute that matches the "accountref" value...

cheers Dan