I've sent an executable and associated files to someone to comment on the design using a file transfer program (emails get blocked even if zipped if they contain an exe). Here it works, there he's getting a remote logon prompt. Looking at my code I'm setting the session type to stLocal in the IDE and leaving it there.

Worse, the application should just connect (automatic login with no users defined) and open a form to allow users to be added.

Windows 7 both ends, D2006 so 32 bit.

Anyone have any idea what could cause this?

Roy Lambert

Roy

You are in the file-server version, I guess you have the database in a data folder somewhere (probably under the exe-path?)

Your exe will be trying to connect (using whatever login details you have given it) and failing at some point. I realise I am stating the obvious sorry.

The best thing to know is exactly how the user has set up the exe, for example the data-folder might not be exactly where EDB is expecting.

Can you TeamViewer or Remote in to their machine and run it yourself, reviewing how they have done the install?

I would try hacking the code & create an EXE to force in manual values for the DBPath, DBName, SessionName and Password right at the point where you make your first call to the DB. Rebuild and & see whether it works.

I would consider writing code with a ShowMessage for the DBPath and other variables (prior to DB opening) so you can see the ACTUAL values in the programme. They MUST differ from the DB setup or it wouldn't be happening.

... teaching my nana to suck eggs I realise

Adam


>You are in the file-server version, I guess you have the database in a data folder somewhere (probably under the exe-path?)

Yup

>Your exe will be trying to connect (using whatever login details you have given it) and failing at some point. I realise I am stating the obvious sorry.

True but it never hurts

>The best thing to know is exactly how the user has set up the exe, for example the data-folder might not be exactly where EDB is expecting.

They haven't done any set up. This is a zip they can unpack in a folder somewhere and it should run. Tested here on two different machines using W7 & W10 because I found W10 didn't like TNKForm

I tried running from inside the zip and that simply bombs doesn't bring up the remote logon prompt

>Can you TeamViewer or Remote in to their machine and run it yourself, reviewing how they have done the install?

Nope

>I would try hacking the code & create an EXE to force in manual values for the DBPath, DBName, SessionName and Password right at the point where you make your first call to the DB. Rebuild and & see whether it works.

Logon to ElevateDB is built in - its going to have a single database user with logon to the app.

>I would consider writing code with a ShowMessage for the DBPath and other variables (prior to DB opening) so you can see the ACTUAL values in the programme. They MUST differ from the DB setup or it wouldn't be happening.
>
>.. teaching my nana to suck eggs I realise

The only problem I have with that is that even though I live in the Scottish Highlands I don't wear a skirt!

Roy

They don't have the ZIP in Outlook, or in a DropBox or other virtual or network drive that might make your exe barf?

Are they definitely in a drive location with admin read/write permissions?

Adam

>They don't have the ZIP in Outlook, or in a DropBox or other virtual or network drive that might make your exe barf?
>
>Are they definitely in a drive location with admin read/write permissions?

The guy who's doing the review for me had to go off to the hospital (check up on knee operation) I'm going to pursue things when he gets back.

Roy

Roy,

<< I've sent an executable and associated files to someone to comment on the design using a file transfer program (emails get blocked even if zipped if they contain an exe). Here it works, there he's getting a remote logon prompt. Looking at my code I'm setting the session type to stLocal in the IDE and leaving it there. >>

The default prompt says "Remote Login...", but that's just because that's what *Delphi* labeled it, and we use the built-in login dialog for database access.  IOW, you're just seeing a normal login prompt for a local session.  This means that your session doesn't have a proper user name/password set.

Tim Young
Elevate Software
www.elevatesoft.com

Tim


><< I've sent an executable and associated files to someone to comment on the design using a file transfer program (emails get blocked even if zipped if they contain an exe). Here it works, there he's getting a remote logon prompt. Looking at my code I'm setting the session type to stLocal in the IDE and leaving it there. >>
>
>The default prompt says "Remote Login...", but that's just because that's what *Delphi* labeled it, and we use the built-in login dialog for database access. IOW, you're just seeing a normal login prompt for a local session. This means that your session doesn't have a proper user name/password set.

That's probably it. It also explains why I was so confused about it.

Roy