Re: SQL server connectivity

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Yup and contrary to the ODBC and OLEDB Providers, backward and/or forward
compatibility is not guaranteed between either DMO or SMO and the different
versions of SQL-Server.

To the OP, for the installation process, I have no idea what's required for
the installation of either DMO or SMO.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain aei ca (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)


"Ekrem Önsoy" <ekrem@xxxxxxxxxxxx> wrote in message
news:A165074E-7B4B-422C-A082-46DC9A0163A6@xxxxxxxxxxxxxxxx
FYI: DMO is deprecated, you better check out SMO.

--
Ekrem Önsoy



"thaar" <thaar@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BF4F0E6A-8D88-43B2-98AA-0C7A8A9A6EAB@xxxxxxxxxxxxxxxx
Dear Sylvain,
If i want to use DMO in VB, can i install only sql backward compatibility
without sql express.

best regards and thanks.

thaar

"Sylvain Lafontaine" wrote:

No, the older ODBC drivers for SQL-Server 7, 2000 or 2005 should work
fine.
However, if you have nothing installed at this moment (which would be
surprising if you already have VB or FoxPro), you can install the MDAC
components:

http://www.microsoft.com/Downloads/details.aspx?familyid=6C050FE3-C795-4B7D-B037-185D0506396C&displaylang=en

Alternatively, you can chose to install the latest ODBC and OLEDB
drivers
for SQL-Server 2008 which are called the "Microsoft SQL Server 2008
Native
Client":

http://www.microsoft.com/downloads/details.aspx?FamilyId=C6C3E9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain aei ca (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)


"thaar" <thaar@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EF138531-4634-48E7-93D4-7A54F1F97B11@xxxxxxxxxxxxxxxx
Dear all,

is it require to install sql express 2008 as a client connectivity to
sql
server 2008 when using Visual basic and visual Fox pro?


best regards and thanks

thaar






.

Relevant Pages

  • Re: SQL2000-Database, SQLExpress, Access
    ... Did you install the SQL-Server Express Management Studio (or something like ... you should be able to connect to an instance of SQL-Server ... Sylvain Lafontaine, ing. ... installation of SQLExpress and attachment of the database to SQLExpress ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Connect to Access Data from various regional locations
    ... SQL-Server is expensive but MSDE is free. ... You can install the later at ... home and play with it some time before you commit yourself to spend money. ...
    (microsoft.public.access.externaldata)
  • Re: Connect to Access Data from various regional locations
    ... SQL-Server is expensive but MSDE is free. ... You can install the later at ... home and play with it some time before you commit yourself to spend money. ...
    (microsoft.public.access.dataaccess.pages)
  • Re: Selecting from a Combobox makes Access 2003 crash after SP3
    ... Sylvain Lafontaine, ing. ... SP3 installed and it's no longer my intention to install it anymore. ... The Combobox is situated in a TabControl ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Co existence of SQL 2000 and SQL Express 2005
    ... I did have the beta installed some time few months a go. ... a previous backup on it before going with the installation of SQL-Server ... What's happens if you stop the SQL 2005 service before trying to start SQL ... My access always hangs after having Visual Basic Express 2005 install. ...
    (microsoft.public.access.adp.sqlserver)