Thanks Denis
I'll test it Monday
Mo
>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
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