Re: Connection to SQL Server on Vista
- From: "Daniel Graham" <daniel@xxxxxxxxxxxxxxxxxxx>
- Date: Sat, 8 Mar 2008 14:52:42 -0000
Hi
The installation of MSDE is setup to only accept NT Integrated Security
logins. Login with an NT account that has permissions to access the MSDE
instance.
e.g use
Dim strConnectionString as String
Dim objConn as ADODB.Connection
objConn = new ADODB.Connection
strConnectionString = "Driver={SQL Server};Server=(local);Database=Coordinator;Uid=myUsername;Pwd=myPassword;"
objConn.Open(objConn)
Regards
Daniel
"vovan" <v@xxxxx> wrote in message news:e%23jRhPhYIHA.4476@xxxxxxxxxxxxxxxxxxxxxxx
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
.
- Prev by Date: Re: Execute a stored procedure from Visual Basic
- Next by Date: Trouble reading fields containing special characters
- Previous by thread: Execute a stored procedure from Visual Basic
- Next by thread: Trouble reading fields containing special characters
- Index(es):
Relevant Pages
|
