Solved

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

Posted on 2014-11-05
6
272 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 40

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 50

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
Transaction Monitoring Vs. Real User Monitoring

Synthetic Transaction Monitoring Vs. Real User Monitoring: When To Use Each Approach? In this article, we will discuss two major monitoring approaches: Synthetic Transaction and Real User Monitoring.

 

Author Comment

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

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

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

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

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

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

695 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