CODEWITHSUNDEEP
sql-serverwindows-xpsql-server-2012compatibility
HugoRune
HugoRune

Reputation: 13819

Accessing SQL Server 2012 from Windows XP

Is there a compatibility problem that would prevent a program running under Windows XP from accessing a SQL Server 2012 Standard instance running on a Windows 2008 server on the same domain?

This might be a stupid question; I know that it is not possible to install SQL Server 2012 on XP, but I cannot think of a reason why it would not allow access by a program.

So this is merely a stab in the dark. For the moment I only wish to know whether there are any problems in principle; if there are none I will try to come up with a minimal error case for my particular setup and ask a separate question.

Upvotes: 1

Views: 12265

Answers (1)

George Mastros
George Mastros

Reputation: 24498

I just confirmed that an application written in VB6 using ADO with the "Microsoft OLEDB provider for SQL Server" can connect to a SQL Server 2012 database. The connection string looks like this:

Provider=SQLOLEDB.1;
Password=PasswordHere;
Persist Security Info=False;
User ID=SomeUserName;
Initial Catalog=SomeDatabase;
Data Source=SQL2012Instance

The operating system is Microsoft Windows XP Service Pack 3.

The operating system hosting the SQL database is Win-7.

The database engine is Microsoft SQL Server 2012 - 11.0.2100.60 (x64)

Upvotes: 4

Related Questions