Skip to Content
0
Former Member
Jun 28, 2013 at 01:51 AM

SQL Server 2012 LocalDB failing to connect

409 Views

PB 11.5 4011 Windows 7 64 bit

I am attempting to connect to a SQL Server 2012 LocalDB through powerbuilder. I have done the following steps:

1) Install SQL Server LocalDB

2) Create a named instance Using the following CMD command (C:\> SqlLocalDb create "DirectLink")

3) Connect to my named instance through SSMS with a server name = (LocalDB)\DirectLink

3) Create a test database to confirm everything works

Now For the Powerbuilder portion. I have been trying to connect via the native client, this is what I have so far.

// Profile Test

SQLCA.DBMS = "SNC SQL Native Client(OLE DB)"

SQLCA.LogPass = <****>

SQLCA.ServerName = "(LocalDB)\DirectLink"

SQLCA.LogId = "sa"

SQLCA.AutoCommit = False

SQLCA.DBParm = "Provider='SQLNCLI10',Database='Direct'"

When i do test connection I get the following error:

SQLSTATE = 08001

Microsoft SQL Server Native Client 10.0

SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].

Any thoughts/Ideas? Maybe I shouldn't be using Native Client?