Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > VB.NET
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
VB.NET General VB.NET discussions for issues that don't fall into other VB.NET forums.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB.NET section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old February 3rd, 2006, 05:51 AM
Authorized User
 
Join Date: Nov 2005
Location: INDIA, Chennai, TAMIL NADU, India.
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Default Connecting to SQL Server Express

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
Reply With Quote
  #2 (permalink)  
Old February 3rd, 2006, 01:11 PM
Friend of Wrox
 
Join Date: Feb 2006
Location: noida, UP, India.
Posts: 133
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to gaurav_jain2403
Default

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
Reply With Quote
  #3 (permalink)  
Old February 3rd, 2006, 11:28 PM
Authorized User
 
Join Date: Nov 2005
Location: INDIA, Chennai, TAMIL NADU, India.
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
  #4 (permalink)  
Old February 4th, 2006, 12:00 AM
Friend of Wrox
 
Join Date: Feb 2006
Location: noida, UP, India.
Posts: 133
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to gaurav_jain2403
Default

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


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Connecting SQL server express edition gauravawas C# 1 February 19th, 2008 05:03 PM
Connecting to SQL Server 2005 Express Locally GM_Access BOOK: Beginning Access 2003 VBA 1 August 7th, 2007 06:34 PM
Connecting to SQL server 2000 with VB 2005 Express ericgelders Visual Basic 2005 Basics 0 February 20th, 2007 06:15 PM
connecting to SQL express cherry C# 2005 2 September 2nd, 2006 12:34 PM
Win Appl./ Connecting SQL Server Express Editition venkikrao VB.NET 0 January 4th, 2006 12:57 AM



All times are GMT -4. The time now is 02:15 AM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.