[dba-SQLServer] provider name

http://www.aspfaq.com/sql2005/show.asp?id=3
 
 
 
Martin WP Reid
Training and Assessment Unit
Riddle Hall
Belfast
 
tel: 02890 974477
 

________________________________

From: dba-sqlserver-bounces at databaseadvisors.com on behalf of Susan Harkins
Sent: Mon 06/03/2006 20:17
To: SQLList
Subject: [dba-SQLServer] provider name



Does anyone know the provider name for SQL Server Express? I tried SQLOLEDB,
but it didn't work. I also used (local) for the server -- perhaps that's the
problem?

con.Open("Provider=SQLOLEDB;Server=(local);Database=AdventureWorks;Trusted_C
onnection=Yes")

Susan H.

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com