How To Connect To A SQL Server DB

How To Connect To A SQL Server DB

To connect SQL Server DB to cardPresso please click in the Connect to Database button and choose ODBC connection.

 

Click in the ODBC Administrator option and select the Add... button.

 

 

Select the SQL Server you need and click Finish.

 

Fill the Name that will identify the connection in cardPresso and select the correct server to connect and click Next.

Select the option for login and insert login data.

Choose the options according to your needs and click Next.

 

Select the options according to your needs and click Finish.

Test the Data Source and confirm that the connection is working as expected.

 

Click OK until you return to the initial window. Select the desired connection and click OK.

Select the correct ODBC and click Next.

Fill the credentials and click OK.

Select the table you want to work with and click Next.

Proceed with the connection clicking Next until Finish.
The connection is now established, and your table data is available in Bodno.
If the user has proper permissions it is possible to add, edit and delete records through Bodno.