Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Create Table using VFP OleDB
Message
From
08/02/2005 19:49:05
 
 
To
08/02/2005 18:52:55
David Mckay
Australian Workplace Software
Sydney, Australia
General information
Forum:
Visual FoxPro
Category:
Visual FoxPro and .NET
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00984982
Message ID:
00984991
Views:
34
> string conn = "Provider=VFPOLEDB.1;Data > >Source=C:\\Temp\\FoxPro\\test.dbc;Password='';Collating Sequence=MACHINE";

> OleDbConnection oleconn = new OleDbConnection(conn);

>OleDbCommand olecmd = new OleDbCommand("CREATE TABLE newtable (number CHAR(15))", oleconn);

>oleconn.Open();

>olecmd.ExecuteNonQuery();

>oleconn.Close();

>Could this be an issue with the oledb foxpro driver??


This could be a permission issue, try to give read/write access to ASPNET account(IIS5) or Network Service(IIS6).
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform