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 Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
FORMATED BINDING
I am binding a textbox to a dataset created with a SELECT command from SQLServer2000 linked server from FoxPro 2.6 Dos tables. From a Date type field I get in the text box "01/01/2003 00:00:00" can the time portion be removed before binding takes place. Many thanks- clivelp
- Thread
- Replies: 0
- Forum: Visual Basic (Classic)
-
UPDATE STATEMENTS IN OPENQUERY
I need to run UPDATE commands in a stored procedure to a linked server connected to a legacy database, no probs with SELECT commands but am in a mess with UPDATE and INSERT SELECT code as follows SET @SQL = 'SELECT * FROM OPENQUERY(myServer," SELECT '+''+@Fields+''+' FROM Department WHERE...- clivelp
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Programming
-
SQL 2000 Linked servers in VB.NET
I am trying to access FoxPro 2.6 tables and have created a linked server with a System.DSN ODBC driver as the data source, and the correct FoxPro tables are listed in mySQLServer.myLinkedServer.Tables node. In a VB.NET app Using OleDb Connection and Command objects I can view the 'pubs' tables...- clivelp
- Thread
- Replies: 4
- Forum: Linux (server)
