Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 DSN vs. DSN-Less connections.

Author  Topic 

Eagle_f90
Constraint Violating Yak Guru

424 Posts

Posted - 2007-12-21 : 22:47:08
Is there any type of performance gain to using DSN connections? Or any real advantage to using them over DSN-Less connections?

--
If I get used to envying others...
Those things about my self I pride will slowly fade away.
-Stellvia

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-12-21 : 22:54:45
ODBC is getting kinda old for your database connections. What programming language are you using?


Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

Eagle_f90
Constraint Violating Yak Guru

424 Posts

Posted - 2007-12-21 : 23:02:55
I am using perl and right now I am so pissed at ODBC. I originaly asked the question because I can not get ODBC working on my local Vista machine. What other ways of connecting to an MS SQL 2k5 DB in Perl are there and what do you recomend using?

--
If I get used to envying others...
Those things about my self I pride will slowly fade away.
-Stellvia
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-21 : 23:25:38
How about jdbc?
Go to Top of Page

Eagle_f90
Constraint Violating Yak Guru

424 Posts

Posted - 2007-12-22 : 21:21:49
quote:
Originally posted by rmiao

How about jdbc?


As far as I can tell jdbc is for Java apps not perl.

--
If I get used to envying others...
Those things about my self I pride will slowly fade away.
-Stellvia
Go to Top of Page

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-12-22 : 22:00:49
did you read this?

http://www.sqlservercentral.com/articles/Miscellaneous/connectingtosqlserverusingperlwin32odbc/863/

EDIT: also here are some other options:
http://www.sommarskog.se/mssqlperl/index.html
http://www.sommarskog.se/mssqlperl/alternatives.html


elsasoft.org
Go to Top of Page
   

- Advertisement -