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!

  • Congratulations Chris Miller 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. jmatte

    Searching text field help!

    I am using the freetext function in SQL server to search through a description field of products. I realize that the catalog contains an index of words for the field and only references the record it belongs to. The problem is the order in which the result set comes back. The field contains...
  2. jmatte

    Page through Records

    I have a search results page which I populate by calling a stored procedure in SQL Server 2000 and saving the results to a recordset. I iterate through the recordset placing each field in the appropriate column and row where I also take the id field and href to a matching image which appears...
  3. jmatte

    Need to call Stored Proc from DTS COM

    Any suggestions are appreciated. I need to create a DTS task in VB6 to call a stored procedure in SQL Server 2000. I am using VB6 and the DTS COM interface. I've only found code samples using the ExecuteSQLTask.SQLStatement but I don't want to use any SQL in my VB component. I would rather keep...
  4. jmatte

    System DSN

    I've created a system DSN to access a SQLServer 2000 database. I need to access this DSN in an ActiveX DLL that uses ADO. I've tried using a connection string dsn=__;uid=__;pw=__ but that couldn't find the system DSN I created. What is the correct syntax for doing this? Thanks in advance for...
  5. jmatte

    System DSN

    I've created a system DSN to access a SQLServer 2000 database. I need to access this DSN in an ActiveX DLL that uses ADO. I've tried using a connection string dsn=__;uid=__;pw=__ but that couldn't find the system DSN I created. What is the correct syntax for doing this? Thanks in advance for...
  6. jmatte

    Accessing a DLL using Server.CreateObject()

    Hello, I am fairly new to ASP so any help is appreciated. I would like to access a DLL that I created using an ASP page. My code is: 'Declare object Dim objConn 'Set object to DLL Name and Class Set objConn = Server.CreateObject("DataUtilityDLL.cClass") 'Pass in parameters to DLL...

Part and Inventory Search

Back
Top