borderAndreaVB free resources for Visual Basic developersborder

borderAndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2007 Andrea Tincaniborder

AndreaVB | Forum | News | Downloads | Register | Help | Member List | Statistics | Search | PM | Profile

Print This Topic
Previous Topic (VB .Net Query Database)Next Topic (Transistion from DAO to ADO) New Topic New Poll Post Reply
AndreaVB Forum : Database : Connecting VB with SQL Server 2000 (Urgent!) Solved Topic
Poster Message
Gary
Level: Sage

Registered: 27-11-2005
Posts: 50

icon Connecting VB with SQL Server 2000 (Urgent!)

Hi there,

May I know how can I connect VB with SQL Server 2000, is there any sample code or steps to do so because I used to connect with MS Access only...

Urgent, thank guys...


Gary

08-09-2006 at 07:45 AM
View Profile Send Email to User Show All Posts | Quote Reply
yronium
Level: Moderator


Registered: 14-04-2002
Posts: 907
icon Re: Connecting VB with SQL Server 2000 (Urgent!)

Hello, Urgent.
You might want having a look here.
HIH

____________________________
Real Programmer can count up to 1024 on his fingers

08-09-2006 at 09:26 AM
View Profile Send Email to User Show All Posts | Quote Reply
Gary
Level: Sage

Registered: 27-11-2005
Posts: 50
icon Re: Connecting VB with SQL Server 2000 (Urgent!)

Thanks man,

But can I know is there any help that provides how's the steps to link it or sample code because I have no idea how can be connected...

Thank you...


Gary

08-09-2006 at 09:33 AM
View Profile Send Email to User Show All Posts | Quote Reply
yronium
Level: Moderator


Registered: 14-04-2002
Posts: 907
icon Re: Connecting VB with SQL Server 2000 (Urgent!)

Well, search in the forum for "Access database connecting" and similar, and you'll find plenty of posts with sample code. All you have to do is change the connection string to use, and that's it.
Hope it helps.

____________________________
Real Programmer can count up to 1024 on his fingers

08-09-2006 at 10:07 AM
View Profile Send Email to User Show All Posts | Quote Reply
Gary
Level: Sage

Registered: 27-11-2005
Posts: 50
icon Re: Connecting VB with SQL Server 2000 (Urgent!)

Thanks friend,

I've solved it by using d same way I connected to MS Access. (Using Wizard).

Anyway, thank you...


Gary

15-09-2006 at 03:46 AM
View Profile Send Email to User Show All Posts | Quote Reply
AndreaVB Forum : Database : Connecting VB with SQL Server 2000 (Urgent!) Solved Topic
Previous Topic (VB .Net Query Database)Next Topic (Transistion from DAO to ADO) New Topic New Poll Post Reply
Surf To:


Not Logged In? Username: Password: Lost your password?
Partners: Download Actual Software | Free Software Download
borderAndreaVB free resources for Visual Basic developersborder

borderAndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2007 Andrea Tincaniborder