Some background… My company is migrating a Oracle database to Sybase. The new database is pretty radical compared to the old, so there’s a lot of work to be done in the transition. I’m using an Access database as a kind of go between right now.
My problem, I’m trying to do a simple select query between my Access database and the Sybase, and when I say simple, I mean dead simple. But it fails, “[Microsoft][ODBC Microsoft Access Driver] ODBC–call failed.” I can’t figure out what to do to make this work. Any help would be greatly appreciated. Thanks!