September 28, 2006 at 6:16 am
i have a a few excel reports that connect to my database by using an ODBC connection. both TCP/IP and named pipes are enabled on the server. i can connect to the server via TCP/IP only, but i get no connection with pipes. The problem is that the excel reports exclusively use pipes. Whats very annoying is my neighbour can access the database using both pipes and TCP/IP, and has no problems refreshing his reports. I have re created my ODBC Connection, changed connection in CLICONFG, reset the server, reset my pc and still it works for my neighbour, but not for me and a few more. can anyone advise as to why this is so?
September 29, 2006 at 10:32 am
Thats the second time my reply was lost.
Check the named pipe, this is everything after \\.\PIPE, by default its \sql\query.
xp service pack two autoamticaly enables the windows firewall and disables port 445. netbios over tcp requies port 445.
verify you and your partner are on the same subnet and thus going through the same firewall.
the nbtstat should help with figuring out what is configured in netbios; similar to the netstat command for tcp/ip that tells you what ports are listening on by what process.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply