Program_name empty using SqlConnect

[intec]

When I use de function SqlConnect on Centura 4.1 to connect my app on a SQL server. I have to see the program_name field on the dbo.sysprocesses table, but the datum it's empty.
Any setting or command Existsto perform this information?

Thank you in advance
Best regards

[Jeff Luther]

Intec: note I moved your msg. to the "Older" section, since you are using CTD v4.1.

As to your question, let me ask internally about this.

[Jeff Luther]

I did hear back from the router/DB developer who wrote that:

There is no TD reason this wouldn’t work. SqlServer works in 4.1 [and was certified for MS SS per the matrix table for TD 2005.1:
http://www.guptatechnologies.com/Produc ... atrix.aspx ]

Possibilities:
• Most likely: The field is actually NULL. Has he tried the query in SQL Management Studio?
See this http://www.bigresource.com/MS_SQL-syspr ... 3VwAI.html .
[Have him try] selecting a row in TD from the same table “where program_name = NULL”? That would tell him if it is.

• He doesn’t have permission on the table (unlikely -- I’d expect him to see an error in this case).

That's all the info. I have.

[intec]

Thank you the fast reply.

I read the information attached, but I can advance that: the value of Program_name it's empty but not NULL, then I can see the whole row (isn't a permission issue) , the result set show me rows with Program_name value for each app in the sysprocesses without count those internal process.

the sysprocesses table work like a system monitor, where I can see the Procces Id, Host name, program name and misc.
In the SQLConnect case, the value of Program_name isn't null, only null string, (not null datum, only '') ,



For example, I excecute

select * from master.dbo.sysprocesses


I try to know the way for have the program_name field some value when I connect to a SQL server Database, for monitory the Server Activity.



Thank you in advance
Best Regards

[Jeff Luther]

What's the version of MS SS? Also, do you have another TD version you can try? If so, can you see program_name in that.

the value of Program_name it's empty but not NULL

?? how do you know?