ADS using
Hi,
i try to use an Advantage Database or normal DBF Files as Data Source.
What is the right Way to do that? My tests with ODBC don??t work.
Regards, Frank
i try to use an Advantage Database or normal DBF Files as Data Source.
What is the right Way to do that? My tests with ODBC don??t work.
Regards, Frank
Comments
The only way to connect to such DB is via ODBC. Are you able to connect to it in Visual Studio?
no. I get only a OLEDB Connection with VS. The ODBC Driver i get not working (I think i make somethink wrong) Other Problem is that can only Test 32bit systems.
Regards, Frank
when i use the ADS ODBC i see no Tables in FR Data Wizard.
when i using the MS OLE DB Provider for Visual Foxpro i get this error in FR:
System.AccessViolationException: Es wurde versucht, im gesch??tzten Speicher zu lesen oder zu schreiben. Dies ist h?¤ufig ein Hinweis darauf, dass anderer Speicher besch?¤digt ist.
bei System.Windows.Forms.UnsafeNativeMethods.PeekMessage(MSG& msg, HandleRef hwnd, Int32 msgMin, Int32 msgMax, Int32 remove)
bei System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData)
bei System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
bei System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
bei System.Windows.Forms.Application.RunDialog(Form form)
bei System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
bei System.Windows.Forms.Form.ShowDialog()
bei FastReport.Design.DataCommand.InvokeAddDataSource(Object sender, EventArgs e)
bei DevComponents.DotNetBar.BaseItem.RaiseClick(eEventSource source)
bei DevComponents.DotNetBar.BaseItem.InternalMouseUp(MouseEventArgs objArg)
bei DevComponents.DotNetBar.PopupItem.InternalMouseUp(MouseEventArgs objArg)
bei DevComponents.DotNetBar.ButtonItem.InternalMouseUp(MouseEventArgs objArg)
bei DevComponents.DotNetBar.MenuPanel.OnMouseUp(MouseEventArgs e)
bei System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
bei System.Windows.Forms.Control.WndProc(Message& m)
bei DevComponents.DotNetBar.MenuPanel.WndProc(Message& m)
bei System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
bei System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
bei System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
Regards, Frank
Because i get not the ADS ODBC running and ADS is not supported by FR i try to use the
VFPOLEDB to Open the DBF Files.
Fastreport 1.3.68
Start FR Designer "As Admin"
Data
Add Data Source
New connection
Select "Ole DB connection"
Build
Select under Provider Microsoft OLE DB Provider for Visual FoxPro
Next
The Error before.
But i have now Test with XP, and there it work.
W7 32/64 and Vista32 the Same Error by me.
Hope that help.
Unfortunately I have no VFP OLE DB driver on my machine. It however works with Jet.OLEDB driver for .mdb (tested in WinXP and Vista, both 32bit). If you get an error after pressing the "Next" button in the OLE DB connection string builder dialog, this is probably the system error and does not relate to FastReport. Also note that some OLE DB drivers do not work under 64bit systems (Jet.OLEDB is one of them).
OK, the Error is only when open the Data Wizard from FR.
I can write the Connection String and use the Report.
But then i have the Problem that OLEDB Provider is not for 64-Bit Systems. I can use this with C#, but not with FR.
It look like that i have no chance to use DBF Files with FR at 64bit OS?
Regards, Frank
i will go an other way.
Regards, Frank