[dba-SQLServer] provider name

That's interesting Martin -- I had tried a few variations of the provider
name, but I hadn't expected the syntax of the statement to change. Thank
you. 

Susan H.  

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Martin Reid
Sent: Monday, March 06, 2006 3:38 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [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




--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 268.1.2/274 - Release Date: 3/3/2006