Using ProductCart - Accessing Remote database via MS

Print Page | Close Window

Accessing Remote database via MS

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Using ProductCart
Forum Description: Running your store with ProductCart
URL: https://forum.productcart.com/forum_posts.asp?TID=2331
Printed Date: 26-June-2024 at 7:08am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Accessing Remote database via MS

Posted By: terencef
Subject: Accessing Remote database via MS
Date 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

Replies:

Posted By: Greg Dinger
Date 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.

-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |

Posted By: terencef
Date 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.

Posted By: Greg Dinger
Date Posted: 10-January-2009 at 11:02am

Sorry it didn't help. Hope you get it resolved.

-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |

Posted By: terencef
Date 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!