<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div apple-content-edited="true"><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Verdana; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; -webkit-text-decorations-in-effect: none; text-indent: 0px; -webkit-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; -webkit-text-decorations-in-effect: none; text-indent: 0px; -webkit-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; "><div><div><span class="Apple-style-span" style="font-family: Verdana; ">On 27/mag/09, at 12:00, Fabio D'Alfonso wrote:</span></div></div></span></div></span></div></span></div><div><br class="Apple-interchange-newline"><blockquote type="cite"> <div bgcolor="#ffffff" text="#000000">vi ringrazio per il suggerimento, l'ho installato e ho testato la connessione con tsql.<br> A questo punto come lo posso usare da Perl/DBI?<br></div></blockquote><div><br></div>Mi pare che sul link ci fosse... comunque prima setta ODBC, poi usa il modo classico di DBI ma con driver "dbi:ODBC" al posto di "DBI:mysql".</div><div><br></div><div>In "/etc/odbc.ini" (le parti in corsivo vanno modificate):</div><div><br>[<i>mydb</i>]<br>Driver = FreeTDS <br>Description = <i>My ODBC connection</i><br>Trace = No<br>Server = <i>mysqlserver.mycompany.com</i><br>Port = 1433<br>Database = <i>NORTHWIND</i></div><div><br></div><div>poi in Perl:</div><div><br></div><div>use DBI;</div><div>my $dbh= DBI->connect( 'dbi:ODBC:<i>mydb</i>', '<i>user</i>', '<i>pass</i>' );</div><div><br></div><div>ciao</div><div><span class="Apple-style-span" style="font-family: Helvetica; "><div>-- </div><div>Marco Balestra</div><div>IT consultant</div><div><a href="mailto:balestra@cesmail.net">balestra@cesmail.net</a></div><div><font class="Apple-style-span" face="Verdana"><font class="Apple-style-span" face="Helvetica"><br></font></font></div></span></div></body></html>