Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2182
  • Last Modified:

Delphi 7 :: MS SQL Connection Error

Hi All,

I have 2 app who connect to the same SQL database.
Both applications is connecting 100% on my local environment.
But when published to our testing server one of the apps gives the following error at startup:

[DBNETLIB][CONNECTIONOPEN (Connect()).]SQL Server does not exist or access denied.

Like I said, one app is connecting  without any problem but the other one NOT.
I am using same connectionstring for both and also same windows login.

Why this?

Thanks!
0
Marius0188
Asked:
Marius0188
  • 2
  • 2
1 Solution
 
ziolkoCommented:
check firewall settings, is this SQLSever or SQLExpress?

ziolko.
0
 
Marius0188Author Commented:
Server.

But I got the problem, or hope at least it looks like it and makes sense.

In the design time the ADOConnection was connected.
When disconnecting the TADOConnection it works fine.
0
 
Marius0188Author Commented:
I will give you the poins for replying first.
:)
0
 
ziolkoCommented:
ok thanks:)
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now