asked on

VPN troubles

I am connecting into a clients computer over a VPN. I can connect fine, however i am getting an error in a program because it can not connect properly. The program is Ultimate Collection Control Client. The error i am gettin is "[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied." Any clue as to what this can be and how I can solve it?

Thanks in advance

Marakush

When you setup the user DSN via ODBC use the IP address rather then the host name.

Marakush

securi-tech

ASKER

I'm sorry but you lost me, could you elaborate a little more?
Thanks

Marakush

To create a DSN

WIN XP
http://support.microsoft.com/default.aspx?scid=kb;en-us;305599

WIN2000
http://support.microsoft.com/default.aspx?scid=kb;en-us;300596

The error that you posted, something is trying to connect to an SQL DB when you create the DSN use the IP of the SQL server rather then the Name of the SQL server. Because it sounds like it isn't resolving correctly.

Marakush

James Goethe

Marakush is right... Also check to make sure you can access folders on the network or if you can ping the server via name and not ip (or see if you can by both to make sure the connection is good).. Which VPN server are you using.

securi-tech

ASKER

Windows 2000, for some reason i dont think the vpn is configured right. I can connect but no luck on pinging or finding anything on their side of the network! I know this is not the right forum but any help will be appreciated. I tried the above answer and still not working.

SOLUTION

Marakush

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

James Goethe

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

securi-tech

ASKER

It was client server, the machine was an old nt server. I convinced the person to buy a vpn router. Thank god...its a one more problem of my plate

Thanks for the help

James Goethe

No prob.. I have used some SMC ones.. older but under 100 bux SMC7004FW i think it is
might be able to find them still..