Forum Replies Created
Viewing 15 posts - 226 through 240 (of 247 total)
-
RE: Filling in a Form w/data from a XML file
OK, first off you've got one problem. Your XML is not well-formed. I'm guessing that it should be this:
<?xml version="1.0"?>
<RESULTS>
<NTFD>1111</NTFD>
<PRB>1111</PRB> <!-- this line was bad -->
<NAME>11111</NAME>
June 17, 2005 at 9:14 am
-
RE: .NET Programming
I've got a similar situation here, except that the database I have to hit on is not in compatibility mode, it *is* SQL Server 6.5. ODBC works OK against it...
-
RE: Debate - .Net Dev Vs. DBA Who will win?
Here's another example directly from on-line help, example code that populates a dataset from a data adapter:
Dim nwindConn As SqlConnection = New SqlConnection("Data Source=localhost;Integrated Security=SSPI;Initial Catalog=northwind")
Dim...
-
RE: Debate - .Net Dev Vs. DBA Who will win?
Also, FYI, why don't you run a trace on the server, if you can, to see how all those connections are behaving, while the app is in use? If they...
-
RE: Debate - .Net Dev Vs. DBA Who will win?
From on-line help:
"The Fill method implicitly opens the Connection that the DataAdapter is using if it finds that the connection is not already open. If Fill opened the connection, it...
-
RE: Debate - .Net Dev Vs. DBA Who will win?
I agree with this, it looks to me like the open connections are not being closed. ADO.NET does not automatically close connections, even when the connection goes out of scope....
-
RE: DTS troublshooting
Can you do a "disconnected edit" in your DTS package to determine which item is failing? Open the package in Enterprise Manager, right-click on a blank portion of the package...
-
RE: More efficient way
Since you're just getting the year, would the year() function perform any better? Probably a wash, but maybe worth trying in addition to other suggestions.
-
RE: How can I tell if an "image" data type column contains a value?
What query tool are you using? Query Analyzer shows NULL if there's no data. Can you use the datalength() function to determine if there is any data in the field?
Quick...
-
RE: How to detect slow or frozen dts packages?
We had a problem where a particular job (DTS package) had exactly this problem, where the job failed but SQL Server didn't actually fail the package, it would just keep...
-
RE: Stored Procedures Parameters
Don't know about previous versions, but stored procedures in SQL Server 2000 may have type of "text" or "ntext", which theoretically will let you pass in just about as much...
-
RE: Help on XML display...
OK, here's a "better" version that actually does something.
<html>
<head></head>
<body onload ="init()">
<xml id="xmlDoc">
<definitions>
<def>
<phrase>IANAL</phrase>
<definition>I am not a lawyer</definition>
</def>
<def>
<phrase>IIRC</phrase>
<definition>If I recall correctly</definition>
</def>
<def>
<phrase>IMOP</phrase>
<definition>In my opinion</definition>
</def>
</definitions>
</xml>
<label>Pick a phrase: </label>
<select...
-
RE: Help on XML display...
Oops, my bad, you don't need these lines, take them out:var xmlSource = new ActiveXObject("MSXML2.DOMDocument.3.0");
xmlSource.async = false;
xmlSource.validateOnParse=false;
xmlSource.setProperty("SelectionLanguage", "XPath");
Sorry about that, I...
-
RE: Help on XML display...
Here's a code snippet that might get you started. This works in Internet Explorer, not sure about any other browsers. This contains an embedded XML "data island" and uses XPath...
-
RE: Determine Location Within DTS Package
OK, here's an ActiveX script (suitable for use in a DTS package) that uses DMO to get the name of the server, into a package global variable (and shows a...
Viewing 15 posts - 226 through 240 (of 247 total)