Search results for query: *

No, that's the wild thing. No triggers on the Mysql table. It doesn't appear that any major data in the SQL DB is changed... I don't think. The SQL database's triggers log changes to major data in that table, and nothing from me is logged there. But those same triggers decided to put my...

I wrote the following query to update a table in a mysql database from sql server. I cannot figure out why this wound up updating the updatedate field for some 3000 records on the linked SQL server. It should have been the source of updated fields. I can't tell what it might have updated, if...

Hello, I'm creating a webservice for a customer. I have a small problem - prefer that a domain account be used to authenticate users before the access this service, but they don't have anything suitable in their domain. Seems to me that a domain user that isn't given access to anything except...

In case anyone in the future comes along looking for the answer.... The class needed to look like this: Partial Public Class cXMLRequestShipNoticeRequestShipControlCarrierIdentifier Private domainfield As String Private valueField As String...

I need to create an XML file that looks like this: <ShipControl> <CarrierIdentifier domain="SCAC">FDE</CarrierIdentifier> </ShipControl> I have: Partial Public Class cXMLRequestShipNoticeRequestShipControl <System.Xml.Serialization.XmlElement()> _ Public CarrierIdentifier() As...

VB.net 2008 service, trying to write a file to a directory on another server. I've tried both Dim Filestrm As New FileStream(OutputPath, FileMode.Create, FileAccess.Write) and a simple file copy after writing the file locally first; both get me an "Error 5: Access to the path '(outputpath...

The old hard drive is connected as a slave - the OS on it won't boot, but we have everything on it except for whatever key piece of windows got trashed, preventing it from booting. The old certificates are there. Just no pfx. I told them I'm pretty sure they're hosed, too. But if there's any...

My customer had a certificate on their server 2003 machine. It was called when encrypting and decrypting credit card numbers. The machine inconveniently went kaput this week without warning. OS is apparently trash. We have everything running again, but have no way to access the old credit...

I have a solution, but it's not pretty. I would really love to be able to do this in a select query rather than resorting to something procedural. But, if nothing else, I did find a method that will work. CREATE TABLE XmlImportTest ( xmlFileName VARCHAR(300), xml_data xml ) GO DECLARE...

What are you trying to insert into the table? Are you sure you know how many characters it *actually* is?

Can you order by JobNum, ShipDate and select Top 1 ?

2005 sp3

I have XML Data that looks like this. <?xml version="1.0" encoding="UTF-8" ?> <CustomerMapping xmlns:i="http://www.w3.org/2001/XMLSchema-instance"> <CustMap NetworkId="AN01000018306-T" CustID="Testing" /> <CustMap NetworkId="AN01000018304-T" CustID="Nobody" /> </CustomerMapping> Over...

(I should be more specific. I did try that, and it didn't fix it. :-) )

Yes, I did try that, thanks.

I have a new service that watches a directory for new xml files and takes action when one is added/changed. When I add the following code, I find that once I save a file in the watched directory, I'm no longer able to access it. My service has it locked up. Offending code: Dim xpathDoc As...

I need to use a schema in Visual Studio, and VS requires it to be an XSD. I've not done XML in VS before (I'm really a SQL person that used to be a programmer and now I get to wear more hats). I've used both XMLSpy and xsd.exe to convert a DTD to an XSD. But when I do, it always creates THREE...

Nevermind, got one working with WebRequest.

God, I hate being a newb again! I have successfully avoided all this web-service stuff that started in with programming when I jumped from being a standalone VB6 app programmer to a SQL person. But it turns out that while I've been gone from the developing world, things, um, changed. I need...

XML Spy doesn't go for free anymore, sadly. $160 for the Standard ed and I think I might need the pro. Alchemist seems to just connect to mysql and oracle, but I need xml to be both source and destination. Seems like it should be so simple, and I must be overlooking something. I hate being...