app can't connect on some PCs but can on others

[qwertyjjj]

We have an ODBC connection (System DSN) set up for an application with linked tables to the SQL server.
On some PCs, this works straight away.

On others, a login was set up on the SQL server (DOMAIN\username) and the test function in the ODBC connection works but the actual application cannot connect and just falls over...no error.

Any ideas what the issue could be ?

 

[odin1701]

Can you log into the sql server manually on these systems?

Do these users have logins to the SQL server, or are they part of a group which has the proper access?

 

[qwertyjjj]

Can you log into the sql server manually on these systems?

Do these users have logins to the SQL server, or are they part of a group which has the proper access?

None of these systems have SQL enterprise or query analyzer installed but when testing the ODBC link, it connects successfully.
They login through separate NT access at the moment. So, until I set up a group, they each have their own DOMAIN\username login on the sql server.

I can't see why 1 computer would work and the other not.