Click here to Skip to main content
14,327,370 members
   

Database

 
AnswerRe: In Access: group of records and assign conditional group ? Pin
Chris Quinn28-Mar-19 1:55
memberChris Quinn28-Mar-19 1:55 
QuestionSQL Remote Connections Pin
Kevin Marois18-Mar-19 8:00
professionalKevin Marois18-Mar-19 8:00 
AnswerRe: SQL Remote Connections Pin
Richard Deeming18-Mar-19 9:35
mveRichard Deeming18-Mar-19 9:35 
GeneralRe: SQL Remote Connections Pin
Kevin Marois18-Mar-19 10:02
professionalKevin Marois18-Mar-19 10:02 
GeneralRe: SQL Remote Connections Pin
Richard Deeming19-Mar-19 1:57
mveRichard Deeming19-Mar-19 1:57 
GeneralRe: SQL Remote Connections Pin
Kevin Marois18-Apr-19 8:16
professionalKevin Marois18-Apr-19 8:16 
GeneralMessage Closed Pin
22-Mar-19 21:10
memberMember 1419297522-Mar-19 21:10 
AnswerRe: SQL Remote Connections Pin
jschell23-Mar-19 6:01
memberjschell23-Mar-19 6:01 
Presuming you are NOT using named pipes and in fact the server is remote (different box) then the way to test connectivity is as follows.
1. Log in to the client box
2. Use telnet to access the other box
3. If telnet works then you have connectivity. If not then no connectivity.

To use telnet you must have the 'host' (name or ip) and the 'port'. Telnet doesn't need to do anything other than connect. That is the entire test.

If you do NOT have connectivity then one or more of the following is true
1. host is wrong
2. port is wrong
3. server is not up
4. server is not configured for the port you used (but see 1.)
5. Network is blocking traffic. This can include firewalls.

If you do have connectivity then you have an incorrect assumption. For example your test used the wrong host/port or your application is using the wrong host/port.


Kevin Marois wrote:
For some reason I can no longer connect.


If it fact this is true. It worked at the install site and no longer does, then it suggests something changed in the install. For example
1. Configuration changed
2. Someone changed the stack. For example installed or changed a firewall.

Don't forget the always wildly popular - the server just simply is not running.
QuestionHelp with simple database Pin
Member 1418292514-Mar-19 13:14
memberMember 1418292514-Mar-19 13:14 
AnswerRe: Help with simple database Pin
Richard MacCutchan14-Mar-19 23:06
protectorRichard MacCutchan14-Mar-19 23:06 
AnswerRe: Help with simple database Pin
Eddy Vluggen14-Mar-19 23:17
mveEddy Vluggen14-Mar-19 23:17 
AnswerRe: Help with simple database Pin
Mycroft Holmes15-Mar-19 12:49
memberMycroft Holmes15-Mar-19 12:49 
PraiseRe: Help with simple database Pin
Peter_in_278015-Mar-19 14:20
professionalPeter_in_278015-Mar-19 14:20 
GeneralRe: Help with simple database Pin
Mycroft Holmes15-Mar-19 14:57
memberMycroft Holmes15-Mar-19 14:57 
QuestionOracle database USER and SCHEMA [SOLVED] Pin
Valentinor11-Mar-19 9:16
memberValentinor11-Mar-19 9:16 
AnswerRe: Oracle database USER and SCHEMA Pin
CHill6012-Mar-19 22:45
protectorCHill6012-Mar-19 22:45 
GeneralRe: Oracle database USER and SCHEMA Pin
Valentinor13-Mar-19 1:30
memberValentinor13-Mar-19 1:30 
GeneralRe: Oracle database USER and SCHEMA Pin
CHill6013-Mar-19 2:23
protectorCHill6013-Mar-19 2:23 
GeneralRe: Oracle database USER and SCHEMA Pin
Valentinor13-Mar-19 3:04
memberValentinor13-Mar-19 3:04 
AnswerRe: Oracle database USER and SCHEMA Pin
Eddy Vluggen13-Mar-19 0:59
mveEddy Vluggen13-Mar-19 0:59 
QuestionDisplaying multiple rows into single row as columns based on id - Sql Server Pin
Member 111541886-Mar-19 20:18
memberMember 111541886-Mar-19 20:18 
SuggestionRe: Displaying multiple rows into single row as columns based on id - Sql Server Pin
CHill606-Mar-19 21:47
protectorCHill606-Mar-19 21:47 
AnswerRe: Displaying multiple rows into single row as columns based on id - Sql Server Pin
Victor Nijegorodov6-Mar-19 21:52
memberVictor Nijegorodov6-Mar-19 21:52 
GeneralRe: Displaying multiple rows into single row as columns based on id - Sql Server Pin
Member 111541886-Mar-19 23:24
memberMember 111541886-Mar-19 23:24 
AnswerRe: Displaying multiple rows into single row as columns based on id - Sql Server Pin
Richard Deeming6-Mar-19 22:08
mveRichard Deeming6-Mar-19 22:08 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.