Cannot create SQL DSN

[TingB]

I have a Win2K box with CF 5.0 and am trying to create a DSN to a new box
running SQL 2000 on Win2003 - and it won't. I can make an ODBC connection OK,
however. Checking elsewhere I saw mention of using an "ODBC Socket" data type -
but don't have that in my drop-down. I also tried using dynamic assignment
using this:

<CFQUERY
name="GetInfo"
dbtype="DYNAMIC"
ConnectString="Driver={MERANT 3.70 ColdFusion OEM 32-BIT SQLBase};
SRVR=xyz;
UID=ABC;
PWD=DEF">
select Vend_name FROM Vendors
</CFQUERY>

and get this: ODBC Error Code = IM003 (Specified driver could not be loaded)

Someone else suggested that on the target box I needed a local machine user
with the same name as a SQL user, but this hasn't helped either.

Any thoughts MOST appreciated - I have to get this thing up by Thursday.

Ting

[byron1021]

Are you trying to connect with the SQL driver as a trusted connection, when
trying to create the DSN using the SQL Server driver? You would need a NT
user on the new sql server with the same name and password, that the CF
services is running under in windows services. Then add that NT users as a
login on the sql server with access to whatever db's needed.

[TingB]

Yup. CF has to run as a user with not only a login on the remote machine but a SQL user who has permission on the db in question. Whew!

Thanks all!