I would like to connect to MSAccess 2003 database from a SQL 2005 database.  
I tried using Linked Server but it will not work as my MSAccess database is
on a different server.
I am also trying to use OpenDataSource but I am getting an error.

I just bought a book that I thought was about the SQL query language. Turns out it's
really about mySQL. Uh.
What is the difference between query language for mySQL and MS SQL? Is there a good
reference?

SQL 2005, sp1 on win 2003, sp1.
while starting a named instance, getting error :
ERROR : The Service did not respond to start or control request in a timely
fashion.

I have a Sql Server 7 running on a webserver. Now I have a quite complicated
query that I run on 4 ways.
1: Using ODBC-driver directly on the Sql Server. time to execute: 12 seconds
(done this about 10 times)

I hope someone here can advise or at least point me to a good site to
pursue this.
Have installed a password protection system (freeware) successfully on
a unix/php/mysql server and looking forward to developing it into a

Question - I have a little app that uses the ODBC Bulk Operations and DB-Lib
bcp functions to load data into a table from variables (bcp_sendrow).  It
works great on SQL 2000, but I'm encountering some problems on SQL 6.5.
Basically on the SQL 6.5 box the bcp_init function is ...

I have 2 nodes SQL Server 2005 Ent. 64 bit SP1 cluster on Win2003 R2 Ent. I
would like to connect via SSIS to an Oracle DB. I don't get any Oracle data
providers on the list of providers. When I try to use one of the MS providers
like MS OLE DB for Oracle I get "Oracle client and ...

We are writing a Java stand-alone program and need to connect to a SQL
server 7.0 database.
I can't find any drivers to connect to the database. There are very few
which are in the market with interoperability with MS SQL Server7.0. The rest

I think I have done my homework and research on this. I'm in a company
Intranet and through Enterprise Manager, I have added the server I want to
access (FES89TXNCEV501) in my server group. I can access the that server and
open a view on that server (read only).

ok heres the scenario.
I have my SQL2000 server on a Windows 2003 and its also on a AD2003 domain
I have another server with is Windows 2003 and it was on the AD2003 domain
but I had to put it in a workgroup for security reasons.  Now my server cant

I'm having trouble getting a new linked server to work.
Server Mfr is 2005 Dev (sp1) and is the 'local' server.
Server Krypton is 2000 EE sp3 and is the target server I need to link to and
query.

Hi...
On a remote server, I have SQL 2005 installed as the default instance as
well as a new named instance.
From SQLCMD, I can connect to both instances.  However, from Management

I need to combine data from two different tables on two MS SQL servers
running on the same LAN into a single SELECT or VIEW.  Is this possible and
what would the syntax look like?
Thanks,

I would appreciate any help I can get.  I'm no expert at ASP or SQL, but
I've done a little research and I feel like I'm doing things right.
I'm getting the following error message from my ASP page.
Microsoft OLE DB Provider for SQL Server error '80004005'

I have two Windows virtual servers hosted by Linux -- one running SQL
Server 2000 and the other trying to connect to it via JDBC. Are there
any issues related to running a JDBC driver under a virtual windows
server?