Re: ODBC via tcp
it sounds good to use DBD::Sybase i heard it need some work to get mssql7 to work with - but still hope it works fine with mssql2k - my client machine is linux debian - i tried to use easysoft software for bridging connection - it should work fine (connection is ok - i've already checked) but i still have some problems with compiling DBI and DBD::ODBC - make test for DBI-1.31 gives me annoying messege t/01basics..ok t/02dbidrv..ok t/03hleak...ok t/04modsok t/05thrcloneskipping test on this platform t/06attrs...ok t/07kidsok t/10examp...Insecure dependency in parameter 1 of DBI::st=HASH(0x8243f78)-FETCH method call while running with -T switch at t/10examp.t line 320. DBI handle cleared whilst still active. dbih_clearcom (sth 0x82477b8 0x816cb40, com 0x8249160, imp DBD::ExampleP::st): FLAGS 0x60011: COMSET Warn TaintIn TaintOut PARENT DBI::db=HASH(0x82437bc) KIDS 0 (0 Active) IMP_DATA ARRAY(0x824795c) NUM_OF_FIELDS 3 NUM_OF_PARAMS 1 dubious Test returned status 20 (wstat 5120, 0x1400) Undefined subroutine Test::Harness::WCOREDUMP called at /usr/lib/perl5/5.005/Test/Harness.pm line 288. make: *** [test_dynamic] Error 20 any idea what's wrong ? - i am using perl 5.005 thanks all of you for sugestions greg
RE: ODBC via tcp
how to use DBD::ODBC to connect sql server on nt machine do i have to install odbc-odbc bridge on client and server or is any simplest way to connect mssql via tcp ? From a Windows platform, just use DBD::ODBC and configure a data source for the server. From a Unixy platform, either use DBD::ODBC and ODBC bridge software, or consider just using DBD::Sybase and FreeTDS. -- Steve Haslam, Developer for Activis; Integralis Ltd, Theale http://www.activis.com/ Please note that: 1. This e-mail may constitute privileged information. If you are not the intended recipient, you have received this confidential email and any attachments transmitted with it in error and you must not disclose, copy, circulate or in any other way use or rely on this information. 2. E-mails to and from the company are monitored for operational reasons and in accordance with lawful business practices. 3. The contents of this email are those of the individual and do not necessarily represent the views of the company. 4. The company does not conclude contracts by email and all negotiations are subject to contract. 5. The company accepts no responsibility once an e-mail and any attachments is sent. http://www.activis.com This annotation was added by the e-scan service. http://www.activis.com -- This message has been checked for all known viruses by e:)scan. For further information please contact [EMAIL PROTECTED]
Re: ODBC via tcp
Skorpion wrote: how to use DBD::ODBC to connect sql server on nt machine do i have to install odbc-odbc bridge on client and server or is any simplest way to connect mssql via tcp ? greg Is that NT to NT or Unix to NT (you didn't say). If the former just use the SQL server ODBC driver. If the latter you can use a DBD-Sybase with the FreeTDS libraries. -- Simon Oliver
RE: ODBC via tcp
Hmmm, is your client on Unix/Linux? If not, just set up a DSN in ODBC to point to the db, if yes, then an appropriate driver (and there are many) for Linux/Unix needs to be installed and DSN set up in a similar way. Ilya -Original Message- From: Skorpion [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 04, 2003 10:05 AM To: [EMAIL PROTECTED] Subject: ODBC via tcp how to use DBD::ODBC to connect sql server on nt machine do i have to install odbc-odbc bridge on client and server or is any simplest way to connect mssql via tcp ? greg