Tip - Remote connection to MS SQL using Vista 64-bit OS

terencepjf · Post by **terencepjf** » Sat Jan 10, 2009 5:16 pm

I just moved to Vista 64 bit OS and had trouble connection to a remote MS-SQL database with a non standard port.

Here's the fix for Vista 64 bit OS

There are 2 ODBC data managers - the default is the 64-bit version found in the Control Panel. This one will NOT work

Steps to setup:
1) Navigate to: C:\Windows\SysWOW64
2) Run the program: odbcad32.exe
3) Setup your SYSTEM DSN
4) Make sure you change the Port in "Client Configration" (the 2-nd step) of the wizard
5) Use Server authentication and use your credentials
6) Test & Save the connection

To use this in MS:
Let>str=DSN=PCart;Uid=user_id;Pwd=user_pwd;

This should save you some time IF you move to Vista-64

Cheers!

Post by **Marcus Tettmar** » Sat Jan 10, 2009 5:22 pm

Thanks. Have moved this to Scripts 'n Tips.