setowmich

Hello everyone, I'm working with a 3rd party software that is sending query over ODBC in what I think is some sort of ANSI mode example: SELECT "Age","Last Name","First Name","DOB","Sex","MI","Height","Weight","ID1","ID2" FROM Demographics I was wondering if there is anyway for FMP to accept this type of query? I know in MySQL you can run in a ansi mode which will treat the "" as idenitfiers not as a string. Right now the result of that statment looks like this: "Age" "Last name" "First name" Could someone please point me at the right direction. Thank you

yeah I should of posted in odbc sorry. lee

Thanks for the reply, in MySQL I guess ANSI changes the behavior of sql statments (check out the following link). http://mysqld.active-venture.com/ANSI_mode.html The query statment above is from a 3rd party software which talks to a database (in this case FMP) over ODBC. The purpose of the select statment above is to list a list of users, it is not a text file. The reason I want to see if i can run FMP in an ANSI mode so it will treat "age" as a field, treating "" as idenifiers. Right now it treat "age" as the a string age, I want it to return a number. I'm hoping theres a ODBC translator out there somewhere. Thanks again Lee Joe

Hello everyone, I'm working with a 3rd party software that is sending query over ODBC in what I think is some sort of ANSI mode example: SELECT "Age","Last Name","First Name","DOB","Sex","MI","Height","Weight","ID1","ID2" FROM Demographics I was wondering if there is anyway for FMP to accept this type of query? I know in MySQL you can switch it to a ansi mode. Thank you

Hello everyone, I

OOPS I feel like a dummy my database wasn't up, thats why I was getting the TCP/IP error. I am able to connect to my database using either localhost or 127.0.0.1 but not with the machines ip address(150.198.131.45) I get a 3061 error "[DataDirect][ODBC SequeLink Driver][sequeLink Server]Authorisation failure." (Yes, they did spell authorization with an "s") Can someone please point me at the right direction? Again I'm able to do this on an MySQL setup on the same machine so the ip address is correct and is not an issue. Thank you Joe

Help! I'm trying to set up ODBC on FMP 7. Heres what I did: Installed MDAC 2.8, the database is on the local machine, the odbc sharing is enable for All users, I'm using port 2399, Network sharing is also enable but I dont think it has anythign to do with ODBC. I get error 2306 "[datadirect][ODBC Sequelink driver][sqequelink] TCP/IP error, connection refused" when I use 127.0.0.1, localhost or the ip address of the machine in the "SequeLink Server Host:" field. Additional note: I used MySQL to create the same database and was able succesfully do a test connection and prcoess queries via ODBC, so I don't think is my machine. Please point me at the right direction. Joe

yehonatan Thanks for the reply I will give that a try.

I'm having the same problem but I do not have a space in my filename "GrassDB". Any suggestions? Thanks

Hi all, I need some help. I

Hey all, I