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
Posts: n/a