Navigation:  FAQ > GeoOffice ePaper designer >

OleDb Connection on SQL Database

Previous pageReturn to chapter overviewNext page

Why is the Connection String not correctly displayed with a OleDB Connection on a SQL database with a SQL Server Native Client 10.0?

The Connection to the SQL server and to the database was correctly created. The connections string looks like this:

_img20

When the connection with this connection string is checked with Test, the note appears:

_img21

Several redundant parameters are in the connection string. These can be deleted. These are all the parameters that contain empty fields "". Besides the parameter Password is missing for password in the connection string. Add this retroactively. For the connection to work smoothly, the connection string must look like this.

_img11

You can find more information about creating Connection Strings at http://www.connectionstrings.com/.