Nie jesteś zalogowany.
Jeśli nie posiadasz konta, zarejestruj je już teraz! Pozwoli Ci ono w pełni korzystać z naszego serwisu. Spamerom dziękujemy!

Ogłoszenie

Prosimy o pomoc dla małej Julki — przekaż 1% podatku na Fundacji Dzieciom zdazyć z Pomocą.
Więcej informacji na dug.net.pl/pomagamy/.

#1  2009-02-03 14:32:30

  buli - Użytkownik

buli
Użytkownik
Skąd: Człuchów
Zarejestrowany: 2006-04-30

MS SQL (Win XP) PHP (Debian)

Takie buty.. Baza na SQL Express na XP Pro i Apache z PHP @ Debian

Cos tam zaczytalem o FreeTDS zrobilem sobie konfiga..
[Venus]
        host = 192.168.1.30
        instance = SQL
        port = 1433
        tds version = 7.0

Kod:

14:28:48.063444 18296 (log.c:190):Starting log file for FreeTDS 0.82
        on 2009-02-03 14:28:48 with debug flags 0xffff.
14:28:48.064129 18296 (iconv.c:197):names for ISO-8859-1: ISO-8859-1
14:28:48.064202 18296 (iconv.c:197):names for UTF-8: UTF-8
14:28:48.064232 18296 (iconv.c:197):names for UCS-2LE: UCS-2LE
14:28:48.064262 18296 (iconv.c:197):names for UCS-2BE: UCS-2BE
14:28:48.064291 18296 (iconv.c:363):iconv to convert client-side data to the "ANSI_X3.4-1968" character set
14:28:48.064371 18296 (iconv.c:516):tds_iconv_info_init: converting "US-ASCII"->"UCS-2LE"
14:28:48.064435 18296 (iconv.c:516):tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
14:28:48.064467 18296 (net.c:836):tds7_get_instance_port(192.168.1.30, SQL)
14:28:49.060959 18296 (net.c:905):tds7_get_instance_port: timed out on try 0 of 16
14:28:50.060963 18296 (net.c:905):tds7_get_instance_port: timed out on try 1 of 16
14:28:51.060959 18296 (net.c:905):tds7_get_instance_port: timed out on try 2 of 16
14:28:52.060963 18296 (net.c:905):tds7_get_instance_port: timed out on try 3 of 16
14:28:53.060960 18296 (net.c:905):tds7_get_instance_port: timed out on try 4 of 16
14:28:54.060961 18296 (net.c:905):tds7_get_instance_port: timed out on try 5 of 16
14:28:55.060960 18296 (net.c:905):tds7_get_instance_port: timed out on try 6 of 16
14:28:56.060962 18296 (net.c:905):tds7_get_instance_port: timed out on try 7 of 16
14:28:57.060958 18296 (net.c:905):tds7_get_instance_port: timed out on try 8 of 16
14:28:58.060963 18296 (net.c:905):tds7_get_instance_port: timed out on try 9 of 16
14:28:59.060961 18296 (net.c:905):tds7_get_instance_port: timed out on try 10 of 16
14:29:00.060963 18296 (net.c:905):tds7_get_instance_port: timed out on try 11 of 16
14:29:01.060963 18296 (net.c:905):tds7_get_instance_port: timed out on try 12 of 16
14:29:02.060964 18296 (net.c:905):tds7_get_instance_port: timed out on try 13 of 16
14:29:03.060960 18296 (net.c:905):tds7_get_instance_port: timed out on try 14 of 16
14:29:04.060962 18296 (net.c:905):tds7_get_instance_port: timed out on try 15 of 16
14:29:04.061140 18296 (net.c:974):instance port is 0
14:29:04.061174 18296 (login.c:418):invalid port number
14:29:04.061228 18296 (dblib.c:1372):dbclose(0x899a178)
14:29:04.061262 18296 (dblib.c:256):dblib_del_connection(0xb6757640, 0x83bd500)
14:29:04.061364 18296 (mem.c:563):tds_free_all_results()
14:29:04.061422 18296 (dblib.c:303):dblib_release_tds_ctx(1)
14:29:04.061470 18296 (dblib.c:5727):dbfreebuf(0x899a178)
14:29:04.061705 18296 (dblib.c:718):dbloginfree(0x83bf6f0)

Jesli zakomentuje
[Venus]
        host = 192.168.1.30
;        instance = SQL
        port = 1433
;        tds version = 7.0

Kod:

14:30:41.625627 18300 (log.c:190):Starting log file for FreeTDS 0.82
        on 2009-02-03 14:30:41 with debug flags 0xffff.
14:30:41.625712 18300 (iconv.c:363):iconv to convert client-side data to the "ANSI_X3.4-1968" character set
14:30:41.625788 18300 (iconv.c:516):tds_iconv_info_init: converting "US-ASCII"->"UCS-2LE"
14:30:41.625835 18300 (net.c:210):Connecting to 192.168.1.30 port 1433 (TDS version 4.2)
14:30:41.626047 18300 (net.c:264):tds_open_socket: connect(2) returned "Operation now in progress"
14:30:41.626231 18300 (net.c:299):getsockopt(2) reported: Connection refused
14:30:41.626288 18300 (util.c:334):tdserror(0x89325e8, 0x8c7bd98, 20009, 115)
14:30:41.626327 18300 (dblib.c:7782):dbperror(0x8c799d8, 20009, 115)
14:30:41.626361 18300 (dblib.c:7835):20009: "Unable to connect: Adaptive Server is unavailable or does not exist"
14:30:41.626392 18300 (dblib.c:7856):"Unable to connect: Adaptive Server is unavailable or does not exist", client returns 2 (INT_CANCEL)
14:30:41.626424 18300 (util.c:368):tdserror: client library returned TDS_INT_CANCEL(2)
14:30:41.626454 18300 (util.c:389):tdserror: returning TDS_INT_CANCEL(2)
14:30:41.626483 18300 (net.c:310):tds_open_socket() failed
14:30:41.626521 18300 (dblib.c:1372):dbclose(0x8c799d8)
14:30:41.626551 18300 (dblib.c:256):dblib_del_connection(0xb6757640, 0x8c7bd98)
14:30:41.626650 18300 (mem.c:563):tds_free_all_results()
14:30:41.626693 18300 (dblib.c:303):dblib_release_tds_ctx(1)
14:30:41.626735 18300 (dblib.c:5727):dbfreebuf(0x8c799d8)
14:30:41.626877 18300 (dblib.c:718):dbloginfree(0x8c89538)

Nigdy tego nie gryzlem wiec prosze o pomoc.. sposob laczenia..

Kod:

<?
$connection = mssql_connect("Venus", "wydruki", "pass");
?>

blehh :F

Offline

 

#2  2009-02-03 17:07:30

  grzegorz.85 - Członek DUG

grzegorz.85
Członek DUG
Skąd: Ostrołęka
Zarejestrowany: 2007-07-12
Serwis

Re: MS SQL (Win XP) PHP (Debian)

Może nie do końca odpowiedź na Twoje pytanie, ale zgodna tematycznie. Ja do łączenia się z MS SQL używam ADOdb, ewentualnie czasem połączenie uzyskuje przez ODBC skonfigurowane na maszynie z Window$em.

Jeżeli któryś ze sposobów bardziej Cię zainteresuje napisz, to szerzej opisze moje poczynania.

Offline

 

#3  2010-02-08 15:28:38

  mehow206 - Nowy użytkownik

mehow206
Nowy użytkownik
Zarejestrowany: 2010-02-08

Offline

 

Stopka forum

Powered by PunBB
© Copyright 2002–2005 Rickard Andersson
Nas ludzie lubią po prostu, a nie klikając w przyciski ;-)