Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Art S. Kagel — — source: Informix-list mailing list archive (1991-1998)
Makunin Dmitry wrote:
>
> Hi
> I want make this query :
>
> SELECT * FROM appdb@mfcinf:t_1 ;>
> But it do'nt work .
> Help
Saying "But it don't work" isn't telling us much to go on is it? What
version is the local server? The remote server? Platforms (remote &
local)? What was the SQL error returned (code and message)? What was
the ISAM error returned (code and message)? What do the sqlhosts files
on each machine look like? Does the user have a valid login on the
remote machine? Does the user have connect permissions on the remote
database and select permission on the remote table? Are the logging
modes of the two databases compatible? Does the local server support
the datatypes returned by the remote server (ex if local is SE and
remote is IDS and the table includes variable length fields)? Are you
connecting directly to the remote engine or going through the local
engine? There is more I could ask but you get the idea, it could be
lots of things. With more detail maybe someone will recognise the
problem right away. As it stands we'd be guessing.
Art S. Kagel
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.