Re: Database Connection
From: John Smith (notmyreal_at_address.com)
Date: 11/17/04
- Next message: tshad: "Re: posting without having old page in history"
- Previous message: Kikoz: "Re: c# page level global object postback"
- In reply to: Kevin Spencer: "Re: Database Connection"
- Next in thread: Kevin Spencer: "Re: Database Connection"
- Reply: Kevin Spencer: "Re: Database Connection"
- Reply: Eliahu: "Re: Database Connection"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 17 Nov 2004 15:46:18 -0500
Database Software: FoxPro 7
I installed the VFPOLEDB.DLL for FoxPro 8. The software vendor uses VFP 7
for their database and I want to connect to it to generate custom reports
through asp.net (vb). I tried to connect to the database and get the error
message below. I even tried to manually registering VFPOLEDB.DLL and the
register succeeded. Any ideas? I have search all day trying to find the
solution to this, so far I have had no success. Any help would be much
appreciated.
--------------------------------------------------
CONNECTION STRING:
--------------------------------------------------
Connection String: "Provider=VFPOLEDB.1;Data Source='c:\data';Collating
Sequence=general"
--------------------------------------------------
ERROR MESSAGE:
--------------------------------------------------
Server Error in '/MeetingReports' Application.
No error information available: REGDB_E_CLASSNOTREG(0x80040154).
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.
Exception Details: System.Data.OleDb.OleDbException: No error information
available: REGDB_E_CLASSNOTREG(0x80040154).
Source Error:
Line 73:
Line 74: '*** Fill DataSet with the current returned records ***
--> Line 75: objOleDbDataAdapter.Fill(objDataSet, DataTableName)
Line 76:
Line 77: '*** Fill DataGrid Control with DatatTable ***
Source File: c:\inetpub\wwwroot\xxx\0.aspx.vb Line: 75
Stack Trace:
[OleDbException (0x80040154): No error information available:
REGDB_E_CLASSNOTREG(0x80040154).]
[InvalidOperationException: The 'VFPOLEDB.1' provider is not registered on
the local machine.]
System.Data.OleDb.OleDbConnection.CreateProviderError(Int32 hr) +81
System.Data.OleDb.OleDbConnection.CreateProvider(OleDbConnectionString
constr) +107
System.Data.OleDb.OleDbConnection.Open() +203
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection,
ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord,
Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
+36
MeetingReports._0.PopulateDataGridControl(DataGrid DataGridControl,
String sqlStatement, String DataTableName) in
c:\inetpub\wwwroot\xxx\0.aspx.vb:75
xxx._0.popDataGrid(DataGrid DataGridControl) in
c:\inetpub\wwwroot\xxx\0.aspx.vb:114
xxx._0.Page_Load(Object sender, EventArgs e) in
c:\inetpub\wwwroot\xxx\0.aspx.vb:26
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET
Version:1.1.4322.573
"Kevin Spencer" <kspencer@takempis.com> wrote in message
news:uyKGRePyEHA.1196@TK2MSFTNGP15.phx.gbl...
> Hi John,
>
> You can read about the OLE DB Driver for Visual FoxPro at the following
URL:
>
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/fox7help/html/dggrfOLEDBProviderforVisualFoxPro.asp
>
> You can get good Connection Strings from http://www.connectionstrings.com.
>
> --
> HTH,
> Kevin Spencer
> .Net Developer
> Microsoft MVP
> Neither a follower
> nor a lender be.
>
> "John Smith" <notmyreal@address.com> wrote in message
> news:O1XERZPyEHA.1204@TK2MSFTNGP10.phx.gbl...
> > How do I connect to a FoxPro 7 database?
> >
> >
>
>
- Next message: tshad: "Re: posting without having old page in history"
- Previous message: Kikoz: "Re: c# page level global object postback"
- In reply to: Kevin Spencer: "Re: Database Connection"
- Next in thread: Kevin Spencer: "Re: Database Connection"
- Reply: Kevin Spencer: "Re: Database Connection"
- Reply: Eliahu: "Re: Database Connection"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
