About Linking Server

Oct 27, 2007

About linking server













Hi,
I am using sqlserver2005, when i make linked server connection between sqlserver2005 and oracle10g . It shows an error like that " Particular table doesnot exist or user doesn't have permission to connect ti this table"and below this one message is shown which is " Message 7314, line16".But i am giving it a proper "username/password ". In this linked server i am using Oracle10g new provider "ODAC101040.exe". so, please elaborate my such problem and also gives me the solution of this problem.
Thanx
regards
gautam

View 3 Replies


ADVERTISEMENT

Linking To SQL Server 5.0

Sep 2, 2007

I'm writing my first web site using VS 2005 and with my login page I'm trying to link with my SQL database using the following setting in my web.config file
<appSettings> <add key="SQLDB" value="server=STEVE-LT; database=MasterDB; uid=sa pwd="/></appSettings>
Then in my Login.aspx file I use the following code to access the SQL database
Dim Sc As SqlConnection = New SqlConnection(System.Configuration.ConfigurationManager.AppSettings("SQLDB"))Dim SqlCmd As SqlCommand = New SqlCommand("Select Password, Name from Login")SqlCmd.CommandType = CommandType.StoredProcedure
Sc.Open()SqlCmd.Connection = Sc
 This raises the following error message
A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
Could someone please tell me where I am going wrong. Thanks

View 2 Replies View Related

Linking 6.5 Server

Mar 8, 1999

I can't seem to link a 6.5 database from 7.0 and there's nothing in help which seems to help. Is it a "SQL Server" or do you have to use the OLE DB Provider? If the latter, what's supposed to be in the Product, Data Source, Provider String and Catalog fields? What about security? I've tried everything I can think of and can't get it to work. I also get errors creating a new DTS package that says "Could ot create Component Categories Manager", and then "Error during creation of DTS Package". I installed the desktop version of 7 on an NT Workstation. Has anyone successfully linked a 6.5 server in this environment?

View 4 Replies View Related

Linking From SQL Server To MySQL

Dec 13, 2004

Hi all, hoping someone can help.
I have created an ODBC connection to a remote MySQL database.
I can then go into DTS wizard and specify this ODBC connection, it all goes through fine and I can see the tables on the remote server and import data.
The problem arises when I try and create a linked server using the same ODBC connection. I get the following error, when I try to view the tables.
I am so stuck. Any help would be very much appreciated.

View 3 Replies View Related

Linking SQL Server To Frontpage

Feb 26, 2005

Is this possible?

View 2 Replies View Related

Linking To SQL Server In Access

Feb 6, 2006

We recently upgraded a number of databases from MS Access 2000 to SQL Server 2000. I need to make it so that users can display the data from the SQL Server so I created some link tables in Access for them to view the data without using SQL Server Enterprise Manager. This works fine in tables with only a few thousand rows of data. However some of the tables have 100K+ rows of data, and these are not displaying the data. When someone tries to view the data in one of these tables all they see is #Deleted in every column. Is it possible to link to tables in SQL Server with large numbers of rows and view this info in Access?

Miranda

View 5 Replies View Related

Linking To An SQL Server Table

Apr 3, 2006

Rather than using the upsize wizard in MS Access to connect to tables on a backend SQL server, how would I go about linking an Access Database to an existing table on an SQL server?

Thanks, Phil

View 11 Replies View Related

Linking To SQL Server To Access 97

Dec 7, 2007

OK here is my situation: I work in a laboratory with a 10 year old instrument that stores results in an Access 97 DB. The DB is beautifully designed and implemented. The problem is that since the software is so old, once the DB gets above a few MB in size the application starts to fail. So their solution is to Backup (make a copy) and Cleanup (delete data older than X days) once a week. So what I end up with is a bunch of copies of the DB, which fragments the data that I need. In order to get the data results I have been using an Access 2003 DB linked to this one (because I can't create Views in that database). The lab users then use the linked DB directly or I have written some automation code in Excel VBA (ADO) to simplify it for the other users. This allows us to query data immediately as it is produced.

My hope is that I can somehow get all of the data into a SQL Server DB. Now I have imported one of the backup copies of the DB in and the table structure and data imports fine into SQL Server, but I end up with duplicate rows because the different DB backup files have overlapping data, and for some reason there aren't PKeys. Also, I'd prefer to have some way of automating the input. Something like a trigger on the Access table so that any new data is imported into the SQL DB automatically. I doubt this is possible, but that is generally what I am trying to do and I am out of ideas. The ultimate goal is that the SQL DB will always be "updated" and I can use that as my query source and take advantage of the power of SQL Server.

Hopefully that all made sense... if anyone has any ideas I would love to hear them.

Thanks for your time.

View 4 Replies View Related

Linking To Client Server

Nov 21, 2007

Our client wants some changes/modifications in his DB but he does notwant us to touch the original Server. What would be the best/ fastestsolution for two SQL Servers connecting each other?Thx.

View 1 Replies View Related

Linking Two Tables Within One Server

Mar 31, 2008

First off, I am a novice in regards to SQL server and have the rudimentary skills to navigate, execute, query under SQL Server Manager. So, please bear with me.

I am working on a program that was not developed by myself, it is for my business and the company that developed it has gone under, so I have no technical support. The program uses SQL Server and ASP.net. We had a recent hard drive crash and I am in the predicament of having to re-install a new instance of the server onto a new computer. I have the most recent saved "data" files within "Microsoft SQL server/MSSQL/Data" directory. It includes the master, model, MSDB, etc. files.

Long story short, I have been successful in making the program operational again and I can connect to the server properly. It even works when web connecting with internet explorer. The problem I am facing is that all of the data is missing. When I connect through SQL Server Manager, I can see that there are two databases, I will name them "data1" and "data2". When I run a query of the tables, all the data is in "data2". All the stored procedures and tables are identical in both "data1" and "data2".

I am assuming (hopefully I'm right) that "data1" and "data2" are somehow linked or joined in some way. Any insight in how to get these two tables to link would be very much appreciated. Again, I am a novice, and will need help with specific coding that I can put into a query window and execute.

Thanks in advanced.

View 6 Replies View Related

Linking Tables To SQL Server

Apr 23, 2007

I'm new to SQL Server 2000. I decided to purchase this server because my old company (UPS) used the server to help expedite queries and manage on-line reporting. So, now it's up to me to utilize and understand the new server. I have been using MS Access as my front-end for several ad-hoc databases, so I'd like to keep utilizing this method. I want to test my first database using the SQL Server.



I've got everything set up. The IT department has installed the server software on my computer. Within my Access database, I link in tables from a database called "Progress" using a Merant driver. Queries, forms, macros and modules are all pulling from these "linked" tables. Do I need to link these tables into the SQL Server? How do I transistion this database over to SQL? I guess I'm confused about the relationship of how all of this should work.



Right now it looks like this:



PROGRESS ..... linked....... MS Access ....... reporting/results



Where does SQL fit in?

View 1 Replies View Related

Linking Access To SQL Server

Jan 22, 2007

Hi,

I have an existing Access DB with many Tables, Forms, Queries and Reports. I need to put a SQL Server Back end on this database.

Do I need to code a mirror images of these objects or is there some way to export these into SQL Server?

Also, where do I deal with assigning usernames and passwords? Access or SQL Server. I need to have different views for different users based upon their rights (user, admin)

Thanks,

Mark

View 4 Replies View Related

Problem With Federated Server Linking

Apr 29, 2008

Hello everyone.

I am trying to implement linked servers and I am having some trouble. The setup is as follows: I have two machines with the same SA login/pwd. BOTH machines have a database called: Federated_Bridge.

On machine 1: Federated_Bridge contains a table Fed_Entity_1

On machine 2: Federated_Bridge contains a table Fed_Entity_2


Machine 1, when I look it up in SQL Enterprise Manager it says: (local)

Machine 2, when I look it up in SQL Enterprise Manager it says: REALIBM2


When I expand those, I can see the databases folder and I can then see Federated_Bridge respectively.


On machine 1 (local) I am trying to create a linked server. I use the following SP call:

---------

use master
go
EXEC sp_addlinkedserver
@server = 'TEST3',
@srvproduct = 'SQLServer OLEDB Provider',
@provider = 'SQLOLEDB',
@datasrc = 'REALIBM2Federated_Bridge'


EXEC sp_addlinkedsrvlogin 'TEST3', 'false', 'sa', 'sa', 'mysapwd'

--------

The above queries seem to execute fine. Afterwards, when I check in Enterprise manager, I can see under linked servers TEST3 .. but no tables or views are showing.

When I run the following select query from query analyzer, I get an error message:


SELECT * FROM Test3.Federated_Bridge.dbo.Fed_Entity_2

SQL Server Does Not Exist Or Access Denied


Please help!!

Thanks.

View 1 Replies View Related

Linking A Text File To SQL Server

Jul 18, 2006

Hi all.

I need to create a Linked Server in SQL 2000 to a text file. Importing the file is not an option. It has to be linked. I tried creating a ODBC link to it but I must be doing something wrong because it didn't work.

Please help.

Thanks,
ODaniels

View 2 Replies View Related

Linking A SQL Server 2000 DB To 2005

Aug 8, 2007

I am trying to link an existing SQL 2000 server to a new 2005 box, but for some reason it will not link. I tried another 2000 server and that one worked perfectly well.

When I link it and perform a simple query...
select a, b from [server1].[db1].[dbo].tablec

I receive a 7314 message with text "OLE DB provider "SQLNCLI" for linked server "server1" does not contain the table "].[db1].[dbo].tablec". The table either does not exist or the current user does not have permissions on that table.

What's odd is that I was able to link the problematic server to other SQL 2000 servers with no previous issues.

Any ideas?

Thanks,
Steve

View 3 Replies View Related

Linking SQL Server To Access MDB File

Mar 8, 2004

Hi,

I am using an MDB file to talk to a SQL Server. I would like to use pass-through queries to keep as much of the processing on the server as possible. However, I have been told that the results of such queries will be read-only. How do I keep the processing on the server but generate read-write answers to my queries?

Thanks
Matt

View 3 Replies View Related

SQL Server 2008 :: Linking Two Tables To One

Feb 6, 2015

I have table1(Client widgets) and Table2(Client Toys) I want to link both Table1 and table2 up to Table3(ClientNames)

All tables have a clientid field

I want to right join them so I get all the client widgets and Client toys for each client...

View 2 Replies View Related

Linking Informix Database To Sql Server

Sep 7, 2005

Can anyone halp me with this?

I want to link/access informix database to Sql Server stored procedure.

View 12 Replies View Related

Linking Tables Between Databases On Same Server

Aug 29, 2007

Hi, I have 2 similar databases on the same SQL server (due to licencing and customisation issues for off the shelf software).

I would like to create a third database with site specific lookup tables to map data across to site codes, to do summary queries for data reporting, and to create a single point for data access. I can't modify the 2 databases.

I have created the third database and added the necessary tables, relationships, views, etc. But, how do I link to tables in the other databases on the same server so that I can do joins in a query/view ? I have SQL Server Enterprise manager.

Thanks.

View 7 Replies View Related

Linking SQL Server 2000 To DB2 Connect 8.x

Jul 23, 2005

I need to connect SQL Server 2000 to DB2 on z/OS through DB2 Connect 8.I can successfully connect and query data through a System DSN, buttrying to link the server using this DSN and MSDASQL fails (can't seemto find the DB2 Connect server). I've also tried IBM's OLE/DB driver(IBMDADB2).Has anyone successfully linked to DB2 on a mainframe through DB2Connect 8.x via either ODBC or OLE/DB drivers?

View 3 Replies View Related

Problems Linking To Oracle Server

Jun 8, 2006

Has anyone successfully linked to an Linux Oracle server running 9i? We are unable to get the link working.....have installe dvarious drivers and still get connection refused. Any thoughts?

View 1 Replies View Related

Linking Two SQL Server Express Servers

Oct 26, 2006

Hello all!

How do I go about linking two SQL Server Express servers? I can't seem to find information on this.

Also, I need to import data from MSDE. Is there anyway to do this?



Regards,



Andrew Cappella-Pakos

View 1 Replies View Related

Linking Access Tables Into SQL Server 2005

May 22, 2008

I am trying to add a linked table to my server, it is an access table.

Here is the code i am using but i get an error:
EXEC sp_addlinkedserver
@server = 'AITdb_be2',
@provider = 'Microsoft.Jet.OLEDB.4.0',
@srvproduct = 'Access',
@datasrc = '\kcapp03deptsCommonEIQAIT DBTestAITdb_be.mdb'
GO

-- Set up login mapping using current user's security context
EXEC sp_addlinkedsrvlogin
@rmtsrvname = 'AITdb_be2',
@useself = 'false',
@rmtuser = 'Admin',
@rmtpassword = ''
GO

-- List the tables on the linked server
EXEC sp_tables_ex 'AITdb_be2'
GO

ERROR:
OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "AITdb_be2" returned message "The Microsoft Jet database engine cannot open the file '\kcapp03deptsCommonEIQAIT DBTestAITdb_be.mdb'. It is already opened exclusively by another user, or you need permission to view its data.".
Msg 7303, Level 16, State 1, Procedure sp_tables_ex, Line 41
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "AITdb_be2".

View 3 Replies View Related

Linking Access As Frontend To Sql Server 2005

Dec 27, 2007

I have a sql server 2005 db.
Is there anyway I can link access to be used as a frontend by my client for viewing the data?
is this possible through linked table manager?

Please advise?

View 1 Replies View Related

When Linking A Server; Only System Tables Are Accessible!

Dec 8, 2005

I added a linked server successfully; but the only tables accessible areonly the system tables!I do have all the rights on both servers (Windows & SQL server).All the non system tables are designated as DBO.Strange thing is that I was able to access the non system tables onlyfrom the query analyzer (not from the SQL Manager tree) by using thefollowing script:EXEC sp_addlinkedserver 'LINKED_SERVER_NAME', N'SQL Server'GOSet ANSI_NULLS onSet ANSI_WARNINGS onGOSelect * From LINKED_SERVER_NAME.Database_name.DBO.table_nameGOThank you very muchMike*** Sent via Developersdex http://www.developersdex.com ***

View 3 Replies View Related

Linking Oracle View To SQL Server Express

Sep 6, 2007

Hi,

I was able to link SQL Server Express to Oracle views using Linked Manager. However, when I run the query, the performance is very slow.

Is there a way to improve performance in querying?

Previously I was using Access to link to Oracle view. But the performance is not good. Takes about 8 hours for approx 6000 records.

Thanks a lot,
Stara

View 3 Replies View Related

Linking SQL Server Databases AND Data Formatting Like InputMask

Mar 11, 2004

Hi

I have two questions : 1) Linking SQL Server Databases
2) Data Formatting like InputMask

1) I want to know if there is a way to link two seperate SQL server databases (it's tables) within the same server (local server). I created one Global database - with clients, etc. tables. The reason I did it like this is that I have to handle three seperate invoices databases, but using the same clients, etc. tables to get their information from. I used MS Access like this, linking Clients, etc tables from the Clients Database with the three other Databases. It worked fine but now I need some new features like setting the InvoiceNumber to something different, eg . 04/0001 for this year and then 05/0001 for next year. My Access databases can't change this numbers - it's just a autonumber I used. I know some Visual Basic code can make a change like perhaps adding a new column like InvYear and then adding it together with InvoiceNumber to get the Invoice Number, but I want to change it to SQL Server because I want to learn how SQL Server works. I am just starting out and not doing courses.

2) The other thing is I want to know if there is some feature in SQL Server to make data input easier, like a InputMask in Access where you can let a text column be formatted as you want. Eg. for a telephone number, it can store it in the format you made; like (011) 123 4567, not like you typed it : 0111234567.

I would appreciate some help.

Thank you

Corné

View 3 Replies View Related

SQL Server 2014 :: Linking Parameter To Multiple Values

Feb 17, 2015

Attempting to build a report were you can place a specific code in the parameter field and it will return all row values based on that particular code. I have a similar report that works great, but the specific code is just in 1 column, the one I'm trying to create has the potential to have that code in up to 20 different spots. I have the report built, but the issue I'm facing is linking the parameter. Is there a way to link 1 parameter to multiple column options?

Here's an example:

Docflo Distribution Group Queue Status Pend1 Pend 2 Pend 3 Pend 4 Pend 5
ABC ABC1 Catch All NEW 123 126 125 621 129
ABC ABC1 Various PENDED 621 123 872 542 630

Right now if I were to link the parameter to the Pend1 field, I would get every line I wanted that had Pend "123", but it would not include any of the lines where Pend "123" was in Pend 2, Pend 3, Pend 4, so on.

How would I link the parameter to more than 1 column so it would return all rows with a specific code no matter which Pend column it was in?

View 9 Replies View Related

Linking SQL Server 2000 Servers In Express 2005

Jun 5, 2006

Hello,

I was wondering whether it is possible to query linked servers in SQL Server Management Studio Express 2005 if those servers linked to are SQL Server 2000 machines?

I have added some linked servers to express and queried them, however the login timeout is expiring. I thought it might be because of an incompatability.

Cheers,
Damien.

View 1 Replies View Related

A Transport-level Error Has Occurred... When Linking A Server.

Apr 9, 2007

I just installed Microsoft SQL Server Express SP2. I setup a linked server to an Oracle database using the followings commands:

EXEC sp_addlinkedserver 'Oracle_DEV', 'Oracle', 'MSDAORA', 'DEV'

EXEC sp_addlinkedsrvlogin 'Oracle_DEV ', false, NULL, 'oracledbuser', 'dbuserpassword'

When I try and query the linked database I get the following error message:

Msg 109, Level 20, State 0, Line 0
A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - The pipe has been ended.)

I've been searching the web and have gotten a lot of hits on the error message but have yet to uncover anything specifically related to linked servers or anything closely related enough to help me resolve this problem. Any advice would be appreciated. Thanks.

View 3 Replies View Related

This Is An Access Project Linking Tables On SQL 2005 Server.

May 10, 2006

Looks like the Office 2003 MS Access has no support for creating a linked server and implement design changes. While you could link to the SQL 2005 tables, which show up as queries in MS Access 2003, any further use of the linked queries are not supported unless the Access 2003 version came out after the SQL 2005 release. What kind of an update is needed, or fix is needed so that Access projects can be developed?

View 6 Replies View Related

Linking SQL Server 2k To Exchange Server 2003

Jun 8, 2004

I am trying to find information about creating a link server in SQL 2000 to connect to Exchange 2003 server. Can anyone help with this?

I am also interested in any kind of tutorial on how to connect to Exchange 2003 Server using C#.

Thanks!

View 1 Replies View Related

Connection Fails In Linking SQL Server 2005 Tables Into Access Using DAO 3.51

Aug 21, 2006

Hi,

I have an app that creates and attaches tables from SQL Server into an Access mdb using an ODBC link from VB6 using DAO 3.51 on Windows 2000. Recently I upgraded to SQL Server Express edition and tested it. It worked fine against the Express Edition. So, I installed SQL Server 2005 Standard Edition on our Server hoping that they operate identically. How wrong one can be! the same code that worked against Express Edition does not work on Standard Edition.

It is strange that the App works for about 5 seconds which attaches about 38 tables and after that the connection drops and I have a hell of a time to get the rest of the tables linked. The error that comes up is:

Connection failed:
SQLState: '01000'
SQL Server Error: 10060
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 11
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation.

The PC that I am using to connect is in a different domain to the Server where the SQL Server database resides. I thought that domains might be the reason. But even joining the PC to the same domain as the server still does not work and behaves the same. So I do not think it is a domain related issue.

I have also looked at the SQL Server and database configurtaions. I cannot see anywhere any specific time out of around 5 seconds. Even the time out through the SQL Server ODBC driver is set to 30 seconds by default as far as I know. So, it looks like there is a time out somewhere but I am absolutely confused as to where this 5 second time out is comming from.

I also thought permissions on the database or tables might be the issue but after looking at the database and table permissions, they all look OK. The user has prettymuch the same access as the SA on the database.

Has anybody came across this problem? If so, I appreciate if someboday can give me a hint as to where I can start.

Thanks,

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved