Accessing Remote database via MS

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Hi; I use Jolt Hosting and they are great - but they lock down the default port and I cannot access the database remotely. 

I was told to use the following syntax: server,port

as in...

Driver=Provider={SQL Server};Server=server,port;Database=dbname;Uid=user_name;Pwd=user_pwd;

But it does not connect via Macro Scheduler. It works with SQL Server Management Express...

Can anyone offer some alternatives to connect via Macro Scheduler for a locked default port?

Thanks

Edited by terencef - 10-January-2009 at 10:30am

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
terencef Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 04-May-2008 Status: Offline Points: 0	Post Options Post Reply Quote terencef Report Post Thanks(0) Quote Reply Topic: Accessing Remote database via MS Posted: 10-January-2009 at 10:30am
	Hi; I use Jolt Hosting and they are great - but they lock down the default port and I cannot access the database remotely. I was told to use the following syntax: server,port as in... Driver=Provider={SQL Server};Server=*server,port*;Database=dbname;Uid=user_name;Pwd=user_pwd; But it does not connect via Macro Scheduler. It works with SQL Server Management Express... Can anyone offer some alternatives to connect via Macro Scheduler for a locked default port? Thanks Edited by terencef - 10-January-2009 at 10:30am

Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply Posted: 10-January-2009 at 10:37am
	I will PM to you the port I have had to use with them when connecting via SQL Server Management Studio, and that may help. However, their support folks should tell you the port they want you to use.

terencef Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 04-May-2008 Status: Offline Points: 0	Post Options Post Reply Quote terencef Report Post Thanks(0) Quote Reply Posted: 10-January-2009 at 10:55am
	Thanks Greg; I tried that port... I'm not sure if it's related to Vista 64 bit OS, I created an ODBC datasource and it successfully connected, however, MS does throws an error: [Microsoft][ODBC Driver Manager] Data Source name not found and no default driver specified.

Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply Posted: 10-January-2009 at 11:02am
	Sorry it didn't help. Hope you get it resolved.

terencef Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 04-May-2008 Status: Offline Points: 0	Post Options Post Reply Quote terencef Report Post Thanks(0) Quote Reply Posted: 10-January-2009 at 11:12am
	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 etc 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!