Avatar of raubein
raubeinFlag for Germany asked on

Connect to sql server from vista box via ADO

My Delphi application uses ADO to connect to Sql Server Express 2005 on a Windows Server 2003 in a local network. Since i migrated from delphi 7 to delphi 2009 i get an exception when i try to connect from some vista boxes. Connecting on the same boxes with same application but compiled under Delphi 7 succeeds!
I get this error:

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

After disabling uac on the vista machine everything is fine but that is no solution, it should also run under uac as it does with delphi 7.
Used Connectionstring:
Provider=SQLOLEDB.1;Password=xxxxxx;Persist Security Info=True;User ID=sa;Initial Catalog=Easy;Data Source=SERVER2003\SQLEXPRESS

Open in new window

DelphiWindows Vista

Avatar of undefined
Last Comment
raubein

8/22/2022 - Mon
Abhay Pujari

I don't know much about delphi, but Delphi 2009 version could have problem using Vista UAC. You can test this. Create a test application with Vista UAC on i Delphi 2009 and see the result. Post your comments here after that.
ASKER
raubein

Hello abhvp,
i have some applications compiled with delphi 2009 running under vista UAC. So far no problem.
It is just the problem with sql server in this environment. Accessing a local MSAccess-Database with the same Exe file is possible and works.
ASKER CERTIFIED SOLUTION
Abhay Pujari

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
raubein

IP adress works!
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck