I have installed Sql Server 2005 express and Visual Basic. Net 2003 standard edition.
How do I connect to Sql Server 2005 express from Visual Basic. Net 2003 standard edition
I tried to use sqlnative client to connect, but it gave an error message saying this is not supported in this version of Visual studio.
Looking for an answer ...
thanks.
VB.NET 2003 STD WITH SQL SERVER EXPRESS
justin_______
HTH; Jens Suessmeyer.
Fivekeepers
Hwo did you use the native client, it should be possible to use it in the connection string. Otherwise use the .NET 1.1 provider (without using th enew cool features of SQL Server 2005). The connection string can be seen on www.connectionstrings.com under SQL native Client.
HTH, Jens Suessmeyer.
blacklight
Tried all stunts, but it keeps giving the same error msg.
MS has been smart enough to hide this information cleverly till a person buys the version.
We had bought the VB.Net 2003 standard version just to evaluate. If we were ok with it, we would have bought the professional version on OLV.
chemosevilla
Thanks. In the meantime, i found something which says that VB.NET 2003 Standard edition only supports Desktop engine and MS Access.
I don't know if SQL Server 2005 express will be able to work with the VB.Net 2003 standard edition.
--quote
"This edition of Visual Studio .NET edition can only connect to a database on the SQL Server Desktop Engine or a Microsoft Access database (.mdb). If you want to connect to a database on other Microsoft SQL Servers or an Oracle database, you must purchase either a Professional or Enterprise edition of Visual Studio .NET."
-unquote