Re: SQL server connectivity

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

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: SQL server connectivity
    ... DMO is deprecated, ... "thaar" wrote in message ... If i want to use DMO in VB, can i install only sql backward compatibility ...
    (microsoft.public.sqlserver.clients)
  • Re: how do I change the user install wizard to create user folder in different location?
    ... Some people read the instructions in such a way that they install both a new ... instance of sql, ... Never slight the SBS wizards. ... I reinstalled from scratch using the Dell OpenManage Server ...
    (microsoft.public.windows.server.sbs)
  • Re: Unable to install 64bit SQL 2005 on Windows 2008 Cluster
    ... cluster installation of SQL. ... All of the database files are on the SAN share. ... Below are the logs from the install. ... SELECT `Action`,`Type`,`Source`,`Target`, NULL, `ExtendedType` FROM ...
    (microsoft.public.sqlserver.clustering)
  • Re: SBS 2003 and Sql Server ~ Client Install
    ... I've found the client tools and have now ... A word mail merge document could access a SQL database via ... We want to install to gain an understanding. ... Once we've managed to install the SQL Server Client we can start to ...
    (microsoft.public.backoffice.smallbiz2000)
  • RE: How do I get back to base SQL server on my SBS 2003 server?
    ... What's the error message you see when installing SQL? ... the easier way is to restore the server from recent backup. ... Screen shot of the error when you install SQL 2005 Workgroup edition. ... <The server-based applications that were running fine are: McAFee EPO, ...
    (microsoft.public.windows.server.sbs)