I am trying to run a SQL query from Query Analyzer or from my desktop to data on our AS400. The query checks out ok, but when I execute the query, it just sits there and never returns any data. Can anyone help?Need some more information, want to know if you are using "Linked Server" or just trying to execute the query using a DSN wiht OSQL.
also would like to know which drivers you have used to make the connection with the database on AS400 server.
Thanks.
Showing posts with label desktop. Show all posts
Showing posts with label desktop. Show all posts
Sunday, March 11, 2012
Sunday, February 12, 2012
Are there any JDBC Drivers for MSDE
Are there any JDBC Drivers for MSDE ver of SQL Server 2000 Desktop Engine
Release A?
We prefer a MS version of the JDBC but I dont see it....
Thanks
-Tom
Download:
http://www.microsoft.com/downloads/d...displaylang=en
Service Packs:
http://support.microsoft.com/default...b;en-us;883370
How to use:
http://support.microsoft.com/default...b;en-us;313100
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Tom Celica" <Tom@.DontReply.net> wrote in message
news:_bc1f.795$ht7.731@.newssvr21.news.prodigy.com. ..
> Are there any JDBC Drivers for MSDE ver of SQL Server 2000 Desktop Engine
> Release A?
> We prefer a MS version of the JDBC but I dont see it....
> Thanks
> -Tom
>
|||Mike, thanks for looking this up. But the versions of JDBC referenced below
don't work with MSDE version of SQL 2000.
-tom
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:etxB$VpyFHA.3408@.TK2MSFTNGP09.phx.gbl...
> Download:
> http://www.microsoft.com/downloads/d...displaylang=en
> Service Packs:
> http://support.microsoft.com/default...b;en-us;883370
> How to use:
> http://support.microsoft.com/default...b;en-us;313100
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Tom Celica" <Tom@.DontReply.net> wrote in message
> news:_bc1f.795$ht7.731@.newssvr21.news.prodigy.com. ..
>
Release A?
We prefer a MS version of the JDBC but I dont see it....
Thanks
-Tom
Download:
http://www.microsoft.com/downloads/d...displaylang=en
Service Packs:
http://support.microsoft.com/default...b;en-us;883370
How to use:
http://support.microsoft.com/default...b;en-us;313100
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Tom Celica" <Tom@.DontReply.net> wrote in message
news:_bc1f.795$ht7.731@.newssvr21.news.prodigy.com. ..
> Are there any JDBC Drivers for MSDE ver of SQL Server 2000 Desktop Engine
> Release A?
> We prefer a MS version of the JDBC but I dont see it....
> Thanks
> -Tom
>
|||Mike, thanks for looking this up. But the versions of JDBC referenced below
don't work with MSDE version of SQL 2000.
-tom
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:etxB$VpyFHA.3408@.TK2MSFTNGP09.phx.gbl...
> Download:
> http://www.microsoft.com/downloads/d...displaylang=en
> Service Packs:
> http://support.microsoft.com/default...b;en-us;883370
> How to use:
> http://support.microsoft.com/default...b;en-us;313100
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Tom Celica" <Tom@.DontReply.net> wrote in message
> news:_bc1f.795$ht7.731@.newssvr21.news.prodigy.com. ..
>
Subscribe to:
Posts (Atom)