Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
c
Starting Member
1 Post |
 Posted - 2005-01-31 : 18:10:33
|
| I've installed unixODBC and mdbTools and im accessing a M.Access data base in a remote server with no problems, connection is fine.BUT i only can use "SELECT" tag and "FROM" tag. if i use "WHERE" or other else SQL tag a get always this error: odbc_do(): SQL error: [unixODBC]Couldn't parse SQL , SQL state 08001 HELP ME |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-01-31 : 19:17:45
|
| If you know you're passing a valid query, then that's definitely a problem with the driver you're using. Not much we can recommend except to contact the vendor or website where you got the driver from.There are plenty of drivers and data layers available, depending on the platform and language you're programming in. Can you shed any light on your environment?By the way, SELECT, FROM, and WHERE are not "tags", they are clauses of a SQL statement. If you have a programming reference or environment that uses "tags" to describe these, you'll need to post more information on how you're writing this code. |
 |
|
|
|
|
|
only works "select" and "from" SQL tags