Originally made of PB 8.0 with SQLSERVER2000 system, debugging all normal, now I change the database to SQLSERVER2005, not how also connect to database! SQL server2005 also did Settings, allow the network access, please expert help! The younger brother thanks first!

CodePudding user response:

The eldest brother to help the younger brother!

CodePudding user response:

I'm also looking forward to the answer, wait!!!!!!!!!! .

CodePudding user response:

Personal guess:
SQL 2005 no longer provide direct connection mouth, but the old db interface

In pb8 use old db to connect to SQL 2005 try.

CodePudding user response:

With an odbc connection?
If not, explain your database is not set, or not enough access rights, or when you install sql2005 account access enabled local account options,
You try to access Internet after the success of the neighbor, join again and have a look

CodePudding user response:

Connection is not what is wrong

CodePudding user response:

The SQLCA. DBMS="OLE DB"
The SQLCA. LogPass='12345678'
The SQLCA. LogId='sa'
The SQLCA. The AutoCommit=False
='SQLOLEDB' SQLCA. DBParm="PROVIDER and DATASOURCE='168.200.200.141', PBCatalogOwner='dbo', PROVIDERSTRING='Database=XZGG'"

CodePudding user response:

SQL2005 I'll use the original method can also be connected,
But don't know why is the SQL2000 database guide after the past, can not directly see table,

CodePudding user response:

I also want to know, is looking for this information ~ ~ ~ ~ ~