Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
adodb connecting to a server issues
I am trying to connect to a remote server using the string:
objconn.Open "driver=sql server;server=MYSERVER;database=MYDB;uid=MYUSER;pw d=MYPASSWD;" the connection works fine when it is on a machine that is currently logged in as a domain authenticated user. It seems though, if I try to connect with a machine logged in with a non-domain account it fails with the error: -2147467259 (80004005) Client unable to establish connection If I connect to a share on the data server prior to making the connection - all works well. any ideas how I can establish this connection with attaching to the server first? or any other work-arounds? thanks in advance - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
connecting to back end server | Excel Discussion (Misc queries) | |||
Excel 2003 Error Cannot Locate the Internet Server or Proxy Server | Excel Discussion (Misc queries) | |||
Runtime error 91 when connecting to SQL Server 2000 | Excel Programming | |||
problem updating link from Novell server to windows server #REF er | Excel Discussion (Misc queries) | |||
Excel Connecting to SQL Server Database - Need your Help | Excel Programming |