I can't connect to ODBC MsAccess database

Stimulsoft Reports.PHP discussion
Post Reply
infocom
Posts: 5
Joined: Thu Oct 25, 2012 2:50 pm

I can't connect to ODBC MsAccess database

Post by infocom »

Hi Friends,

I can't connect to MsAccess database .mdb file via ODBC, when I try to define the new connection always Designer display the "this feature is not supported in AIR Report designer" message error.

I test with several connection string sintax, but all possible conection string are wrong for Designer.

Can you post any connection string sample to simply connect to a local .mdb database file ?

Thanks
Aquiles
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: I can't connect to ODBC MsAccess database

Post by HighAley »

Hello.

The AIR Report Designer supports XML and mySQL data sources only.
Please, use the web-based Designer.

Thank you.
infocom
Posts: 5
Joined: Thu Oct 25, 2012 2:50 pm

Re: I can't connect to ODBC MsAccess database

Post by infocom »

Hi Aleksey,

I work with Scriptcase (an app generator for php) that don't have a good report generator, then I want to integrate scriptcase and stimulsoft reports, booth in php.

My scriptcase app is binded to msaccess via odbc and apache web server, I'am not clear about scriptcase.web with asp.
Why scriptcase.fx for php can't connect to odbc ? odbc is part of the choices when I try to create a new connection, please add this option to .fx or send me a link to documentation for .web ONLY, because stimulsoft documentation is always generic.

Thanks,
Aquiles
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: I can't connect to ODBC MsAccess database

Post by HighAley »

Hello.

There are two report designers in the Reports.Fx for PHP product.
1. Stand alone AIR Report Designer. Uses internal data adapters and supports XML and MySQL only.
3. Web-based Designer. It uses PHP data adapters and support all listed data bases.

Thank you.
infocom
Posts: 5
Joined: Thu Oct 25, 2012 2:50 pm

Re: I can't connect to ODBC MsAccess database

Post by infocom »

Thanks Aleksey,

One last help please, the Web Based Designer,
How to start working with these designer ? any download ? a link please ....
where reside my reports ?
How to connect to my local server data ?
How to run one report with parameters ?

Remember, I work on Windows environment with PHP as programming language

Thanks again
Aquiles
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: I can't connect to ODBC MsAccess database

Post by HighAley »

Hello.

Please, try to read the Stimulsoft Reports.Fx for PHP Developer FAQ
There you could find answer on your questions.

Thank you.
Post Reply