?
Solved

SQL Connection Errors

Posted on 2006-11-27
3
Medium Priority
?
159 Views
Last Modified: 2013-11-23
i have a vb6 program that connects to a sql 2000 database.

this program runs with no problems on my network.

however i have just setup a vpn.  when i run this program at my remote site, the first few times i recieved this error

-2147467259 (80004005)
data provider or order service returned an E_Fail status

but now i get the following error upon loading and cannot go any further


connection failed
sqlstate 'HY000'
error 0

a dialog box appears first asking for my login credentials for SQL 2000 which can either be trusted or just a straight user and password.

i have tried both but get the same error

what does this mean
0
Comment
Question by:Marcusw
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 12

Expert Comment

by:jkaios
ID: 18023079
This obviously relates to your VPN security.  Check to make sure that remote VPN connections are allowed to authenticate with the target SQL Server.
0
 

Author Comment

by:Marcusw
ID: 18023214
where would i check that setting
0
 
LVL 12

Accepted Solution

by:
jkaios earned 2000 total points
ID: 18025779
If you're not the one who set up the VPN, then I believe you should contact the Network Administrator (the person who set it up) about it.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Suggested Courses
Course of the Month12 days, 12 hours left to enroll

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question