ADS using

FrankM

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

AlexTZ

Hello,

The only way to connect to such DB is via ODBC. Are you able to connect to it in Visual Studio?

FrankM

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

AlexTZ

You also may try to use OLE DB connection from FastReport. There seems a problem with ADS native driver.

FrankM

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

AlexTZ

Please tell me the step-by-step instruction to reproduce this error. Which FR version are you using?

FrankM

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.

AlexTZ

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).

FrankM

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

AlexTZ

As far as I know, you can't use OLE DB in 64bit system, so this is not only FR-related issue.

FrankM

OK,

i will go an other way.

Regards, Frank