How to connect DBMaker via Microsoft SQL Linked Server? (DBMR3153)

~ 0 min
2020-08-11 11:15

There are two providers to use MS linked server to connect DBMaker. They are Microsoft OLE DB Provider for ODBC Drivers and OLE DB Provider for DBMaker 5.4.3. Please follow below step to connect DBMaker.

 

1. Provider for Microsoft OLE DB Provider for ODBC Drivers

    a. Open ODBC data source administrator. Add the database to system data source name.

    b. Open Microsoft SQL Server Management Studio, open object explorer, click server object, right-click linked servers, and click new linked server.

    c. Enter linked server name, choose provider Microsoft OLE DB Provider for ODBC Drivers, enter database name to data source.

    d. Start database server from DBMaker.

    e. Click Ctrl + N to open new query, and enter SQL query.

2. Provider for OLE DB Provider for DBMaker 5.4.3

    a. Open Microsoft SQL Server Management Studio, open object explorer, click linked server, click provider, double-click “DMOLE54”, and tick “AllowInProcess”.

    b. Open object explorer, click server object, right-click linked servers, and click new  linked server.

    c. Enter linked server name, choose provider OLE DB Provider for DBMaker 5.4.3, enter database name, data source and connection string to data source.

   d. Start database server from DBMaker.

   e. Click Ctrl + N to open new query, and enter SQL query.

 

Version: DBMaker 5.4.3, SQL Server 2016, SQL Server Management Studio 18

Product: Normal/Bundle

Platform: Windows

Average rating 0 (0 Votes)

You cannot comment on this entry

Tags