I've a database in 2000 which needs to be accessed from 2005 via linked
server. I've tried the GUI options and it is failing. One thins is that our
both servers have hyphen('-' not underscore, could that be a problem) in the
names, like 2k-srv and 2k5-srv as hosts, but the instances are default.
Can anyone give me the steps please.
TIA
Nasir
I am using VS .net 2005 to develop a web application with sql server 2000, but the SQL servrer 2000 is setup on other computer,so, my web server is setup on A machine and SQL servr is setup on B machine.I got a problem when i try to connect to SQL server through the Web form as following error."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)"
I had try to setup the MDAC 2.8 on my Web Server, but i got a setup error sth like "MDAC 2.8 cannot install on your machine because it is not support your windows version.........."
Why i can't connect to SQL 2000 through the Web server???
It is a urgent case, Please help thx a lot.
Hi there,
I got a shared web hosting server with sql server db which is 2k, and now ive got dedicated with godaddy where i installed sql 2005 express edition, now my shared hosting ppl gave me db bkup which i cant restore , so i copied all data from asp.net web based enterprise manager into an excel sheet and am trying to copy that data into sql2005 management studio express, however it doesnt let me do that.
I am trying to use openrowset, but my knowledge in sql is minimal so cant run that either.
can you please please please tell me how to do this asap, its very urgent as my contract runs out with shared hosting on 31 and ive to switch this site live by tomorrow.
please let me know asap wat to do, i can pay also for this job?
amit
amitsharma1977@gmail.com
Hello,
I want read only connection to Sybase server from MS SQL Server 2000. I think Link server should be best solution. Can anyone guide me as help shows link of Oracle but not sybase. any help is apreciated.
I've written following on creating link server from ER
ProductName : Sybase ASE
Datasource : Server A
providerstring: DRIVER={Sybase.ASEOLEDBProvider};SERVER=unixbox,45 10;UID=sa;PWD=abc1411'
Thanks A Lot
Hello,
Can anyone guide me how to create link server to sybase from MS SQL Server 2000 cluster.
Thanks
Sejal
hi
How to link xml to sql server 2000?
Hello All,
I am new to this forum and hope that some one can help me with this problem.
I know that in MS Access you can have a linked table in your databse such that as long a the like is not broken, it behaves similar to any other table in the database.
My problem is that I need to do the same thing for multiple databases that I have on a MS SQL Server that ALL currently have copies of the same table in common.
I wish to have a single table that they all share and have access to just link any other table that they currently have but is actually linked.
Can this be done?
And if so, then could someone please guide me in this?
My logic is that if MS Access can link tables then I could suspect that MS SQL Server should be able to also, but I could be wrong.
Thanks in advance,
Lonnie
Hi,
I've 2 SQL Server 2000 EE (A & B). Both are connected to internet but not in the same LAN. How do I insert a row triggered from A to a table in B ?
If I've both SQL Server 2005 Express in the same setup above, is it possible to setup as above ?
Advice pls...TIA !
i'm trying to set a data source in Access 2000 to link to SQL Server express..I have mixed mode set..what user/password do I put in? I tried sa, but get error server does not exist, or access denied..
thanks!
Hi, I have recently qualified as a MCITP - DBA with SQL 2005, but as I have no commercial experience, have been strugglling to get into the industry. However, I have finally been offered an interview on Monday. The problem is that the company use 2000, not 2005. I think I am pretty much up to speed on the differences, but was wondering (nay, pleading) if anybody could let me know the main commands for analysing query performance and index statistics etc, with a reference to thier equivalent DMV in 2005 (which I am totaly familiar with) This is something I could easily pick up whilst doing the job, but I am aware that there will be an SQL test to asses my knowledge during the interview and I am desperate not to get caught out. Please help!
View 2 Replies View RelatedI have upsized an Access database into SQL Server and manged to getthe data in place ok. The wizard created an Access Project which Ihave started to modify.However, I am also trying to get data from an AS/400. Specifically fora currency/exchange rate file. I only want ot copy the records sincethe last copy otherwise there are a vast number of records.I have created a linked server to the AS/400 within SQL Server, andcreated a view, within my specific database which allows me to look atall the data in the table.However, my problem is that I want a VB routine, in the AccessProject, which lets me copy out specic records from the view into atable within the SQL Server database. Any clues?????My oroginal code used a link to the AS/400 and the folowing code:-s = "INSERT into zacjdf00 "s = s + "select CJCNCD, CJD5E9, CJCUCD, CJD5FF, CJD5FG, CJD5FH,CJD5FI, CJD5FJ, CJD5FK "s = s + "from XGHLDTM_ZACJDF00 "s = s + "where "s = s + "CJD5E9 = '" & group & "'"DoCmd.RunSQL (s)group is preset in the VB code.
View 1 Replies View RelatedI have created a linked server on which following query works fine.
EXECUTE ('SELECT TOP 10 * FROM dummyOBJECTS') AT [REMOTE]
but the same statement executed with openquery
select * from openquery([remote],'select top 10 * from dummyObjects') returns following error.
Msg 7356, Level 16, State 1, Line 1
The OLE DB provider "SQLNCLI" for linked server "remote" supplied inconsistent metadata for a column. The column "dummyObjectID" (compile-time ordinal 1) of object "select top 10 * from dummyobjects" was reported to have a "Incomplete schema-error logic." of 0 at compile time and 0 at run time.
Error 7302: Could not create an instance of OLE DB provider 'SQLOLEDB'. OLE DB error trace [Non-interface error: CoCreate of DSO for SQLOLEDB returned x8007007f].
CASE:
I created a link server from SQL Server 2000 to FoxPro database using vfpoledb driver. SQL server and FoxPro database are NOT being run on the same machine.
Server1 - SQL Server 2000 (I created the link server which connects to Server2)
Server2 - FoxPro database
TROUBLESHOOT
When I test the link server on the machine which has FoxPro database , It is working with no problem.
PROBLEM STATEMENT:
When a user machine sends a query to Server1/Link Server, it is getting Error:7302
Please help me.
Greetings,
I want to connet to Oracle databse from SQL server 2000 since I am more comfortable with SQL 2000 client package. The oracle server is 8i or above.
I am running a SQL Server 2000 on a PC with Windows XP OS.
Please help what I need to do and configuration information.
Thank you all in advance.
BPG
Hello,
I think I may be going a little bit mad. Last week I created a database on SQL Server. I then created an access database on a different windows server, and set up an ODBC connection on that windows server to my database on SQL Server. I then set up linked tables within Access to point to my tables on the SQL Server. I'm fairly sure that I opened those links at the time and managed to display and update the data from Access. However I have come to this today and when I go into the Access database and attempt to open one of the links I get a connection failed message. When I check the ODBC connection on the windows server it is fine. Does anyone have any ideas on this? I really need this to be working by tomorrow to do a demo, and I'm so convinced it worked last week I am a little bemused!
Many many thanks in advance of your wonderful and prompt replies!!! :)
Paula
Hi,
I am trying to transfer data from a sql server 2000 database to a Sql Server 2005 database... and i just want to transfer around 2 tables.. and my sql server 2000 database is located in one machine and the 2005 database is located in the other machine.. So i am trying to insert data into the sql server 2005 database. So can i do it like this..
Insert into SqlServer2005comp.Databasename..TableName
(
Columns
)
Select
Columns
From
sqlserver2000comp.Databasename..tablenames
Where UserId = @UserId.
Is this the right way to do it.. and can i give this query in the sqlserver2005 db or the 2000 db
any help or ideas will be appreciated.
Regards...
Karen
Hi Folks,
Somehow i am stuck at a very basic step. I have two pages -
1. DomainList.aspx which just displays all the records from the Domains table.2. DomainAddEdit.aspx which displays the selected record in FormView(Edit Mode) with two link for Update and Cancel.
The Update link in the FormView does nothing on the first click. It just reloads the page with the new data I entered. If I click again on the Update link, it throws me an error:
"Cannot insert the value NULL into column 'DNS', table 'MSInteractive.dbo.Domains'; column does not allow nulls. UPDATE fails.The statement has been terminated. "
I have no clue why all this is happening. I have spent more than two days on this and this is very very frustrating.
Just to mention, I haven't written any code for this. Its developed all using the VWD tools available. I have posted this message earlier but haven't got any response. I am sure most of you guys must have been doing these steps everyday. So, please post your thoughts.
Thanks a million.
Here is the relevant code for my DomainADDEdit.aspx:
<asp:FormView ID="FormView1" runat="server" DataSourceID="SqlDataSource1" DefaultMode="Edit"> <EditItemTemplate> Id: <asp:TextBox ID="IdTextBox" runat="server" Text='<%# Bind("Id") %>'></asp:TextBox><br /> RegistrarAccountId: <asp:TextBox ID="RegistrarAccountIdTextBox" runat="server" Text='<%# Bind("RegistrarAccountId") %>'></asp:TextBox><br /> Registrar: <asp:TextBox ID="RegistrarTextBox" runat="server" Text='<%# Bind("Registrar") %>'></asp:TextBox><br /> DNS: <asp:TextBox ID="DNSTextBox" runat="server" AutoPostBack="True" OnTextChanged="DNSTextBox_TextChanged" Text='<%# Bind("DNS") %>'></asp:TextBox><br /> EmailHost: <asp:TextBox ID="EmailHostTextBox" runat="server" Text='<%# Bind("EmailHost") %>'></asp:TextBox><br /> Registered: <asp:TextBox ID="RegisteredTextBox" runat="server" Text='<%# Bind("Registered") %>'></asp:TextBox><br /> Expires: <asp:TextBox ID="ExpiresTextBox" runat="server" Text='<%# Bind("Expires") %>'></asp:TextBox><br /> MsiResponsible: <asp:CheckBox ID="MsiResponsibleCheckBox" runat="server" Checked='<%# Bind("MsiResponsible") %>' /> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MSInteractiveConnectionString %>" SelectCommand="SELECT [Id], [RegistrarAccountId], [Registrar], [DNS], [EmailHost], [Registered], [Expires], [MsiResponsible] FROM [Domains] WHERE ([Id] = @Id)" UpdateCommand="UPDATE Domains SET DNS = @txtDNS WHERE (Id = @Id)"> <UpdateParameters> <asp:FormParameter FormField="DNSTextBox" Name="txtDNS" /> <asp:QueryStringParameter Name="Id" QueryStringField="Id" /> </UpdateParameters> <SelectParameters> <asp:QueryStringParameter Name="Id" QueryStringField="Id" Type="String" /> </SelectParameters> </asp:SqlDataSource><br /> <asp:LinkButton ID="UpdateButton" runat="server" CommandName="Update" Text="Update" OnClick="UpdateButton_Click"></asp:LinkButton> <asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel"></asp:LinkButton> </EditItemTemplate>
Hi,
I have two database one on local system and another on web both are in MS SQL 2005 Now I want to link both of them by using Link server but the System procedure ask of oledb I am not understanding what to do.
I searched the web but .....
So plz tell me some link or code ........
thanks
Hi,
I have two database.and i want to transfer datafrom one to another so for that I need Link server. both the database are in SQL 2005
i have altered the store procedure and login but it give connection time out error.
will u give me some link to understand and implement the same in my app.
EXEC master.dbo.sp_addlinkedserver @server = N'vidyalink', @srvproduct=N'SqlServer', @provider=N'SQLNCLI', @datasrc=N'myb_29074'
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'vidyalink',@useself=N'False',@locallogin=NULL,@rmtuser=N'mybe',@rmtpassword='########'
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'vidyalink',@useself=N'True',@locallogin=N'sa',@rmtuser=NULL,@rmtpassword=NULL
GO
EXEC master.dbo.sp_serveroption @server=N'vidyalink', @optname=N'collation compatible', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'vidyalink', @optname=N'data access', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'vidyalink', @optname=N'dist', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'vidyalink', @optname=N'pub', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'vidyalink', @optname=N'rpc', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'vidyalink', @optname=N'rpc out', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'vidyalink', @optname=N'sub', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'vidyalink', @optname=N'connect timeout', @optvalue=N'60'
GO
EXEC master.dbo.sp_serveroption @server=N'vidyalink', @optname=N'collation name', @optvalue=null
GO
EXEC master.dbo.sp_serveroption @server=N'vidyalink', @optname=N'lazy schema validation', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'vidyalink', @optname=N'query timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'vidyalink', @optname=N'use remote collation', @optvalue=N'true'
Labour never goes waste.
I created a linked server (PLNK Oracle 9i), and run the query:
Insert into MSTBL1
select * from openquery(PLNK,'select * from v_ora_view1);
The above query run success when I issue the query in Query Analyzer.
But it got access denide after I copy it to a job.
Any idea?
Hi guys,
Please can anyone show me how to connect SQL Server 2005 to ODBC Driver(Novell).
The import/export wizard data source has no ODBC option.
My final goal is to extract data from an eDirectory into SQL table.
I used Novell Client to create a link to eDirectory; with the ODBC driver as the data Source for the SQL Server to extract data from.
Every help will be rewarded with appreciation.
Thanks
Hi ,
looking for a good link to start with sql server 2005 , could anybody suggest one.
thanks
bcj
bennichan
HI,
I need to link two SQL-2005 server's databases. And both databases are on different machine and on same network.
After linking I have to create Views.
In other words :
I need to create a View of One -Database in to Second Database . For this Do I need to link first?
please let me know. ASAP.
Hi all.
I don't know if this is the right forum to post this question, but here it goes.
We have restored into sql 2005 the database backups made in sql 2000. We connect with trusted connection and application roles, and when trying to execute a transaction to another database (with the guest user), we get a permission error.
Does anyone know if, apart from restoring the databases, we should do something else to get the guest user working the same way as with sql 2000 in the restored databases?
Thanks in advance for your help.
Hi All,
Is there any way to remove the My Subscription,Site Setting links on the main page in Report manager.And also our client wants SSRS reports to be seen by his customer over the internet.Anybody knows about this?
Any help will be appreciated.
Thanks
Anupama
The first public beta of SQL Server 2005 is available for download. Try the link below and happy coding.http://www.microsoft.com/downloads/details.aspx?FamilyId=DC02CBB3-D688-4663-9103-37C83E044D59&displaylang=en
View 5 Replies View Relatedhi,1. is there a statement in ms sql, what creates a sequence? cant findanything in web :-(-oracle: CREATE SEQUENCE XYZ INCREMENT BY 1 START WITH 1 NOCYCLECACHE 20;-ms sql: ???2. hwo do i create a link to another ms-sql databasethx a lot need help, urgend :-)
View 14 Replies View Relatedplease tell me the best way?
thanks
:-)
I have just downloaded and installed the SQL Server 2005 Express version, enabled TCIP and Named pipes but when I try to link to the tables with Access 2003 or try to create a database connection I get an error 17 "connection failed - SQL Server does not exist or access is denied".
I am able to open Management Studio Express and see all of the databases, including another SQL Server 2005 server that I have. I am able to Link to my other server but I can't get see my local install.
What can I do?
Thanks,
Mike
Hi
I'm a newbie at SQL 2005 and I'm trying to create linked tables to our ERP system through ODBC. I can do this in MS Access or vb.net by using the ERP system's ODBC driver, but I am lost when it comes to SQL Server 2005.
Thanks for any help
If I define a table-valued function in a SQL Server 2005 database, can I link to it from Access 2003 using ODBC?
I've defined the function successfully, and I can link from Access to tables in the database (so my ODBC link is basically functioning), but I can't see the table-valued function in the Linked Table Manager in Access.
I can define a pass-through query to grab the table, but with a pass-through query I have to provide the ODBC password every time.
What am I missing?
Suggestions?
I have a sql server 2005 database with Delphi 2006 in the front end and for querrying and reporting we use MS Access 2003 by connecting to this database via ODBC connection. I recently found out that the SQL Server 2005 data connected thus can be edited (updated) from MS Access. I do not want end users to modify/update the SQL Server 2005 data from MS Access while I also want them to have the ability to insert/update/delete rights using the appropriate application interface. For now, I am handling this by creating a user id that is not permitted to update, insert and delete and using the same account in the ODBC. Is there a way in SQL Server 2005 you can control insert/update/delete rights for all users that will be applicable only in the ODBC mode?
Any help will be greatly appreciated.
thulo
Hi,
I just developed a ASP.NET website with SQL Server 2005 as database. I am having connection crash problem when multiple user click on same link to fetch data from the database. If users click on different links or there is few seconds of time gap between the data access, then it works fine. But the connections crash problem only occurs when 2 or more users click same link at same time.
I am using the following kind of Datalayers to access the data from database:
public static ContentInformation GetContentForUpdate(int ContentId)
{
ContentInformation result = new ContentInformation(); ;
SqlCommand command = new SqlCommand();
command.CommandType = CommandType.StoredProcedure;
command.Connection = Connection;
command.CommandText = "Content_GetContentForUpdate1";
SqlParameter parameter = new SqlParameter("@ContentId", SqlDbType.Int);
parameter.Direction = ParameterDirection.Input;
parameter.Value = ContentId;
command.Parameters.Add(parameter);
try
{
command.Connection.Open();
SqlDataReader reader = command.ExecuteReader(CommandBehavior.SingleRow);
if (reader.Read())
{
// read the data
}
reader.Close();
}
catch (SqlException ex)
{
Trace.TraceError(ex.Message);
throw ex;
}
finally
{
command.Connection.Close();
}
return result;
}
I would be really grateful if someone can help me out with this problem. Waiting for the soonest reply. Thanks.