SQL 2000 Linked servers in VB.NET

[clivelp]

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 ok, but cannot view the linked server FoxPro tables, nor can I see them in Server Explorer

Sample of code

Dim myConnString As String = "Provider=SQLOledb;" & _
                "Data source=myDataserver\mySQLServer;" & _
                "Integrated Security=SSPI;"

Dim mySQLString As String = "SELECT Em_Fname,Em_Lname, " & _
         "Em_Alias, Em_PWord FROM myLinkedServer.Employee"

Dim myConnection As New OleDbConnection(myConnString)

Dim myCommand As New OleDbCommand(mySQLString, myConnection)

Try
    myCommand.Connection.Open()
    Dim myReader As OleDbDataReader

    etc.etc.

I have used many combinations of the code displayed above with no effect. Could anyone Please point me in the right direction.

Many thanks

 

[danielhozac]

And this has what to do with Apache? //Daniel

 

[sleipnir214]

danielhozac:

Did I miss a memo? Was Sunday the beginning of The Week of Bad Questions? Want the best answers? Ask the best questions:

http://www.tuxedo.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[danielhozac]

Sure does seem like it. //Daniel

 

[btaber]

Since this is here, BE SURE YOUR SQL SERVER 2000 IS UP TO DATE!!!, avoid adding to the current sh*t storm of W32.Slammer...