Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

ODBC Connection Pool

 
   Database Forums (Home) -> ODBC RSS
Next:  I need to optimize this query  
Author Message
SFB EIM

External


Since: Feb 07, 2008
Posts: 3



(Msg. 1) Posted: Thu Feb 07, 2008 12:13 pm
Post subject: ODBC Connection Pool
Archived from groups: microsoft>public>sqlserver>odbc (more info?)

I have a need to find out when any ODBC connection is made to a certain SQL
Server.

I assume any/all ODBC connections will have to use TCP port 1433 - since SQL
uses only TCP 1433 in this server's case.

Is there any SQL method to detect a new ODBC connection and perhaps send a
notification or else log it to some SQL log file?

I need to pick up the remote client's IP address for immediate notification
to Management.

Thanks for any help.

Lars

 >> Stay informed about: ODBC Connection Pool 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
ODBC Connection - Hi, All, I got problem with ODBC connection, I have a product server and a stage server, I made a sysdsn called SQLDSN, create a com+ called login and just a very simply statement: list below: private oconn as new adodb.connection Public Function vPWD()...

ODBC Connections - I have a network with 6 machines sitting on it. All PC`s are configued in the same way. 5 of the machines connect to a SQL server via ODBC with no problems. The sixth PC however does not connect to the server giving the following :- Connection Failed...

ODBC Connection - I have a problem creating an ODBC link from a Window 2000 Descktop to a SQL database. This works on other machines with the same setup and on the same location. The error message I am getting is :- Connection failed: SQLState: '01000' SQL Server Error...

Connection Pooling in ODBC with DB2 - Hi, We have an ASP application running in IIS using a IBM ODBC driver and specifying PROVIDER=IBMDBDB2 in the connection string. This is running on a Windows Server 2005 - the IBM ODBC driver is 8.2. However, we are not sure where the connection..

SQL 2005 ODBC Connection Support - I recently installed SQL 2005 Developer Edition, and ODBC access is only supported via ADO.net wrapper. Did MS take out native ODBC support? In the past I'm able to select existing ODBC connections and import data from Cache (intersystems database)..
   Database Forums (Home) -> ODBC All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]