Link to home
Create AccountLog in
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

Avatar of Abhay Pujari
Abhay Pujari
Flag of India image

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.
Avatar of raubein

ASKER

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
Avatar of Abhay Pujari
Abhay Pujari
Flag of India image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of raubein

ASKER

IP adress works!