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 Chriss 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: *

  • Users: FGS
  • Order by date
  1. FGS

    Btrieve->SQL error 7347 unexpected field length

    Additional info The problem does not occur using a DTS ODBC connection object - only using the Linked Server, even though both sources use the same DSN. Does anyone know the difference between how the ODBC connection is implemented via Linked Server vs a DTS data source connection object? FGS
  2. FGS

    Btrieve->SQL error 7347 unexpected field length

    Additional info The problem does not occur using a DTS ODBC connection object - only using the Linked Server, even though both sources use the same DSN. Does anyone know the difference between how the ODBC connection is implemented via Linked Server vs a DTS data source connection object? FGS
  3. FGS

    Btrieve->SQL error 7347 unexpected field length

    I am trying to import from a Btrieve 6.15 data file (generated by Scala v5.0)using Perv ODBC 2.04, into SQL 7 sp3 via linked server. The whole process is on a desktop machine running NT4 sp6. The imports are monthly, and worked until this month. The error was - Server: Msg 7347, Level 16...
  4. FGS

    Btrieve->SQL error 7347 unexpected field length

    I am trying to import from a Btrieve 6.15 data file (generated by Scala v5.0)using Perv ODBC 2.04, into SQL 7 sp3 via linked server. The whole process is on a desktop machine running NT4 sp6. The imports are monthly, and worked until this month. The error was - "Server: Msg 7347, Level...
  5. FGS

    Select Criteria in a SQL Query

    Here is a wordy explanation from Pervasive that may explain why you have seen that construct before - it has to do with one of the options in setting up an ODBC data source: Scalable SQL-style null handling vs. ODBC-style null handling Scalable SQL determines null values by examining the data...
  6. FGS

    SELECT OK, SELECT INTO loses data

    Found my own problem - corrupt data in a primary key field on three records in the site address table. Why this effected the make table query and not the select query is still something I do not understand.
  7. FGS

    SELECT OK, SELECT INTO loses data

    When I execute the following in Access 97 (checking whether the customer has a different site address from invoice address): SELECT ServContrac.ServContrNo AS ContrNo, ServContrac.ICustCodeCon AS ICustNo, ServContrac.CustSiteNo AS Site...

Part and Inventory Search

Back
Top