Hi,
I have a linked server connection from SQL SERVER 2000 to Sybase
11.9.2 and can see all the tables and views in sybase database. But,
when I try to access a table from MSSQL SQL query analyser it is not
able to access one single table and gives the following error....
I am a newbie in SQL2000. Please help.
Server: Msg 7356, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' supplied inconsistent metadata for a column.
Metadata information was changed at execution time.
Regards
Subhas
3  7159  db************@ yahoo.com (Subhas) wrote in message news:<d7******* *************** ***@posting.goo gle.com>... Hi,
I have a linked server connection from SQL SERVER 2000 to Sybase
11.9.2 and can see all the tables and views in sybase database. But,
when I try to access a table from MSSQL SQL query analyser it is not
able to access one single table and gives the following error....
I am a newbie in SQL2000. Please help.
Server: Msg 7356, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' supplied inconsistent metadata for a column.
Metadata information was changed at execution time.
Regards
Subhas
I don't know what's causing the error, but I would check that you have
the latest servicepacks and ODBC/MDAC versions.
Simon
Did you get it working?
Regards,
David Penney http://www.metamatrix.com
"Subhas" <db************ @yahoo.com> wrote in message
news:d7******** *************** **@posting.goog le.com... Hi,
I have a linked server connection from SQL SERVER 2000 to Sybase
11.9.2 and can see all the tables and views in sybase database. But,
when I try to access a table from MSSQL SQL query analyser it is not
able to access one single table and gives the following error....
I am a newbie in SQL2000. Please help.
Server: Msg 7356, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' supplied inconsistent metadata for a column.
Metadata information was changed at execution time.
Regards
Subhas
Did you get it working?
Regards,
David Penney http://www.metamatrix.com
"Subhas" <db************ @yahoo.com> wrote in message
news:d7******** *************** **@posting.goog le.com... Hi,
I have a linked server connection from SQL SERVER 2000 to Sybase
11.9.2 and can see all the tables and views in sybase database. But,
when I try to access a table from MSSQL SQL query analyser it is not
able to access one single table and gives the following error....
I am a newbie in SQL2000. Please help.
Server: Msg 7356, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' supplied inconsistent metadata for a column.
Metadata information was changed at execution time.
Regards
Subhas This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Andreas Lauffer |
last post by:
I changed from Access97 to AccessXP and I have immense performance
problems.
Details:
- Access XP MDB with Jet 4.0 ( no ADP-Project )
- Linked Tables to SQL-Server 2000 over ODBC
I used the SQL Profile to watch the T-SQL-Command which Access ( who
creates the commands?) creates and noticed:
|
by: pheonix1t |
last post by:
hello,
I'm trying to create a linked server from an SQL2000 to a Unify ELS
(very old, odbc is version 1) database on SCO unix.
The odbc driver is old but it works fine when used by applications for
creating reports.
What I want to do is make a linked server from the SCO box to the win2k
box. So, I'm using enterprise manager to create the...
|
by: Bretl Andy |
last post by:
Hi All,
I am close before throwing the machine out of the window.
I tried to establish a linked server on our SQL2000 server pointing to a DB.
EXEC sp_addlinkedserver
@server = 'DB2',
@srvproduct = 'IBM OLE DB Provider for DB2 Servers',
@provider = 'IBMDADB2',
@provstr='DSN=JDE_PROD;UID=XXXX;PWD=XXX;DATABASE=JDE_PROD;'
|
by: TBlair |
last post by:
I am about to start working on a project where I would be required to
dynamically create linked servers during the execution of an
application. One of the requirements is for the Link Servers to be
created and dropped before and after the retrieval of the data. My
question is about any type of cap on the number of linked servers SQL
Server...
|
by: vorpal |
last post by:
Hi,
I have successfully set and used a linked server to query ADSI.
Since this question also concerns MSSQLServer, I've cross posted it --
I hope this is not a breach of etiquette.
I have successly created a view based on the linked server.
Unfortunately, it only shows 1000 records, and there does not seem to
be any way to set the Page...
| | |
by: arichie |
last post by:
Can anyone point me where can I find a good architectural document on
how the Linked server works in SQL Server. I am not asking about how to
use Linked server, I am interested in know how it is defined and
architected.
Our project needs a data transfer from SQL server database to the
Oracle database, I am trying to find out whether can we...
|
by: Bill J. |
last post by:
I have to update a PostgreSQL linked server through MSSQL2K.
I first configured the connection with ODBC as follows and I can do queries
with no problem:
EXEC sp_droplinkedsrvlogin @rmtsrvname = 'PostgreSQL', @locallogin = NULL
GO
EXEC sp_DropServer 'PostgreSQL'
GO
|
by: Bill J. |
last post by:
I have to update a PostgreSQL linked server through MSSQL2K.
I first configured the connection with ODBC as follows and I can do queries
with no problem:
EXEC sp_droplinkedsrvlogin @rmtsrvname = 'PostgreSQL', @locallogin = NULL
GO
EXEC sp_DropServer 'PostgreSQL'
GO
|
by: tim.pascoe |
last post by:
I've been trying to work with Linked Servers for the first time, with
mixed success. My problem right now is in trying to write a View using
a linked server. The linked server is another SQL-Server, and it was
set up using the 'Enterprise Manager' interface. When the server was
created, the name was given as the full server address -...
|
by: Bret Kuhns |
last post by:
I recently started a co-op/internship at a company and they are
looking to migrate a large legacy supported application from OLEDB to
SQL Server. I'm doing prelim work in experimenting with the options
available. The application is huge (1+ million lines of C++ code), so
it'd be quite a bit of man hours to adapt all the database code for
SQL...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
| | |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |
