Help newbie error vb6 connect to db2 8.2 Express

SoCalled · #1 (**permalink**) 12-02-05, 23:52

Okay am getting the following error...

Quote:

"ADMINISTRATOR.CATAGORY is an undefined name"

In this code block on the .open statement

Quote:

Set oCommand = New ADODB.Command
With oCommand
.CommandType = adCmdText
.ActiveConnection = oConnect
.CommandText = "SELECT * FROM CATAGORY"
End With
'

Set oRecordset = New ADODB.Recordset
oRecordset.Open oCommand, , adOpenStatic, adLockOptimistic
'
txtId = oRecordset.Fields("ID")
txtDescription = oRecordset.Fields("DESCRIPTION")

The table is CATAGORY and the db connection appears to be working. This is my first attempt at db2 and vb6 for that matter so go easy.

Thanks in advance.

db2guru1 · #2 (**permalink**) 12-03-05, 07:16

What is your schema? If you have used the default schema try qualifying the table like SELECT * FROM DB2ADMIN.CATEGORY

SoCalled · #3 (**permalink**) 12-03-05, 17:50

Hey thanks guru worked like a charm

For no apparent reason chose SQLJ (wasn't sure on which schema to use as am waiting on my IBM courses).

Expect a few more newbie questions as l am used to the IBM u2 databases, this is all new to me.

Once again thank you very much for your answer. This one is resolved, like a really resolved thing.

Internet Services

Web Development

Digital Marketing

Consumer Tech