Search found 8 matches

Thanks for your help, that indeed solved my issue.

I do not enter any value in the 'station' column. I also leave it empty for messages sent to a single recipient, and it works.

I have a problem when trying to send a message to a group.

From a 3rd party application, I'm writing directly into the 'messages' table of PageGate DB. When the receiver is a simple user, everything works as expected. But when the user is member of a group, I receive the following error message in Scheduler logs: "Message rejected for recipient: xxx in group: test_group. Interface not enabled for this recipient"

When I send a message to that group from PageGate Admin, it works. What interface should I enable in order for this to work?

Thanks.

So after multiple attempts, I managed to get the PG Admin started. The problem is I had to use an User DSN, instead of a System DSN. In the ODBC Administrator tool, it now shows my data source as 32/64-bit platform, which wasn't possible to have for System data sources.

Having this setup, the PG Admin seems to work correctly, and the data in stored into the SQL Server DB.

I have 64-bit SQL Server, 64-bit MS Access, and when I try to select the data source in MS Access it only displays the ones on 64-bit, and the User DSN which has 32/64-bit as platform.

Is there a 64-bit version for PageGate?

Indeed, I have configured the data source for 64-bit because the MS Access works on 64-bit, and it displays only those data sources. When I configured the driver for 32-bit, it didn't show up in the data sources list.

I'll try to find a way to view the 32-bit data sources in MS Access, and get back to you. Thanks

No, I cannot. I receive the connection error message, but this time it's "in Procedure: send_form send Program Halted".

I already tried with the 'Save password' checkbox marked, and when I open the two tables in MS Access it doesn't ask for the authentication password. But the error when running PageGate Admin is still present.

What I noticed during all the attempts is that when I have only the 'messages' table linked, I can start PG Admin, but when the 'users' table is linked too, I can't pass that error window.

I am currently trying to get the PageGate MS Access DB linked with SQL Server.

I generated the SQL Server corresponding tables for messages and users, and linked them from MS Access. When I open them in MS Access, I am able to view the records, and perform read/write operations.
The issue I have is when trying to open PageGate Admin. I keep getting the following fatal error window:
"Excessive database errors: 3151 ODBC--conection to 'pgdatabase' failed. in Procedure: treeform load Program Halted"

I believe that PageGate Admin doesn't know my SQL Server authentication ID and password, but I can't figure out where I can edit them. If I remove the linked tables from the PageGate Database, the Admin application starts correctly.

Any suggestions are welcomed, thanks.

Author	Message
Topic: Message written directly to DB
AndR3X Replies: 4 Views: 11910	Forum: PageGate Support Posted: Wed Nov 12, 2014 2:47 am Subject: Message written directly to DB
AndR3X Replies: 4 Views: 11910	Thanks for your help, that indeed solved my issue.
Topic: Message written directly to DB
AndR3X Replies: 4 Views: 11910	Forum: PageGate Support Posted: Mon Nov 10, 2014 12:37 pm Subject: Message written directly to DB
AndR3X Replies: 4 Views: 11910	I do not enter any value in the 'station' column. I also leave it empty for messages sent to a single recipient, and it works.
Topic: Message written directly to DB
AndR3X Replies: 4 Views: 11910	Forum: PageGate Support Posted: Mon Nov 10, 2014 12:05 pm Subject: Message written directly to DB
AndR3X Replies: 4 Views: 11910	I have a problem when trying to send a message to a group. From a 3rd party application, I'm writing directly into the 'messages' table of PageGate DB. When the receiver is a simple user, everything works as expected. But when the user is member of a group, I receive the following error message in Scheduler logs: "Message rejected for recipient: xxx in group: test_group. Interface not enabled for this recipient" When I send a message to that group from PageGate Admin, it works. What interface should I enable in order for this to work? Thanks.
Topic: SQL Server integration
AndR3X Replies: 8 Views: 34561	Forum: Integration Related Questions Posted: Wed Oct 08, 2014 3:13 am Subject: SQL Server integration
AndR3X Replies: 8 Views: 34561	So after multiple attempts, I managed to get the PG Admin started. The problem is I had to use an User DSN, instead of a System DSN. In the ODBC Administrator tool, it now shows my data source as 32/64-bit platform, which wasn't possible to have for System data sources. Having this setup, the PG Admin seems to work correctly, and the data in stored into the SQL Server DB. I have 64-bit SQL Server, 64-bit MS Access, and when I try to select the data source in MS Access it only displays the ones on 64-bit, and the User DSN which has 32/64-bit as platform. Is there a 64-bit version for PageGate?
Topic: SQL Server integration
AndR3X Replies: 8 Views: 34561	Forum: Integration Related Questions Posted: Tue Oct 07, 2014 11:55 am Subject: SQL Server integration
AndR3X Replies: 8 Views: 34561	Indeed, I have configured the data source for 64-bit because the MS Access works on 64-bit, and it displays only those data sources. When I configured the driver for 32-bit, it didn't show up in the data sources list. I'll try to find a way to view the 32-bit data sources in MS Access, and get back to you. Thanks
Topic: SQL Server integration
AndR3X Replies: 8 Views: 34561	Forum: Integration Related Questions Posted: Tue Oct 07, 2014 10:07 am Subject: SQL Server integration
AndR3X Replies: 8 Views: 34561	No, I cannot. I receive the connection error message, but this time it's "in Procedure: send_form send Program Halted".
Topic: SQL Server integration
AndR3X Replies: 8 Views: 34561	Forum: Integration Related Questions Posted: Tue Oct 07, 2014 9:22 am Subject: SQL Server integration
AndR3X Replies: 8 Views: 34561	I already tried with the 'Save password' checkbox marked, and when I open the two tables in MS Access it doesn't ask for the authentication password. But the error when running PageGate Admin is still present. What I noticed during all the attempts is that when I have only the 'messages' table linked, I can start PG Admin, but when the 'users' table is linked too, I can't pass that error window.
Topic: SQL Server integration
AndR3X Replies: 8 Views: 34561	Forum: Integration Related Questions Posted: Tue Oct 07, 2014 3:35 am Subject: SQL Server integration
AndR3X Replies: 8 Views: 34561	I am currently trying to get the PageGate MS Access DB linked with SQL Server. I generated the SQL Server corresponding tables for messages and users, and linked them from MS Access. When I open them in MS Access, I am able to view the records, and perform read/write operations. The issue I have is when trying to open PageGate Admin. I keep getting the following fatal error window: "Excessive database errors: 3151 ODBC--conection to 'pgdatabase' failed. in Procedure: treeform load Program Halted" I believe that PageGate Admin doesn't know my SQL Server authentication ID and password, but I can't figure out where I can edit them. If I remove the linked tables from the PageGate Database, the Admin application starts correctly. Any suggestions are welcomed, thanks.