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
Previous
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