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: 1
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: 3737
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: 1384
Joined: Mon Apr 11, 2005 5:55 am
Location: Iowa - USA


Return to NeoBookDBPro

Who is online

Users browsing this forum: No registered users and 1 guest

cron