Group:  Microsoft Access ยป microsoft.public.access.odbcclientsvr
Thread: SQLEXPRESS data access from A2k3

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

SQLEXPRESS data access from A2k3
JohnDU 29.11.2005 17:09:08
I cannot find any specific information (articles, blogs, etc.) on connecting
to SQL Express from A2k3. I have been using ADO & VBA to connect to SQL2k
and MSDE2k from both mdb and adp. and of course adp can connect directly
(via ADO I presume) using the create wizard. I tried using the wizard to
connect adp to SQLX but had no luck. any suggestions?
Re: SQLEXPRESS data access from A2k3
Philipp Stiefel <phil[ at ]codekabinett.de> 03.12.2005 00:09:39
<JohnDU[ at ]discussions.microsoft.com> wrote:

[Quoted Text]
> I cannot find any specific information (articles, blogs, etc.) on connecting
> to SQL Express from A2k3. I have been using ADO & VBA to connect to SQL2k
> and MSDE2k from both mdb and adp. and of course adp can connect directly
> (via ADO I presume) using the create wizard. I tried using the wizard to
> connect adp to SQLX but had no luck. any suggestions?

Have you tried to just create a new, empty ADP (existing data)
and to connect that to SQLX? - If that fails, can you please
describe the symptoms (errormessages, etc.) in more detail?


Cheers
Phil

Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net