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 Mike Lewis 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. Horsegag9

    Apostrophies

    Hello All, What is the syntax for including a single quote or ' in my query? I know you have to wrap it in something, but I can't remember what it is. Thanks in Advance Horse
  2. Horsegag9

    DTS Error

    When I import a simple text file into a SQL database I am getting the following error: "Not enough storage is available to complete this operation" Does anyone know why this error comes up? I have imported two other larger tables into this DB without incident. Thanks in advance Horse
  3. Horsegag9

    Opening and Closing Record Sets

    Hi Guys, What do I need to do to read from more than one recordset within a single script? Do I need to close the Conn and RS first. Any scripting samples would be great thanks. Horse
  4. Horsegag9

    Populating recordsets

    Hey All, I am executing the following query in a vbscript, it obviously pulls info from various tables: strFilter ="SELECT A.PDDOCO, A.PDAN8, B.A6AN8, C.ABAN8, C.ABAN85, C.ABALPH, C.ABDC, B.A6TRAP FROM PRODDTA.F4311 A, PRODDTA.F0101 C, PRODDTA.F0401 B WHERE A.PDAN8 = C.ABAN8 AND C.ABAN85 =...
  5. Horsegag9

    VBScript and SOAP Problem

    Hey All, I have the below script on a field that is used to make a call using webservices and then pull back the result from that call and populate the field. The script on the field is thus: On Error Resume Next Dim oSOAP Set oSOAP = CreateObject("MSSOAP.SoapClient30")...
  6. Horsegag9

    Blanks as Nulls

    Hey All, I am trying to import a text file into a blank database, creating the table in the process. This is all done using DTS. How can I avoid blank fields being represented as "Null"? I would like to to stay blank on import, but no amount of configuring in DTS can stop this from happening...
  7. Horsegag9

    Web Services in VBScript

    Hi All, I am trying to execute the following script: ===================================================== dim SOAPClient set SOAPClient = createobject("MSSOAP.SOAPClient") on error resume next SOAPClient.mssoapinit("http://www.xmethods.net/sd/CurrencyExchangeService.wsdl") if err then...
  8. Horsegag9

    MDF File Extension

    It's alright, answered my own question. File for a SQL database for anyone who was also curious.
  9. Horsegag9

    MDF File Extension

    Hey All, I was curious if anybody knew what application produces a MDF file extension? DF sounds like it stands for data file, but no regular programs such as Access, SQL or Ultra Edit can read it properly. Any suggestions? Thanks in advance. H

Part and Inventory Search

Back
Top