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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement