Showing posts with label reference. Show all posts
Showing posts with label reference. Show all posts

Sunday, March 25, 2012

Connecting to SQL 2005 using VB6

Is there some reference material that shows how to connect to a SQL 2005 DB
using Visual Basic 6? Any help is appreciated.Charlie (jadkins4@.yahoo.com) writes:

Quote:

Originally Posted by

Is there some reference material that shows how to connect to a SQL 2005
DB using Visual Basic 6? Any help is appreciated.


You find the reference for ADO on
http://msdn2.microsoft.com/en-us/library/ms675532.aspx. ADO is a piece
of crap in my opinion, but*it's nevertheless the best option for VB6.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Friday, February 24, 2012

connecting on SQL server database to another SQL server database

I am hoping to find a reference for the procedure on
connecting one SQL server database (SQLServerA) with
another SQL server database (SQLServerB) where SQLServerA
is in a different physical location and on a different
network from SQLServerB. In the past SQLServerA was an
Access database that used 'linked tables' to bring the
tables in from SQLServerB. I am hoping to recreate the
linked tables functionality on the SQL server. I'd
appreciate any websites or manuals,
Thanks,
Rachel"Rachel Gibson" <gibsora@.shands.ufl.edu> wrote in message
news:822201c40776$eba263c0$a601280a@.phx.gbl...
> I am hoping to find a reference for the procedure on
> connecting one SQL server database (SQLServerA) with
> another SQL server database (SQLServerB) where SQLServerA
> is in a different physical location and on a different
> network from SQLServerB. In the past SQLServerA was an
> Access database that used 'linked tables' to bring the
> tables in from SQLServerB. I am hoping to recreate the
> linked tables functionality on the SQL server. I'd
> appreciate any websites or manuals,
You can use Linked Servers to accomplish that, see BOL for more
instructions. Basically you can use EM to create the link or
sp_addlinkedserver.
Steve