Server: try the IP address, IP address/instance name
Database: try the instance name, database name, instance name/database name
Various attempts, however, it is an error,

Really don't understand, please everyone a great god, thank you!

CodePudding user response:

If is the machine used, suggest you try the (local)

CodePudding user response:

Not connect the unit, is to connect the network database,

CodePudding user response:

You to the database server, open the SQL server configuration manager, see the server in the network configuration of TCP/IP protocol, namd - namd pepes protocol is disabled?

CodePudding user response:

reference fm20027 reply: 3/f

you on to the database server, open the SQL server configuration manager, see the server in the network configuration of TCP/IP protocol, namd - namd pepes protocol is disabled?

Try this, you also can try the native database client access to the LAN database does not?

CodePudding user response:

You use the name of the machine have a try!

CodePudding user response:

Solved, port ', ', thank you,

CodePudding user response:

My connection configuration file is as follows, there was a note is DBParm Async=10 million don't add!!
(DATABASE)
//connected MS SQL SERVER 2008,
//in the DBParm parameter:
//"Async=1" don't add!!
//PROVIDERSTRING='database=XXX' it must add, otherwise will be directly connected to the master database!!!!!!
The DBMS=SNC SQL Native Client (OLE DB)
The Database=erp_mss
Server=pc1
LogId=sa
Logpass=admini
Userid=sa
Dbpass=admini
The AutoCommit=False
='SQLNCLI10' DBParm="Provider, DisableBind=0, BindSPInput=1, PBCatalogOwner='dbo' Identity='IDENT_CURRENT ()', TrimSpaces=1, OJSyntax='PB', PROVIDERSTRING='DataTypeCompatibility=80; The database=erp_mss ', PBTrimCharColumns='Yes' "
Dbasekind=MSS
Changed=0

CodePudding user response:

Plus the Async=1 what's the problem?

CodePudding user response:

Don't Provider='SQLNCLI10' can also be connected, what reason be?

CodePudding user response:

Pb12.5 can connect SQL2014?