problem with dbload!
I have tried to load a file with two columns of ascii chars to my
informix table. This table name is ttable and it is located at testbase
in my testserver. Testserver and client are at same machine.
Now. I have made following command line:
FILE e:\\informixds\\bin\\testchars1.txt
chars1(1-5,
chars2 6-10);
INSERT INTO testtaulu (c1, c2)
VALUES (chars1, chars2);
I have used following dbload command:
dbload -d testbase -c testcommandfile -l lf
Dbload says: no connect permission, ISAM ERROR: no record found.
My NT - registry have correct values:
HKEY_LOCAL_MACHINE....SQLHOSTS\\testserver
default "testserver"
HOST "mypcname"
OPTIONS "x=testserver"
PROTOCOL "olsoctcp"
SERVICE "idunno"
at SETNET I have a following values:
ENVIRONMENT:
INFORMIXSERVER=testserver
INFORMIXSQLHOSTS=\\\\mypcname
SERVER INFORMATION
INFORMIX SERVER = testserver
Hostname = \\\\mypcname
protocolname = olsoctcp
Service name = idunno
options = x=testserver
PLEASE HELP!
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
The user (e.g. justerman) You are starting dbload with, is not allowed to
connect to the database.
Log in as informix (or who ever created the database) and do a
GRANT CONNECT TO justerman
using dbaccess or SQL-Editor.
Wolfgang
<justerman@my-deja.com> schrieb in im Newsbeitrag:
7kcuii$bml$1@nnrp1.deja.com...
> I have tried to load a file with two columns of ascii chars to my
> informix table. This table name is ttable and it is located at testbase
> in my testserver. Testserver and client are at same machine.
>
> Now. I have made following command line:
>
> FILE e:\\informixds\\bin\\testchars1.txt
>
> chars1(1-5,
> chars2 6-10);
>
> INSERT INTO testtaulu (c1, c2)
> VALUES (chars1, chars2);>
> I have used following dbload command:
>
> dbload -d testbase -c testcommandfile -l lf>
> Dbload says: no connect permission, ISAM ERROR: no record found.
>
> My NT - registry have correct values:
>
> HKEY_LOCAL_MACHINE....SQLHOSTS\\testserver
> default "testserver"
> HOST "mypcname"
> OPTIONS "x=testserver"
> PROTOCOL "olsoctcp"
> SERVICE "idunno"
>
> at SETNET I have a following values:
>
> ENVIRONMENT:
> INFORMIXSERVER=testserver
> INFORMIXSQLHOSTS=\\\\mypcname>
> SERVER INFORMATION
> INFORMIX SERVER = testserver
> Hostname = \\\\mypcname
> protocolname = olsoctcp
> Service name = idunno
> options = x=testserver
>
> PLEASE HELP!
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.