Closed

TSQL Function SQL Server 2012 - repost

Hi,

I need someone to write a TSQL function that returns the name of the ODBC DSN for a given connection.

I can use the queries below, to get information about the connection, but none of these return the DSN name for example.

1. select * from sys.dm_exec_connections

2. select * from sysprocesses

3. select connectionproperty('net_transport')

4. select connectionproperty('protocol_type')

This link shows the C# class that may be able to return this information.

[url removed, login to view]

So if ...

I use a client to connect to SQL Server using odbc connection with a DSN name of ConnectionA and

YOU use a client to connect to the same SQL Server using odbc connection with a DSN name of ConnectionB,

when you run

SELECT dbo.ufn_GetODBCDSN()

you should get "ConnectionB"

and when I run

SELECT dbo.ufn_GetODBCDSN()

I should get "ConnectionA"...

I am NOT looking for stored procedures like sp_enumdsn or sp_dsninfo...

I only say this as some of the developers here have been suggesting this kind of answers..

So to be clear, I am looking to find out what the CLIENT DSN name was, that the connection is using.

I am NOT looking for DSNs defined on the SERVER.

Could you quote for writing this function (dbo.ufn_GetODBCDSN() ) that I can use from TSQL code that returns the name of the DSN?

Thank you

Skills: .NET, C# Programming, Database Administration, SQL

See more: sharp developers, quote answers, quote about writing, find someone to write a code, find net developers, c sharp library, c programming find function, Writing SQL Queries, sql server or, code sys, TSQL, sql odbc, net sql server, net c# sql server, MICROSOFT SQL SERVER, get programming answers c, dsn, developers get quote, system library sql, sql stored function, link sql, tsql dsn, net server using, write sql queries, sql server 2012 connect server

About the Employer:
( 29 reviews ) London, United Kingdom

Project ID: #5061137

13 freelancers are bidding on average $210 for this job

GediminasB

MS SQL server has no information about data consumers connected to it. The only way is enumerate registry entries and check which one is yours. TSQL has no tools for doing that – CLR procedure with high access rights m More

$277 USD in 10 days
(4 Reviews)
5.5
murtaza1981

Hi, An ASP.NET,c#,vb and SqlServer expert here. Please feel free to discuss the project with me so that i can wrap it up in a timely manner as per your requirements. I would like to highlight following qualities of m More

$350 USD in 7 days
(12 Reviews)
4.6
elboukharimu

Hi, I saw your message in the previous project but the website don't allow me to answer to it because you already awarded it to another freelancer. I think the previous freelancer did not do the job well. Please send m More

$200 USD in 7 days
(13 Reviews)
4.5
ultrasonicsoft

Hi, Hope you find this message in in good health. I have very strong hands on C#.NET and SQL Server. I have done many projects using the same. I can do this project with good quality. Hope to hear from you More

$250 USD in 5 days
(12 Reviews)
4.4
oplalchandani

I can help you with this You may like to check my profile, as I have done lot of similar work Quality work and timeliness is assured thanks

$250 USD in 3 days
(2 Reviews)
3.0
abparmar99

Hello, Expert Web developer is here for you, I have gone through your requirements and are ready to Start now. Please check our work links - - - [url removed, login to view] | [url removed, login to view] | More

$226 USD in 7 days
(1 Review)
2.8
beenishb

Howdy, My Name is Beenish Burhan and I am a dynamic problem solver, Sir, I have read the job description and I am sure I can easily handle this job. I have good expertise in following databases MSSQL 2012,2008, More

$222 USD in 5 days
(2 Reviews)
2.7
sumanbeniwal

Dear Hiring Manager, I have read this job for "TSQL Function SQL Server 2012 - repost".And I am confident,I can complete this work very well. I am ready for this job right now.I'm a web developer with more than six ye More

$222 USD in 10 days
(0 Reviews)
0.0
Nirajbajaniya

Hello, which version or framework do you have to use ( Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 , Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium More

$250 USD in 6 days
(0 Reviews)
0.0
iuliagatea

A proposal has not yet been provided

$111 USD in 2 days
(0 Reviews)
0.0
venkatagari85

A proposal has not yet been provided

$122 USD in 5 days
(0 Reviews)
0.0
GabrielDreb

Ainda não foi fornecida uma proposta

$190 USD in 3 days
(0 Reviews)
0.0
hoangtqb

I have an experiences in .net and sql. I hope this project is good with me. Please give me the project. Thanks and great you back to me.

$222 USD in 7 days
(0 Reviews)
0.0
globsware

Hi dear, This is an international software development services provider company. [url removed, login to view] will develop your desired Retail System with features that you have mentioned, from scratch using ASP.NET 4.5 technology, C# More

$88 USD in 3 days
(0 Reviews)
0.0