Connection to SQL Server on Vista
- From: "vovan" <v@xxxxx>
- Date: Mon, 28 Jan 2008 20:11:22 -0500
I have VB6 application which connects to SQL Server 2000 (installed on the
developer machine) database.
I use this code to connect:
strConnectionString = "DRIVER=SQL
Server;SERVER=(local);UID=;DATABASE=Coordinator;Trusted_Connection=Yes"
objConn.Properties("Extended Properties") = strConnectionString
objConn.Open
Everything works fine on Windows XP
I installed everything I need on my laptop with Vista Business and tried to
run my application.
I'm getting an error saying 'Login failed for user 'NameOfMyLaptop\MyName'
I installed everything I need on the same laptop but I replaced Vista with
XP. Everything works.
So, the only difference I see it's OS.
Any suggestion please
Thank you
vovan
.
- Follow-Ups:
- Re: Connection to SQL Server on Vista
- From: William Vaughn
- Re: Connection to SQL Server on Vista
- From: vovan
- Re: Connection to SQL Server on Vista
- Prev by Date: Re: resorting recordset returned from SQL stroed procedure
- Next by Date: Re: Connection to SQL Server on Vista
- Previous by thread: resorting recordset returned from SQL stroed procedure
- Next by thread: Re: Connection to SQL Server on Vista
- Index(es):
Loading