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 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!
Recent content by bjw
-
I have a linked server using SQL Se
I'll let you know how things turn out. Thanks!- bjw
- Post #5
- Forum: Microsoft SQL Server: Programming
-
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...- bjw
- Post #3
- Forum: Microsoft SQL Server: Programming
-
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...- bjw
- Thread
- Replies: 5
- Forum: Microsoft SQL Server: Programming
