8-) How can i connect to SQL Server DB on VB App via ADO or OLEDB

[coolphilboy]

Im a newbie in SQL Server, could someone help me on how to open a connection to SQL Server Database using VB App via OLEDB or ADO? TIA...

 

[tlbroadbent]

Check out the Microsoft Visual Basic® Data Access Guide at

http://msdn.microsoft.com/library/en-us/vbcon98/html/vbconDataAccessGuide.asp

That page contains several links including a link to Data Access Tools in Visual Basic at

http://msdn.microsoft.com/library/en-us/vbcon98/html/vbcondataaccesstoolsinvisualbasic.asp

Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.