>Hi all,
>
>I using below connection string in ASP.NET and C# with ADO.NET oledb command when I changed the data source to D driver. I encounter a error like this "Exception Details: System.Data.OleDb.OleDbException: Invalid path or file name".
>
>
>strconnection = "provider=VFPOLEDB.1 ;data source='D:\DATABASES\VFP\SPF_LTM';password='';user id=''";
>
>What is the problem of foxpro ole db provider ? ONLY can access the data source in C driver!
>Can somebody help me solve the problem? Thank you in advance.
Vincent,
Besides security check your connection string. Version says C# and code looks like C#. If it's C# or C++, \ in string denote an escape character. Either use \\ as path separator or prefix your string with @. However I think it's a typo writing here otherwise I expect the compiler to catch it (but might slip with valid escape sequences).
Cetin