I usually do sql-server programming but sometimes I also need to test and query ODBC-datasources with SQL such as Access or Progress databases. I usually do this using active server pages which I find rather obscure, and I would prefer to have a nice little program sort of like query analyzer, where I can specify the connection-string and write my SQL in there somewhere. Does anyone know of such a program?To test and query ODBC-datasources in the manner described one may use Microsoft Query MSQRY32.exe, Sql Plus, Sql *, or a variety of similar tools from packages like ER Studio, ERWin, etc.|||I posted this message in a usenet group aswell and someone came up with a neet little _free_ program that was exactly what I was looking for with alot of nice features...
-> http://www.indus-soft.com/winsql/sql
Showing posts with label progress. Show all posts
Showing posts with label progress. Show all posts
Monday, March 26, 2012
Friday, March 9, 2012
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 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.
>
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...
>
>
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 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.
>
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...
>
>
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...
>
>
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...
>
>
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 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.
>
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:
>> 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.
> 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...
> > 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
> >> 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.
> >>
> > 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
>
>
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 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.
>
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:
>> 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.
> 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...
> > 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
> >> 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.
> >>
> > 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
>
>
Saturday, February 25, 2012
odbc problems with Linked server in sql 2005
Hi guys,
I've a Linked server en sql 2000 with oledb provider for odbc drivers (Progress software) to do some queries, and works fine, I m trying to do the same in sql 2005, i set up exactly as i do in sql 2000 but when I try to view the tables: there are nothing the list is missing and obviosly when i try to query, I got errors:
OLE DB provider "MSDASQL" for linked server "test" returned message "[DataDirect-Technologies][ODBC PROGRESS driver]Driver's SQLSetConnectAttr failed.".
OLE DB provider "MSDASQL" for linked server "test" returned message "[DataDirect-Technologies][ODBC PROGRESS driver][PROGRESS]Access denied(Authorisation failed)".
OLE DB provider "MSDASQL" for linked server "test" returned message "[DataDirect-Technologies][ODBC PROGRESS
ex:
works perfectly in sql 2000, not in 2005
SELECT * FROM OPENQUERY (MY_LINKED_SERVER, 'SELECT * FROM AFN_cotizaseguro_rmt')
some body knows if i have to set up additional stuff in sql 2005?
Hi
This seems to be a discussion on ProgressTalk that refers to your problem:
http://www.progresstalk.com/showthread.php?t=103352
If the connection works in the ODBC administrator Test Connection then they seem to suggest checking the security context setting in the security page of the linked servers settings in SQL Management studio.
I hope this is some use to you.
|||Thank u Dhericean, you really help me, now I 'm working with my linked servers in sql 2005, it was just a click in the security, awesome !!!
Regards
Subscribe to:
Posts (Atom)