passthrough query connection string 1

[1DMF]

Hi,

I'm having problems with the syntax for a passthrough query connection string using TCP/IP & Port

ODBC;DRIVER=SQL Server;SERVER=xxx.xxx.xxx.xxx;PORT=1433;UID=MyID;PWD=MyPWD;DATABASE=MyDB

I've tried SERVER = xxx.xxx.xxx.xxx,1433 with and without quotes, I just get 'ODBC connection failed'

I guess i've got the syntax wrong, so your help is appreciated.

Cheers,
1DMF

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

MIME::Lite TLS Email Encryption - Perl v0.02 beta

 

[1DMF]

Got it , it was xxx.xxx.xxx.xxx, port

I think I need a break, the simple things are starting to become a chore!


"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

MIME::Lite TLS Email Encryption - Perl v0.02 beta

 

[genomon]

Might be some help here:

http://www.connectionstrings.com/

Gluais faicilleach le cupan làn

 

[1DMF]

Thanks, bookmarked that page, very usefull!

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

MIME::Lite TLS Email Encryption - Perl v0.02 beta