Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

9
  • Should have added: If I set Database to any path that exists on both the local and remote machines, it acts as if Server is set to localhost and creates a FDB on the local machine. If I set Database to a path that exists on the remote but not locally, I get a "Path not found" error trying to create the FDB. In other words, it seems to be forcing Server to localhost regardless of what I set Server to. This is D12.2 Enterprise so FireDAC local-only restrictions should not apply. Commented Jun 30 at 15:45
  • Did you use FireDAC.Phys.FB? Otherwise, I think it defaults to the embedded driver, which can't do tcp/ip connections Commented Jun 30 at 20:03
  • @Anya - Yes. It's definitely ignoring the Server setting in the ConnectionDef, I just don't know why. If, after setting dbConn.ConnectionDefName, I set the dbConn.Params Server and Database params again, it then connects to the remote machine and creates the empty FDB. But that doesn't seem right, and isn't in line with the examples. I'm sure I'm doing something fundamental wrong, I just don't know what it is. :( Commented Jun 30 at 20:12
  • I have zero knowledge of FireDAC (or even Delphi), but is ipTCPIP the right constant? Commented Jul 1 at 13:16
  • @Mark, it is for this case. The property expects a TIBProtocol typed constant; other options like ipLocal, ipNetBEUI and ipSPX can be used where appropriate. Commented Jul 1 at 14:18