| CetinBasoz wrote:|
Practically no. It only has dangers as with any other database system (like you'd decide what to do if 2 users are updating the same record). IOW you can think of your C# + VFP as 2 VFP or 2 C# multiuser application.
Along the lines I read ODBC in your message. My suggestion forget ODBC and use VFPOLEDB instead (OleDbConnection).
As per speed between VFP and MSSQL, being primarily a foxhead, I'd too like if VFP was faster but I can't say that. MSSQL 2005 has many more undeniable plusses (hey comparison simply is not fair - my simple rule, if you have a chance to use MSSQL, use it else VFP. You can even mix them.).
PS: Since you're completing it probably you would not interested but have you ever thought of remoting instead of winsock programming directly (or maybe I got it wrong).
Cetin, thank you. I just read your post since I seldom now come to visit here. No time. Your comment on MySQL is of considerable value for me. I will focus on it for another project for sure. Actually I have already installed a server.
I do use VFPOLEDB connection to the VFP tables. It turned out to be the only solution or rather the easiest one.
I actually came here for another post of yours. It seems to me it has been wiped out. Did you remove it as the author There was some C# code in it and I did not save it. Now I regret.
I do have a situation now with another database (also VFP) where I read tables into C# with OleDbConnection but do not want to use XML for sending the data back. I thought that I should look at your sample but now it is gone. I think you gave an example of that.
One of my posts in this thread has also disappeared. Very funny. That post of course is of no value for me.
You should trespass over to C# General. You will have fun. And also your knowledge will be helpful for a lot of folks over there.