Hello all,

I am able to use SQL SELECT (to read) and UPDATE (to update) a VFP table that is bound to its main.dbc database using any of the following ASP.NET/VB connection strings:

Dim m_connString As String = "Provider=VFPOLEDB.1;Data Source=c:\database\main.dbc;Shared=True"
Dim m_connString As String = "Provider=VFPOLEDB.1;Data Source=c:\database\main.dbc;Mode=ReadWrite|Share Deny None;Password='';Collating Sequence=MACHINE"
Dim m_connString As String = "Provider=VFPOLEDB.1;Data Source=c:\database\main.dbc;Mode=Share Deny None;Password='';Collating Sequence=MACHINE"

BUT, when I have the main.dbc opened in share mode in VFP 9 (with or without the table being USEd in share mode) and then try to do the SELECT or UPDATE with my VB asp code I get a "cannot open the c:\database\main.dbc" file.

I have also tried the connection string with Mode=READWRITE and get same error. I also have removed the reference to main.dbc in the connection string (leaving just the path) and get the same error.

So, my question is, "What is the ASP.NET/VB connection string to use when VFP will already have the database and tables opened by VFP users in SHAREd mode"?

Thank you for any assistance,
Ron

PS I believe I can open the VFP9\samples\data\testdata.dbc using a version of the above connection string even if this database is opened in SHAREd mode by VFP before I try to open it using my ASP.NET/VB code.