I want to connect to SQL Server express in VB .NET 2003 - Standard version. Please guide me which method I have to use.(note - i tried all the methods i am getting error only).

1. OLE DB - SQL Server method
2. ODBC
3. SQL Native Client

Please give me some sample code in the sequence I suppose to follow mentioning Connection,DataAdapter,Dataset etc.

venki Rao

VENKATESH

__________________
VENKATESH

Venki, If you are using SQL SERVER 7.0 or later then use SQLClient and if you are using SQL SERVER earlier than 7.0 then use OLEDBClient....tell me which version you are using...

Gaurav

hi gaurv,
i am using sql express 2005 (recently downloaded from microsoft site) installed in win XP. And my question is, can i use VB .NET 2003 standard edition to connect to my sql express edition (2005). It is showing an error as
'this version supports only desktop database. use higher version'
so, please guide me

regds.
venki

VENKATESH

Sorry Venki, I have no idea about SQL Express 2005. I think someone else has to help us.