odbc to progress db

I have users that thru and ODBC connection to my Sql2000 db attach tables
and query different information. Now they need to read data from a Progress
database on Unix to pull some values from a table. I have the ODBC driver
that allows me to connect to the Progress DB. Could I create a DB in SQL
that is nothing but views to the Progress tables?
I don't want to replicate the data down to Sql.
Any help or suggestions would be much appreciated.Hi Andy
"Andy" wrote:

> I have users that thru and ODBC connection to my Sql2000 db attach tables
> and query different information. Now they need to read data from a Progres
s
> database on Unix to pull some values from a table. I have the ODBC driver
> that allows me to connect to the Progress DB. Could I create a DB in SQL
> that is nothing but views to the Progress tables?
> I don't want to replicate the data down to Sql.
>
> Any help or suggestions would be much appreciated.
>
If you have an odbc driver then you may be able to create a linked server
that will allow you users to query the remote database. See
http://msdn2.microsoft.com/ru-ru/library/aa213778(SQL.80).aspx and
http://msdn2.microsoft.com/ru-ru/library/aa259589(SQL.80).aspx for more.
John|||Do you still create a DB in SQL.
After you create the Link-Server how do the users run queries agisnt the
Progress(Unix) tables?
What does ther syntax look like?
Thanks..
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:1F399B30-FDAD-41CF-B05D-B56B48FFFBEE@.microsoft.com...
> Hi Andy
> "Andy" wrote:
>
> If you have an odbc driver then you may be able to create a linked server
> that will allow you users to query the remote database. See
> http://msdn2.microsoft.com/ru-ru/library/aa213778(SQL.80).aspx and
> http://msdn2.microsoft.com/ru-ru/library/aa259589(SQL.80).aspx for more.
>
> John|||Hi
You don't need to create a separate database unless you want to keep access
away from your existing databases.
You can access the linked server using four part names such as:
SELECT col1, col2
FROM RemoteServer.RemoteDB..RemoteTable
See http://msdn2.microsoft.com/en-us/library/aa172676(SQL.80).aspx and
http://msdn2.microsoft.com/en-us/library/ms187879.aspx
You can also use OPENQUERY see
http://msdn2.microsoft.com/en-us/library/aa276848(SQL.80).aspx
If you use stored procedures or views
http://msdn2.microsoft.com/en-us/library/aa258253(SQL.80).aspx to access the
remote database the users do not need to know where the data is.
John
"Andy" wrote:

> Do you still create a DB in SQL.
> After you create the Link-Server how do the users run queries agisnt the
> Progress(Unix) tables?
> What does ther syntax look like?
> Thanks..
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:1F399B30-FDAD-41CF-B05D-B56B48FFFBEE@.microsoft.com...
>
>