using vista home and business

[baran121]

i have two problem.

1.
can i connect to sql server 2005 express from vista home.
i use this connection :
.ConnectionString = "provider=SQLOLEDB;server=" & server_adi & ";uid=" & Text2.Text & ";pwd=" & Text1.Text & ";database=" & database_adi

i cant connect to server.
with business i can connect but i have another problem

2.
in vista businees i have another problem.
it's religion setting is different for date and time
it has :
m/dd/yyyy
hh:mm:dd AM/PM
format
but i want that:
dd.mm.yyyy
hh:mm:dd
how can i do that please help me.

 

[markros]

For your second question (and I guess you meant "region" settings, not religion )) check this blog

http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/setting-a-standard-dateformat-for-sql-se

 

[baran121]

yes .
i solved my problem.
i changed language to turkish for region setting not religion
thank you very much.

but i still have my first problem.

 

[markros]

I think your connection string in the first case is incorrect.

Check this thread for some help

http://forums.asp.net/t/1462135.aspx