I'me having the error The OLE DB provider "MSDASQL" has not been registered.
for the OPENROWSET command :
select * from
OPENROWSET(  'MSDASQL',  'Driver={Microsoft Text Driver (*.txt; *.csv)};

I am running SQL Server 2k version 8.00 on one pc (A) on a lan, and SQL
Express 2005 version 9.0
on another (B). I can see the 2k server on A from Management Studio Express
on B but not the other way round.

I am running SQL Server 2000 sp4 in local mode on my laptop.  I have some
other software which uses 1433 to access SQL.  Remember this is all running
locally on a laptop.  Port 1433 is being blocked.  I have both the Windows
Firewall and the Mcaffee Firewalls disabled.

I'm unable to make connection to my sql2000 instance, I tried to
search the knowledge base on msdn and failed with their solutions
(defining alias).
Can you give me some advice on this ?

We have some legacy processes written in C with embedded SQL. They were
compiled with MSSQL2000 libraries and used db-lib for database connections.
After the database was upgraded to MSSQL2005, they could still make the
connection. Recently we have applied MSSQL2005 service pack ...

I have these lines repeated many times, every 1 second, in the error log:
Login failed for user 'user'
Login failed for user 'sa'
Login failed for user 'root'

I am using the latest SQL 2005 JDBC Driver 1.1 to connect to run a query.
When I try to get the date value from the result set using
rs.getDate("beginDate") it always returns to me the first day of the year.  
For example, it should return "2006-12-31" but is returning ...

Hi, I have SQL 2005 developer edition on my laptop. I am wondering if it is
possible to work with databases created for sql express edition. What I mean,
is that I have VS 2005, I created a Personal web site starter kit. The wizard
creates database files in the app_data directory ...

I need the following lines:
SELECT DISTINCT CLIREAL FROM VENTAS WHERE CLIREAL NOT IN (SELECT CODE FROM
CLIENTES)
UNION

How do I disable in sql server ----- ansi quote identifiers in sql server.
ansi nulls, padding, warnings.
I set up an ODBC connection If I turn these off --- doesn't work , It works
it tehy are checked.

I'm having troubles brining up details of existing SQL Jobs from remote
server. When I double-click existing job, it brings up "New Job" dialog box
instead of job details.
I needed to see and modify steps of a job on my collegue's machine. I can

I have a VB6 application that has MSDE as its current backend.  In
testing moving to SLSQLExpress I've noticed, since this application is
run on laptops, that if I disconnect the network cable while I'm in
the VB6 app I lose "connection" to the database. If I end task on the

Perplexed...Why am I able to get a connection to my SQL Server from an
Access 2003 database via DSN linked SQL server db table without a
common protocol between the client and server?  Could it be that the
client does have TCP/IP or Named Pipes enabled but they are just not

       I have one SQL Server 2000 that has been installed into a domain,
having allowed "Windows and SQL Server" authentication and using as
connectivity options Named Pipes and TCP/ip - 1433
        On every client computer that is also a domain member I can set up

I have installed sql server 2005 express on a Windows xp system with windows
authentification. I did this with my administrator account (dan). When i
start sql server management studio, i see: user name: myserver\dan .
Now i want to create a new login, so i rightclick on 'logins' ...