I've been informed that our data feed systems are going to be shut down and that our data will be residing in Teradata V2R5 databases. I was wondering if anyone knows if you can get connectivity to a Teradata server via Linked Server in the Security folder of SQL Server Enterprise Manager? If no then; Is it possible through a DTS package? Thanks for the info...
View 2 RepliesHi,
How do I connect from SSIS to TeraData database. Is there any OLEDB providers available for evaluation.
If any of the experiences can be shared on this, it would be greatly helpful.
Thanks,
S Suresh
I am trying to set up the Linked 2005 Server to Teradata v2r5, and have got most of the way there. My problem is that using both methods (OPENQUERY and SELECT with 4-part naming string) seems to submit only the SELECT * part to Teradata with the rest of the SQL waiting until the data is all pulled back to SQL Server. This is a problem when working with big tables! It puts a huge strain on the network, and also runs me out of temp space in Teradata. Is there a way to get ALL the SQL passed to Teradata? I am looking to create a Report Model for Report Builder or Pro-Clarity. I have a dummy SQL Server 2005 database set up with views of the Teradata tables through the Linked Server. Any help would be greatly appreciated!
View 1 Replies View RelatedCreate a linked server to another box.
exec sp_serveroption 'RemoteServer', 'connect timeout', '1'
exec sp_serveroption 'RemoteServer', 'query timeout', '1'
Pull the network cable from the remote box.
SELECT * from RemoteServer.Database.dbo.Table1
Why does it take almost exactly 21 seconds, every time, before it fails?
How can I get it to fail immediately?
BACKGROUND:
I have two databases that support two separate applications. Both applications are required to be in sync with one anther. One application is MSSQL 2000 based and the other is Oracle 9.i. Given the complexity of the first application (host), the best solution was to use linked servers to connect the SQL database to the Oracle database.
To prevent imbalances, the host application calls a package in Oracle to update the secondary application before it completes the transaction in SQL. This way, if anything fails at any point, the entire transaction is rolled back and neither databases are updated.
PROBLEM:
Our test system is stand alone but is performing the previously mentioned transaction in the same manner to an Oracle database on a Linux server. After passing testing, we promoted the application to the live system and are experiencing the following error when the transaction attempts to call the Oracle package:
Connectivity error: [Microsoft][ODBBC SQL Server Driver][SQL Server]MSDTC on server XXXXX is unavailable.
I have done some reading, but there really isn€™t much literature on linked servers. Will someone help?
Thanks so much,
Tony
Hi!
I'm using SQL Server 2005 Enterprise on a Win2003 x64. I want to connect to a Teradata 2.6, but there are no x64 ODBC- or OLE-DB-drivers for Teradata yet. So, only OLE-DB can't be used as the 32-Bit OLE-DB-driver for Teradata is not visible e.g. if you want to create a linked-server-connection. One workaround would be to use "OLE-DB for ODBC", but this OLE-DB is also not available on my system.
Does anybody know a way to connect SQL 2005 x64 to Teradata or to get "OLE-DB for ODBC" up and running???
There is an entry to a similar issue (http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=699116&SiteID=1) where the workaround "use 64Bit-ODBC with .net ODBC" (?) puzzles me!
Thanks
B.G.
I am fetching large amount of data from teradata to sql server using linked server. I am facing below query:
A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.)
I am fetching large amount of data from teradata to sql server using linked server. I am facing below query:
A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.)
I've build a few reports in visual studio, they work and they don't work, in a minute I can run them next minute I can't and I get this errors in event viewer every time they can't be run:
Report Server (MSSQLSERVER) cannot load the SQLPDW extension.
Report Server (MSSQLSERVER) cannot load the TERADATA extension.
SP2 for SQL Server 2005 x64 has been less than happy for me.
The initial problem, mentioned in another thread, concerned SSIS client which stopped liking Data Flow components. It was solved by a removal and reinstallation of the client tools.
However, there now seems to be a problem with making use of the Teradata oledb provider within SSIS. Prior to the installation of SP2 there was no problem.
I create a new SSIS package
Add a Data Flow component
Within the data flow add an oledb source
Create a new connection - using the Teradata oledb provider
Test the connection (it works!)
Use SQL something like "select * from some_teradata_table_on_the_TD_server"
Click on columns, wait a second, a list of columns is returned
Add a SQL Server destination (with a new SQL Server connection)
Connect the two components
Save the package
Click go
The TD oledb source component turns bright red and the error is "class not registered"
I have uninstalled the TD oledb provider (and underlying TD components) and re-installed (32-bit and 64-bit) - no change
Any ideas?
- KjM
Hi ,
On my Desktop i registered Production Server in Enterprise Manager
on that Server if i go to SecurityLinked Servers
There is another Server is already mapped, when i am trying to see the Tables under that one of the
Linked Server i am getting the Error message saying that
"Error 17 SQL Server does not exist or access denied"
if i went to Production Server location and if i try to see the tables i am able to see properly, no problems
why i am not able to see from my Desk top
i am using the sa user while mapping the Production Server on my DESKTOP using (ENTERPRISE MANAGER)
And i check the Client Network Utility in the Alias using Named Pipe only, i changed to TCP/IP still same problem
What might the Problem how can i see the Tables in Linked Server from my DESKTOP
Thanks
I am using Linked Server in SQL Server 2008R2 connecting to a couple of Linked Servers.
I was able to connect Linked Servers, but I cannot point to a specific database in a Linked Server, also, I cannot rename Linked Server's name.
How to point the linked server to a specific database? How to rename the Linked Server?
The following is the code that I am using right now:
USE [master]
GO
EXEC master.dbo.sp_addlinkedserver
   @server = N'Machine123Instance456',
   @srvproduct=N'SQL Server' ;
GO
EXEC sp_addlinkedsrvlogin 'Machine123Instance456', 'false', NULL, 'username', 'password'Â Â
Is there a way to bypass the syntax checking when adding a stored procedure via a script?
I have a script that has a LINKed server reference (see below) .
INSERT
INTO ACTDMSLINKED.ACTDMS.DBO.COILS ..etc.
ACTDMSLINKED does not exist at the time I need to add the stored procedure that references it.
PLEASE to not tell me to add the LINK and then run the script. This is not an option in this scenerio.
Thanks,
Terry
Hi:
I m in new in ASP.net and can't connect sql server db with ASP.net.I write exact code.but it give error in connection string and server error some time.I found that error is in web.config file.can any one have running project of asp.net with sqlserver db..
if any one have then mail the project at this mail address..
ray_boby@hotmail.com
I am using webforms for ASP .NET which has code in C#. My database is running on SQL Server 7. Whats the best way to connect to database. I have tried ODBC connection through myConnection=new SqlConnection(ConfigurationSettings.AppSettings["dsn"]);but it gives me an error that can not connect to the SQL Server 2005 or it does not allow remote connections though it is running SQL Server 7 and not SQL Server 2005. Thanks in advance.
View 1 Replies View Relatedhello , i have a small problem , an associate want to connect to a micrsoft sql server under nt from a pc with only dos! can such a thing be done?
View 1 Replies View RelatedI am trying to connect to my dev Sql server instance remotely from my developer edition and I get the 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
i Made sure that the following are complete
# [Link] Enable the TCP/IP protocol using the Surface Area Configuration Utility
# [Link] Make sure the TCP/IP protocol is enabled in the SQL Server Configuration Utility
# [Link] Make sure the SQL Server browser is started
Hi,
We have a DB2 server which is linked to our SQL Server 2005 database. The link is through ODBC connection. Now, we are able to access some of the tables without any problems. But couple of tables are not accessible and we get following error::"
"com.ibm.db.DataException: A database manager error occurred. : [IBM][CLI Driver][DB2/NT] SQL1822N Unexpected error code "08S01" received from data source "TESTPROD". Associated text and tokens are "Communication link failure". SQLSTATE=560BD "
Any ideas on why this is happening and how to resolve this?
Thanks,
Ujjaval
Hi All
how i connect sql server 2000 to Asp.Net.
Please Help me
Thanks
Hi,
I am new to SQL Server. I want to connet to SQL Server database and fetch records. SQL Server will be present in some other server.
For connecting to SQL Server is it necessary to create DSN. Is it possibel to connect to SQL Server with out DSN
I want following parameters are enough for opening connetion are not:
MyConnObj.Open _
"Provider = sqloledb;" & _
"Data Source=172.16.1.60;" & _
"Initial Catalog=TESTATV;" & _
"User ID=sa;" & _
"Password=p@ssW0rd;"
As per my assumption
Data Source is your server name
Initial Catalog is your database name
please clarify me on this.
thanks
hi i am using sql server 2000 i want to connect from asp.net i am confused with web.config what is this for, to connect should i edit it or simple connectivity is also posible if u know any tutorial please refer me which will guide for database connectivity faisal iqbal ch
View 1 Replies View RelatedI had SQL Server working without a problem on my laptop until I changed the identification name of my laptop to make it more recognisable when I connect to a LAN. However, since I've changed my laptops name, my local SQL Server service wont run and I cant connect to my local databases. I can connect to remote SQL Servers though. If I change my laptops name back to what it was before, it still doesnt work. This has happened in the past and the only way I could solve the problem then was to uninstall SQL Server 7, remove all registry keys referring to it then reinstall it. I dont want to do all that again so....HELP!!!???! I'd really appreciate any help anyone could give me. Please email me at adrianmhills@hotmail.com
View 2 Replies View RelatedHi...
I am using MSACCESS form to connect to SQL SERVER database..Is that possible.
my tables are defined in SQL SERVER and through MS ACCESSS forms as a front End I am manipulating it...
How should I do that...Can any body help me in the same
Thanks in Advance
Rakesh
To All,
I have two different servers,server1 and server2
they have the same databases(did a dump from server1 and restored on server2)
now I am using ipx/spx to connect to both the servers on the same network.
the problem is I am not able to connect to them when both are online.(using isqlw)
i have to switch one of them off to login to another,but i want both of them to be up and running at the same time
how to solve this problem?
DP
Has anyone experienced timeouts connecting to SQL 2K from a client and also the server console itself. Typically this error occurs on the client: Microsoft OLE DB Provider for SQL Server error `80040e14`
OLE/DB provider returned message: Timeout expired
conn_info.asp, line 444
Hello everyone,
I am experiencing problems connecting to me database from my App. I had created this database and my application that calls all the stored procedures at my old work place. I had then moved it all to my home machine. When I open my connection, I get the error saying, "SQL Server is not available or access is denied"! I have added aspnet user to the users group in the SQL Server, disabled my firewall, made sure that physically in the server view I am able to get to the tables inside of the IDE....but to no success. I have been stuck on this for over two days and need serious help from someone.
Kindly let me know of the reasons and troubleshooting methods for this problem.
Thanks in advance
Hi,
I am new to SQL Server. I want to connet to SQL Server database and fetch records. SQL Server will be present in some other server.
For connecting to SQL Server is it necessary to create DSN. Is it possibel to connect to SQL Server with out DSN
I want following parameters are enough for opening connetion are not:
MyConnObj.Open _
"Provider = sqloledb;" & _
"Data Source=172.16.1.60;" & _
"Initial Catalog=TESTATV;" & _
"User ID=sa;" & _
"Password=p@ssW0rd;"
As per my assumption
Data Source is your server name
Initial Catalog is your database name
please clarify me on this.
thanks
How do I configure the MS-SQLSERVER to accept JDBC connections andprocess the sql?I'm using SQLSERVER 2000 on Windows NT.Thanks for your help
View 2 Replies View RelatedCouple of questions for the SQL Server Guru's out there.
SQLServer 2005
Web Hosting Provider
Ok I am developing a Web application in ASP.NET with AJAX, etc. etc. It will be some time before it is ready to roll out. As a mockup I created the same application in Microsoft Access and Visual Basic (VS 2008), which I can link the tables to the hosting provider on the internet. Works very well and speed is very acceptable.
My question is, is how secure is the data that is moving from the local application to SQLServer 2005 with the web hosting provider ? Is there anything that I can do to increase security ?
Thanks, any thoughts ?
Hello All -
I am using SQL server 2005 sp1 to work with my applications... and i am using ODBC connection to communicate with SQL serrver...
The connectivity has been working fine for more than a 6 months now .... and suddenly it thows an error ...
"General network error. Check your network documentation.ConnectionRead (recv())."
There about 10 applications accessing SQL server... and all the applications throws this same error...
I intially thought it migjht be bacuase some applications are over utilizing the SQL connection and not closing them properly... but i noticed the connection opened in the Activity monitor are the same as it supposed to be ... no extra unwanted connection opened...
I also noticed that SQLserver.exe process is utilizing almost all the RAM memory and trying to allocate more page memory.... so i restarted the SQL sever service and that reinstated all the connectivity properly....
in couple of days .... the memory utilization again reached the max and this problem started again and i had to restart the SQL server again... and this problem happens every 2 days...
I know SQL server is using up those memory for caching purpose which is normal... but Y would this cause the connectivity to fail...
Is it a problem in SQL server 2005 SP1 ... shd i upgrade it to SP2?
If some of my application is causing this how would i narrow it down to that application and pin point on that particular one?
The thrown error does not have much information for it to guide me in a direction for debugging...
Please can any one help me tro this problem?
Badri
Hi All,
I have made a system DSN to connect to sql server, and in my asp code i got the createObjects for the connection strings.
But it keeps asking me for a data provider. What do I do?
Thx
Hello all, I am hoping this is the correct place for this. I have an application that depends on an active connection to Sql Server Express 2005. I am looking for a way is any to check for the existance ofthe server I defined and wether it is online or not. I know I can just catch the error on connection but it takes a bit and I have customers trying to cancel it before it's finished because they think it's locked up. I would like a quick way to check without trying to create a connection if it's online, then if it is, proceed, if not, let the customer know. I was hoping for something like a database server ping of sorts.
Thank you,
Jim
I'm setting up a simple SSRS implementation for a non-profit organization, using two servers hosted at a data center. The first server has SQL Server Standard Edition and Reporting Services installed. I've designed and deployed a number of useful reports on this server.
I was hoping to isolate this first server by installing IIS and SSRS on the second server, have users browse from the Internet to that second server (over SSL, of course), and have all reports served up from databases (and, presumably, the report server database) on the first server.
During the installation of SSRS on the second server, however, I'm being prompted to specify the service account. According to the help text:
"Reporting Services. Service accounts are used to configure a report server database connection. Choose a domain user account if you want to connect to a report server database on a remote SQL Server instance. If you are using a local report server database, you can use a domain user account or Local System to run the service."
I believe I want to configure SSRS to connect to a report server database on a remote SQL Server instance; therefore, it appears that I need to enter a domain user account. The only problem is, neither server belongs to a domain; they are members of a simple two-server workgroup.
Does SSRS, configured to connect to a report server database on a remote SQL Server instance, require a domain? Does what I'm hoping to accomplish require a domain? Creating a two-server domain seems like overkill for this implementation, doesn't it?
I appreciate any comments and suggestions. Thanks!