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
|
yronium Level: Moderator Registered: 14-04-2002 Posts: 907
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
|
Gary Level: Sage Registered: 27-11-2005 Posts: 50
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
|
yronium Level: Moderator Registered: 14-04-2002 Posts: 907
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
|
Gary Level: Sage Registered: 27-11-2005 Posts: 50
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).