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 wri
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 si
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 san
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 vi
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 tunneled
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
Ok..
So 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 im
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:
USE
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; SELE
Matthew Tedder wrote:
Ok,
So I’ve been reading up on unixODBC. I cannot use the GUI tools since
the server is headless.. So I referred to:
http://www.unixodbc.org/odbcinst.html
It seems to say I need /etc/odbc.ini but also /etc/odbcinst.ini and a
“template” file somewhere that looks almost
10 matches
Mail list logo
