Click here to Skip to main content
14,980,370 members
Home / Discussions / Database
   

Database

 
AnswerRe: Simple Database design Pin
Victor Nijegorodov23-Sep-20 20:54
MemberVictor Nijegorodov23-Sep-20 20:54 
AnswerRe: Simple Database design Pin
Mycroft Holmes24-Sep-20 12:18
professionalMycroft Holmes24-Sep-20 12:18 
QuestionWhy does MySQL not convert dates before 2010-01-01? Pin
fd97507-Sep-20 2:35
professionalfd97507-Sep-20 2:35 
AnswerRe: Why does MySQL not convert dates before 2010-01-01? Pin
Jörgen Andersson7-Sep-20 4:18
professionalJörgen Andersson7-Sep-20 4:18 
GeneralRe: Why does MySQL not convert dates before 2010-01-01? Pin
fd97507-Sep-20 21:14
professionalfd97507-Sep-20 21:14 
AnswerRe: Why does MySQL not convert dates before 2010-01-01? Pin
ZurdoDev21-Sep-20 7:03
professionalZurdoDev21-Sep-20 7:03 
QuestionHow to use a FileInfo control to add a filename to an Access database Pin
rodgerm25-Aug-20 14:51
Memberrodgerm25-Aug-20 14:51 
AnswerRe: How to use a FileInfo control to add a filename to an Access database Pin
Richard MacCutchan25-Aug-20 21:16
mveRichard MacCutchan25-Aug-20 21:16 
QuestionDATABASE KEY Pin
Member 1492238425-Aug-20 0:42
MemberMember 1492238425-Aug-20 0:42 
AnswerRe: DATABASE KEY Pin
OriginalGriff25-Aug-20 0:45
mveOriginalGriff25-Aug-20 0:45 
AnswerRe: DATABASE KEY Pin
ZurdoDev31-Aug-20 9:45
professionalZurdoDev31-Aug-20 9:45 
AnswerRe: DATABASE KEY Pin
Eddy Vluggen24-Sep-20 8:12
professionalEddy Vluggen24-Sep-20 8:12 
QuestionAny recommendations ora 01722 ??? Pin
Mahmoud Mohammad23-Aug-20 23:26
MemberMahmoud Mohammad23-Aug-20 23:26 
AnswerRe: Any recommendations ora 01722 ??? Pin
Richard Deeming24-Aug-20 0:42
mveRichard Deeming24-Aug-20 0:42 
Questionsql server express 2014 named instance not connecting from outside network Pin
Member 1258438314-Aug-20 1:28
MemberMember 1258438314-Aug-20 1:28 
Hi,

I've install SQL Server Express 2014 named instance with mixed mode authentication.

one more SQL Server 2005 version installed with default instance and TCP port has been assigned 1433.

following error occurred
Server Name: .\sqlexpress
Error Number: 18456
Severity: 14
State: 1
Line Number: 65536
-I want to connect locally (with dot) but not able to connect, I also want to connect from outside network

-with static IP still getting the same problem.

following changes I've done

-remove dynamic TCP port from configuration manager ipall

-instead of dynamic port I've place static tcp port 1438 and 1440 both are listening

-try 1434 TCP port but SQL service not able start so I've change into 1438 and 1440.

-and same has been configured from firewall inbound and outbound rule.

--also tried through dbeaver to make connection but following error occurred
SQLEXPRESS,1438 failed. Error: "java.net.UnknownHostException: 103.87.24.38:3390: invalid IPv6 address". Verify the server and instance names and check that no firewall is blocking UDP traffic to port 1434. For SQL Server 2005 or later, verify that the SQL Server Browser Service is running on the host.


modified 14-Aug-20 7:40am.

AnswerRe: sql server express 2014 named instance not connecting from outside network Pin
Sandeep Mewara18-Aug-20 23:17
mvaSandeep Mewara18-Aug-20 23:17 
QuestionAny good tool (free) for DB Schema? Pin
Sandeep Mewara14-Aug-20 0:01
mvaSandeep Mewara14-Aug-20 0:01 
AnswerRe: Any good tool (free) for DB Schema? Pin
Richard MacCutchan14-Aug-20 1:44
mveRichard MacCutchan14-Aug-20 1:44 
GeneralRe: Any good tool (free) for DB Schema? Pin
Sandeep Mewara14-Aug-20 1:45
mvaSandeep Mewara14-Aug-20 1:45 
GeneralRe: Any good tool (free) for DB Schema? Pin
Jörgen Andersson14-Aug-20 3:24
professionalJörgen Andersson14-Aug-20 3:24 
GeneralRe: Any good tool (free) for DB Schema? Pin
Sandeep Mewara14-Aug-20 3:39
mvaSandeep Mewara14-Aug-20 3:39 
QuestionMS SQL Database Breach Pin
Otekpo Emmanuel13-Aug-20 4:03
MemberOtekpo Emmanuel13-Aug-20 4:03 
AnswerRe: MS SQL Database Bridge Pin
Richard MacCutchan13-Aug-20 4:14
mveRichard MacCutchan13-Aug-20 4:14 
GeneralRe: MS SQL Database Bridge Pin
Otekpo Emmanuel13-Aug-20 5:02
MemberOtekpo Emmanuel13-Aug-20 5:02 
AnswerRe: MS SQL Database Bridge Pin
Richard Deeming13-Aug-20 4:18
mveRichard Deeming13-Aug-20 4:18 

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.