ADS using

edited 12:18AM in FastReport .NET
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

Comments

  • edited 12:18AM
    Hello,

    The only way to connect to such DB is via ODBC. Are you able to connect to it in Visual Studio?
  • edited 12:18AM
    Hi Alex,

    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
  • edited 12:18AM
    You also may try to use OLE DB connection from FastReport. There seems a problem with ADS native driver.
  • edited 12:18AM
    Hi,

    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
  • edited 12:18AM
    Please tell me the step-by-step instruction to reproduce this error. Which FR version are you using?
  • edited 12:18AM
    Hi,
    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.

  • edited 12:18AM
    Hello,

    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).
  • edited 12:18AM
    Hi,

    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

  • edited 12:18AM
    As far as I know, you can't use OLE DB in 64bit system, so this is not only FR-related issue.
  • edited 12:18AM
    OK,

    i will go an other way.

    Regards, Frank

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.