Jump to content

setowmich

Members
  • Content Count

    11
  • Joined

  • Last visited

Community Reputation

0 Neutral

About setowmich

  • Rank
    novice
  • Birthday 10/29/1980
  1. setowmich

    run in ANSI mode?

    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
  2. setowmich

    ANSI mode?

    yeah I should of posted in odbc sorry. lee
  3. setowmich

    ANSI mode?

    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
  4. setowmich

    ANSI mode?

    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
  5. Hello everyone, I
  6. setowmich

    error 2306

    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
  7. setowmich

    error 2306

    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
  8. setowmich

    SequeLink Error: 3201

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

    SequeLink Error: 3201

    I'm having the same problem but I do not have a space in my filename "GrassDB". Any suggestions? Thanks
  10. Hi all, I need some help. I
  11. Hey all, I
×

Important Information

By using this site, you agree to our Terms of Use.