php - Call to undefined function odbc_connect() message while connecting SAP Hana database -


i used odbc_connect() in php page connect hana database. works fine when run locally. upload same php page server , getting error: 

fatal error: call undefined function odbc_connect()

the code:

$connect = odbc_connect("team6datasource", "team6", "password1", sql_cur_use_odbc);

team6datasource = datasource name.

ip address = 54.217.234.218

can 1 please me? thanks

i go through in google this instruction helpful you.

  1. download sql server odbc driver php client
    platform.     (registration required.) if sql server odbc driver not available platform, check list of
    odbc-odbc bridge client platforms. odbc-odbc bridge an
    alternative sql server solution easysoft, can download site.
  2. install , license sql server odbc driver on machine php installed. installation instructions, see odbc driver documentation. refer documentation see environment variables need set (ld_library_path, libpath, ld_run_path, shlib_path depending on driver, platform , linker).

  3. create odbc data source in /etc/odbc.ini connects sql server database want access php. example, sql server odbc data source connects sql server express instance serves northwind database:

    • use isql test new data source. example: cd /usr/local/easysoft/unixodbc/bin

    ./isql -v mssql-php

[mssql-php] driver                  = easysoft odbc-sql server server                  = my_machine\sqlexpress user                    = my_domain\my_user password                = my_password

please copy , paste script , execute 

<? /* php mssql example  replace data_source_name name of data source. replace database_username , database_password sql server database username , password. */ $data_source='data_source_name'; $user='database_username'; $password='database_password';  // connect data source , handle connection. $conn=odbc_connect($data_source,$user,$password); if (!$conn){     if (phpversion() < '4.0'){       exit("connection failed: . $php_errormsg" );     }     else{       exit("connection failed:" . odbc_errormsg() );     } }  // query generates result set 1 record in it. $sql="select 1 test_col";  # execute statement. $rs=odbc_exec($conn,$sql);  // fetch , display result set value. if (!$rs){     exit("error in sql"); } while (odbc_fetch_row($rs)){     $col1=odbc_result($rs, "test_col");     echo "$col1\n"; }  // disconnect database database handle. odbc_close($conn); ?>
  1. replace data_source_name, database_username , database_password sql server odbc data source, login name , password.

  2. to run script under apache, save file below apache web server’s document root directory. example, /var/www/apache2-default/php-mssql-connection.phtml. view file in web browser:

    http://localhost/php-mssql-connection.phtml
  3. if web browser not running on same machine web server, replace localhost web server’s host name or ip address.

  4. to run script command line, save file.

    for example, /tmp/php-mssql-connection.php. run $ php /tmp/php-mssql-connection.php.

further more details refer link


Comments

Post a Comment

Popular posts from this blog

curl - PHP fsockopen help required -

i trying work on cloudflare api , have found in documentation. unfortunately have no idea how can use in fsockopen or through curl. here example of post request. need know how can make request below data post using curl or fsockopen curl https://www.cloudflare.com/api_json.html -d 'a=cache_lvl' \ -d 'tkn=8afbe6dea02407989af4dd4c97bb6e25' \ -d 'email=sample@example.com' \ -d 'z=example.com' \ -d 'v=agg' here link cloudflare https://www.cloudflare.com/docs/client-api.html#s4.2 try one: $ch = curl_init("https://www.cloudflare.com/api_json.html"); curl_setopt($ch, curlopt_returntransfer,1); curl_setopt($ch, curlopt_followlocation, 1); curl_setopt($ch, curlopt_ssl_verifypeer,false); // handling of -d curl parameter here. $param = array( 'a' => 'cache_lvl', 'tkn' => '8afbe6dea02407989af4dd4c97bb6e25', 'email' => 'sample@example.com', 'z' =...
Read more

HTTP/1.0 407 Proxy Authentication Required PHP -

i working in restricted network/limited access internet. since have use proxy make web service call. here php code calling web service , response . $client = new soapclient("http: //www.xyz.com/abc/wsdls/login.wsdl", array("trace" => 1, "exceptions" => 1, 'proxy_host' => $proxy_host, 'proxy_port' => $proxy_port, 'proxy_login' => $proxy_login, 'proxy_password' => $proxy_password)); response is fatal error: uncaught soapfault exception: [wsdl] soap-error: parsing wsdl: couldn't load ' http://www.xyz.com/abc/wsdls/login.wsdl ' : failed load external entity if copy url error message , paste in browser(with same proxy settings) works. 2nd scenario is, if pass values instead of variables giving me diffarant response $client = new soapclient("http: //www.xyz.com/abc/wsdls/login.wsdl", array("trace" => 1, "exceptions" => 1, 'proxy_host' ...
Read more

c# - Resource not found error -

i have problem accessing method on homecontroller. show code of method : [httpget] public actionresult decriptidentifiantetredirige(string login_crypter, string mdp_crypter) { string loginacrypter = _globalmanager.protegemotdepasse(login_crypter); string mdpacrypter = _globalmanager.protegemotdepasse(mdp_crypter); user userapp = new models.user(login_crypter, mdp_crypter); if (userapp.authentificationvalidee(userapp.userlogin, userapp.password)) { session["name"] = userapp.userlogin; return redirecttoaction("accueil", "home"); } else { return redirecttoaction("validerauthentification", "home"); } } then in routeconfig.cs wrote route : routes.maproute( name: "authentificationapresdecryptage", url: "{controller}/{action}/{login_crypter}/{mdp_crypter}", defaults: new...
Read more