Re: Vista connect to SQL server



Hi Ivan,



I searched through Google Forum and found your article.

I have the same problem now. Do you solve the problem now?

And what's the reason?



Thanks for any help.



Derek


"Ivan" <i...@xxxxxxxxxxxxx> wrote:
We are now testing out program usingVista.

When we directconnectSQL2000 using ADO, andSQLauthentication, the login
fail.

When we use XP or Windows 2000, using ADO as connection, the program run
fine.

Is there anything we need to set?

Ivan


.



Relevant Pages

  • Re: connection strings question
    ... missed this for some reason previously. ... First of all ADO does not work with ODBC drivers directly and in a case ... > when you specify ODBC driver in your connection string, ... If you are trying to open connection once and keep it during life of the ...
    (microsoft.public.vb.database.ado)
  • Re: Error when updating SQL 2000 view via ADODB.Recordset Update
    ... The reason being that the synchronization system I mentioned is designed ... >> ad-hoc tsql, or Enterprise Manager. ... >> every column is recognized by ADO using its unique alias (e.g. ADO does ...
    (microsoft.public.data.ado)
  • Re: VBA Users & Groups
    ... I guess the main reason for the conversion is for the ... >ADO is a generic data access method, ... DAO is preferable in ... and some's in SQL Server) ...
    (microsoft.public.access.security)
  • Re: Compile error when converting from A2003 to A2007
    ... convert to or use ADO (and it is not recommended if you only use JET ... IF you ONLY use DAO, it IS NOT NECESSARY to disambiguate code. ... It can be resolved by being aware of the references. ... I say, unless there is a specific reason, you SHOULD NOT HAVE both DAO and ADO ...
    (microsoft.public.access.conversion)
  • Re: Select Count(*) problem
    ... coming from that source (Chris Hanscom, MVP http://www.veign.com) ... i had no reason to question the viability of the method ... why not set all your numeric variables to zero amd ... And whatcha going to do when using ADO in a language/script/technology ...
    (comp.databases.ms-access)