Linked Server error - ODBC timeout
Fri, 18 Apr 2008 01:29:47 -0400
My MS Access app links to an SQL Server 2000 db which includes a linked
server.
A pass through query like "select * from linkedtable" works fine. But
"select * from linkedtable where linkedtablekey=1" fails - ODBC timeout
error.
The same thing happens when I try the queries in Query Analyzer.
This error ...
|
SQL Native Client vs SQL Server Driver
17 Apr 2008 09:25:02 -0500
I'm developing an application that must support connecting to SQL
Server 2005 as well as SQL Server 2000. Which driver should I use for
the connection?
1. Use SQL Native Client driver for both 2005 and 2000.
2. Use SQL Server driver for both 2005 and 2000.
3. Use SQL Native Client driver for 2005 and SQL Serv ...
|
Running a Job / Parse Issues
Tue, 15 Apr 2008 14:46:15 -0400
Hi All,
I'm having a problem with a job on an SQL 2000 Server that is linked to pull
data from an SQL 2005 server. When I enter my infromation into the Job Step
properties and parse the SQL, the system tells me it is fine. When I run
the code through query analyzer, it also works fine as well. However, w ...
|
sql odbc data source for windows me
Mon, 14 Apr 2008 15:10:03 -0700
Hi,
Thanks to anyone who can help.
We are in the process of renewing all our old Win Me clients, but this
cannot be done overnight and we have many old Me clients still attached to
the domain. Unfortunatley we suffered a server (SBS 2003 premium) crash and
rebuilt the server with SQL 2000 server. Before ...
|
SQL2005 y Oracle 9i
Mon, 14 Apr 2008 09:47:01 -0700
Hi
I have SQL2005 linked server to Oracle9i, but it does not work, I get this
error when I try to list Tables and Views from SSMS:
The OLE DB provider "MSDASQL" for linked server "ORACLEODBC03" reported an
error. Access denied.
Cannot obtain the required interface ("IID_IDBSchemaRowset") from OLE DB
prov ...
|
MSDAC OLEDB x64 drivers
Sat, 12 Apr 2008 12:39:00 -0700
Has anyone installed the new x64 drives for MS MSDAC OLEDB support? I dont
have a x64 dev server and didnt want to just run it on a prod system. Just
curious how its working or if anyone installed it yet.
--
Stan ...
|
Import help
Thu, 10 Apr 2008 08:36:48 -0400
We recently purchased a new SQL 2005 server that I need to import a DB from
another server. in order to connect to the "other" server I have to use a
3rd party thoroughbred odbc driver. On our old SQL2000 box to perform this
task I would select import and next to data source I could select the
thoroughbred d ...
|
|
|
help,a difficult text how to sql table code ?
Sat, 5 Apr 2008 15:32:51 -0700
help,a difficult text how to sql table code ?
i have a text as follow, line with ¡°|¡±and {LF},
8|-000000186075919.|+000000000387820.|2008-03-31|20010423|
9|-000000000003919.|-000000000123620.|2008-03-31|20010123|
8|-000000018623419.|+000000000381230.|2008-05-30|20010423|
i want to sign char(1)£¬ ...
|
miising oracle odbc data provider
Thu, 03 Apr 2008 09:07:40 -0700
Hi Gurus,
This is a question that I may have asked in the past on another forum I
think it was not the right forum well here goes... I have an instance of
sqlserver2005 64 bit and I need to be able to link it to an oracle 11g
server for the transfer of data
in all of the other instances there is an oracle l ...
|
Select "count" result on ONE line
Wed, 2 Apr 2008 11:21:00 -0700
I'm doing a "select count(*) from table_name" via ODBC. How can I get the
answer to be displayed in ONE line?
ex. select count(*) total_count from table_name
total_count
22
I need that "22" on the same line as the literal "total_count".
How can I do that? Thanks in advance! ...
|
