I'm trying to execute a procedure through linked server using 4 part names.
The Linked server is configured for PRC and RPCout .
Still I get this message... What Am I Missing...
Could not execute procedure on remote server because SQL Server is not

I tried to set up and .adp with SQL 2005 but got the message that Access 2003
would not allox me to save any modifications of my .adp
Am I missing something or is Access 2003 not yet compatible with SQL 2005
CTP September.

I have two SQl Servers
SQL Server A is on Windows XP
SQL Server B is on Windows 2003 Server
Using Enterprise manager i try to register Server B on Server A and am

   Using Visual Basic can you assign a resultant recordset to an array
without looping through the number or returned records and fields.
   Dim strArray() as String
   Dim rs As ADODB.Recordset

Login failed for user 'sa'. Reason: Not associated with a trusted SQL
Server connection. (severity 14)
I am beating my head against a wall.
My server setup was working fine with php4 on another machine so i can

Hi;
I have put a sample program, output, DB contents, etc. at
http://www.windward.net/jdbc_unicode.zip
When I call ResultSet.getString() it returns the ? char for any unicode

       I got an extremely serious problem with SQL Server 2000 now. Without
it, I couldn't start SQL and continue my programming work in SQL CE(I need
both). Please kindly give me some help concerning the problem below:
1. When my pc starts, sometimes the SQL Server and the SQL ...

I have a late requirement from de Security Department.
This is the situation: the apps must connect to SQL Server 2000 through OLE
DB using a generic user, but the developers will not know its credentials
(at least the password)

I have a question regarding a certain behavior of updateable
resultsets. If I update a column using any of the updateXXX methods and
then try to use the getXXX methods from the same column to see if it
updated the results locally and not on the server, I get the same old

I have been using SQL for a while using TCP/IP server side network utility
only, but suddenly it seems that I am unable to connect to SQL.
Checking most of the related posiblities (TCP/IP Protocol ...Etc...) I was
unable to resolve the connection problem.

I am having a SQL connectivity issue (Query Analyzer or Enterprise
Manager connection) - from specifically one server to another.  Lets
just call them ServerA and ServerB.  I cannot connect from ServerA to
ServerB in either QA or EM.  BUT, I can be on any other SQL server box

   I am currently using ORACLE 9i but I am trying to move to SQL server.
Below is my code,  I am getting very strenge error, I can retrieve all the
data from database, but when I do .Edit(), the code crashes. Eventhough, I
am opening the recordset dynaset, it still does not let me ...