Hi,
I just made some test and I have not problem with 2 databases and view based on table from another database.
I create oleDBConnection using VS IDE, place DataGrid control.. and wrote simple code
Dim loDS As DataSet
loDS = New DataSet
Dim loOleDBAdapter As OleDbDataAdapter
loOleDBAdapter = New OleDbDataAdapter(New OleDbCommand("Select * from view1"))
loOleDBAdapter.SelectCommand.Connection = Me.OleDbConnection1
loOleDBAdapter.Fill(loDS, "resultset")
Me.DataGrid1.DataSource = loDS
Me.DataGrid1.DataMember = "resultset"
All works correct.. but I check realy simple case when simple view from database2 based on simple table from database1
Denis.
>I have 2 vfp databases. 1 database has views that query table from the second database.
>When I try to call a view from inside ASP.NET, the connection point to only one database and can not see the second database.
>is there a solution for this issue?
>
>One way is to ignore the view and write code to call the second database but would be nice if I can use the views as is.
>
>Mo
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only