Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. HamotIntern

    Can you read an XML file into an ADO recordset - if so, how

    Here's how I did it. This puts the XML into a record set. Function Main() Dim strConnect strConnect = "Provider=MSPersist" Dim rs SET rs = CreateObject ("ADODB.Recordset") Set SQLcn = CreateObject("ADODB.Connection") SQLcn.ConnectionString = "Driver={SQL Server}; Server= [Server Name]...
  2. HamotIntern

    loading an xml file with sp_xml_preparedocument

    I too am having problems using OPENXML with a XML file. By replying to this, the thread will surface to the top again and perhaps someone who understands OPENXML will help the both of us.
  3. HamotIntern

    How do I import a physical file with XML-data into MS-SQL?

    I too am having problems using OPENXML with a XML file. Perhaps by replying to this, the thread will surface to the top again and perhaps someone who understands OPENXML will help us.
  4. HamotIntern

    Import a XML-file..?

    I too am having problems using OPENXML. Perhaps by replying to this, the thread will surface to the top again and perhaps someone who understands OPENXML will help the both of us.
  5. HamotIntern

    XML and SQL Tables

    I realize what I am going to say will not make a lot of sense why I want to do this, but after I gave you long explanation, it would. I want to put a number of NON-SQL tables into XML documents. Then, I want to inert the data from the XML documents into existing SQL tables. The format of the...
  6. HamotIntern

    SQL Tables and XML

    I realize what I am going to say will not make a lot of sense why I want to do this, but after I gave you long explanation, it would. I want to put a number of NON-SQL tables into XML documents. Then, I want to inert the data from the XML documents into existing SQL tables. The format of the...
  7. HamotIntern

    Putting two connections to work in one statement

    You are correct, field one is the name of the table to import, field two is the table to import into. Yes, the source and destinations have the same structure. IF I could SQL query the source tables, I’d be very happy. However, SQL Server cannot link the tables and its DTS Wizard does not...
  8. HamotIntern

    Putting two connections to work in one statement

    This driving me nuts. SQL’s automated DTS does not work with the ODBC driver I am using. So am forced to do it manually. Below is the code. I have the connections working correctly, but when it comes to the actual transfer part, I am at a loss. My coworker’s have tried to help but no luck...
  9. HamotIntern

    Putting two connections into one statement

    This driving me nuts. SQL’s automated DTS does not work with the ODBC driver I am using. So am forced to do it manually. Below is the code. I have the connections working correctly, but when it comes to the actual transfer part, I am at a loss. My coworker’s have tried to help but no luck...
  10. HamotIntern

    Putting two connections to work in one statement

    This driving me nuts. SQL’s automated DTS does not work with the ODBC driver I am using. So am forced to do it manually. Below is the code. I have the connections working correctly, but when it comes to the actual transfer part, I am at a loss. My coworker’s have tried to help but no luck...
  11. HamotIntern

    Using Access event code in DTS

    I'm slowly getting it on my own. The part of the code that is giving me grief right now is, With rst .Source="bxj_Import" .ActiveConnection=oCn .CursorType=adOpenKeyset .Open .Find strCriteria Do While Not .EOF ... Specifically the line ".CursorType=adOpenKeyset". Since I want to use .find...
  12. HamotIntern

    Using Access event code in DTS

    One of my co-workers gave me a hand writing the script. We think we’re on the right track and may even have it, but are receiving an error that we cannot figure out. The code we wrote is, Function Main() Dim sServer Dim sLogin Dim sPwd Dim oCn Dim rst Dim sNames Dim oFso Dim oFileOut...
  13. HamotIntern

    Using Access event code in DTS

    :-) It’s not quite that easy (I tried that first). MS Access is able to do something SQL Server can’t, and that’s why I was using it. The database that the adp file is attached to is SQL server, not an Access database. So I’m essentially working with the SQL server with Access as the front...
  14. HamotIntern

    Using Access event code in DTS

    I have a piece of code that is associated to a button on a simple form in Access. When I press it, it looks at a table for which tables to import from an AllBase database and then imports it/them. DTS’s Import Function does not work in this application because it doesn’t work with the ODBC...
  15. HamotIntern

    Piecing back together a chopped up note

    I don't want this thread ending with me asking a stupid question. Right after I submitted it I realized how evident the answer was.
  16. HamotIntern

    Piecing back together a chopped up note

    I kind of stepped away from this problem for a little while, now I’m back. PH, where exactly should I place that piece of code?
  17. HamotIntern

    Grey Scale Reports

    I apologize if this has been addressed in another thread, I didn’t see one that does. It’s kind of an age-old problem and was kind of surprised not to see a thread on it…designing a report to print in black and white/grey scale. I have a line chart that has six elements on it. The report will...
  18. HamotIntern

    How do you keep from charting NULL values?

    I had success last night, or at least I accomplished my goal. I more or less catered to the chart in my query by adding SELECT what.*, CASE WHEN what.ClassLL = 'Other BP' THEN what.Expn1 END AS Systolic, CASE WHEN what.ClassLL = 'Other BP' THEN what.expn2 END AS Dyastolic...
  19. HamotIntern

    How do you keep from charting NULL values?

    I posted this question in another forum (http://www.manning-sandbox.com/forum.jspa?forumID=97&start=0) and got the following response http://www.manning-sandbox.com/thread.jspa?messageID=42780&#42780. I have not been able to successfully implement his idea yet, but I thought you might...
  20. HamotIntern

    How do you keep from charting NULL values?

    Yea, I think it’s time for more clarification. Yes, all of the vitals are on one chart (as requested by one of the VPs). It doesn’t make sense to me either, but it’s what he wants. It is at the top of a daily report that shows a patent’s history for a one-day period. There is an Input/Output...

Part and Inventory Search

Back
Top