Problem filling DataSet with MS Remote OLE DB Provider [VB.NET]
Hi all
I am having a problem filling a DataSet object when using the MS Remote OLE
DB Provider to access a remote ODBC DSN over a WAN. This is my code.
~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~
'Data Access Variables
Dim odbc_Connection As New System.Data.OleDb.OleDbConnection _
("Provider=MS Remote;Remote Server= http://www.*-*-*.com/ ; Remote
Provider=MSDASQL;DSN=MyDSN;Uid=Username;Pwd=Password")
Dim odbc_Adapter As New System.Data.OleDb.OleDbDataAdapter _
("SELECT DWORD_KEY FROM tblCustomerDetails WHERE CustomerID = '" &
CustomerID & "'", odbc_Connection)
Dim odbc_DataSet As New System.Data.DataSet()
odbc_Adapter.Fill(odbc_DataSet)
~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~
Any help would be greatly appreciated.
Many thanks
Andy Kimbrey - Agile IT