Skip to main content
Question

Error table doesn't exists on PHP

  • March 25, 2020
  • 3 replies
  • 15 views

TheSkiin

Hello , I have a error about the table doesn't exist (but really exist) the selects works but the inserts and inputs not.
I'm using a pg_connect for that maybe is that the error, the connection works.
But show's me that error
Warning: pg_select(): Table 'rpt.home_sec' doesn't exists

3 replies

SruthiA
Forum|alt.badge.img+1
  • Participating Frequently
  • March 25, 2020

pg_connect is a postgreSQL command and not a vertica command. Could you please share your PHP Code? Please find the below documentation link which has more information on how to connect to vertica using PHP

https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/ConnectingToVertica/ClientPHP/QueryingTheDatabaseUsingPHP.htm


TheSkiin
  • Author
  • New Participant
  • March 25, 2020

@SruthiA Now I'm trying to make a conection with OBDC , I configurated de OBDC DSN on mi windows. but I don't understand were I need to configurate de obdc.ini https://www.vertica.com/docs/9.3.x/HTML/Content/Authoring/ConnectingToVertica/ClientPHP/ProgrammingPHPClientApplications.htm

And the conection show me error. I'm using xampp for the Apache.

Code:
<?php # Connect to the Database $dsn = "Vertica"; $conn = odbc_connect($dsn,'','') or die ("<br/>CONNECTION ERROR"); echo "

Connected with DSN: $dsn

"; odbc_close($conn); ?>

SruthiA
Forum|alt.badge.img+1
  • Participating Frequently
  • March 27, 2020

@TheSkiin Can you share me your odbc.ini for review?