I need to work with an SQL Server database at work, and I decided to give
dbman a try.  The DB is set up as a System DSN, so I loaded dbman, clicked
on the “…” to select a data source, and selected the data source from the
list (there is no UID or password, as it uses Windows authentication).

Clicking on “Test” in dbman gets me “Connecting to … Success”.

Clicking on “OK” gets me a wdhandler message:

“error in: f_ok_button
index error: ddschtbl
  2   {“1 dat

I can access the database with odbc inside J using code like

load'dd'
ch=: ddcon 'dsn=DSM;modifysql=0'
sh=: 'select …;' ddsel ch
r=: ddfet sh,10
ddend sh
dddis ch

and get reasonable answers.

I tried ‘find in files’ for ddschtbl, and I see both its definition in
ddx.ijs and its later use in dbman.ijs.  I’m not sure what it’s doing,
though; can someone give me a mental shortcut?  Anyone have any idea what
might cause an error like this or how to fix it?

I did ‘find in files’ on ds_select, because that’s what seems to be the
immediate cause of the error in f_ok_button (I assume it calls ddschtbl at
some point) and found

c:\program files\j602\addons\data\dbman\selds.ijs (2)
  d=. >{.(0".ds_select){DS
  d=. {.(0".ds_select){DS

I didn’t see where ds_select was defined, though, so I couldn’t trace it
back.  I figure I’m missing something obvious.

Thanks,

Bill

PS: I sent this a moment ago, but I think it looked as if it came from a
different address and was thus blocked.  I hope this works and the other
failed; forgive me if you see two identical queries.

----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm

Reply via email to