Re: [AFMUG] Platypus Help

2017-11-14 Thread Chris Wright
If you do any kind of custom reports, the templates typically get wiped 
whenever you upgrade. Pretty amazing, actually.

 

Chris Wright

Network Administrator

 

From: Af [mailto:af-boun...@afmug.com] On Behalf Of Mike Hammett
Sent: Tuesday, November 14, 2017 10:09 AM
To: af@afmug.com
Subject: Re: [AFMUG] Platypus Help

 

*sigh* I finally got to someone else's PC and it became self-evident.









Somehow the server's IP changed, which is why no one would connect.





Somehow the one user I was working with lost their ODBC connection.





Now people can connect.





I heard there has been an issue getting reports, but I suppose more on that 
later.

 



-
Mike Hammett
 <http://www.ics-il.com/> Intelligent Computing Solutions
 <https://www.facebook.com/ICSIL>  
<https://plus.google.com/+IntelligentComputingSolutionsDeKalb>  
<https://www.linkedin.com/company/intelligent-computing-solutions>  
<https://twitter.com/ICSIL> 
 <http://www.midwest-ix.com/> Midwest Internet Exchange
 <https://www.facebook.com/mdwestix>  
<https://www.linkedin.com/company/midwest-internet-exchange>  
<https://twitter.com/mdwestix> 
 <http://www.thebrotherswisp.com/> The Brothers WISP
 <https://www.facebook.com/thebrotherswisp>  
<https://www.youtube.com/channel/UCXSdfxQv7SpoRQYNyLwntZg> 




  _  

From: "Darren Shea" <darr...@ecpi.com>
To: af@afmug.com
Sent: Tuesday, November 14, 2017 11:59:54 AM
Subject: Re: [AFMUG] Platypus Help

Mike,

 

On a Windows system, you’d find the ODBC config in “Windows Administrative 
Tools” -> ODBC Data Sources (32-bit). Look in the System DSN tab.

 

When I install the client, one of the earliest steps in the installation is 
configuring the server access – there is a Test Database Connection step that 
will tell you if the client machine can successfully connect to the database. 
If that’s good, then you should be fine.

 

When you launch the client software, does it ask which database you want to 
use, or does it go to the Platypus window with the Login dialog box?

 

 

 

n  Darren

 

From: Af [mailto:af-boun...@afmug.com] On Behalf Of Mike Hammett
Sent: Tuesday, November 14, 2017 11:50 AM
To: af@afmug.com
Subject: Re: [AFMUG] Platypus Help

 

On the client side, I don't see where the ODBC points to the server. Where do I 
find that?

I've successfully created a new user in SQL and got the client installed on the 
server to at least connect to the system. I don't have a Plat login, so I can't 
do anything there, but I got that far at least. I don't know how to check the 
clients are talking to the right place.



-
Mike Hammett
 <http://www.ics-il.com/> Intelligent Computing Solutions
 <https://www.facebook.com/ICSIL>  
<https://plus.google.com/+IntelligentComputingSolutionsDeKalb>  
<https://www.linkedin.com/company/intelligent-computing-solutions>  
<https://twitter.com/ICSIL> 
 <http://www.midwest-ix.com/> Midwest Internet Exchange
 <https://www.facebook.com/mdwestix>  
<https://www.linkedin.com/company/midwest-internet-exchange>  
<https://twitter.com/mdwestix> 
 <http://www.thebrotherswisp.com/> The Brothers WISP
 <https://www.facebook.com/thebrotherswisp>  
<https://www.youtube.com/channel/UCXSdfxQv7SpoRQYNyLwntZg> 




  _  

From: "Adam Moffett" <dmmoff...@gmail.com>
To: af@afmug.com
Sent: Tuesday, November 14, 2017 11:13:24 AM
Subject: Re: [AFMUG] Platypus Help

Tucows support is pretty responsive (assuming they're paying for it).

 

That said, the client is a front end for an MSSQL database.  If the MSSQL 
database is up and the client has the correct ODBC source set up, then that's 
like 90% of it.

 

 

 

-- Original Message --

From: "Mike Hammett" <af...@ics-il.net>

To: af@afmug.com

Sent: 11/14/2017 12:10:56 PM

Subject: [AFMUG] Platypus Help

 

Do any of you with experience with Platypus have a few minutes?

A client of mine has a down Platypus system and with my first experience with 
Platypus being a non-functional system, I'm not sure how a few things are 
supposed to work.



-
Mike Hammett
 <http://www.ics-il.com/> Intelligent Computing Solutions
 <https://www.facebook.com/ICSIL>  
<https://plus.google.com/+IntelligentComputingSolutionsDeKalb>  
<https://www.linkedin.com/company/intelligent-computing-solutions>  
<https://twitter.com/ICSIL> 
 <http://www.midwest-ix.com/> Midwest Internet Exchange
 <https://www.facebook.com/mdwestix>  
<https://www.linkedin.com/company/midwest-internet-exchange>  
<https://twitter.com/mdwestix> 
 <http://www.thebrotherswisp.com/> The Brothers WISP
 <https://www.facebook.com/thebrotherswisp>  
<https://www.youtube.com/channel/UCXSdfxQv7SpoRQYNyLwntZg> 




 

 



Re: [AFMUG] Platypus Help

2017-11-14 Thread Mike Hammett


*sigh* I finally got to someone else's PC and it became self-evident. 







Somehow the server's IP changed, which is why no one would connect. 




Somehow the one user I was working with lost their ODBC connection. 




Now people can connect. 




I heard there has been an issue getting reports, but I suppose more on that 
later. 



- 
Mike Hammett 
Intelligent Computing Solutions 

Midwest Internet Exchange 

The Brothers WISP 




- Original Message -

From: "Darren Shea" <darr...@ecpi.com> 
To: af@afmug.com 
Sent: Tuesday, November 14, 2017 11:59:54 AM 
Subject: Re: [AFMUG] Platypus Help 



Mike, 

On a Windows system, you’d find the ODBC config in “Windows Administrative 
Tools” -> ODBC Data Sources (32-bit). Look in the System DSN tab. 

When I install the client, one of the earliest steps in the installation is 
configuring the server access – there is a Test Database Connection step that 
will tell you if the client machine can successfully connect to the database. 
If that’s good, then you should be fine. 

When you launch the client software, does it ask which database you want to 
use, or does it go to the Platypus window with the Login dialog box? 



n Darren 



From: Af [mailto:af-boun...@afmug.com] On Behalf Of Mike Hammett 
Sent: Tuesday, November 14, 2017 11:50 AM 
To: af@afmug.com 
Subject: Re: [AFMUG] Platypus Help 


On the client side, I don't see where the ODBC points to the server. Where do I 
find that? 

I've successfully created a new user in SQL and got the client installed on the 
server to at least connect to the system. I don't have a Plat login, so I can't 
do anything there, but I got that far at least. I don't know how to check the 
clients are talking to the right place. 



- 
Mike Hammett 
Intelligent Computing Solutions 

Midwest Internet Exchange 

The Brothers WISP 




- Original Message -


From: "Adam Moffett" < dmmoff...@gmail.com > 
To: af@afmug.com 
Sent: Tuesday, November 14, 2017 11:13:24 AM 
Subject: Re: [AFMUG] Platypus Help 

Tucows support is pretty responsive (assuming they're paying for it). 



That said, the client is a front end for an MSSQL database. If the MSSQL 
database is up and the client has the correct ODBC source set up, then that's 
like 90% of it. 







-- Original Message -- 

From: "Mike Hammett" < af...@ics-il.net > 

To: af@afmug.com 

Sent: 11/14/2017 12:10:56 PM 

Subject: [AFMUG] Platypus Help 






Do any of you with experience with Platypus have a few minutes? 

A client of mine has a down Platypus system and with my first experience with 
Platypus being a non-functional system, I'm not sure how a few things are 
supposed to work. 



- 
Mike Hammett 
Intelligent Computing Solutions 

Midwest Internet Exchange 

The Brothers WISP 









Re: [AFMUG] Platypus Help

2017-11-14 Thread Adam Moffett
I haven't used Plat in 3 years, but I thought when you opened the client 
there was a drop down where you could select an ODBC connection.
One thing I remember pretty clearly is if you run the installer for the 
client there's a place in the setup wizard to add the server IP, SQL 
user, etc.



-- Original Message --
From: "Mike Hammett" <af...@ics-il.net>
To: af@afmug.com
Sent: 11/14/2017 12:50:12 PM
Subject: Re: [AFMUG] Platypus Help

On the client side, I don't see where the ODBC points to the server. 
Where do I find that?


I've successfully created a new user in SQL and got the client 
installed on the server to at least connect to the system. I don't have 
a Plat login, so I can't do anything there, but I got that far at 
least. I don't know how to check the clients are talking to the right 
place.




-
Mike Hammett
Intelligent Computing Solutions <http://www.ics-il.com/>
<https://www.facebook.com/ICSIL> 
<https://plus.google.com/+IntelligentComputingSolutionsDeKalb> 
<https://www.linkedin.com/company/intelligent-computing-solutions> 
<https://twitter.com/ICSIL>

Midwest Internet Exchange <http://www.midwest-ix.com/>
<https://www.facebook.com/mdwestix> 
<https://www.linkedin.com/company/midwest-internet-exchange> 
<https://twitter.com/mdwestix>

The Brothers WISP <http://www.thebrotherswisp.com/>
<https://www.facebook.com/thebrotherswisp>


<https://www.youtube.com/channel/UCXSdfxQv7SpoRQYNyLwntZg>

From: "Adam Moffett" <dmmoff...@gmail.com>
To: af@afmug.com
Sent: Tuesday, November 14, 2017 11:13:24 AM
Subject: Re: [AFMUG] Platypus Help

Tucows support is pretty responsive (assuming they're paying for it).

That said, the client is a front end for an MSSQL database.  If the 
MSSQL database is up and the client has the correct ODBC source set up, 
then that's like 90% of it.




-- Original Message --
From: "Mike Hammett" <af...@ics-il.net>
To: af@afmug.com
Sent: 11/14/2017 12:10:56 PM
Subject: [AFMUG] Platypus Help


Do any of you with experience with Platypus have a few minutes?

A client of mine has a down Platypus system and with my first 
experience with Platypus being a non-functional system, I'm not sure 
how a few things are supposed to work.




-
Mike Hammett
Intelligent Computing Solutions <http://www.ics-il.com/>
<https://www.facebook.com/ICSIL> 
<https://plus.google.com/+IntelligentComputingSolutionsDeKalb> 
<https://www.linkedin.com/company/intelligent-computing-solutions> 
<https://twitter.com/ICSIL>

Midwest Internet Exchange <http://www.midwest-ix.com/>
<https://www.facebook.com/mdwestix> 
<https://www.linkedin.com/company/midwest-internet-exchange> 
<https://twitter.com/mdwestix>

The Brothers WISP <http://www.thebrotherswisp.com/>
<https://www.facebook.com/thebrotherswisp>


<https://www.youtube.com/channel/UCXSdfxQv7SpoRQYNyLwntZg>


Re: [AFMUG] Platypus Help

2017-11-14 Thread Darren Shea
Mike,

 

On a Windows system, you’d find the ODBC config in “Windows Administrative 
Tools” -> ODBC Data Sources (32-bit). Look in the System DSN tab.

 

When I install the client, one of the earliest steps in the installation is 
configuring the server access – there is a Test Database Connection step that 
will tell you if the client machine can successfully connect to the database. 
If that’s good, then you should be fine.

 

When you launch the client software, does it ask which database you want to 
use, or does it go to the Platypus window with the Login dialog box?

 

 

 

n  Darren

 

From: Af [mailto:af-boun...@afmug.com] On Behalf Of Mike Hammett
Sent: Tuesday, November 14, 2017 11:50 AM
To: af@afmug.com
Subject: Re: [AFMUG] Platypus Help

 

On the client side, I don't see where the ODBC points to the server. Where do I 
find that?

I've successfully created a new user in SQL and got the client installed on the 
server to at least connect to the system. I don't have a Plat login, so I can't 
do anything there, but I got that far at least. I don't know how to check the 
clients are talking to the right place.



-
Mike Hammett
 <http://www.ics-il.com/> Intelligent Computing Solutions
 <https://www.facebook.com/ICSIL>  
<https://plus.google.com/+IntelligentComputingSolutionsDeKalb>  
<https://www.linkedin.com/company/intelligent-computing-solutions>  
<https://twitter.com/ICSIL> 
 <http://www.midwest-ix.com/> Midwest Internet Exchange
 <https://www.facebook.com/mdwestix>  
<https://www.linkedin.com/company/midwest-internet-exchange>  
<https://twitter.com/mdwestix> 
 <http://www.thebrotherswisp.com/> The Brothers WISP
 <https://www.facebook.com/thebrotherswisp>  
<https://www.youtube.com/channel/UCXSdfxQv7SpoRQYNyLwntZg> 




  _  

From: "Adam Moffett" <dmmoff...@gmail.com>
To: af@afmug.com
Sent: Tuesday, November 14, 2017 11:13:24 AM
Subject: Re: [AFMUG] Platypus Help

Tucows support is pretty responsive (assuming they're paying for it).

 

That said, the client is a front end for an MSSQL database.  If the MSSQL 
database is up and the client has the correct ODBC source set up, then that's 
like 90% of it.

 

 

 

-- Original Message --

From: "Mike Hammett" <af...@ics-il.net>

To: af@afmug.com

Sent: 11/14/2017 12:10:56 PM

Subject: [AFMUG] Platypus Help

 

Do any of you with experience with Platypus have a few minutes?

A client of mine has a down Platypus system and with my first experience with 
Platypus being a non-functional system, I'm not sure how a few things are 
supposed to work.



-
Mike Hammett
 <http://www.ics-il.com/> Intelligent Computing Solutions
 <https://www.facebook.com/ICSIL>  
<https://plus.google.com/+IntelligentComputingSolutionsDeKalb>  
<https://www.linkedin.com/company/intelligent-computing-solutions>  
<https://twitter.com/ICSIL> 
 <http://www.midwest-ix.com/> Midwest Internet Exchange
 <https://www.facebook.com/mdwestix>  
<https://www.linkedin.com/company/midwest-internet-exchange>  
<https://twitter.com/mdwestix> 
 <http://www.thebrotherswisp.com/> The Brothers WISP
 <https://www.facebook.com/thebrotherswisp>  
<https://www.youtube.com/channel/UCXSdfxQv7SpoRQYNyLwntZg> 




 



Re: [AFMUG] Platypus Help

2017-11-14 Thread Mike Hammett
On the client side, I don't see where the ODBC points to the server. Where do I 
find that? 

I've successfully created a new user in SQL and got the client installed on the 
server to at least connect to the system. I don't have a Plat login, so I can't 
do anything there, but I got that far at least. I don't know how to check the 
clients are talking to the right place. 




- 
Mike Hammett 
Intelligent Computing Solutions 

Midwest Internet Exchange 

The Brothers WISP 




- Original Message -

From: "Adam Moffett" <dmmoff...@gmail.com> 
To: af@afmug.com 
Sent: Tuesday, November 14, 2017 11:13:24 AM 
Subject: Re: [AFMUG] Platypus Help 


Tucows support is pretty responsive (assuming they're paying for it). 


That said, the client is a front end for an MSSQL database. If the MSSQL 
database is up and the client has the correct ODBC source set up, then that's 
like 90% of it. 






-- Original Message -- 
From: "Mike Hammett" < af...@ics-il.net > 
To: af@afmug.com 
Sent: 11/14/2017 12:10:56 PM 
Subject: [AFMUG] Platypus Help 





Do any of you with experience with Platypus have a few minutes? 

A client of mine has a down Platypus system and with my first experience with 
Platypus being a non-functional system, I'm not sure how a few things are 
supposed to work. 




- 
Mike Hammett 
Intelligent Computing Solutions 

Midwest Internet Exchange 

The Brothers WISP 









Re: [AFMUG] Platypus Help

2017-11-14 Thread Mike Hammett
I have no idea if they're paying for it. 




- 
Mike Hammett 
Intelligent Computing Solutions 

Midwest Internet Exchange 

The Brothers WISP 




- Original Message -

From: "Adam Moffett" <dmmoff...@gmail.com> 
To: af@afmug.com 
Sent: Tuesday, November 14, 2017 11:13:24 AM 
Subject: Re: [AFMUG] Platypus Help 


Tucows support is pretty responsive (assuming they're paying for it). 


That said, the client is a front end for an MSSQL database. If the MSSQL 
database is up and the client has the correct ODBC source set up, then that's 
like 90% of it. 






-- Original Message -- 
From: "Mike Hammett" < af...@ics-il.net > 
To: af@afmug.com 
Sent: 11/14/2017 12:10:56 PM 
Subject: [AFMUG] Platypus Help 





Do any of you with experience with Platypus have a few minutes? 

A client of mine has a down Platypus system and with my first experience with 
Platypus being a non-functional system, I'm not sure how a few things are 
supposed to work. 




- 
Mike Hammett 
Intelligent Computing Solutions 

Midwest Internet Exchange 

The Brothers WISP 









Re: [AFMUG] Platypus Help

2017-11-14 Thread Adam Moffett

Tucows support is pretty responsive (assuming they're paying for it).

That said, the client is a front end for an MSSQL database.  If the 
MSSQL database is up and the client has the correct ODBC source set up, 
then that's like 90% of it.




-- Original Message --
From: "Mike Hammett" <af...@ics-il.net>
To: af@afmug.com
Sent: 11/14/2017 12:10:56 PM
Subject: [AFMUG] Platypus Help


Do any of you with experience with Platypus have a few minutes?

A client of mine has a down Platypus system and with my first 
experience with Platypus being a non-functional system, I'm not sure 
how a few things are supposed to work.




-
Mike Hammett
Intelligent Computing Solutions <http://www.ics-il.com/>
<https://www.facebook.com/ICSIL> 
<https://plus.google.com/+IntelligentComputingSolutionsDeKalb> 
<https://www.linkedin.com/company/intelligent-computing-solutions> 
<https://twitter.com/ICSIL>

Midwest Internet Exchange <http://www.midwest-ix.com/>
<https://www.facebook.com/mdwestix> 
<https://www.linkedin.com/company/midwest-internet-exchange> 
<https://twitter.com/mdwestix>

The Brothers WISP <http://www.thebrotherswisp.com/>
<https://www.facebook.com/thebrotherswisp>


<https://www.youtube.com/channel/UCXSdfxQv7SpoRQYNyLwntZg>

[AFMUG] Platypus Help

2017-11-14 Thread Mike Hammett
Do any of you with experience with Platypus have a few minutes? 

A client of mine has a down Platypus system and with my first experience with 
Platypus being a non-functional system, I'm not sure how a few things are 
supposed to work. 




- 
Mike Hammett 
Intelligent Computing Solutions 

Midwest Internet Exchange 

The Brothers WISP