I'm trying to import to SqlServer(2000) from a Sybase ODBC(12) connection. I
can use the Sybase connection with appps like MSAcess, and Crystal reports,
but I can't get SqlServer to use that same ODBC connection to Sybase. I get
"no provider exits for this connection on this ...

I want the following query to result in "2004/10".
SELECT DATEPART(yyyy, datein) & '/' & DATEPART(mm, datein) AS theDate
From myTable
However, I get the error:

I have a column in a table defined as Char(1).  I'm trying to map it in
a call to SQLBindParameter using:
sql type = SQL_CHAR
native type = SQL_C_CHAR

I have a client machine running VS.Net 2003, using TCP/IP to connect to a
server running SQL Server 2000 Developer. The first time I connect to the
server it always takes 15 seconds. Subsequent work on the server is very
quick but that first 15 seconds is extremely painful. It ...

I have a client machine running VS.Net 2003, using TCP/IP to connect to a
server running SQL Server 2000 Developer. The first time I connect to the
server it always takes 15 seconds. Subsequent work on the server is very
quick but that first 15 seconds is extremely painful. It ...

I have a client machine running VS.Net 2003, using TCP/IP to connect to a
server running SQL Server 2000 Developer. The first time I connect to the
server it always takes 15 seconds. Subsequent work on the server is very
quick but that first 15 seconds is extremely painful. It ...

a user of my lan has windows xp installed (sp1 first now sp2). He works with
access 2002 and wants to link to some sqlserver tables.
when he creates a new odbc connection to that sqlserver he gets  the
following error message:

SQL - 2000 running on Win2k Server
I am unable to view my databases in enterprise manager but can see them in Query Analyzer/ODBC.  I had deleted a bunch of unused databases last night and after reboot this morning Enterprise manager will not display any of my databases.  What ...

We are trying to connect to an Oracle Server via MSSQL Enterprise Manager so
that we are able to query both the Oracle & SQL Database, can anybody tell me
if this is possible and how to do it??
I have followed the instructions in Q280106 and this does not appear to show

I have just imported into SQL server all of my Access 2000 tables. In my
front end Access app, I now am using linked tables to access the data in the
SQL server db.
The speed isn't the greatest.

we have an customer trying to run our app. after installation. They get the
error messeage: Login failed for user skdomain/skuser.
Our app uses ADO.NET and the database is MS SQL Server. The program and sql
server is installed on a separate server. To run the app. they have 8

I have set up FileMaker 7 trial and FileMaker Server 7 trial on my Windows
2003 server pc. I have installed DataDirect SequeLink 4.5 ODBC driver.
The problem is, when I try to actually create a datasource, in this case on
the local machine, I get the following error when I try to ...

I want to add an SQL Server 2000 to the list of linked servers of an sql
server 7 in order to run distributed queries.
I used sp_addlinkedserver and also sp_addlinkedsrvlogin, both with no error
but trying to execute a distributed query returns the following error:

At work, I've no problems connecting to our testserver. From home I have
problems. I use VPN to get inside our firewall, and everything else works as
expected. Whether I try to connect to my testdata from my application, or I
try to connect using SQL Query Analyzer, I get the same ...

I am trying to find information on the actual values for the fRequest
parameter needed for this API Call
I have looked in MSDN etc but cannot find the actualuu defs for the actual
values