![]() |
![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
| Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks. |
| |||||||
![]() |
| |
| | #1 (permalink) |
| | ODBC / Vista / Foxpro I have installed our .NET application on a system running Microsoft Windows Vista operating system. When I run our application, I receive the following error message whenever it tries to create a DBF file using VFPODBC: "ERROR [IM001] [Microsoft][ODBC Driver Manager] Driver does not support this function" I am using a connection string that I have used for many years with no problems, here is some sample C# code: try { string connectionStatement = "Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDb=C:\\temp"; string createTableStatement = "CREATE TABLE [c:\\temp\\test] FREE(field1 C(10), field2 C(10), field3 C(10))"; OdbcConnection dbConnection = new OdbcConnection(connectionStatement); dbConnection.Open(); OdbcCommand createCmd = new OdbcCommand(createTableStatement, dbConnection); createCmd.ExecuteNonQuery(); <<<< Fails here with the message above >>>> } catch( System.Exception e ) { MessageBox.Show(e.Message, "Error Creating Report Table" ,MessageBoxButtons.OK, MessageBoxIcon.Error); } How can I get my program to work in Vista (32 and 64bit)? Rob |
My System Specs![]() |
| | #2 (permalink) |
| | Re: ODBC / Vista / Foxpro "Robert Hooker" <rhooker@noemail.noemail> wrote in message news:OG3ny8U7GHA.4552@TK2MSFTNGP05.phx.gbl... >I have installed our .NET application on a system running Microsoft Windows >Vista operating system. > > When I run our application, I receive the following error message whenever > it tries to create a DBF file using VFPODBC: > "ERROR [IM001] [Microsoft][ODBC Driver Manager] Driver does not support > this function" > > I am using a connection string that I have used for many years with no > problems, here is some sample C# code: > > try > { > string connectionStatement = "Driver={Microsoft Visual FoxPro > Driver};SourceType=DBF;SourceDb=C:\\temp"; > string createTableStatement = "CREATE TABLE [c:\\temp\\test] FREE(field1 > C(10), field2 C(10), field3 C(10))"; > > OdbcConnection dbConnection = new OdbcConnection(connectionStatement); > dbConnection.Open(); > > OdbcCommand createCmd = new OdbcCommand(createTableStatement, > dbConnection); > createCmd.ExecuteNonQuery(); <<<< Fails here with the > message above >>>> > } > catch( System.Exception e ) > { > MessageBox.Show(e.Message, "Error Creating Report Table" > ,MessageBoxButtons.OK, MessageBoxIcon.Error); > } > > > How can I get my program to work in Vista (32 and 64bit)? > Rob > > > You could try: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=<path>;Extended Properties=dBASE IV;User ID=Admin;Password=" as the connection string and use OleDb instead of ODBC. HTH, Mythran |
My System Specs![]() |
| | #3 (permalink) |
| | Re: ODBC / Vista / Foxpro Small correction: It actually fails here: dbConnection.Open(); "Robert Hooker" <rhooker@noemail.noemail> wrote in message news:OG3ny8U7GHA.4552@TK2MSFTNGP05.phx.gbl... >I have installed our .NET application on a system running Microsoft Windows >Vista operating system. > > When I run our application, I receive the following error message whenever > it tries to create a DBF file using VFPODBC: > "ERROR [IM001] [Microsoft][ODBC Driver Manager] Driver does not support > this function" > > I am using a connection string that I have used for many years with no > problems, here is some sample C# code: > > try > { > string connectionStatement = "Driver={Microsoft Visual FoxPro > Driver};SourceType=DBF;SourceDb=C:\\temp"; > string createTableStatement = "CREATE TABLE [c:\\temp\\test] FREE(field1 > C(10), field2 C(10), field3 C(10))"; > > OdbcConnection dbConnection = new OdbcConnection(connectionStatement); > dbConnection.Open(); > > OdbcCommand createCmd = new OdbcCommand(createTableStatement, > dbConnection); > createCmd.ExecuteNonQuery(); <<<< Fails here with the > message above >>>> > } > catch( System.Exception e ) > { > MessageBox.Show(e.Message, "Error Creating Report Table" > ,MessageBoxButtons.OK, MessageBoxIcon.Error); > } > > > How can I get my program to work in Vista (32 and 64bit)? > Rob > > > |
My System Specs![]() |
| | #4 (permalink) |
| | Re: ODBC / Vista / Foxpro Hi Mythran, For the record, not all DBFs are compatible with the dBase driver. FoxPro DBFs created with VFP3-6 may be accessed via the FoxPro and Visual FoxPro ODBC drivers, downloadable from msdn.microsoft.com/vfoxpro/downloads/updates/odbc, and also DBFs that are created with VFP7-9 if they don't use any of the new data features added in VFP7 and above. All versions of FoxPro DBFs are accessible via the FoxPro and Visual FoxPro OLE DB data provider, downloadable from msdn.microsoft.com/vfoxpro/downloads/updates . -- Cindy Winegarden MCSD, Microsoft Most Valuable Professional cindy@cindywinegarden.com "Mythran" <kip_potter@hotmail.com> wrote in message news:emtRpNV7GHA.4348@TK2MSFTNGP03.phx.gbl... > > "Robert Hooker" <rhooker@noemail.noemail> wrote in message > news:OG3ny8U7GHA.4552@TK2MSFTNGP05.phx.gbl... > You could try: > > "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=<path>;Extended > Properties=dBASE IV;User ID=Admin;Password=" > > as the connection string and use OleDb instead of ODBC. |
My System Specs![]() |
| | #5 (permalink) |
| | Re: ODBC / Vista / Foxpro Hi Robert, Have you tried the FoxPro and Visual FoxPro OLE DB data provider, downloadable from msdn.microsoft.com/vfoxpro/downloads/updates ? A typical OLE DB data provider connection string (in VB) looks like: connString = "Provider = VFPOLEDB.1; Data Source = C:\Temp;" You can only work with Visual FoxPro ODBC or OLE DB in a 64-bit environment in compatibility mode. There are no plans to create a 64-bit FoxPro ODBC driver or OLD DB data provider. I'm told there will, however, be a .NET data provider for FoxPro. -- Cindy Winegarden MCSD, Microsoft Most Valuable Professional cindy@cindywinegarden.com "Robert Hooker" <rhooker@noemail.noemail> wrote in message news:ONrcPwV7GHA.4476@TK2MSFTNGP04.phx.gbl... > It actually fails here: > dbConnection.Open(); >> "ERROR [IM001] [Microsoft][ODBC Driver Manager] Driver does not support >> this function" >> try >> { >> string connectionStatement = "Driver={Microsoft Visual FoxPro >> Driver};SourceType=DBF;SourceDb=C:\\temp"; >> string createTableStatement = "CREATE TABLE [c:\\temp\\test] >> FREE(field1 C(10), field2 C(10), field3 C(10))"; >> >> OdbcConnection dbConnection = new OdbcConnection(connectionStatement); >> dbConnection.Open(); >> How can I get my program to work in Vista (32 and 64bit)? |
My System Specs![]() |
![]() |
| Thread Tools | |
| |
Similar Threads | ||||
| Thread | Forum | |||
| Dos Based Foxpro 2.6 not load on Net Work drive of Vista Business | Vista General | |||
| Cannot connect to FoxPro database in Vista, IIS 7 | General Discussion | |||
| FoxPro ODBC | Vista General | |||
| ms dos foxpro 2.6a (X) will work ? | Vista General | |||
| I have a problem creating a ODBC connection to a Foxpro Database!! | Vista file management | |||