Home All Groups Group Topic Archive Search About

How to connect to sql2008 express from xp

Author
9 Jun 2009 9:21 PM
Mehbs
I am trying to create a ODBC connection on a xp.
I have sql2008 sqlexpress installed on my another server which is on 64 bit
computer.

How do I get access to the sql2008 sqlexpress thru ODBC client?

Thanks

Author
9 Jun 2009 9:28 PM
Ace Fekay [Microsoft Certified Trainer]
"Mehbs" <msam***@comcast.net> wrote in message
news:eYnl2gU6JHA.3592@TK2MSFTNGP02.phx.gbl...
>I am trying to create a ODBC connection on a xp.
> I have sql2008 sqlexpress installed on my another server which is on 64
> bit computer.
>
> How do I get access to the sql2008 sqlexpress thru ODBC client?
>
> Thanks
>


This question is better suited for the SQL newsgroups.

I crossposted it for you to microsoft.public.sqlserver.msde and
microsoft.public.sqlserver.odb.

If anyone from those two groups respond, the responses will also come back
here. Just check back here for responses or you can visit those groups and
start a fresh thread.

--
Ace

This posting is provided "AS-IS" with no warranties or guarantees and
confers no rights.

Ace Fekay, MCSE 2003 & 2000, MCSA 2003 & 2000, MCSA Messaging, MCT
Microsoft Certified Trainer
ace***@mvps.RemoveThisPart.org

For urgent issues, you may want to contact Microsoft PSS directly. Please
check http://support.microsoft.com for regional support phone numbers.

"Efficiency is doing things right; effectiveness is doing the right
things." - Peter F. Drucker
http://twitter.com/acefekay
Are all your drivers up to date? click for free checkup

Author
12 Jun 2009 4:29 PM
Rick Byham, MSFT
Create an ODBC Data Source using the odbcad32.exe program.
And review the connectivity tutorial at
http://msdn.microsoft.com/en-us/library/ms345318(SQL.90).aspx
--
Rick Byham, MSFT
(Implies no warranty or rights)


Show quoteHide quote
"Mehbs" <msam***@comcast.net> wrote in message
news:eYnl2gU6JHA.3592@TK2MSFTNGP02.phx.gbl...
>I am trying to create a ODBC connection on a xp.
> I have sql2008 sqlexpress installed on my another server which is on 64
> bit computer.
>
> How do I get access to the sql2008 sqlexpress thru ODBC client?
>
> Thanks
>

Bookmark and Share