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 Wanet Telecoms Ltd 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: bjw
  • Order by date
  1. bjw

    I have a linked server using SQL Se

    I'll let you know how things turn out. Thanks!
  2. bjw

    I have a linked server using SQL Se

    Thanks Tom for responding. So are you saying that assuming I have instantiated cmdTemp and Rs and of course the object to connect to the database the following should work? cmdTemp.CommandText = "select * from openquery([oracleremote]" & ", " & "'" & "select...
  3. bjw

    I have a linked server using SQL Se

    I have a linked server using SQL Server 7.0 to an Oracle database. I can write the select statement using the Query Analyzer in the Enterprise Manager to query the Oracle database using: select * from openquery([oracleremote], 'select * from task') Oracleremote is the alias for the linked...

Part and Inventory Search

Back
Top