Source language: Translate to:

DPPro won't open excel file unless it is already open!!

Questions about our Advanced Database plug-in

Moderator: Neosoft Support

DPPro won't open excel file unless it is already open!!

Postby Majed » Tue Dec 05, 2017 9:30 am

Hi every one. This is my first participation here.

I love NeoBook (although not being updated for long long time), and I love this awesome community, where every one likes to help everyone.

I'm building an application where it must first get the data from excel file, then it do its stuff. I've tried to open .xls files with NeoBookDBPro, but after multiple errors and tries, I found that the only way to open an excel file with DPPro is when the file is already open in the background! otherwise it won't open. This is unwanted situation where the connection to the data source should always be transparent in the background.

Any solution for this please?

Thanks in advance.
Majed
 
Posts: 2
Joined: Wed Nov 22, 2017 12:53 pm

Re: DPPro won't open excel file unless it is already open!!

Postby Gaev » Tue Dec 05, 2017 1:44 pm

Majed:

1) Is there any access restriction associated with the file in question ? ... try and use a file with access to all users.

2) Post your code (dbpOpendatabase etc.) ... and the error result being received.
User avatar
Gaev
 
Posts: 3757
Joined: Fri Apr 01, 2005 7:48 am
Location: Toronto, Canada

Re: DPPro won't open excel file unless it is already open!!

Postby dpayer » Wed Dec 13, 2017 2:06 pm

You can make ODBC connections to Excel files and access them on demand from that point using DBP.
David Payer
Des Moines, Iowa
USA
User avatar
dpayer
 
Posts: 1391
Joined: Mon Apr 11, 2005 5:55 am
Location: Iowa - USA

Re: DPPro won't open excel file unless it is already open!!

Postby Majed » Sun Dec 24, 2017 1:41 pm

Thank you all for your help

I tried to get screenshot of the error message but my company has applied a "Whitelisting" system where all exe files are blocked unless authorized.

This caused me to request authorisation every time I generate an .exe file. What a bad luck. This will make my development with Neobook a nightmare. :(

Side question: Does NBDB Pro support network multi-user db applications? or I have to do some modifications to make it so?

Thanks again for your great help and support.
Majed
 
Posts: 2
Joined: Wed Nov 22, 2017 12:53 pm

Re: DPPro won't open excel file unless it is already open!!

Postby Gaev » Sun Dec 24, 2017 2:41 pm

Majed:

I tried to get screenshot of the error message but my company has applied a "Whitelisting" system where all exe files are blocked unless authorized.


Why can't you just write it down (on paper) ... and then type it in here ?

Or take a snapshot with your smart phone ... upload it to some public cloud space (Microsoft, Google etc.) and then link to it from here.
User avatar
Gaev
 
Posts: 3757
Joined: Fri Apr 01, 2005 7:48 am
Location: Toronto, Canada


Return to NeoBookDBPro

Who is online

Users browsing this forum: No registered users and 1 guest