473,396 Members | 2,111 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

home > topics > asp.net > questions > database connection

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Database Connection

How do I connect to a FoxPro 7 database?
Nov 18 '05 #1
8 2152
Google search should bring this one up pretty quick. Here is one link

http://msdn.microsoft.com/library/de...etwithvfp7.asp
"John Smith" wrote:
How do I connect to a FoxPro 7 database?

Nov 18 '05 #2
Hi John,

You can read about the OLE DB Driver for Visual FoxPro at the following URL:

http://msdn.microsoft.com/library/de...sualFoxPro.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" <no*******@address.com> wrote in message
news:O1**************@TK2MSFTNGP10.phx.gbl...
How do I connect to a FoxPro 7 database?

Nov 18 '05 #3
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.CreateProviderEr ror(Int32 hr) +81
System.Data.OleDb.OleDbConnection.CreateProvider(O leDbConnectionString
constr) +107
System.Data.OleDb.OleDbConnection.Open() +203
System.Data.Common.DbDataAdapter.QuietOpen(IDbConn ection connection,
ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(O bject 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" <ks******@takempis.com> wrote in message
news:uy**************@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/de...sualFoxPro.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" <no*******@address.com> wrote in message
news:O1**************@TK2MSFTNGP10.phx.gbl...
How do I connect to a FoxPro 7 database?


Nov 18 '05 #4
Well, I'm not sure what you mean by "installed" but it looks like the driver
is not registered.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Neither a follower
nor a lender be.

"John Smith" <no*******@address.com> wrote in message
news:uu**************@TK2MSFTNGP10.phx.gbl...
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.CreateProviderEr ror(Int32 hr) +81
System.Data.OleDb.OleDbConnection.CreateProvider(O leDbConnectionString
constr) +107
System.Data.OleDb.OleDbConnection.Open() +203
System.Data.Common.DbDataAdapter.QuietOpen(IDbConn ection connection,
ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(O bject 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" <ks******@takempis.com> wrote in message
news:uy**************@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/de...sualFoxPro.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" <no*******@address.com> wrote in message
news:O1**************@TK2MSFTNGP10.phx.gbl...
How do I connect to a FoxPro 7 database?



Nov 18 '05 #5
have you tried to use the DSN? You can register your data source as odbc and
use the odbc driver ..
"John Smith" <no*******@address.com> wrote in message
news:uu****************@TK2MSFTNGP10.phx.gbl...
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.CreateProviderEr ror(Int32 hr) +81
System.Data.OleDb.OleDbConnection.CreateProvider(O leDbConnectionString
constr) +107
System.Data.OleDb.OleDbConnection.Open() +203
System.Data.Common.DbDataAdapter.QuietOpen(IDbConn ection connection,
ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(O bject 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" <ks******@takempis.com> wrote in message
news:uy**************@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/de...sualFoxPro.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" <no*******@address.com> wrote in message
news:O1**************@TK2MSFTNGP10.phx.gbl...
> How do I connect to a FoxPro 7 database?
>
>



Nov 18 '05 #6
You really want to avoid using ODBC if at all possible ODBC is a wrapper for
OLE DB, which makes it much slower, as a System DSN is a registry entry
which must be read in order to use it, and of course, you have the overhead
of using a wrapper instead of OLE DB directly.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Neither a follower
nor a lender be.

"Eliahu" <br******@hotmail.com> wrote in message
news:#H*************@TK2MSFTNGP10.phx.gbl...
have you tried to use the DSN? You can register your data source as odbc and use the odbc driver ..
"John Smith" <no*******@address.com> wrote in message
news:uu****************@TK2MSFTNGP10.phx.gbl...
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.CreateProviderEr ror(Int32 hr) +81
System.Data.OleDb.OleDbConnection.CreateProvider(O leDbConnectionString
constr) +107
System.Data.OleDb.OleDbConnection.Open() +203
System.Data.Common.DbDataAdapter.QuietOpen(IDbConn ection connection,
ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(O bject 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" <ks******@takempis.com> wrote in message
news:uy**************@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/de...sualFoxPro.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" <no*******@address.com> wrote in message
news:O1**************@TK2MSFTNGP10.phx.gbl...
> How do I connect to a FoxPro 7 database?
>
>



Nov 18 '05 #7
I would like to avoid ODBC if at all possible. But... I did try it just to
see if the driver would work for me and it did work. But much like Kevin
stated I would really prefer to not use odbc. Any idea why it would work
forcing the provider to use an odbc dsn vs. straight oledb? Any ideas what
I can do to get the other connection to work? I could potentially be
dealing with 10K's - 100K's of records at any one point and would like to
use the faster connection.

the connection string that worked for me: "Provider=VFPOLEDB.1;DSN=myData"
"Kevin Spencer" <ks******@takempis.com> wrote in message
news:Ot*************@TK2MSFTNGP11.phx.gbl...
You really want to avoid using ODBC if at all possible ODBC is a wrapper for OLE DB, which makes it much slower, as a System DSN is a registry entry
which must be read in order to use it, and of course, you have the overhead of using a wrapper instead of OLE DB directly.

--
HTH,
Kevin Spencer
.Net Developer
Microsoft MVP
Neither a follower
nor a lender be.

"Eliahu" <br******@hotmail.com> wrote in message
news:#H*************@TK2MSFTNGP10.phx.gbl...
have you tried to use the DSN? You can register your data source as odbc and
use the odbc driver ..
"John Smith" <no*******@address.com> wrote in message
news:uu****************@TK2MSFTNGP10.phx.gbl...
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.CreateProviderEr ror(Int32 hr) +81
System.Data.OleDb.OleDbConnection.CreateProvider(O leDbConnectionString constr) +107
System.Data.OleDb.OleDbConnection.Open() +203
System.Data.Common.DbDataAdapter.QuietOpen(IDbConn ection connection,
ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(O bject 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" <ks******@takempis.com> wrote in message
news:uy**************@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/de...sualFoxPro.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" <no*******@address.com> wrote in message
> news:O1**************@TK2MSFTNGP10.phx.gbl...
> > How do I connect to a FoxPro 7 database?
> >
> >
>
>



Nov 18 '05 #8
Well, John, as I mentioned before, it looks like the driver wasn't installed
properly. The error message indicates that it isn't registered. Every COM
component on a given machine must be registered with the System Registry in
order to be used by a client app. That was why I asked what you meant by
"installed." You can't simply copy the DLL to the machine. That's one of the
improvements in .Net.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Neither a follower
nor a lender be.

"John Smith" <no*******@address.com> wrote in message
news:u7**************@TK2MSFTNGP09.phx.gbl...
I would like to avoid ODBC if at all possible. But... I did try it just to see if the driver would work for me and it did work. But much like Kevin
stated I would really prefer to not use odbc. Any idea why it would work
forcing the provider to use an odbc dsn vs. straight oledb? Any ideas what I can do to get the other connection to work? I could potentially be
dealing with 10K's - 100K's of records at any one point and would like to
use the faster connection.

the connection string that worked for me: "Provider=VFPOLEDB.1;DSN=myData"
"Kevin Spencer" <ks******@takempis.com> wrote in message
news:Ot*************@TK2MSFTNGP11.phx.gbl...
You really want to avoid using ODBC if at all possible ODBC is a wrapper

for
OLE DB, which makes it much slower, as a System DSN is a registry entry
which must be read in order to use it, and of course, you have the

overhead
of using a wrapper instead of OLE DB directly.

--
HTH,
Kevin Spencer
.Net Developer
Microsoft MVP
Neither a follower
nor a lender be.

"Eliahu" <br******@hotmail.com> wrote in message
news:#H*************@TK2MSFTNGP10.phx.gbl...
have you tried to use the DSN? You can register your data source as odbc
and
use the odbc driver ..
"John Smith" <no*******@address.com> wrote in message
news:uu****************@TK2MSFTNGP10.phx.gbl...
> 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.CreateProviderEr ror(Int32 hr) +81 >

System.Data.OleDb.OleDbConnection.CreateProvider(O leDbConnectionString > constr) +107
> System.Data.OleDb.OleDbConnection.Open() +203
> System.Data.Common.DbDataAdapter.QuietOpen(IDbConn ection connection, > ConnectionState& originalState) +44
> System.Data.Common.DbDataAdapter.FillFromCommand(O bject 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" <ks******@takempis.com> wrote in message
> news:uy**************@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/de...sualFoxPro.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" <no*******@address.com> wrote in message
>> news:O1**************@TK2MSFTNGP10.phx.gbl...
>> > How do I connect to a FoxPro 7 database?
>> >
>> >
>>
>>
>
>



Nov 18 '05 #9
New Post

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
Question about database connections
by: Mudge | last post by:
Hi, My hosting provider only allows me to use 50 connections to my MySQL database that my Web site will use. I don't know what this 50 connections means exactly. Does this mean that only 50...
PHP
11
Database Connection questions.
by: pradeep_TP | last post by:
Hi all, I have a few questions that I have been wanting to ask for long. These are all related to ADO.net and specifically to conenction to database. 1) If I have opened a connection to a...
C# / C Sharp
3
Database connection advice
by: R Reyes | last post by:
Hi, I'm trying to modularize my database connections a little better and get more out of my project with less code. First check out this common dbOpen() function inside class clsDatabase. I...
C# / C Sharp
14
ConnectionState problem - managing connections to an Access database
by: Nick Gilbert | last post by:
Hi, I have an asp.net application which runs from a CD-ROM using Cassini. As such, it is single user only. The application connects to an Access database when it is loaded, and keeps the same...
ASP.NET
7
Basic question about database connection in ASP.NET
by: Lau Lei Cheong | last post by:
Hello, Actually I think I should have had asked it long before, but somehow I haven't. Here's the scenerio: Say we have a few pages in an ASP.NET project, each of them needs to connect to...
ASP.NET
3
database connection loss
by: Martin B | last post by:
Hallo! I'm working with C# .NET 2.0, implementing Client/Server Applications which are connecting via Network to SQL-Server or Oracle Databases. To stay independent from the underlaying Database...
C# / C Sharp
35
Making a database connection global
by: Terry Jolly | last post by:
Web Solution Goal: Have a global database connection Why: (There will be 30+ tables, represented by 30+ classes) I only want to reference the database connection once. I put the connection...
ASP.NET
6
How to use one database connection object per page request
by: Arsalan Ahmad | last post by:
Hi all, I am creating a website in which in an Item detail page there are a number of web controls (7 or 8) and what is happening that inside each of control's Page_Load() function I am creating...
ASP.NET
22
Frinavale
How To Use A Database In Your Program
by: Frinavale | last post by:
How To Use A Database In Your Program Many .NET solutions are database driven and so many of us often wonder how to access the database. To help you understand the answer to this question I've...
.NET Framework
1
Curtis Rutland
How To Use A Database In Your Program Part II
by: Curtis Rutland | last post by:
How To Use A Database In Your Program Part II This article is intended to extend Frinny’s excellent article: How to Use a Database in Your Program. Frinny’s article defines the basic concepts...
.NET Framework
0
Merging data from multiple Excel files
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
Data Management
0
Migrating Website to Cloud - Emmanuel Katto
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
General
0
BarryA
Navigating the Data Structures and Algorithms (DSA)
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
Algorithms / Advanced Math
0
How to build RAID in BIOS?
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
Computer Hardware
0
Changing the language in Windows 10
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
Windows Server
0
Oralloy
Problem With Comparison Operator <=> in G++
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
C / C++
0
The easy way to turn off automatic updates for Windows 10/11
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
Windows Server
0
tracyyun
Discussion: How does Zigbee compare with other wireless protocols in smart home applications?
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
General
0
agi2029
AI Job Threat for Devs
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
Career Advice

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.

BYTES.COM © 2024
About Bytes
Terms Of Use
Privacy Policy
Sitemap
Advertise on Bytes:
Post a Job
Sponsored Posts
Platinum & Gold Sponsors
Hire Now!