I am having a strange problem.

I have developed an app in VB5 SP3 that makes an ODBC call to SQL Server 6.5 SP3.
When I install this app on a NT4 SP4 server the ODBC Call fails.
If I install VB5 on the Server the ODBC Call then works.

Here is my connection code:

Set Wks = DBEngine.CreateWorkspace("ODBC", "", "", dbUseODBC)
StrCn = "ODBC;DSN=SQLSRV;UID=XXX;PWD=XXX;DATABASE=QUEUE"
Set Cnn = Wks.OpenConnection("", dbDriverNoPrompt, False, StrCn)

Any help would be appreciated.