>>>>
>>>>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.
Interesting problem, I'd be interested in finding out the answer.
Fred Lauckner
You know, it works on my computer. I don't know what your problem is.
.Net aint so bad.