Alias DB

[Steve S]

In FM 6 if you wanted to make an alias to a database on a server, you actually had to create a new database that ran a script that opened the hosted file and then closed itself.

Do you still have to do this in FM 7? Is there a way to alias a hosted DB without creating an additional db?

[Fitch]

You still use opener files in FM7. The good news is, you can now explicitly define file references, so you can set up the opener file without having to actually connect to the server. You just go to define, type in e.g. fmnet:/xx.xx.xx.xx/yourFile. The bad news is, that's the only way to do it -- you can't define a file ref. from a field or script, which would be ideal for this use.

Another cool thing about FM7 is multiple tables per file. I made myself a deluxe launcher file that includes a table with all the FM error codes. Took all of 3 minutes to set up and import. Now my users get semi-intelligent error messages when the hosted file fails to open for whatever reason.

[Steve S]

well. this might be more for a permissions thread, but I'll post here anyway.

So I use the starter file and it works to open the hosted one. My problem now is logging in. It seems that if I set the starter file to auto log in, then it will use that logon for the hosted file. I dont get a chance to log in at all.

So I can see to fix this, I can create the same accounts I have on the hosted db onto my starter db. then logon to the starter and it will use that logon for the hosted db. But this is a pain. Every time I make a new account i'll have to update the starter file on every client. Not friendly.

Can I set it to somehow ignore the authentication to the starter file when it hits the hosted DB.. And just use the accounts created in the Hosted DB?

hope that makes sense, thanks!

[Claus Lavendt]

Yes. Just make the opener file unlocked, or use an account/password that you do NOT have in the systems on the server.

This way, the user is forced to enter username/password to the remote file.

(The remote file must be set to NOT log in automatically)

;-) Claus

[Steve S]

Thanks much you guys. This is what I needed to get it working.

Hey Fitch, any chance you can give me a look at that delux starter file you mentioned? It sounds pretty neat and I'd love to see how you did it. And maybe save meself some time trying to figure it out. :

Thanks again

[Fitch]

When I have a little time I'll clean up the file and post it.

[Fitch]

Finally uploaded the file. See the Sample Files forum. I'd post a link, but the tags don't seem to be working today.