[dba-SQLServer] provider name

Susan Harkins harkinsss at bellsouth.net
Mon Mar 6 14:17:54 CST 2006


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. 




More information about the dba-SQLServer mailing list