Show Posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
61
ODBC / ODBC / Linked Server
« on: February 08, 2022, 09:37:04 AM »
Hello All,
We are trying to attempt is to set up a linked server in SQL as a read only to pull data from a Pxplus database. The linked server is an ODBC type using the 5.20 64 bit driver and we can see all the tables but we cannot query anything. Using Excel we are able to pull data using the same odbc connection but SQL locks up all users and does nothing. The SQL server is in Azure and we are using SSMS to access the connection. We have tried this before with the same result on older versions of SQL both 3.50 64 bit and the 4.21.1 32 bit. Has anyone ever been able to get linked server to work in SQL or is it just not compatible?
thanks
jeff
We are trying to attempt is to set up a linked server in SQL as a read only to pull data from a Pxplus database. The linked server is an ODBC type using the 5.20 64 bit driver and we can see all the tables but we cannot query anything. Using Excel we are able to pull data using the same odbc connection but SQL locks up all users and does nothing. The SQL server is in Azure and we are using SSMS to access the connection. We have tried this before with the same result on older versions of SQL both 3.50 64 bit and the 4.21.1 32 bit. Has anyone ever been able to get linked server to work in SQL or is it just not compatible?
thanks
jeff
62
ODBC / Re: Getting a View to Show ODBC
« on: January 21, 2022, 03:02:05 PM »
Hi Devon,
Thank you that worked but my excel is locking up trying to query the View.
I tried it with another view that someone else created and I had same issue.
Small Views seem to work fine.
I think I might have to just make an interim file.
thanks for you help though.
Thank you that worked but my excel is locking up trying to query the View.
I tried it with another view that someone else created and I had same issue.
Small Views seem to work fine.
I think I might have to just make an interim file.
thanks for you help though.
63
ODBC / Getting a View to Show ODBC
« on: January 21, 2022, 01:32:21 PM »
Hi List,
I'm trying to start using Views to make complex file linking easier for our customers. I'm having trouble getting the Views to display in my ODBC DSN. I see the views dll...i dont have that filled in...can someone give me some pointers.
jeff
I'm trying to start using Views to make complex file linking easier for our customers. I'm having trouble getting the Views to display in my ODBC DSN. I see the views dll...i dont have that filled in...can someone give me some pointers.
jeff
64
Language / Re: Error in Character Editor
« on: January 10, 2022, 12:21:46 PM »
Hi Mike,
I'm running in Terminal Services but removing the +2 fixed it...
i just wanted to make sure i wasnt going to break anything...
thank you ...
i hope i'm not the only person left still using character editor ....
jeff
I'm running in Terminal Services but removing the +2 fixed it...
i just wanted to make sure i wasnt going to break anything...
thank you ...
i hope i'm not the only person left still using character editor ....
jeff
65
Language / Re: Error in Character Editor
« on: January 10, 2022, 12:10:18 PM »
Hi Mike,
version 17
mxc(0)=249
mxl(0)=59
i think the 249 is causing the problem....
version 17
mxc(0)=249
mxl(0)=59
i think the 249 is causing the problem....
66
Language / Error in Character Editor
« on: January 10, 2022, 11:06:42 AM »
Hi All,
I know I should use GUI editor but I like some features in the character editor...but I cannot save programs in Character editor.
I get an error 41 at line 5039
5039 print 'textwdw'(-200,-200,mxc(0)+2,mxl(0)+2,'CS'),
i do have a bigger monitor...does anyone know how i can fix this?
thanks
jeff
I know I should use GUI editor but I like some features in the character editor...but I cannot save programs in Character editor.
I get an error 41 at line 5039
5039 print 'textwdw'(-200,-200,mxc(0)+2,mxl(0)+2,'CS'),
i do have a bigger monitor...does anyone know how i can fix this?
thanks
jeff
67
ODBC / Crystal Reports SAP/PxPlus ODBC Driver Error 3 Tables
« on: October 19, 2021, 11:04:36 AM »
Hello All
I have a client that does the following using Crystal and PxPlus ODBC Driver:
-> Links Order Header to Order Lines (works fine)
-> Links Order Lines to Inventory Master (works fine)
-> Links Order Header to Order Lines and Order Lines to Inventory Master (fails)
I don't know if it is a Crystal Problem or a PxPlus ODBC problem. Has anyone else had an issue like this
jeff
I have a client that does the following using Crystal and PxPlus ODBC Driver:
-> Links Order Header to Order Lines (works fine)
-> Links Order Lines to Inventory Master (works fine)
-> Links Order Header to Order Lines and Order Lines to Inventory Master (fails)
I don't know if it is a Crystal Problem or a PxPlus ODBC problem. Has anyone else had an issue like this
jeff
68
Nomads / Scrolling in a panel
« on: September 14, 2021, 04:55:08 PM »
Hello,
If i make panel resizable. Is there any way to get vertical and horizontal scroll bars on it...it is a tabbed panel.
i dont know if that is confounding things.
thanks
jeff
If i make panel resizable. Is there any way to get vertical and horizontal scroll bars on it...it is a tabbed panel.
i dont know if that is confounding things.
thanks
jeff
69
Language / Determine Viewer
« on: June 23, 2021, 02:38:28 PM »
Hello List,
When we open a printer - we can do the following
print fin(print_chan,"DEVICE") ! Determine Printer
If we open the *viewer* is there any sure fire way to determine that we have the Viewer Open
thanks
Jeff
When we open a printer - we can do the following
print fin(print_chan,"DEVICE") ! Determine Printer
If we open the *viewer* is there any sure fire way to determine that we have the Viewer Open
thanks
Jeff
70
Language / Re: Was Program Called
« on: June 16, 2021, 11:11:43 AM »
Hi Mike would this work if the called program was a few level deeps like this
run "TEST01"
perform "TEST02;GET_ORDER_NUMBER"
perform "TEST03;SEQUENCE_NUMBER_MAIN"
call "TEST03;GET_NEXT_SEQUENCE"
run "TEST01"
perform "TEST02;GET_ORDER_NUMBER"
perform "TEST03;SEQUENCE_NUMBER_MAIN"
call "TEST03;GET_NEXT_SEQUENCE"
71
Language / Was Program Called
« on: June 16, 2021, 10:53:39 AM »
Hi List
To determine if a program was called:
Thru the years, i've seen programs check tcb(13)<>0 but I have had problems with that.
Then i saw check tcb(20) but then I encountered programs called with no arguments.
Is there any sure fire fool proof way to know if a program was called.
jeff
To determine if a program was called:
Thru the years, i've seen programs check tcb(13)<>0 but I have had problems with that.
Then i saw check tcb(20) but then I encountered programs called with no arguments.
Is there any sure fire fool proof way to know if a program was called.
jeff
72
Off Topic / Re: Determining a Cell Provider
« on: May 21, 2021, 04:04:47 PM »
thank you Loren and Mike...so for years we've been texting people by just sending an email to something like this
4015551212@vtext.com
and it worked fine (but these are internal users and we know provider).....
i explained to customer that he is going to have to join a service and we'll use their api or the pxplus utility
i thought about just sending the email to all of them
att, sprint, verizon, tmobile, cricket, boost but i'll probably get blacklisted
4015551212@vtext.com
and it worked fine (but these are internal users and we know provider).....
i explained to customer that he is going to have to join a service and we'll use their api or the pxplus utility
i thought about just sending the email to all of them
att, sprint, verizon, tmobile, cricket, boost but i'll probably get blacklisted
73
Off Topic / Re: Determining a Cell Provider
« on: May 21, 2021, 01:31:09 PM »
Hi Mike,
Because I did not know it existed.
Thank you again.
I will check it out.
Because I did not know it existed.
Thank you again.
I will check it out.
74
Off Topic / Determining a Cell Provider
« on: May 21, 2021, 01:22:51 PM »
Hello List,
I have a client that wants to send texts from our software ...the only problem is that is in order for me to do it i need to attach the extension of the phone carrier like @vtext.com @att.text.com, does anyone at any of the divisions know of an api or something i can use that can tell me the extension of a phone carrier..i found a web site but i would love to do it programatically.
any help is appreciated...
thanks
jeff
I have a client that wants to send texts from our software ...the only problem is that is in order for me to do it i need to attach the extension of the phone carrier like @vtext.com @att.text.com, does anyone at any of the divisions know of an api or something i can use that can tell me the extension of a phone carrier..i found a web site but i would love to do it programatically.
any help is appreciated...
thanks
jeff
75
Programming / Re: Does PID Exist
« on: May 20, 2021, 10:59:08 AM »
Mike,
i just did something like that with tasklist but i used an interim text file.
that is much better...that will work perfect...
thank you !!!!
jeff
i just did something like that with tasklist but i used an interim text file.
that is much better...that will work perfect...
thank you !!!!
jeff