undersea

I have a Windows 2003 server running FMS10. After an extended power outage and a failed UPS the server functions corrctly when sharing databases to FM clients. ODBC however does not does. The FMS admin tool says it's running but clients get an error "..conneciton refused" when connecting. I've already tried reloading FMS but with not success. Has anyone else seen this behavior? Thanks, Jon

Has anyone run across FMP/FMS creating odd SQL Select statements when using ESS via FMS? Here's a quick version of what I'm doing: Filemaker Server 9.0.3.325 (Windows Server 2003) System DNS created using default SQL driver Filemaker Advanced 9.0v3 (Windows XP) I'm trying to use invoice number in both tables to match and create a relationship. The relationship works, but is very slow and the SQL statements are not as simple as they could be. Simple SQL Example: SELECT Field001, Field002, InvoiceNo FROM [sql_Table] WHERE (InvoiceNo = '12345678') Here's what FM is creating: SELECT Field001,InvoiceNo,Field002 FROM [sql_Table] WHERE (Field001=N'ABCD123' AND Field002=1 AND InvoiceNo=N'12345678') What's strange is Field001 and Field002 aren't references anywhere in the FMP shadow table or the relationship. One thing I can say is Field001 & Field002 are "Key" fields in the SQL table. I called FMP tech support and was told I cannot edit the SQL statement when using ESS and a server based DSN. I'm hoping someone else has run across this and maybe has another angle on it. Any input would be very helpful. Thanks, Jon

ok...this seams like it should be simple, but it's not working. I want to pull a value list from my FMP5 db and display it in a pulldown / check box / etc field on an add form. How does this work?

sure enough, you're right. they were 2 levels deep in the linked directory. Thanks for the help!

I tired that first, but it didn't open any of the files within the linked directory. More background. The drive the software is installed on as a UW SCSI drive. I'm trying to move the files to a RAID 5.

Anyone know how to have server on NT open Fmp files that are not in it's program folder? jon@brprinters.com