Hello, can i use a named pipes connection to MS SQL Server 2000? On server i cant use TCP/IP temporarily (few months maybe), so i have available only named pipes variant :(. Please help.
Thank you.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Well IMO if the client is on Windows, you should be able to connect with Named Pipes. Just install e.g. SQL 2000 Personal Edition on the client machine (you need the client tools), then use Client Network Utility applet to configure communication layer, and you should be done. Then you should be able to pull the config out of the registry and use it on other machines. Sorry, presently I can't assist you in every detail, but I'm sure it's possible.
Regards,
Andrzej
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Thank you for info. Unfortunately i try to connect from linux box (Debian Etch) to Windows 2000 Server machine, so i havent native SQL client :(. Is there any solution for Linux (FreeTDS, unixOdbc)?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello, can i use a named pipes connection to MS SQL Server 2000? On server i cant use TCP/IP temporarily (few months maybe), so i have available only named pipes variant :(. Please help.
Thank you.
Well IMO if the client is on Windows, you should be able to connect with Named Pipes. Just install e.g. SQL 2000 Personal Edition on the client machine (you need the client tools), then use Client Network Utility applet to configure communication layer, and you should be done. Then you should be able to pull the config out of the registry and use it on other machines. Sorry, presently I can't assist you in every detail, but I'm sure it's possible.
Regards,
Andrzej
Thank you for info. Unfortunately i try to connect from linux box (Debian Etch) to Windows 2000 Server machine, so i havent native SQL client :(. Is there any solution for Linux (FreeTDS, unixOdbc)?
I'm sure it is, but I'm not aware of.