Good morning.
How can I access a SQL Server's data from a COM ?
SQL Passthrough ? Is there a better way than SQLPT ?
Should I create remote views in a DBC and call them from the COM (I d'ont know if this is possible...) But then, if I have to modify the remote view online, It is a little bit complicated.

I am developping on the client-server architecture right now.
I would like to go to n-tier development but have a lot of questions on how I should access the data. I read a lot of book and magazines on COM and got it all, it is just that little step that I need to understand.

I want to implement a COM Server, a SQL Server as backend and a Visual Foxpro interface from start.

When I look at some samples of COM accessing data, it is always on Visual Foxpro native data sample I see.

Any clues for me ?

Thanks.

André