ODBC And SQL Hostnames As Seen By Profiler

Nov 17, 2005

Just an FYI,
In looking at the current activity in SQL Server 2000, I came across a machine logging in with my userid but a very old hostname. It turns out that a Batch machine was running a scheduled query via an ODBC connection. The Access application, using the ODBC connection, was created on another machine and copied to the batch machine. SQL was using the machine name affiliated with the ODBC connection not the actual machine that was running the query. I know I should optimize the query and use ADO and this will go away. This has been running for a long time but I've just never noticed. Hope this is helpful to someone.

View 1 Replies

SQL Server 2008 :: Why User Hostnames Showing As Various

May 6, 2015

Several apps connecting to a SQL 2008 server show the users having a hostname of "Various" when doing an sp_who2 or looking at relevant DMVs.

I joined dm_exec_sessions to dm_exec_connections and was able to get the IP addresses and they resolve back to real clients. So why they'e not displayed and I see "Various" instead?

View 0 Replies View Related

Integration Services :: Unable To See 64bit ODBC Driver From SSIS Odbc Connection?

Jun 1, 2015

I am using SSIS 2014 with the below .net framework version and installed in Windows server 2012 R2 . I have installed my client's odbc drivers (both 32 bit and 64 bit) in my production server and created ODBC system DSNs for 32 bit and 64 bit.

When i open SSIS 2014 and tried to create the odbc connection but i can able to see only the 32 bit system DSN connection ,i can't able to see my 64 bit odbc system dsn connection.

Microsoft Visual Studio 2012 Shell (Integrated)
Version 11.0.50727.1 RTMREL
Microsoft .NET Framework
Version 4.5.51650

SQL Server Integration Services
Microsoft SQL Server Integration Services Designer
Version 12.0.1524.0

And i installed my client odbc drivers(32,64 bit) and created ODBC system DSNs in my local system and when i open ssis 2014 and i can able to see both the ODBC system DSNS(32,64) connections from SSIS ODBC connection.

I am using below version of .net framework in my local system which was installed in windows 7 and i have SSIS 2012 also installed in my system and i can able to see both ODBC connections using 2012 as well in my local system.

Microsoft Visual Studio 2012 Shell (Integrated)
Version 11.0.50727.1 RTMREL
Microsoft .NET Framework
Version 4.5.50938

SQL Server Integration Services
Microsoft SQL Server Integration Services Designer
Version 12.0.1524.0

why i can not see the ODBC 64 bit system DSN connection from SSIS in my production server ?

View 9 Replies View Related

How Can I Use Create Or Alter Statements With ODBC And Microsoft Access ODBC Driver (*mdb)?

May 13, 2007

Hi,

I am using VB.NET 2005 and set up an ODBC connection via ODBC.ODBCConnection to a MDB database. Therefor, I use the "Microsoft Access ODBC Driver (*.mdb)".

When I set up a ODBCCommand like "ALTER DATABASE..." or "CREATE TABLE..." and issue it with the com.ExecuteNonQuery() command, I get an error from ODBC driver, that a SQL statement has to begin with SELECT, INSERT, UPDATE or DELETE.

How can I use DDL statements via ODBC?

I would appreciate if you could help me to use ODBC for that - no OLE, no ADO.

Thanks for help!

Regards,

Stefan D.

View 14 Replies View Related

Can't Find SQL Native Client In ODBC Connection Manager In SQL Server Open Database Connectivity (ODBC)

Feb 13, 2007

I apologize if this is not the correct forum for this posting. Looking at the descriptions, it appeared to be the best choice.

I am running Windows XP Pro SP2. I have installed the SQL Native Client for
XP. However, when I try to add a new data source through ODBC Connection
Manager, SQL Native Client is not listed as an option. I have followed this procedure on three other systems with no problems. What would be causing the
SQL Native Client to not show up in the list of available ODBC data sources?

View 4 Replies View Related

MS OLE DB For ODBC With Oracle ODBC Source Headaches

Dec 25, 2005

Hi all,I am having trouble getting linked Oracle 9 server in MS SQL Server2005 Express to work properly. My machine is running Windows XP.The Microsoft and Oracle OLE DB Providers have problems dealing withOracle's Numeric Data Type, so I decided to use Microsoft's OLE DB forODBC Provider and an Oracle ODBC source. When using the Microsoft ODBCfor Oracle Driver in my ODBC source I have inconsistent behavior.Sometimes my queries are processed properly, then other times I get thefollowing errorOLE DB provider "MSDASQL" for linked server "ODBCBEAST" returnedmessage "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttrfailed".OLE DB provider "MSDASQL" for linked server "ODBCBEAST" returnedmessage "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttrfailed".OLE DB provider "MSDASQL" for linked server "ODBCBEAST" returnedmessage "[Microsoft][ODBC driver for Oracle][Oracle]".Msg 7303, Level 16, State 1, Line 1Cannot initialize the data source object of OLE DB provider "MSDASQL"for linked server "ODBCBEAST".I have no idea why sometimes I can connect to the linked server with noproblems andwhy other times it performs like this. I'm not changing anything aboutthe system I can think of. When I use an Oracle client (PL/SQL) I haveabsolutely no problems connecting. TNSPING returns that the connectionis good.This is unacceptable so I decided to try my luck with the Oracle 10gODBC driver. However when I use this and perform an openquery selectagainst the linked server I get back only 11 rows, when I know that thedatabase has over 100 rows (in fact when using the Microsoft ODBCdriver and it works that's what I get). I figured maybe the buffersetting needed to be raised in the ODBC configuration so I took it from64000 to 600000 (a magnitude of 10) but I still get back only 11 rows.I'm at my wit's end.Any suggestions on resolving one or the other problem would be muchappreciated.Thanks much

View 2 Replies View Related

Compatible Versions Of Ms SQL Server, ODBC Driver, Driver Manager And ODBC API Spec

Oct 28, 2004

Hi,

Please help share with me if you know the version compatibility matrix of Ms SQL Server, ODBC driver (sqlsrv32.dll), Driver Manager (odbc32.dll) and ODBC API spec. For instance, how can I know Ms SQL Server 2000 can work with which version of sqlsrv32.dll, a particular version of sqlsrv32.dll can work with which version of odbc32.dll and a certain version of sqlsrv32.dll/odbc32.dll conforms to which version of ODBC API spec (e.g. 3.5).

Any help will be appreciated.

Thanks,

vtluu.

View 1 Replies View Related

SQL Profiler�s

Apr 26, 2001

Can only member in the System Administrators role use the SQL Profiler�s? Is there any other role or way to allow user to use this tool other then adding them to this role? Thanks you

View 1 Replies View Related

SQL Profiler !!

Dec 23, 1999

Does anybody have any idea if there is a bug in SQL 7.0 where running multiple traces causes the SQL 7.0 to crash ??
This is running in a clustered environment.

Thanks in advance.
Ajay

View 2 Replies View Related

Profiler

Mar 10, 1999

I've looked high and low for information regarding this problem to no avail. Profiler works fine from the local server where SQL7 is running,
(using NT security). But even though my client is multiprotocol, I cannot connect from my desktop using SQL security (ODBC error) or NT
authentication. NT security gives me ConnectionOpenRcpBindingSetAuthInfo(). I do have a valid id on the NT machine as well and am not
getting any errors in the security events log.

Can/How do you connect remotely to the profiler using TCP/IP or Mulitprotocol client?

Why doesn't NT authentication work?

Thanks in advance for any help.

View 1 Replies View Related

What Is A Profiler?

Aug 1, 2003

Hi Everybody,

Can anyone tell me what is a profiler in SQL server 7.0? What I exactly want to know is, in which practical situation u will find the profiler useful. Explaination with example will be appreciated.

Regards,

Samir.

View 3 Replies View Related

SQL Profiler

Jul 7, 2004

How do I write a process in Profiler to categorise the performance of Stored procedures into buckets of <4 secs,>4secs,between 4 and 10 secs

View 4 Replies View Related

Sql Profiler

Feb 28, 2007

Hello,

My qn is related to profiler.

my app calls an sp, say, sp_DisplayResults. in profiler, i can see multiple entries for this sp call eventhough it is invoked only once from the UI.

no other process/users is invoking the sp.

could any one please let me know why the profiler is displaying it multiple times.

im using MSSQL2k

View 2 Replies View Related

Profiler

Apr 28, 2008

I have a small doubt through profiler how can we find out the long running queries.specifically which events we have to capture.

View 2 Replies View Related

Profiler Help.

Apr 30, 2008

Hi
I need to track the connections hitting to my server through application???

I m doing some work in Profiler but i m not sure from where to start it..I m using SQL SERVER 2005...I m accesing few pages on application and that i want to track that activity involving at server side

T.I.A

View 9 Replies View Related

Profiler

May 16, 2008

I have a small doubt.
where is the ideal place to run a profiler .
can we run a profiler on production server
or we have to run profiler on a seperate instance and connect to production server

View 2 Replies View Related

SQL Profiler

Feb 28, 2006

Lets say I have a username & password , I dont want people to see it being passed on to the SQL Server.

What are the ways I can prevent the parameters being passed on .

Thanks,

Regards
Kidddddddddddddddddd

View 10 Replies View Related

SQL Profiler

Apr 20, 2006

Any one show me the basic guide or tutorial about SQL Profiler for begginer .
Thank in advance !

View 1 Replies View Related

Sql Profiler

Sep 12, 2006

hello friends sorry for this basic question.

i heard a word sql profiler.

i tried through BOL, but not got any good information how to start and from where to start. can anybody give me some brief about this

thank you very much

View 7 Replies View Related

Using Profiler

Oct 27, 2006

1/When I create a new trace, it gives me sevral events including the SQL server s own functions and provcedures. How do I tell profiler to display only the requests we send SQL server from a VB program or other company made programs instead of including sql server own events as well. That will help me filter the requests and locate the problem easily.
2/ also ,. sometimes, my text data column description gets truncated and as a result I can't see the whole text of a request.
What causes that and how can I fox it pls?
Thank you, i am not familiar with profiler.

View 3 Replies View Related

Log's / Profiler / Whatever

Nov 22, 2006

Hi hi, We had a sql express version running fine untill recently.
Now it seems cause high processor use, high memory load, etc.
So the websites being dependant on SQL start performing slower.

Is there some way to monitor what is causing this.
I can't seem to read any log files, there is no profiler in express, etc. So what options do I have?

View 2 Replies View Related

Profiler

Feb 8, 2007

im trying to use the profiler to find out which tables are still being accesses as there seems to be alot of suspected tables lying around and stored objects (sps, functions etc) can the trace profiler be used in this situation?

View 12 Replies View Related

SQL Profiler

Oct 17, 2007

When running a profiler trace for long running queries during peak usage what is a typically expected additional load the process of running it will create on that Database?

Future guru in the making.

View 4 Replies View Related

SQL Profiler

Oct 24, 2007

Hi

Can anyone tell me what is SQL profiler?its function and all.

Thanks in Advance

RKNAIR

View 4 Replies View Related

Sql Profiler

Feb 29, 2008

Dear All,
where can i found sql profiler in sql server 2005?

i'm using
Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
Vinod
Even you learn 1%, Learn it with 100% confidence.

View 3 Replies View Related

Sql Profiler

Mar 30, 2008

I want to know if user defined functions like fn_example can be traced in profiler and what event to choose to trace functions executed.
will it displays the function being executed or just the body of the fucntion?
Thnxxxxxxxx

View 1 Replies View Related

SQL Profiler

Jul 23, 2005

HiI am just started at a new position. This organization has a number ofdatabase servers with mission critical databases. However, I have twodatabase server, 1 a test server and the other a catch all db server thatcontain a hodge podge of databases. On the test server, there are 54databases while the other has 40. I am pretty confindent that not all ofthese databases are being used. My goal is to find out which ones are nolonger needed.In an attempt to find out who/what is using these databases, I have set upSQL Profiler.My SQL profile setup is as suchObjects - Objects openedSecurity Audit - Audit Login, Login Failed, LogoutSession - Existing ConnectionStored Proc - RPC Completed, SP:StmtCompleted, SP:StmtStartingTSQL - SQL Batch completed, SQL:StmtCompletedMy data columns are the standard except I added DatabaseName.And there lies my problem that I hope someone can help. As I run the trace,all other fields seems to be working except Database Name. I see everythingbut the only way to tell what database is being accessed is looking at theSPID number and comparing it with Process Info in EM or sp_who.Does anyone have any idea why this field is not working? Am I missingsomething? Or am I just giving myself a headache for nothing because thereis an easier way to find the information I want: What the heck is going onwith these database and who is doing what on them?Thanks in advance for any and all help:)Akinja

View 2 Replies View Related

How To Run Profiler From Cmd

Feb 21, 2007

Hi,We have a requirement to run profiler continuously to find out themisbehaving applications/SQL in the dataserver. And we are notinterested in running it from an individuals local machine. Also wewant the profiler to start automatically whenever there are SQL Server/Machine restarts.Is there a way to invoke the profiler instance from cmd prompt or isthere a way to script the profiler?Thanks in advance,Thyagu.

View 1 Replies View Related

Why Do We Need SQL Profiler And How To Use It ?

Mar 3, 2008

Hello friends...I want to ask that Why do we need SQL Profiler as SQL Database Developer and How to use it ?

How can I know about that ?

View 4 Replies View Related

Sql Profiler?

Oct 18, 2007

I have the following values on a sql 2000 box, are these values high?

scale 0 to 100

Page/Sec = 0 to 5
Avg. Disk Queue Length = 40 to 50
% Processor Time = 85 to 100

View 1 Replies View Related

How Do I Run SQL Profiler

Sep 12, 2007

I read in a thread that to understand better how a package is run I need to run the SQL Profiler.

How do I run the SQL Profiler?.
thanks

View 4 Replies View Related

SQL Server Profiler

Oct 16, 2006

Hi guys, I'd just like to know how to setup a new Trace in SQL Server Profiler that tells me every time the database is hit with a query. Thanks.