Access to Sqlexpress connection problem in lan enviroment

[Guest]

I have SQLexpress running on an xp box.
I have a access adp application built.
My laptop that runs xp and has access xp on it will connect to the
sqlexpress database using the connection properties.
tcp:192.168.130.103,1500. No issue
Issue:
I have a windows 2000 machine with office xp installed. I take the same adp
access program from above and it will not connect. What is different between
OS xp, w2k and access xp. I get a connection error. Any help would be
greatly appreciated. Thanks

 

[Pieter Wijnen]

You probably don't have the correct SQL Server Client installed on the 2000
machine
Download from ms

HtH

Pieter

 

[Guest]

So, I need to install sql native client on each w2k machine? Then the
Microsoft access adp program will connect? Thanks

 

[Pieter Wijnen]

correct.
You could downsize to the SQL Server 2000 driver though, it works for most
things, but is slower

Pieter

 

[Guest]

Well that did not work. I still get the same problem. Do you have a
specific link to the sql client that needs to be on a w2k computer?

 

[Pieter Wijnen]

yupp

http://www.microsoft.com/downloads/...FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc

Hth

 

[Abhishek Kumar]

i have got a laptop but its dvd rom is not working. and i have to install
windows xp in my laptop. how i will install windows xp in my laptop through
the help of boot from lan connection. plese give the reply briefly and step
wise step.
Can u please reply me on my email id "(e-mail address removed)

 

[John W. Vinson]

On Sat, 15 Nov 2008 14:20:01 -0800, Abhishek Kumar <Abhishek

i have got a laptop but its dvd rom is not working. and i have to install
windows xp in my laptop. how i will install windows xp in my laptop through
the help of boot from lan connection. plese give the reply briefly and step
wise step.
Can u please reply me on my email id "(e-mail address removed)

Please post your question on a Windows XP newsgroup. This group is for
questions about the database software Microsoft Access, not for general
computer questions.

Note also that private email support is *not* something you should expect. The
volunteers here answer questions for everyone's benefit; we're not paid to
give private tech support.