Solved

SQL Connection Errors

Posted on 2006-11-27
3
157 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 500 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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Firemonkey DbLookupComboBox equivalent ? 2 68
Help me. 3 70
update joined tables 2 63
all the possible sequences for numbers 1,2,3,4,5,6,7,8,9,10 in groups of 5. 5 45
When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

726 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