General discussion

Locked

Connecting to SQLBase via MS SQL Server

By ddarmetko ·
I am trying to 'link' to our ADP Payroll database(SQLBase) via SQL Server Enterprise Manager(version 2000). That will give us the ability to write SQL (and maybe stored procs) within Enterprise Manager. I'm not sure if I can (or how)use an ODBC connection like we currently do with the Crystal Reports tool. If you do know the answer, could you detail-out the steps since I'm not too familiar with connecting to other databases within SQL Server Enterprise Manager. Thanks a lot!

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Connecting to SQLBase via MS SQL Server

by Joseph Moore In reply to Connecting to SQLBase via ...

Open Enterprise Manager.
Expand the Microsoft SQL Servers container (or whatever container you have your SQL server in).
Expand the SQL Server itself.
Expand Security
Right-click on Linked Server and choose New Linked Server.
Run the wizard to add your your other database.

hope this helps

Collapse -

Connecting to SQLBase via MS SQL Server

by ddarmetko In reply to Connecting to SQLBase via ...

I do not know what to enter on the Linked Server Properties
(and what would be an example for each one below on a non-MS database, like SQLBase):
- Provider Name?
- Product Name?
- Data Source?
- Provider String?
Thanks a lot!!

Back to Networks Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums