Wrox Home  
Search P2P Archive for: Go

  Return to Index  

activex_data_objects thread: Re: ADO error in MS Access SQL Server Project


Message #1 by "Marco Nebbia" <nebbia_666@h...> on Tue, 15 Oct 2002 10:43:15
Hi.
Please can you say me where i can download this hotfix or if you can send 
me??

Thank a lot!.



> We had a similar problem.  I believe that the problem is with vs.net.  We
were able to download a hotfix from MS that solved the problem.

Rosalind Philips
Tech Services
rosalind115@a...

----- Original Message -----
From: "Jan Borup Coyle" <jb@x...>
To: "ActiveX_Data_Objects" <activex_data_objects@p...>
Sent: Friday, June 14, 2002 11:05 AM
Subject: [activex_data_objects] Re: ADO error in MS Access SQL Server
Project


> Hi Guy
>
> I got the Exact same problem with my database - and i've tryed to
> reinstall my office XP developer, but same problem.
>
> Maybe Microsoft only try new developments systems on there on databases.
>
> Best regards
> Jan Borup Coyle
> Denmark
>
> > Hi,
> >
> >
> > I use Access XP to develop a Client/Server app with a SQL server
> backend
> > (in the access data project format).  Since installing vs.net and
> office
> > xp service pack 1 i get the following error when opening any table in
> my
> > database from the access project:
> >
> > "ADO error: Cannot resolve collation conflict for column 2 in SELECT
> > statement"
> >
> > The default Northwind and Pubs databases work fine if connected to my
> > project. whats up with mine??????
> >
> > any help would be greatly appreciated.
> >
> > Thanks in advance
> >
> > Guy
>

Message #2 by "Marco Nebbia" <nebbia_666@h...> on Tue, 15 Oct 2002 11:15:27
SEE 
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q318989

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Bye

> Hi Guy

> I got the Exact same problem with my database - and i've tryed to 
r> einstall my office XP developer, but same problem.

> Maybe Microsoft only try new developments systems on there on databases.

> Best regards
J> an Borup Coyle
D> enmark

> > Hi,
>>  
>>  
>>  I use Access XP to develop a Client/Server app with a SQL server 
b> ackend 
>>  (in the access data project format).  Since installing vs.net and 
o> ffice 
>>  xp service pack 1 i get the following error when opening any table in 
m> y 
>>  database from the access project:
>>  
>>  "ADO error: Cannot resolve collation conflict for column 2 in SELECT 
>>  statement"
>>  
>>  The default Northwind and Pubs databases work fine if connected to my 
>>  project. whats up with mine??????
>>  
>>  any help would be greatly appreciated.
>>  
>>  Thanks in advance
>>  
>>  Guy

  Return to Index