Solved

how do i set up a sql 2012 odbc connection on xp

Posted on 2014-11-05
6
247 Views
Last Modified: 2014-11-10
i have an xp professional workstation that i need to set up an ODBC connection to a microsoft sql 2012 database

i think i need a driver.
0
Comment
Question by:CASorter
  • 3
  • 2
6 Comments
 
LVL 39

Expert Comment

by:lcohan
ID: 40424586
Please follow the steps from link below:

http://support.microsoft.com/kb/305599
0
 

Author Comment

by:CASorter
ID: 40424686
yah   i know how to set up an ODBC...

when i try  i get server does not exist.... because ... i am quessing the driver i have available cannot talk to the sql 2012 server.

the driver options i have are

sql Native Client   version  2005.90.5000.00
and
sql server version 2000.85.1132..00

as well as a bunch of  other microsoft drivers (for foxpro, text, paradox oracle)

on my windows 7 box.. i have the options for
sql server ver 6.01.7601
sqlserver native client 10.0   ver 2009.100.2500.00
sqlserver native client 11.0 ver 2011.110.3000.00

i usually use the native client 11.0 to connect to sql 2012 from this box.

like i said... i think i need a driver for 2012 ON xp

does such a thing exist?
0
 
LVL 46

Expert Comment

by:Vitor Montalvão
ID: 40428589
sqlserver native client 10.0   ver 2009.100.2500.00 --> For SQL Server 2008 and 2008R2
sqlserver native client 11.0 ver 2011.110.3000.00 --> For SQL Server 2012
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

Author Comment

by:CASorter
ID: 40428760
yes, yes...   i know..

does such a thing exist FOR XP???
0
 
LVL 46

Accepted Solution

by:
Vitor Montalvão earned 500 total points
ID: 40428767
By the MSDN, the answer is no.
0
 

Author Comment

by:CASorter
ID: 40432791
thank you
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now