Offtopic: "query analyzer" for odbc datasources

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

odbc sql server driver timeout expired

Hi,

Has anyone ever had trouble using the query analyzer tool through a vpn
client? I'm able to connect outside of work to a sqlserver db on my
company lan with enterprise mgr, but the query analyzer times out every
time I try to connect from outside of work. Both utilities work fine at
work (no vpn tunnel).

The exact error is:

Unable to connect to server blahblahblah:
ODBC: Msg 0, Level 16, State 1
[Microsoft][ODBC SQL Server Driver] Timeout expired

I've tried increasing the sqlserver odbc driver's CPTimeout without success.

Appreciate any advice.
Eric"efinney" <efinney@.mitre.org> wrote in message
news:cjvgck$a1f$1@.newslocal.mitre.org...
> Hi,
> Has anyone ever had trouble using the query analyzer tool through a vpn
> client? I'm able to connect outside of work to a sqlserver db on my
> company lan with enterprise mgr, but the query analyzer times out every
> time I try to connect from outside of work. Both utilities work fine at
> work (no vpn tunnel).
> The exact error is:
> Unable to connect to server blahblahblah:
> ODBC: Msg 0, Level 16, State 1
> [Microsoft][ODBC SQL Server Driver] Timeout expired
> I've tried increasing the sqlserver odbc driver's CPTimeout without
> success.
> Appreciate any advice.
> Eric

Assuming there are no name resolution issues, then you need to make sure the
correct ports are open over the VPN:

http://support.microsoft.com/defaul...2&Product=sql2k

Simon|||Hi Eric

Can you do

Telnet <SQL Server's name or IP address> 1433

If it connects to port 1433 through VPN then it means your connection
is good then you can start diagnosing why you are getting timeouts,
perhaps slow connection or flakey VPN connection.

Regards

Shehzad

efinney <efinney@.mitre.org> wrote in message news:<cjvgck$a1f$1@.newslocal.mitre.org>...
> Hi,
> Has anyone ever had trouble using the query analyzer tool through a vpn
> client? I'm able to connect outside of work to a sqlserver db on my
> company lan with enterprise mgr, but the query analyzer times out every
> time I try to connect from outside of work. Both utilities work fine at
> work (no vpn tunnel).
> The exact error is:
> Unable to connect to server blahblahblah:
> ODBC: Msg 0, Level 16, State 1
> [Microsoft][ODBC SQL Server Driver] Timeout expired
> I've tried increasing the sqlserver odbc driver's CPTimeout without success.
> Appreciate any advice.
> Eric

ODBC in SQL Query Analyzer

Is there any way to use an ODBC data source in MS SQL Query Analyzer? I
need to join an MS SQL table with a table from a non MSSQL database.
DTS would allow me to import the alient table but I want to avoid that,
if possible.
thanks"EoRaptor013" <rchrismon@.patmedia.net> wrote in message
news:1107369347.205441.278230@.g14g2000cwa.googlegr oups.com...
> Is there any way to use an ODBC data source in MS SQL Query Analyzer? I
> need to join an MS SQL table with a table from a non MSSQL database.
> DTS would allow me to import the alient table but I want to avoid that,
> if possible.
> thanks

Check out sp_addlinkedserver and "Configuring Linked Servers" in Books
Online - you can define a link to a data source on the MSSQL server, then
query it directly with TSQL.

Simon|||Check out the OPENROWSET function if your external datasource is also
OLE DB compatible. (There is, I think, is a OLE DB provider for ODBC
so you should be able to use this).

--
David Rowland
For a good monitor for Users and Server usage, try DBMonitor
http://dbmonitor.tripod.com