PB-SQL Server 7

[santosh2natal]

When I connect MS SQL Server 7.0 directly from client application through ODBC I get the error message "Program type out of range". And also I could not connect SQL Server through default "MSS MS SQL Server 6.x" drivers, it gives error message "Login Incorrect" while creating profile in Database painter. Please help.
Thanx.

 

[vulcanjena]

find the preview(example) of the DB profile ...


// Profile MARRIOT
SQLCA.DBMS = "MSS Microsoft SQL Server"
SQLCA.Database = "TESTDATABASE"
SQLCA.LogPass = <****>
SQLCA.ServerName = &quot;TESTING&quot;
SQLCA.LogId = &quot;testuser&quot;
SQLCA.AutoCommit = False
SQLCA.DBParm = &quot;PBCatalogOwner='jena'&quot;