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

  • Users: AceFM
  • Order by date
  1. AceFM

    sp_addlinkedserver from MS SQL 2000 to Sybase

    Thanks, philhege for pointing that out. I've used opendatasource mostly in the past, and just grabbed the data source string from that, and was mis-reading the error message I got when I tried to run a query against the linkedserver. I did get it to work finally: exec sp_addlinkedserver...
  2. AceFM

    sp_addlinkedserver from MS SQL 2000 to Sybase

    I am running into an issue trying to link from MS SQL 2000 to Sybase. I run the sp_addlinkedserver, which appears to work successfully: exec sp_addlinkedserver @server='test', @srvproduct = '', @provider = 'msdasql', @datasrc = 'Data Source=mySrc;UserID=usrID;Password=pwd', @location =...
  3. AceFM

    Inaccurate results from Outer Join query on linked tables

    Any ideas where to get a driver for the Sybase 12 ODBC? I have just wasted a lot of time trying to get information on Sybase drivers. It has been an exercise in frustration.
  4. AceFM

    Inaccurate results from Outer Join query on linked tables

    Thanks. I had checked the Jet driver version earlier in the process, and it looked correct. But I'll go back and double-check that. At least now I know that is the problem area that needs to be focused on.
  5. AceFM

    Inaccurate results from Outer Join query on linked tables

    That worked! Very interesting. I run the query against the linked tables, and the results are incorrect. But when I run the pass-through query, it does work. It had been my understanding that setting up linked tables is supposed to accomplish the same basic thing as running the pass-through...
  6. AceFM

    Inaccurate results from Outer Join query on linked tables

    Sorry for the confusion. I should proofread a little better. The database is Sybase for both tables.
  7. AceFM

    Inaccurate results from Outer Join query on linked tables

    Thanks for the recommendations. I am new to this forum, and it is great to see how responsive people are. Unfortunately, the idea suggested by cmmrfrds is not going to help. Table2.key2 is the primary key for table2, so it always exists if there is a row in Table2. Sorry if I did not make...
  8. AceFM

    Inaccurate results from Outer Join query on linked tables

    Linking to an Oracle Sybase db via ODBC. And on the second question, Yes. Primary key for Table1 is Key1 Primary key for Table2 is Key2 Table2 stores Key1 in a separate field to link to Table1 in a Mto1 relationship.
  9. AceFM

    Inaccurate results from Outer Join query on linked tables

    Using the subquery works properly. I appreciate the suggestion. The inaccurate results from the first query is still a big problem here because that is the code generated by Access in the Design view. And there are several people here who are tasked with running queries who are new to SQL and...
  10. AceFM

    Inaccurate results from Outer Join query on linked tables

    I have run into a very strange problem. Running MS Access 2003, SP3. I am running a simple query with 2 tables, using an outer join, looking for a list of all records in table 1 where there is no corresponding entry in table 2: SELECT Table1.key, Table1.lastname, Table1.firstname FROM...

Part and Inventory Search

Back
Top