Click here to Skip to main content
15,867,453 members
Home / Discussions / Database
   

Database

 
Questionrecords with their row numbers in a table Pin
indian14325-Feb-07 4:25
indian14325-Feb-07 4:25 
AnswerRe: records with their row numbers in a table Pin
Colin Angus Mackay25-Feb-07 4:37
Colin Angus Mackay25-Feb-07 4:37 
GeneralRe: records with their row numbers in a table Pin
indian14325-Feb-07 18:35
indian14325-Feb-07 18:35 
GeneralRe: records with their row numbers in a table Pin
xfitr226-Feb-07 8:28
xfitr226-Feb-07 8:28 
QuestionHow To Do The Recursive Table Within My Appliaction? Pin
jasyGerges25-Feb-07 2:05
jasyGerges25-Feb-07 2:05 
AnswerRe: How To Do The Recursive Table Within My Appliaction? Pin
JUNEYT25-Feb-07 12:02
JUNEYT25-Feb-07 12:02 
QuestionReporting Services - online page count vs printed count Pin
pnslcs25-Feb-07 2:01
pnslcs25-Feb-07 2:01 
QuestionError when connection to the Server... vb.net 2005 ? [modified] Pin
kindman_nb24-Feb-07 22:52
kindman_nb24-Feb-07 22:52 
Hi ..
the project is running ok ,, after only one pc restart ,, when I reRun the project the new message Is appear :

an error has occured while estaplishing a conneciton to the server ...

I use the next connection to the server ..
Public SqlCon As SqlConnection = New SqlConnection(" workstation id=localhost; Password=123; packet size=4096;user id=sa;data source=PcServer;Network=DBMSSOCN;persist security info=False; persist security info=False; initial catalog=DataB ")

that connection is working on the network as good ..

when I change the connection to be :
Public SqlCon As SqlConnection = New SqlConnection("workstation id=DESKTOP;Password=123; packet size=4096;user id=sa;integrated security=SSPI;data source=PcServer;persist security info=False;initial catalog=DataB;")

the project is running as good ..

i'm Confused | :confused: why .. the first connection was good , and it solved the problem of running the program on the LAN ,,
the second connection can't work on the LAN,,
now what can I do ,, If I use the seconed connectoin the program willn't work on the LAN ,,

it's sure that there're alot of programmers may have faced a poroblem like that >>
Frown | :( (


I founded that When I add Network=DBMSSOCN to the connection string the project can't run ..



-- modified at 5:01 Sunday 25th February, 2007

jooooo

AnswerRe: Error when connection to the Server... vb.net 2005 ? Pin
WoutL1-Mar-07 2:43
WoutL1-Mar-07 2:43 
Questionsql connectivity Pin
vishal dhir24-Feb-07 21:07
vishal dhir24-Feb-07 21:07 
AnswerRe: sql connectivity Pin
Hesham Amin26-Feb-07 0:48
Hesham Amin26-Feb-07 0:48 
QuestionTo avoid aborting of transaction, on failure of trigger in Oracle Pin
Mushtaque Nizamani24-Feb-07 19:16
Mushtaque Nizamani24-Feb-07 19:16 
AnswerRe: To avoid aborting of transaction, on failure of trigger in Oracle Pin
andyharman25-Feb-07 23:41
professionalandyharman25-Feb-07 23:41 
QuestionGetting AutoNumber from last inserted row (C++)? Pin
MasterShin24-Feb-07 7:33
MasterShin24-Feb-07 7:33 
AnswerRe: Getting AutoNumber from last inserted row (C++)? Pin
Hesham Amin24-Feb-07 7:46
Hesham Amin24-Feb-07 7:46 
GeneralRe: Getting AutoNumber from last inserted row (C++)? Pin
MasterShin24-Feb-07 7:52
MasterShin24-Feb-07 7:52 
GeneralRe: Getting AutoNumber from last inserted row (C++)? Pin
Hesham Amin25-Feb-07 7:01
Hesham Amin25-Feb-07 7:01 
Questionarray parameter Pin
illusionFinder23-Feb-07 22:22
illusionFinder23-Feb-07 22:22 
AnswerRe: array parameter Pin
Harini N K24-Feb-07 1:02
Harini N K24-Feb-07 1:02 
QuestionQuery to Display records from 20 to 30 from total of 100 records Pin
indian14323-Feb-07 18:05
indian14323-Feb-07 18:05 
AnswerRe: Query to Display records from 20 to 30 from total of 100 records Pin
Hesham Amin24-Feb-07 7:29
Hesham Amin24-Feb-07 7:29 
AnswerRe: Query to Display records from 20 to 30 from total of 100 records Pin
Atif Ali Bhatti26-Feb-07 0:24
Atif Ali Bhatti26-Feb-07 0:24 
GeneralRe: Query to Display records from 20 to 30 from total of 100 records Pin
indian14326-Feb-07 0:35
indian14326-Feb-07 0:35 
QuestionMs access-how to get the difference between two time fields Pin
jeya krishnan.v23-Feb-07 17:37
jeya krishnan.v23-Feb-07 17:37 
AnswerRe: Ms access-how to get the difference between two time fields Pin
Hesham Amin24-Feb-07 7:31
Hesham Amin24-Feb-07 7:31 

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.