Witaj Gościu! ( Zaloguj | Rejestruj )

Forum PHP.pl

> MSSql PDO problem z połączeniem
PROGer
post 7.05.2015, 09:42:47
Post #1





Grupa: Zarejestrowani
Postów: 63
Pomógł: 0
Dołączył: 30.04.2015

Ostrzeżenie: (0%)
-----


Witam,

Mam problem z połaczeniem się z bazą danych MSSql w wersji 9.0001399.00 (2005). Uprzedzę pytania i dodam że zmiana na nowsza nie wchodzi w tym przypadku w grę. Dodatkowo inne prehistoryczne lelementy to PHP v. 5.2.6 i Apache v 2.2

Połaczenie testuję poprzez (nie wiem czy poprawnie):

  1. <?php
  2. try {
  3.  
  4. $db = new PDO('odbc:Driver={SQL Server};Server=localhost;Database=TEST02; Uid=TEST02\User1;Pwd=Password2');
  5.  
  6. } catch (PDOException $e) {
  7.  
  8. echo $e->getMessage();
  9. }
  10. ?>


Sterowniki które umieściłem w php/ext i które zadeklarowałem w php.ini na samym końcu to:
extension=php_pdo_sqlsrv_52_nts_vc6.dll
extension=php_pdo_sqlsrv_52_ts_vc6.dll
extension=php_pdo_sqlsrv_53_nts_vc6.dll
extension=php_pdo_sqlsrv_53_nts_vc9.dll
extension=php_pdo_sqlsrv_53_ts_vc6.dll
extension=php_pdo_sqlsrv_53_ts_vc9.dll


Test wyrzuca mimo to błąd:
could not find driver

Co może być nie tak?
Go to the top of the page
+Quote Post
 
Start new topic
Odpowiedzi
PROGer
post 8.05.2015, 07:11:06
Post #2





Grupa: Zarejestrowani
Postów: 63
Pomógł: 0
Dołączył: 30.04.2015

Ostrzeżenie: (0%)
-----


Znalazłem w sieci podobny problem tu:

  1. == Problem
  2.  
  3. Consider the following from an httpd.conf file...
  4.  
  5. LoadModule php5_module "E:/xyz/php/php5apache2_2.dll"
  6. PHPIniDir "E:/xyz/php"
  7.  
  8. ...which led to the dreaded...
  9.  
  10. PHP Warning: PHP Startup: Unable to load dynamic library 'E:\\xyz\\php\\ext\\php_mysql.dll' - The specified module could not be found.
  11.  
  12. Note, however, that PHP.exe apparently was found and executed php pages in Apache, but the MySQL functions therein failed.
  13.  
  14. == Solution
  15.  
  16. Because PHP dir was not in $PATH, php5apache2_2.dll failed to find php_mysql.dll (the only extension I enabled) during Apache 2.2 start.
  17.  
  18. == Caveat (!)
  19.  
  20. The BIG issue is that, setting $PATH in...
  21.  
  22. <desk icon>My Computer
  23. <rt click>Properties
  24. <tab>Advanced
  25. <button>Environment Variables
  26.  
  27. ...didn't export the $PATH change such that restarting the Apache service (in MMC) would pick it up. So I tested the working solution (adding PHP dir to $PATH), but it failed because of HOW I set it. It succeeded only when I REBOOTED after changing the $PATH. There may be an easier way that this, but I do not know it at present.
  28.  
  29. == Comment
  30.  
  31. Consider whether PHP dir should need to be in $PATH at all, when PHP.exe apparently was found and executes php pages in Apache, but php5apache2_2.dll failed to find whatever was needed to load the extensions. This should perhaps be addressed.
  32.  
  33. Note that on a WAMP installation (W2K,Apache,MySQL,PHP), only PHP is required in $PATH.


Ale u mnie w zmiennej PATH ścieżka do PHP jest ustawiona i prawidłowa! dry.gif dry.gif dry.gif

PATH
  1. C:\www\PHP\;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\Program Files\Microsoft SQL Server\80\Tools\Binn\;C:\Program Files\Microsoft SQL Server\90\DTS\Binn\;C:\Program Files\Microsoft SQL Server\90\Tools\binn\;C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\


PHPRC
  1. C:\www\PHP\


sprawdź czy powiązane z rozszerzeniami pliki DLL (nie chodzi o te z c:/php/ext) są dostępne przez ścieżki z tej zmiennej
Napisz proszę jak moge to sprawdzić ...

Ten post edytował PROGer 8.05.2015, 07:43:00
Go to the top of the page
+Quote Post
Brettzep
post 9.09.2019, 15:59:25
Post #3





Grupa: Zarejestrowani
Postów: 2
Pomógł: 0
Dołączył: 8.09.2019

Ostrzeżenie: (0%)
-----


The good news is there was no pain. But the sensation was extremely various from having my pussy penetrated. I attempted not to relocate, intended to remain a bit in this position to obtain used to that new sensation. He recognized this without words and also waited on me to take the next step. When I felt all set I pressed a bit back to signify him that I prepared to have his dick totally in my butt. Currently I really wanted it. He pressed forward and his dick slid completely right into my limited asshole. It felt excellent! It took me a few seconds, though, to realize what simply had actually occurred.

https://maps.google.hr/url?q=https://www.xvideoxxnx.com/
https://images.google.ad/url?q=https://www.xvideoxxnx.com/
https://www.google.com.mm/url?q=https://www.xvideoxxnx.com/
https://www.google.ga/url?q=https://www.xvideoxxnx.com/
https://maps.google.com.bn/url?q=https://www.xvideoxxnx.com/
https://maps.google.co.ls/url?q=https://www.xvideoxxnx.com/
https://maps.google.gr/url?q=https://www.xvideoxxnx.com/
https://maps.google.jo/url?q=https://www.xvideoxxnx.com/
https://www.google.ps/url?q=https://www.xvideoxxnx.com/
https://www.google.ad/url?q=https://www.xvideoxxnx.com/


Thankfully there was no discomfort. However the sensation was really various from having my pussy passed through. I risked not to move, wished to stay a little bit in this setting to obtain made use of to that brand-new feeling. He understood this without words and also waited for me to take the following action. When I really felt ready I pressed a bit back to indicate him that I was ready to have his cock completely in my butt. Now I really desired it. He pushed onward as well as his cock slid fully right into my tight asshole. It felt good! It took me a couple of seconds, however, to recognize what just had actually taken place.

https://images.google.no/url?q=https://www.xvideoxxnx.com/
https://images.google.sk/url?q=https://www.xvideoxxnx.com/
https://images.google.ps/url?q=https://www.xvideoxxnx.com/
https://maps.google.me/url?q=https://www.xvideoxxnx.com/
https://www.google.bj/url?q=https://www.xvideoxxnx.com/
https://www.google.com.qa/url?q=https://www.xvideoxxnx.com/
https://www.google.hn/url?q=https://www.xvideoxxnx.com/
https://maps.google.com.ua/url?q=https://www.xvideoxxnx.com/
https://maps.google.tk/url?q=https://www.xvideoxxnx.com/
https://www.google.co.ug/url?q=https://www.xvideoxxnx.com/


The good news is there was no pain. Yet the sensation was really different from having my pussy passed through. I attempted not to relocate, intended to remain a little bit in this setting to obtain made use of to that brand-new feeling. He understood this without words as well as waited for me to take the next action. When I really felt prepared I pressed a bit back to signify him that I prepared to have his cock fully in my ass. Currently I truly desired it. He pushed onward and also his penis glided completely into my limited asshole. It really felt excellent! It took me a few seconds, however, to recognize what just had occurred.

https://maps.google.at/url?q=https://www.xvideoxxnx.com/
https://www.google.li/url?q=https://www.xvideoxxnx.com/
https://images.google.gp/url?q=https://www.xvideoxxnx.com/
https://maps.google.com.cy/url?q=https://www.xvideoxxnx.com/
https://www.google.lv/url?q=https://www.xvideoxxnx.com/
https://www.google.jo/url?q=https://www.xvideoxxnx.com/
https://maps.google.dk/url?q=https://www.xvideoxxnx.com/
https://maps.google.ps/url?q=https://www.xvideoxxnx.com/
https://www.google.com.lb/url?q=https://www.xvideoxxnx.com/
https://www.google.co.th/url?q=https://www.xvideoxxnx.com/


Luckily there was no discomfort. However the sensation was very different from having my pussy passed through. I risked not to move, wished to remain a little bit in this position to get used to that new feeling. He recognized this without words and waited for me to take the following step. When I really felt prepared I pushed a little bit back to signal him that I was ready to have his cock totally in my butt. Now I really wanted it. He pressed forward as well as his dick glided fully right into my limited asshole. It really felt excellent! It took me a couple of secs, however, to realize what just had actually taken place.

https://www.google.td/url?q=https://www.xvideoxxnx.com/
https://images.google.tn/url?q=https://www.xvideoxxnx.com/
https://images.google.sk/url?q=https://www.xvideoxxnx.com/
https://www.google.co.ls/url?q=https://www.xvideoxxnx.com/
https://maps.google.la/url?q=https://www.xvideoxxnx.com/
https://images.google.com.pe/url?q=https://...xvideoxxnx.com/
https://www.google.je/url?q=https://www.xvideoxxnx.com/
https://images.google.im/url?q=https://www.xvideoxxnx.com/
https://maps.google.kz/url?q=https://www.xvideoxxnx.com/
https://images.google.com.gi/url?q=https://...xvideoxxnx.com/


Thankfully there was no pain. Yet the feeling was extremely different from having my pussy permeated. I risked not to relocate, wished to stay a little bit in this placement to obtain utilized to that brand-new feeling. He understood this without words as well as waited for me to take the following action. When I really felt ready I pressed a bit back to indicate him that I was ready to have his penis fully in my butt. Now I really wanted it. He pressed onward and also his dick slid totally right into my limited asshole. It really felt great! It took me a couple of secs, however, to realize what simply had actually taken place.

https://maps.google.ki/url?q=https://www.xvideoxxnx.com/
https://www.google.com.py/url?q=https://www.xvideoxxnx.com/
https://images.google.gp/url?q=https://www.xvideoxxnx.com/
https://www.google.co.ma/url?q=https://www.xvideoxxnx.com/
https://images.google.com.pg/url?q=https://...xvideoxxnx.com/
https://www.google.co.zm/url?q=https://www.xvideoxxnx.com/
https://www.google.is/url?q=https://www.xvideoxxnx.com/
https://maps.google.co.nz/url?q=https://www.xvideoxxnx.com/
https://maps.google.com.ec/url?q=https://www.xvideoxxnx.com/
https://maps.google.nl/url?q=https://www.xvideoxxnx.com/
Go to the top of the page
+Quote Post

Posty w temacie
- PROGer   MSSql PDO problem z połączeniem   7.05.2015, 09:42:47
- - Turson   Restart Apache był?   7.05.2015, 09:50:46
- - PROGer   Tak był oczywiście. Wycinek z końca php.ini'...   7.05.2015, 09:51:58
|- - Phillipfophy   I had acquired some lube ahead of time which he cu...   4.09.2019, 23:02:20
- - Pyton_000   poczytaj to: http://stackoverflow.com/questions/11...   7.05.2015, 09:52:56
- - PROGer   Przeczytałem, ale nic to nie wniosło. Próbuje poł...   7.05.2015, 10:14:37
- - salfunglandyare   Dodaj php_pdo_odbc.dll i sprobuj jak wcześniej - o...   7.05.2015, 11:55:12
- - PROGer   ściągnąłem ten dll, umieściłem w php/ext, dodałem ...   7.05.2015, 12:02:21
- - salfunglandyare   jeszcze taka jedna rzecz: * print_r(PDO::getAvaila...   7.05.2015, 12:16:19
- - PROGer   Array ( [0] => sqlsrv ) could not find driver d...   7.05.2015, 12:29:14
- - salfunglandyare   oznacza to, że masz załadowany tylko driver sqlsrv...   7.05.2015, 12:42:35
- - PROGer   [PHP] pobierz, plaintext Array ( [0] =...   7.05.2015, 12:54:30
- - salfunglandyare   wklej te sekcje php.ini po zmianach, jestes pewien...   7.05.2015, 13:07:54
- - PROGer   Coś dziwnego ... w php.ini mam: [PHP] pobierz, p...   7.05.2015, 13:19:14
- - salfunglandyare   A PHP instalowałeś z XAMMPa? DLLki rozszerzeń same...   7.05.2015, 13:42:08
- - PROGer   Restartowałem Windowsa. Serwer stawiałem bez użyc...   7.05.2015, 15:20:18
- - salfunglandyare   Sprawdź zmienną systemową PATH, sprawdź czy powiąz...   7.05.2015, 15:34:30
- - PROGer   Znalazłem w sieci podobny problem tu: [PHP] pobie...   8.05.2015, 07:11:06
- - Brettzep   The good news is there was no pain. But the sensat...   9.09.2019, 15:59:25


Reply to this topicStart new topic
2 Użytkowników czyta ten temat (2 Gości i 0 Anonimowych użytkowników)
0 Zarejestrowanych:

 



RSS Wersja Lo-Fi Aktualny czas: 28.04.2024 - 13:41