>>>
>>>A shot in the dark but have you installed the lastest Mdac_typ on your new PC?
>>
>>Hi Fred,
>>
>>Some yes, some no. :-)
>
>I noticed that you are passing ODBC in front of your connection string.
>
>I use
>
>omain.conhand1 = SQLSTRINGCONNECT( SQLDRIVER=SQL Server; SERVER=EDispatch ; UID=sa; PWD=; WSID=EClient; DATABASE=Dispatch)
>
>Without any problems, to connect to a SQL Server7 database.
Correct. The usage is in an Outlook form using VBScript. The documentation I read indicates the need for "ODBC" to be in the connection string.
We have narrowed this down to a connection protocol problem. The software is trying to connect using the Named Pipes Network Library but we require TCP/IP. I have not been able to locate where this setting can be made globally in NT. The only place we have seen it is when setting up a DSN.
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.