I have created a linked server for ORACLE.
I created a view in SQL Server using the linked server which has 40 million
records,
when I tried to do a select count(*) on this view it is showing just 200

I have a comupter with Vista x64 on it trying to connect to a XP SQL Server
Both PC's have their firewalls turned off and both can ping each other
But the connection will still not work
The connection is trying to be made through a 32 bit VB application using RDO

I have a new installation of SQL Server 2008 Dev. x64 install on a server.  
Management studio on the server where it is installed connect and functions
as expected.  When accessed from several other computers is gives an error
"Internal connection fatal error. (System.Data)".  It ...

Is there any setup needed in C:\windows\syswow64\odbcad32.exe for the
datasource to be initialized?
I've downloaded and installed MDAC for Office:
http://www.microsoft.com/downloads/details.aspx?FamilyID=7554F536-8C28-4598-9B72
-EF94E038C891&displaylang=en

Hi all,
When I unpacked our projects to my local computer. I rebuilt it and then run
it on my local computer.
But I got an innerexception, when I clicked to view details,

Using Windows authentication.
What are my choices?

I tried posting this in the Microsoft Small Business Accounting Forum and
have written to John Thuneby directly and have not received a response.
Since the problem appears to involve some sort of interaction between
Microsoft Office Accounting Professional(MOA) and SQL Express ...

Thanks in advance for any help.
I have the linked server(named AS400) set up and and I can execute the
following query from the SQL Server Management Studio and it works
perfectly.

I'm using this query via e vb ado.
note:
-all fields concerned in inner join are indexed.
-only that when launching the command via vb code to the query is slow (perhaps 3 or 5 minutes )!!!!!!!

Our product currently uses MS SQL JDBC driver 1.0.  We have recently tried
the 2.0 version, and have encountered occasional deadlock errors, typically
when using stored procedures, e.g.
com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 71)

I cannot connect remotely to SQL 2008 Server using Management studio using
SQL Server authentication. It does work with Windows Authentication. Also, I
cannot connect to SQL 2008 Server using a remote application and SQL
authentication.

We have an appliction that has been using the following code to connect to
sql server 2000 and sql server 2005.  However if the two database engines are
on the same system, I get the following error.  I have reinstalled the SQL
management tools over and over in addition to having ...

We are running Sql Server 2005 in a Windows Server 2003 environment.
I have been unable to create an SSIS package to copy four tables from an
Informix database; nor am I able to manually import from this DB.  This is a
DB created by Avaya and they gave me an OpenLink ODBC driver ...

i have a computer with a client app works fine and logon to SQL05 in
Domain1.  as soon as the computer is switch to a Domain2, i.e. change
workgroup to a different one, then, it will get error on name pipe and
authentication.  from the network, it seems sql server is trying to

I have a .dll which creates all of my ADO connections.  When used in a
compiled (.exe) application it connects to SQL 2005 just fine via TCP.  But
when I am using it in a application I am developing (ie in Debug Mode VS2005)
it won't connect unless I enable Named Pipes on SQL??