So the PHP odbc_connect() method seems to connect, because I get SQL errors.
Can anyone tell me how to at least select from these tables.. I created them
using isql like this:
USE studies;
CREATE TABLE studies ( ...);
But the following variations give SQL errors:
USE studies;
Matthew Tedder wrote:
So the PHP odbc_connect() method seems to connect, because I get SQL
errors.
Can anyone tell me how to at least select from these tables.. I
created them using isql like this:
USE studies;
CREATE TABLE studies ( …);
But the following variations give SQL errors:
Ok..
So qualifier is the database name (from USE studies; so it's
studies)?
I notice SELECT * FROM DB..studies; seems to say there's no such table
while SELECT * FROM studies..studies; gives a syntax error.
Of course, if studies..studies properly references a table then I
cannot
Hi, Matthew --
On Aug 6, 2010, at 08:42 AM, Matthew Tedder wrote:
So the PHP odbc_connect() method seems to connect, because I get SQL errors.
Can anyone tell me how to at least select from these tables.. I created them
using isql like this:
USE studies;
CREATE TABLE studies ( …);
I saw the interface on the earlier virtual machine implement I setup.. It's
very impressive.
This machine (our development environment) is headless and behind firewalls
and I normally ssh tunnel to get to it. However, I connected to an Ubuntu
machine in the same network via remote X (ssh
Matthew Tedder wrote:
I saw the interface on the earlier virtual machine implement I setup.. It's
very impressive.
This machine (our development environment) is headless and behind firewalls
and I normally ssh tunnel to get to it. However, I connected to an Ubuntu
machine in the same network
Actually,
Through PDO I got no errors and no results. So I have been trying the
odbc_connect() method, because at least I get errors to go on. I do usually
use PDO with mysql, postgresql, and mssql. It works fine with those.
I will look at those links you sent as soon as I go get a
HI Matthew,
It shows my database studies at the same level as DB, PUMP,
UDDI,
VAD, etc.
Clicking down to the tables, it shows them as: studies.DBA.studies
I used the default DBA account (for now). I didn't modify any
defaults of
installation from the tarball, to keep things simple.
Unbelievable.. That was it. It doesn't like the semicolon.
I tried excluding the semicolon a few times early on, but probably wasn't
addressing the table correctly.
Wow.. Humiliated again.
Well.. I'll have to work hard over the weekend.
Thank you so incredibly much. I will definitely