PB9 connection 2008/2012 is no problem, but when in the development environment, select table will appear in a large number of system tables, system tables defined tables together with oneself, very annoying, can't afford to have an option to hide system tables,

Through the BBS, didn't mention it, don't all have this problem?

My connection is as follows, if instead of ODBC, there is no problem,

//Profile MSSQL2012 (local)
The SQLCA. DBMS="MSS Microsoft SQL Server"
The SQLCA. Database="powerBizTest"
The SQLCA. LogPass=& lt; * * * * & gt;
The SQLCA. ServerName="DELL - TOUCH \ MSSQLSERVER2008R"
The SQLCA. LogId="sa"
The SQLCA. The AutoCommit=False
The SQLCA. DBParm=""

CodePudding user response:

//Profile MSSQL2012 (local)
The SQLCA. DBMS="MSS Microsoft SQL Server"
The SQLCA. Database="powerBizTest"
The SQLCA. LogPass=& lt; * * * * & gt;
The SQLCA. ServerName="DELL - TOUCH \ MSSQLSERVER2008R"
The SQLCA. LogId="sa"
The SQLCA. The AutoCommit=False
The SQLCA. DBParm=""

Increase in dbparm

The SQLCA. DBParm="PBCatalogOwner='dbo"

Try to have in dbfile Settings

CodePudding user response:

Reference upstairs Daniel say try...

CodePudding user response:

No, in setting up the parameters?

I'm in the database profile setup find another set:

System> The original concept Catalog Table Owner: dbo

This item, the default is dbo, as dbo (regardless of case), PB is directly to ignore, not only the dbo, can see the changes from the preview, but unable to connect:

The SQLCA. DBParm="SystemProcs=0, the Log=0, PBCatalogOwner='aaa'"

You don't have it?

If PB9 connection MSSQL2008/2012, all with what connection? If is the ODBC, how to solve the problem of manual configuration on each computer?

CodePudding user response:

PB version problem? My PB version is:

PB9.0.3 Build8004

CodePudding user response:

reference 4 floor zjpost response:

PB version problem? My PB version is:

PB9.0.3 Build8004

reference 4 floor zjpost response:

PB version problem? My PB version is:

PB9.0.3 Build8004

Promoted to PB9.0.3 Build8836, I didn't appear system tables,

CodePudding user response:

PB9.0.3 Build8836 direct-connect MSSQL2008, a system table did not appear,

CodePudding user response:

WellSoft:

I have just upgraded to PB9.0.3 Build8836, but still, why didn't you?
You can connect your connection configuration posted?

I was like this:
//Profile MSSQL2012 (local)
The SQLCA. DBMS="MSS Microsoft SQL Server"
The SQLCA. Database="powerbiz"
The SQLCA. LogPass=& lt; * * * * * * * * & gt;
The SQLCA. ServerName="192.168.1.106"
The SQLCA. LogId="powerbiz"
The SQLCA. The AutoCommit=False
The SQLCA. DBParm="SystemProcs=0, the Log=0"

CodePudding user response:

Every time to do a datawindow, choosing a table, can appear the following system table

CodePudding user response:

This question in pb9 connection SQLSERVER2005, with 2008201 2, even without SQL2000 problems

Remember just don't have this problem after PB10