connecting SQL 2005 in Vista?

[baran121]

can i connect to SQL SERVER 2005 from vb6.0 in vista home ?. i can connect it in xp pro but cant connect it in vista home? is it about home edition?

i used this link to use adodb in vista home adition:

http://www.microsoft.com/downloads/...e3-c795-4b7d-b037-185d0506396c&displaylang=en

my connection is :
With cnn
.CursorLocation = adUseClient
.ConnectionString = "Provider=SQLNCLI;Server=IPADRESS;Database=zynp_ciftlik;Uid=myid;
Pwd=mypass;"
.Open
End With

thank you.

may i do something in Vista home to connect SQL Server 2005 on network ?

 

[mrdenny]

You may need to tell the Windows Vista firewall to allow the connection.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com