Four-Part Name Requirements For OLE DB Providers
Jul 27, 2006
Could any one pls Explain about the Four-Part Name Requirement for OLE DB Provider.
Thanks
-Sivaraman Latchapathi
Could any one pls Explain about the Four-Part Name Requirement for OLE DB Provider.
Thanks
-Sivaraman Latchapathi
Hi,
I have a DTS package which is using OLEBD provider for Oracle, it was working fine. I tried to open this package and I got this error message "There was a problem retrieving the list of OLE DB Providers"
I tried to intall MDAC8.2, it didn't help, should I reinstall SQL Server?
Thanks!
can any one please give a technical defenition for OLEDB providers
View 1 Replies View RelatedI lost in SQL Server 2000 with SP3a on W2K Server Ole DB Provider.
When I trying make new linked server I cannot select Provider name,
because menu is empty. Existing link between SQL servers returning error message 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 0x80004002]. I tried completly uninstall SQL from server and I installed server again without success.
Hi,
I have Windows server 2003 SR2 and wich to install on it OLE DB Providers. I mainly have an application that needs OLE DB provider for Excel and Dbase to access read excel and dbase Files on disk. I have searched all over the web for a download link. I installed MDAC on the server and restarted bu still no luck. My ODBC applet in the control panel only shows the SQL native drivers.
PS: Windows is 64 bit. I believe this might be why. But what can I do in this situation?
please help
Thanks
I have installed the latest 64-bit Oracle10g Release 2 ODAC for Windows x64 (10.2.0) client software in a 64 bit server but I am having the following issues:
After I installed the software and I try to create a new connection in SSIS using the OLE DB or .NET provider, the providers do not show as an option in the connections.
I believe I am missing one step in registering the driver in the server but I do not known where, Could it be a permissions issue?
In addition, I tested the ODBC connection and I had to declare the path for the Oracle path in the environment variable manually since it was not set during the installation. ODBC connections are working correctly.
Does anybody knows what steps I am missing?
Thanks in advance
Gerry
Hi there,
I am trying to configure an SSIS connection manager to recognise a SQL Server 6.5 database but I can't get it to work. Testing the connection works but I am unable to select a database from the drop down list.
Which OLE DB provider should I use to access a SQL Server 6.5 database?!
_________________________________________________________________________________________________________________________
Inability is a disaster; patience is bravery; abstinence is a treasure, self-restraint is a shield; and the best companion is submission to Divine Will.
Hi,
I am planning on using SSCE in a desktop embedded scenario. In considering deployment options, in addition to the SSCE runtime, I would also need to bundle either MDAC (OLEDB) or .NET Framework 2.0 (ADO.NET).
From the installer footprint standpoint, it's a no-brainer since MDAC is much smaller in size than .NET Framework. However, an article from the MSDN library (http://msdn2.microsoft.com/en-us/library/aa719514(VS.71).aspx) talks about the .NET Framework Data Provider for SQL Server and how it performs much better than the OLEDB counterpart.
So my question is, how much of a performance difference is there between using the OLEDB provider vs. the ADO.NET provider? I am primarily concerned with insert speed.
Also, it does seem a little silly when you need a 22.4Mb installer (.NET Framework) for a provider to a database that is under 2Mb in size.
Eugene
In step one of this Blog ,what's this mean
Step 1: Create or obtain a blank SQL database instance
and how do i go about doing it
http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx
Hi all,
Since I activated the aspnet_regsql.exe tool, it has been a bad day - here's why:
Originally I installed VS2005 Pro (without Sql Express) and then Sql Server 2005 Dev. I then started to learn asp.net from the ".NET FRAMEWORK 2.0 Web-Based client Development" Training kit from Micorsoft. I have compiled and run every exercise up till Chapter 9 lesson 2 exercise 1, without the need to start the Sql Server 2005. In exercise 2 I should learn about asp.net profilers and the exercise showed me to use the aspnet_regsql.exe tool if I was using Sql Server 2005 - and so I did, and exercise 2 worked fine after a couple of adjustment in the connection string, because it was configured to use the SQLEXPRESS server by default.
However - in Chapter 9 lesson 3, I should not use asp.net providers, so I shut down the Sql Server 2005, because I don't have that much memory to spend. Now the trouble comes - every website I have made afterwards require that the Sql Server 2005 is running or else I get some errors.
How can I get back to the way it was before I activated the aspnet_regsql.exe, so I don't have to have the Sql Server 2005 running every time I want to make a website using aspx?
Thanks in advance
For the second time in as many months I've been asked the question. What is the license requirement for me, the service provider, for offering my clients the ability to use SQL Server Express?
I understand the license to say that as long as I'm registered (no cost) there is no further licensing needed in order to offer this to my clients.
Could someone clarify this for me? If I'm incorrect I'd appreciate the right answer.
Thank you!
I have SSRS 2005 SP2 configured to work in Sharepoint integration. Everything works fine except that I am not able to programmatically change any property of report viewer web part (instance) that I have added on on home page of my sharepoint site.
I can do same thing via sharepoint UI but not through program. When my programs runs it fetches all web parts been added on home page, then I need to iterate through each one and find report viewer web part.
While iterating, as soon as I arrive to report viewer web part it is named as "Error web part" with error message as
"Windows SharePoint Services cannot deserialize the Web Part. Check the format of the properties and try again"
If someone has a solution, please respond at your earlist.
Thanks
Shankar
I have a table with a column named measurement decimal(18,1). If the value is 2.0, I want the stored proc to return 2 but if the value is 2.5 I want the stored proc to return 2.5. So if the value after the decimal point is 0, I only want the stored proc to return the integer portion. Is there a sql function that I can use to determine what the fraction part of the decimal value is? In c#, I can use
dr["measurement "].ToString().Split(".".ToCharArray())[1] to see what the value after the decimal is.
I have made the following Scalar-valued function:
CREATE FUNCTION [dbo].[TimeCalc]
(
@OriginalTime AS INTEGER
, @TenthsOrHundredths AS INTEGER -- code 2: 1/10, code 4: 1/100
)
RETURNS NVARCHAR(8)
[Code] ....
What it does is convert numbers to times
E.g.: 81230 gets divided by 10 (times in seconds: 8123). This 1 1 full minute, and the remainder = 2123 making it 1.21.23 mins)
So far so good (function works perfectly)
My question: sometimes times are in 1/100 (like above sample), sometimes in 1/10.
This means that, e.g. with a time like 3.23.40 the last zero must be deleted.
My thoughts are to use the results from the Return Case part, and as the code = 4: leave it as it is,
is the code 2 the use LEFT(... result Return Case ..., Len(..result Return Case.. - 1))
There are 5 codes: 0 1 2 3 and 4
This is taken directly from a job requirement (names are not mentioned to protect the ignorent...I meant Innocent): The employee must occasionally lift and/or move up to 25 pounds. While performing the duties of this job, the employee is frequently required to stand; walk; sit; talk or hear; use hands to finger, handle, or feel; reach with hands and arms; climb or balance; stoop, kneel, crouch, or crawl.
View 6 Replies View RelatedI am considering buying a new home PC but want to make sure it can handle SQL 2005. Most of what Im looking at comes with XP Home edition. I found this:
http://www.microsoft.com/sql/editions/developer/sysreqs.mspx
but it doesnt specifically say Home edition, and I dont want to purchase without knowing this first. Does anyone know a link that would specify this?
TIA, cfr
saravanan writes "hi,
At present i am a B.E. i am quite intrested in sql servers.
i want to be a full fleged DBA. so please guide me , what are the basic requirements and necessary exams to be given for the same and become a DBA in a minimum required time?"
For SQL 2000, what are the licensing requirements for a clustered environment? I thought you needed datacenter for the OS, is there a clustered version of sql server, or do you need 2 copies of enterprise edition. Also, if you cluster can you license sql cals for clients, or do you have to do by processor?
View 4 Replies View RelatedI have a sql server (2k sp4), a web server and a development machine.
I need to install sql server reporting services and am confused as to the prerequisites and as to what gets installed where.
Is there a server install and a client install or do I run the same install on both (and deselect what's not required on each).
Sorry it's a bit vague but in my research various people have told me various different things.
Hey all,
I couldn't find an answer anywhere on the site, if there is one, could you please let me know where to go? Thanks.
Here goes. We receive large csv files, around a million records a month. What we need to do is:
- Of course, import these records
- Be able to run failry heavy reports on around 3 months worth of data (about 3 million records)
- Wanting to store at least a years worth of data
What I need to know:
- What server(s) spec (CPU, HDD, memory, etc) would we need to import and run reports quite fast. Don't want the reports/imports to take days to run. The reports will need to be run by about 3-5 people at the same time
- What OS and database type should I use (I was looking at Windows/Linux and MS SQL/MySQL)
- If we run these types of reports, can we use the same SQL server to run/store other applications (eg. CRM, etc) with no real impact on performance. There would be at least 20 people using the CRM database at the same time.
Thanks
Can 2005 be installed on XP Media Center Edition? I looked on the SQL site,
but it only references Windows XP, not this particular version. Any whitepapers, links, etc., would be especially appreciated.
TIA, ChrisR
What are the minimum requirements for setting up replication ?
i mean, the connection requirements, bandwidth requirements, minimum hardware and software requirements ?
Is it possible to setup a replication across the internet ?
I have seen it mentioned that, unlike with the MSDE where DTS runtime was covered, the new SSIS is not covered by the SQL Server 2005 Express.
Does anybody know of an official microsoft web page detailing comprehensively what is required.
As far as I can gather the client will need a full version of SQL Server 2005, enabling the installation of the client tools, which as far as I can tell are required for the running of the SSIS.
This statement could be totally wrong but clear information seems hard to come by and seems mainly hearsay.
Thanks
What security settings are needed to allow users to veiw reports using SQL Server 2005 Reporting Services Web interface. We have tried adding users to Active Directory Groups and adding these groups to: the security of the folder containing the reports in Reporting Services and the security of the individual reports in Reporting Services. What am I missing? Does something need to be set when creating the report itself?
View 6 Replies View RelatedHello experts out there,
Just one quick question, will installing reporting services require the server to reboot or sql to restart? I'll do this to a production server and just wonder if I can do while the box is in use.
Thank you in advance. You guys rock!
I recently was moved into an applications developers position here at the lawfirm I work at.
Thusfar, its been alot of straight ASP, SQL2000, and Access.
I know the need for me to know .Net is coming, and Ive decided to start playing with ASP.net so I can look a bit proactive..
Ive looked over what I need to get started, in liu of Visual Studio I know of the VS Express options. However, I currently have SQL Server 2000 installed locally on my machine along with IIS 5.1. All the VS Express information Ive found keeps referencing SQL2005 express. Can I get away with using what I already have with 2000? Or if not, can SQL2005 express be run alongside with SQL2000?
Any assistance would be greatly appreciated.
Brian
hello,
What are the requirements to install sqlserver2005 in my pc.I am using windows xp sp2 in my pc.
One of my friend said, windows server2003 is compulsory(to get data base functionality in sqlserver 2005 and other features) in local pc .Is it correct?
And i am not getting database features in xp sp2.
Can any one help me?
Anyone know where to find some hardware requirements based on database size? Thanks!
peter
Hello!
Does anyone know where can i find an information about hardware requirements for SQL-Server 2000. I mean information of different kind of cases (amount of users and transactions etc).
thanks!
Juise K.
I had some issues yesterday with the fact that some of the tables I had indexed views for did not have a unique/clustered index. The tables had unique indexes and clustered indexes but not a unique/clustered index. What I was seeing were rows that should have been in the view, not showing up in a regular select but they would showup in a with noexpand hint.
To fix the problem I created a unique/clustered index on each of the underlying table but cannot find that requirement anywhere, is this a requirement and if so can someone tell me where to find it.
Thanks
Hi ,
I want to install a new SQL 2005 server. i looked on MSDN, it says to create one or more domain user accounts. That means to create a windows domain. Is it neccessary? All I want is a stand-alone SQL server. right now we are working with SQL 2000 and we want to build a new server with SQL 2005.
Please send me a short feedback.
We have a win2003 server box that is using MS-SQL 2000. We have a 20user license on this server at the present time. We have a need toallow up to 5 simultaneous additional users access to a subset of thisdata from our IIS server. How does this affect my current SQL ServerLicense? We can restrict access via connection pooling, etc. Can weuse a 30 user license or must we go to a CPU license? Does anyoneknow where to find Microsoft licensing information on this?
View 1 Replies View RelatedWe€™re doing a website for a TV station, and they want to have a live TV broadcast on their website, our experience is basically in CMS and portal solutions, but we never had any experience in live streaming, so this is all new to us, so we€™re looking for a technical and financial proposal with your suggestions and recommendations, this is the details of the project with some of the inquiries we have:
-The signal is SDI (Pal 25 fps)
-The output (online streaming) 15 fps
-The user will have two options to view the movie in:
1. Low: 56K
2. High: 300K
-The video should come within a customized designed page, probably as a code we can place inside an html table€™s cell, not as a link for external link
-We€™re expecting about 200 users for the video each month; each user€™s logon time expected 10 min.
-We have a Red hat Linux on our server that will host the site, and we use php/MySql technology.
Inquires:
1. Why Windows media is better then Real in terms of performance, can you provide us with a comparison table to include it to our client?
2. If we choose Windows media, what are the requirements we need to have, form both; the TV station side, and in our Linux server? And how much would it cost?
4. Is there any hardware required from the TV station side such as DVR, or some sort of encoder, if so; what€™s you€™re recommendations (type/ brand), please note that this is a TV station and it needs a high quality professional hardware
5. How (and this is probably the most ambiguous task)
5.1. Do you broadcast the digital signal coming from the encoder (I guess) to the server?
5.2. And then place this signal on a PHP page? Do you give us a link to embed in our code?
6. If we choose to host the live streaming on a separated server and include the URL in our code, would that still required from our server to support Windows media, or it doesn€™t matter as long as the video streaming is hosted on a Windows streaming server
7. How much disk space does it need to host a live streaming (with the details mentioned above)?
We would really appreciate your comments and suggestions, as this is our 1st time to dealing with live streaming.