Click here to Skip to main content
15,893,588 members
Home / Discussions / COM
   

COM

 
AnswerRe: Error handling using HRESULT PinPopular
Stephen Hewitt23-Mar-10 21:36
Stephen Hewitt23-Mar-10 21:36 
AnswerRe: Error handling using HRESULT Pin
KarstenK6-Apr-10 21:27
mveKarstenK6-Apr-10 21:27 
QuestionCom Exe server Pin
ashish8patil21-Mar-10 20:28
ashish8patil21-Mar-10 20:28 
AnswerRe: Com Exe server Pin
KingsGambit21-Mar-10 23:09
KingsGambit21-Mar-10 23:09 
GeneralRe: Com Exe server Pin
ashish8patil22-Mar-10 4:11
ashish8patil22-Mar-10 4:11 
GeneralRe: Com Exe server Pin
KingsGambit22-Mar-10 20:36
KingsGambit22-Mar-10 20:36 
AnswerRe: Com Exe server Pin
Adam Roderick J24-Mar-10 19:36
Adam Roderick J24-Mar-10 19:36 
Questionhow to connection to a remote sql server via ado? [modified] Pin
kcynic20-Mar-10 23:43
kcynic20-Mar-10 23:43 
I want to connect to the sql server database and do some query command via ado. I use this connection string to do that work:"Provider=SQLOLEDB;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=DaDian2008;Data Source=localhost;UID=sa;PWD=123456;Network Library=dbmssocn", it works well. But how about with a remote server(LAN). For example, my ip address is 192.168.1.100, i just replace localhost to 192.168.1.100, it would get an exception says:

Code = 80004005
Code meaning = Unspecified error
Source = Microsoft OLE DB Provider for SQL Server
Description = [DBNETLIB][ConnectionOpen (Connect()).]Specified SQL server not found.

Why? And how can i connect to a remote sql server(MS SQL Server within LAN)?

btw, if I use "Driver={SQL Server};Server=192.168.1.100;Address=192.168.1.100,1433;Network=DBMSSOCN;User ID=sa;PWD=123456;Database=DaDian2008; Then, I can connect to the database on my locale computer, but it would fail again on another computer.
modified on Sunday, March 21, 2010 9:16 AM

AnswerRe: how to connection to a remote sql server via ado? Pin
T21024-Apr-10 20:49
T21024-Apr-10 20:49 
QuestionGIT CPU usage Pin
marko201019-Mar-10 15:13
marko201019-Mar-10 15:13 
QuestionQuestion on Regcomplus.exe Pin
Simon Mandy19-Mar-10 8:44
Simon Mandy19-Mar-10 8:44 
QuestionDrag and drop shell extension blocking explorer.exe Pin
Sebastien Mongrain19-Mar-10 8:15
Sebastien Mongrain19-Mar-10 8:15 
QuestionIDispatch Pin
trioum18-Mar-10 2:23
trioum18-Mar-10 2:23 
AnswerRe: IDispatch Pin
Stephen Hewitt20-Mar-10 22:08
Stephen Hewitt20-Mar-10 22:08 
AnswerRe: IDispatch Pin
Cool_Dev21-Mar-10 23:59
Cool_Dev21-Mar-10 23:59 
GeneralRe: IDispatch Pin
trioum26-Mar-10 7:57
trioum26-Mar-10 7:57 
GeneralRe: IDispatch Pin
Cool_Dev27-Mar-10 2:55
Cool_Dev27-Mar-10 2:55 
GeneralRe: IDispatch Pin
trioum16-Apr-10 21:26
trioum16-Apr-10 21:26 
GeneralRe: IDispatch Pin
Cool_Dev17-Apr-10 22:47
Cool_Dev17-Apr-10 22:47 
GeneralRe: IDispatch Pin
trioum18-Apr-10 19:29
trioum18-Apr-10 19:29 
GeneralRe: IDispatch Pin
Cool_Dev19-Apr-10 19:34
Cool_Dev19-Apr-10 19:34 
GeneralRe: IDispatch Pin
trioum20-Apr-10 0:54
trioum20-Apr-10 0:54 
GeneralRe: IDispatch Pin
Cool_Dev20-Apr-10 3:06
Cool_Dev20-Apr-10 3:06 
GeneralRe: IDispatch Pin
trioum20-Apr-10 3:18
trioum20-Apr-10 3:18 
GeneralRe: IDispatch Pin
trioum20-Apr-10 20:47
trioum20-Apr-10 20:47 

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.