Cannot create SQL DSN

Posted: 02-22-2005, 08:31 PM
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

Reply With Quote

Responses to "Cannot create SQL DSN"

byron1021
Guest
Posts: n/a
 
Re: Cannot create SQL DSN
Posted: 02-24-2005, 02:43 AM
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.

Reply With Quote
TingB
Guest
Posts: n/a
 
Re: Cannot create SQL DSN
Posted: 02-24-2005, 06:57 PM
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!
Reply With Quote
 
LinkBack Thread Tools Search this Thread Display Modes
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Create folders stevenlmas Dreamweaver AppDev 0 02-16-2005 08:25 PM
Create folders stevenlmas Dreamweaver AppDev 0 02-16-2005 08:11 PM
Using ID to create PDF Forms Jake_Janovetz@adobeforums.com Adobe Indesign Windows 0 04-01-2004 02:51 AM
Create Rounded Tab Images? gilgantic Adobe Photoshop 7, CS, CS2 & CS3 0 06-27-2003 03:22 PM
How do I create a Collage ? BobHill Adobe Photoshop Elements 0 06-22-2003 02:00 PM