link to proteus (unix) server

Question

link to proteus (unix) server

spin

Hall of Fame

Points: 3274
More actions
March 31, 2011 at 7:59 am

#237742

hi all,
I am trying to link my sql 2005 express to an application/db called proteus which is running on unix.
I have created the system dsn odbc connection which i had to download an odbc driver for so I can see the db from cystal reports which is used in my company. I would really like to get the data into sql though so I can.....well basically do more with the data.
So, I have gone to the server objects --> linked servers window, however when i click Other Data Source my odbc driver (called: Progress OpenEdge 10.1B driver) does not appear in the Providers drop down list.
I have instead selected MS OLE DB Provider for ODBC Drivers but am lost as to what to fill out in the next section and can't find much on the web.
These are the fields required....
Product Name: ?
Data Source: ?
Provider String: ?
Location: ?
Catalog: ?
My system dsn odbc setting are....
Data Source Name: WMSLive
Description: WMSLive
Host Name: 10.XXX.X.XX
Port Number: XXXXX
Database Name: proteus
User id: myID
can anyone help?
Thanks.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323546 More actions · Answer 1

this link shows another forums building a linked server to that type of db; it's got a description for both SQL Server gui settings and then a scripted linked server; the original page from the Progress Knowledge center throws a http 500 error for me:

http://www.experts-exchange.com/Database/4GL/Q_24867300.html

that should have the stuff you need to build your linked server.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

spin Hall of Fame Points: 3274 More actions · Answer 2

thanks Lowell

the link is really useful and has helped me understand how the linked server works but i'm now getting an error message saying :Data source name not found and no default driver specified

I did read on the post "Also, make sure that the ODBC driver for your Progress database is installed on your SQL Server instance b4 attempting to make the DSN."

how do i go about this?? is this likely to be the issue??

Thanks

Lowell SSC Guru Points: 323546 More actions · Answer 3

spin, yes, it's sounding like you need the specific drives;

as you were setting up , you saw there is a selection of some possible drivers, but when you connect to things like SQLite, Progress,Oracle,MYSQL,AS400, or many other database systems, you need to install the driver for that system on the server in order for the server to connect and make linked servers.

nowadays you also have to be careful about the driver version (32 bit SQL Express requires 32 bit drivers to be compatible, 64 bit SQL requires 64 bit drivers.

download and install those drivers and let us know how it goes from there.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

spin Hall of Fame Points: 3274 More actions · Answer 4

Brilliant. It works perfectly. Thanks for your help.