SQLSERVER 2005 X64 Linked Server To SQLSERVER 7.0
Jun 20, 2007
Hello people.
I am in the process of planning a server upgrade to sql2005 x64.
I created 2 linked servers: one to a SQL2000 sp4 server and one to a SQL7.0 SP3.
I have the following error when I query the linked servers.
OLE DB provider "SQLNCLI" for linked server "IVDM2K" returned message "Unspecified error".
OLE DB provider "SQLNCLI" for linked server "IVDM2K" returned message "The stored procedure required to complete this operation could not be found on the server. Please contact your system administrator.".
Msg 7311, Level 16, State 2, Line 1
Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider "SQLNCLI" for linked server "IVDM2K". The provider supports the interface, but returns a failure code when it is used.
I am aware of KB 906954.
http://support.microsoft.com/default.aspx?scid=kb;en-us;906954
I applied the instcat.sql on the SQL2000SP4 server and my linked server issues for that one are gone.
However, I ran the instcat.sql script on the SQL7.0 sp3 server and the linked server is still giving me an issue.
Can someone help me find a solution to this?
View 1 Replies
ADVERTISEMENT
Jun 20, 2007
Hi all!!!
I have the following problem:
I used JTDS to connect to SQL Server 2005 SP1(with Windows Authentication) from a Tomcat DataSource, using your usefull ntlmauth.dll, so I can use Users from Active Directory.
All is ok until I must call a Stored procedure that excecute queries from a linked server table.
I have the following exception message "Login failed for user 'NT AUTHORITYANONYMOUS LOGON'"
I make a lot of test, I make a Java main program invoking the sotred procedure that excecute queries on linked server using JTDS and then using Microsoft SQL Server 2005 JDBC Driver 1.2(April 2007)sqljdbc.jar and Ihave the same problem, but if we use the bridge JDBC-ODBC all works OK.
Please help!!
thanks
Lore
View 4 Replies
View Related
Sep 20, 2006
Hi experts;
I have a problem with unicode character 0x2300
I created this table
create table testunicode (Bez nchar(128))
Insert Data
insert into testunicode (Bez)values('Œ€„¢')
with 2 Unicode characters
Œ€ = 0x2300
„¢ = 0x2122
Selecting the data
select Bez from testunicode
I see
"?„¢"
„¢ = 0x2122 is ok but instead of 0x2300 there is 0x3f
When I modify the insert statement like that ( 8960 = 0x2300 )
insert into testunicode (Bez)values(NCHAR(8960)+'„¢')
and select again voila i see
"Œ€„¢"
Does anyone have an idea?
Thanks
View 1 Replies
View Related
Apr 18, 2008
I am trying to 'load' a copy of a SQLServer 2000 database to SQLServer 2005 Express (on another host). The copy was provided by someone else - it came to me as a MDF file only, no LDF file.
I have tried to Attach the database and it fails with a failure to load the LDF. Is there any way to bypass this issue without the LDF or do I have to have that?
The provider of the database says I can create a new database and just point to the MDF as the data source but I can't seem to find a way to do that? I am using SQL Server Management Studio Express.
Thanks!!
View 1 Replies
View Related
Jun 14, 2006
I have an app that uses a sqlserver 2000 jdbc driver to connect to a sqlserver 2000.
Is it possible to do a direct replacement of sqlserver 2000 with sqlserver 2005 express just by reconfiguring the app to point to the express? The app would still be using the sqlserver 2000 jdbc driver to try and make the connection.
If that is a possibility, what can be some differences in the configuration? Previously with 2000 the config information I entered is:
server name: "machinename"( or ip). I've also tried "machiname/SQLEXPRESS"
DB name: name of db instance
port: 1433(default)
user and pass.
My attempts so far results in
"java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket."
and
"java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Unable to connect. Invalid URL."
View 1 Replies
View Related
Feb 9, 2006
Hello,
I have an SQLServer Mobile database, and I would like to know if there is a way to upgrade it to SQLServer 2005 (.mdf) database. My database has no records in it, just the structure (tables etc). What I am actually asking is if I can create automatically a new SQLServer 2005 Database with the same structure as my existin SQLSErver Mobile database
Thanks in advance,
TassosTS
View 1 Replies
View Related
Apr 11, 2008
Hi
i am try to execute a command " SELECT * FROM [SQLSERVER].[DATABASENAME].[DBO].[TABLE] ".. but i am receiving a error message
Msg 7319, Level 16, State 1, Line 19
The OLE DB provider "SQLNCLI" for linked server "SQLSERVER" returned a "NON-CLUSTERED and NOT INTEGRATED" index "MSmerge_index_1348915877" with the incorrect bookmark ordinal 0.
but when i try to check the linked server it's shows me the linked is okay.. The following command i use to check wethare the link is fine or not..
CREATE TABLE #foo
(
pingResult SYSNAME NULL
);
INSERT #foo
EXEC master..xp_cmdshell
'ping SQLSERVER;
IF EXISTS
(
SELECT 1
FROM #foo
WHERE pingResult LIKE '%TTL%'
)
BEGIN
PRINT 'Feel free to use linked server.';
END
ELSE
BEGIN
PRINT 'Linked server not available.';
END
DROP TABLE #foo;
and Following result i receive..
(13 row(s) affected)
Feel free to use linked server.
Can any One tells me where i m making mistake or how can i resolve this problem
View 5 Replies
View Related
May 9, 2006
Hi every body,
I have SQLServer 2005 runs well for months and stop working after install SqlServer2005 SP1. I try to reinstall the SQLServer 2005 but I have problem when install work station component on my and the error is "There is a problem with this Windows Installer package. A program run as part of the setup did not finish as expected. Contact your support personnel or package vendor". Please help me to fix this bug. I do not want to reformat my machine.
John Dang
View 1 Replies
View Related
May 10, 2007
We have a static class that makes an HTTPWebRequest to get XML data from one of our vendors. We use this as input to a stored proc in SQLServer2005. When I compile this class and call it from a console application in visual studio it executes in milliseconds, everytime. When I compile it, create the assembly and clr function and execute it in SQLServer, it takes around 14 seconds to execute the first time, then on subsequent requests it is again really fast, until I wait for 10 seconds and re-execute, once again it is slow the first time and then fast on subsequent requests. We do not see this behavior when executing outside SQLServer. Makes me think that some sort of authentication is perhaps taking place the first time the function is run in SQLServer? I have no idea how to debug this further. Anyone seen this before or have any ideas?
Here is the class:
Code Snippet
using System;
using System.Collections.Generic;
using System.Text;
using System.Net;
using System.IO;
namespace Predict.Services
{
public static class Foo
{
public static string GetIntradayQuote(string symbol)
{
string returnQuote = "";
HttpWebRequest request = (HttpWebRequest)(WebRequest.Create("http://data.predict.com/predictws/detailed_quote.html?syms=" + symbol + "&fields=1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,28,30"));
request.Timeout = 1000;
HttpWebResponse response = (HttpWebResponse)(request.GetResponse());
StreamReader streamReader = new StreamReader(response.GetResponseStream());
returnQuote = streamReader.ReadToEnd();
streamReader.Close();
response.Close();
return returnQuote;
}
}
}
When I run call it from a console app it is fine.
I compile it into a dll and then create the assembly and function as follows:
Code Snippet
drop function fnTestGetIntradayQuoteXML_SJS
go
drop assembly TestGetIntradayQuoteXML_SJS
go
create ASSEMBLY TestGetIntradayQuoteXML_SJS from 'c:DataBackupsCLRLibrariesTestGetIntradayQuote_SJS.dll' WITH PERMISSION_SET = EXTERNAL_ACCESS
go
CREATE FUNCTION fnTestGetIntradayQuoteXML_SJS(@SymbolList nvarchar(max)) RETURNS nvarchar(max) AS EXTERNAL NAME TestGetIntradayQuoteXML_SJS.[Predict.Services.Foo].GetIntraDayQuote
go
declare @testing nvarchar(max)
set @testing = dbo.fnTestGetIntradayQuoteXML_SJS('goog')
print @testing
When I execute the function as above, again, really slow the first time, then fast on subsequent calls. Could there be something wrong with the code, or some headers that need to be set differently to operate from the CLR in SQLServer?
Regards,
Skipper.
View 1 Replies
View Related
Oct 12, 2004
:confused: Hallo! I'm trying to link a MySql 's DB in SQLServer with ODBC: the operation was susseful but I'm not able to read and write/update the data.
HELP ME PLEASE!!!
silvia, Italy
View 4 Replies
View Related
Jul 29, 2005
I'm chasing after a documetn that was available on one of the Microsoftwebsites that was titled somethign like "MS SQL Server Best Practices"and detailed a nyumber of best practices about securing the server.Included in this was revoking public access to the system tableobjects.Can someone post the URL where I can pick this up, or drop me a note oncontacting them for a copy of the document?
View 2 Replies
View Related
Apr 18, 2007
Regarding KB935356, is there a "post" service pack 2 update for SQLServer Express?
Thanks.
View 7 Replies
View Related
Jul 8, 2006
Hello Expert!
I have 2 Database €“ Access & SQLServer(ver 7)
I need to Import Data TblShift from Access to SQLServer €“ using DTS I€™ve done this successfully!
Now I want to use parameter so I only importing record within range (e.g. ShiftDate BETWEEN 05-24-2006 AND 06-23-2006)
In SQLServer, I have created table to store the date range as following:
TblParameter
DateFrom: 04/24/2006
DateTo: 05/23/2006
How do I use the date range from TblParameter(SQLServer) to import record from TblShift(Access) using DTS?
Is this possible or any better solution for this?
TIA
Regards,
View 4 Replies
View Related
Apr 17, 2007
how we can change db from sql server 2000 to sqlserver 2005.
Jes M George.
View 1 Replies
View Related
Apr 10, 2006
Hello, is it possible to have both sql server 2000 and sql server express 2005 installed at the same box?
I currently have sql2000 installed its used for an application. But I want to install visual studio 2005 and with this sql server express 2005 also is being installed ( if you want to) now I wonder if this is possible, that is is it possible to both run sql server 2000 and sql server express at the same time on the same box?
Thanks
Lars
View 1 Replies
View Related
Aug 13, 2007
What type of licence should we buy among the list below
1.SQL Svr Standard Edtn 2005 Win32 English MVL 1 Processor License
2.SQL Svr Standard Edtn 2005 Win32 English MVL
3.SQL CAL 2005 English MVL User CAL
4.SQL CAL 2005 English MVL Device CAL
5.SQL Svr Enterprise Edtn 2005 Win32 English MVL 1 Processor License
6.SQL Svr Enterprise Edtn 2005 Win32 English MVL
7.SQL Server Wrkgroup Edtn 2005 Win32 English MVL 1 Processor License
8.SQL Server Wrkgroup Edtn 2005 Win32 English MVL 5 Clt
9.SQL Workgroup CAL 2005 Win32 English MVL User CAL
10.SQL Workgroupx CAL 2005 Win32 English MVL Device CAL
11.SQL Svr Developer Edtn 2005 Win32 X64/IA64 English MVL
our environment is
SERVER1,SERVER2,SERVER3 AND SERVER4-DMZ for DEV,QA,TRG AND DR
The servers are coming with the latest version of VMware starter license according to the no of cpu for each server with 2 x Quad-Core Intel Xeon Processor 2.66ghz with minimum 16gb memory and minimum 6 * 146 GB HDD.
Server1 will be partitioned into 5 logical servers
DEV-tranweb,QA- Tranweb, TRG- TranWeb, DR-TranWeb & compiler/sourcecode hosts
Server2 will be partitioned into 5 logical servers
DEV-tranApp,QA- tranApp, TRG- tranApp,DR-tranApp and FP/BugTrack host.
Server3 will be partitioned into 5 logical servers
DEV-tranDB,QA- tranDB, TRG- tranDB,DR-tranDB and AD
SERVER4-DMZ will be partitioned into 9 logical servers
The OS for the servers are Windows 2003 advance server OS with SAN Connectivity.this is the achitecture. Please suggest the best licence to buy for this achitecture.
Appreciate your response
Thanks
View 13 Replies
View Related
May 1, 2008
Hi everyoneHere's the situation:I'm just a liitle confused on how Sql Server 2005 manages permissions.What does it use and where : the computer name or the user name?Basically, where does it get the server name from? And why does SqlServer Express Edition use the server name "somethingSQLEXPRESS" ?
View 1 Replies
View Related
Sep 13, 2007
My upgrade of SQL Server 2000 to SQL Server 2005 is being blocked as follows:
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding
FTCATALOGPATH
DEPRECATEDSP
FTCATALOGNAMERESTRICTION
FTNONPERSISTEDCOMPCOL
Many thanks
JMX
View 3 Replies
View Related
Dec 29, 2005
Hi Friends,
Can some please let me know the differences between sqlserver 2000 and sqlserver 7.0
View 1 Replies
View Related
Jun 6, 2007
Hi,
I am new to SQL Server 2005. I tried connecting to my local machine by using my machine name as Server name and then tried running the following query:
SELECT * FROM SYS.Objects. It gives me following error:
Invalid object name 'sys.objects'.
Whereas, if I connect to my local machine using mahcinenameSQLEXPRESS, then the above mentioned query runs fine.
Why is this difference? What is the difference when I login in these 2 different ways.
Any help would be appreciated.
Thanks in advance.
Any help
View 1 Replies
View Related
Dec 4, 2007
hi guys,
i am having a truble in accesing the server 2005 express edition from my client systems in server 2003 domain network. i get server not accessible. whereas my domain is working perfectly. i really tried alot and i have enable tcpip and named pipes and i am still getting errors while accessing. i have also created user reights for the domain users to access sql server. still i couldn't able to access it.
please guide me to over come this issue. I'm dying.My project is similar to SAP concept project and i am doing it in a production industry.so each department as to access the data from the server to update their daily production and activity.
thnks in advance.
Viswa
View 1 Replies
View Related
Dec 6, 2006
Hi,
We are trying to move our application from SQL2005 to SQL2005, we are using 2005 jdbc driver 1.1.
The problem we have is, when a date is retrieved from the database, only the year part got correctly, but the date is automatically set to January 1 of that year. The interesting thing is this problem doesn't occur on local development environment (developer's windows platform), it only happens when we deploy the application to production server (unix).
Does anyone know what is going on, how to fix it?
Thanks.
Cathie
View 12 Replies
View Related
Mar 29, 2006
Is there a way to transfer data from a SqlServer db to a SqlServer Express db. I tried to use the backup file of SqlServer, but this file is not valid for SqlServer Express. Or there any alternatives?
thanks,
Henk
View 7 Replies
View Related
Mar 7, 2007
is it safe now to install service pack 2 for the new test server which is having sqlserver 2005 and sp1
View 19 Replies
View Related
May 25, 2007
I currently have SQL Server Management Studio Express 2005 and would like to upgrade my machine to SQL Developer 2005 as easily as possible. Keeping my databases and such.
Any recommendations on the best way to do this would be greatly appreciated.
thanks!
View 3 Replies
View Related
Sep 26, 2006
Hello all,I develop under vs2005 and sqlExpress. How can I move my database to sql server2005?? I read somewhere that i need to use "sql server management studio express" which i already installed but for some reason I cant attach to a database under my windows XP account (no password for this account). Please help regards,
View 3 Replies
View Related
May 14, 2007
After several attempts to install SQL2005 I finally got Microsoft SQL Server Management Studio installed.But now I get the error below:An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)The sa account username/password are correct and don't work, windows authentication does not work, I have stopped/started all the services, I have all Protocols enabled correctly, I have my Firewall turned off. Is there anything else I can try? Anything!
View 1 Replies
View Related
Jan 8, 2008
sql server 2005 is installed but some how the link in the programs group has been deleted.
i want start sql server 2005 from cmd prompt or by any other way
please let me know
View 3 Replies
View Related
Oct 18, 2005
Hi All,I hopen this isnt a stupid question but can I connect asp 1 to sqlserver 2005? i want to update the database used on a ASP.net 1 project, I seem to be able to get it to connect but cant get it to see the tables?Thanks for any helpLee
View 5 Replies
View Related
Nov 7, 2005
I installed Visual Studio 2005 (released edition) that I downloaded from MSDN, and then went to install the released edition of SQL Server 2005. On the SQL Server 2005 setup "components to install" screen, all but the last choice ("Workstation components, Books Online, and development tools" are grayed out so I cannot install them.The machine on which I was installing these had just been re-imaged and was clean.How do I get around this so I can install SQL Server2005? Mark
View 1 Replies
View Related
Oct 18, 2006
Hi all,
We do our development in SQLServer 2005. We want to backup and restore our database into the client's side who use SQLServer 2000. Backup and restore cannot work. We try to script the database in 2005 and change the option script to 2000. This fails also. What other option I can use?
Regards
View 8 Replies
View Related
Jan 26, 2007
This is my first task of installing sqlserver 2005 on 64 bit machine in windows 2003 environment.
As a DBA what are the thnigs i need to know for the successful installation of sqlserver 2005 and what the things that are need to be installed along with sqlserver, and what are the accounts to be created like all the things i need to know..
Any help will be a great for me ...
Thanks in advance
View 1 Replies
View Related
Jul 20, 2005
What's the deal with SQLServer 2005 Beta?I've just got a magazine with a free cover disk with VB 2005 beta,and also includes SQLServer 2005. I've installed it, but I can't get itto do anything. It seems to have installed ok, there are the data filesfor allthe usual system and example databases in place, and TaskManager shows that SQLServer is definitely running. However theonly tool that came with it is called 'Computer Management' whichallows configuration options on the network, and to start and stopSQL Server. There are none of the Enterprise Manager controls toaccess the database, create tables, create users and so on. Enterprisemanager from SQL Server 2000 seems unable to detect the newinstallation.What's going on? Are there client tools I can download to access thedatabase with?
View 3 Replies
View Related
