Dear friends,
After installing visual interdev, on a webserver (nt4.0 ent server),
whenever I was trying to configure the DSN on the ODBC settings, It gives
" The ODBC resource DLL (C:WINNTSYSTEM32odbcint.dll)is a different
vaersion than the ODBC setup dll(c:winntsystem32odbccp32.dll)
you need to reinstall the ODBC components to ensure proper operation." error msg.
I thought of removing all the ODBC drivers and reinstlling the odbc drivers came with NT SERVER. I don't know how to do it. If anyone knows how to do it, can you please post it. Thanks a lot.
The programmers encountered a problem as following:
Different programmers use the same account(Admin) to login to the same database to create table from different workstation. The tables were created through the same steps which is highlighted the Table folder -->New table then go through the wizard. The table were created successfully but the ownership were different. One with Admin as owner, the other has dbo as owner. Even Admin is the owner of the database but this created a problem for them that they need to specify differently for the tables depend on who created them.
what is the cause of this, sevice pack 3 is installed on the machine.
hi, i have got 10 dts packages i want to create a job and put them all into that job. I could not execute the dts create in tsql. Can any one say as how to execute that in the job.
Babu.G here, Working as MS-SQL DBA IN MNC..I HAVE A DOUBT SO PLEASE CLARIFY THAT..WHERE SHOULD I DECLARE GLOBAL VARIABLES..FOR EXAMPLE @@ROWCOUNT AND MANY.. LIKE THAT I NEED TO DO..
IN CASE IF I AM DECLARING ONE @@GLOBAL VARIABLE IN PROC AND STORING SOME VALUES IN THAT IF CALLED THAT VARIABLE INTO SOMEOTHER PROC ..IT IS GIVING ERROR..
im currently using sql server 2000... is there a datatype or a way so that you dont have to limit the length that a user can enter into a textbox (for example) that will be saved in a column in a table in sql server?
There was someone who got into the system and modified the database properties to DBO use only..what we want to do is to track such changes with when they did.
As like what happened earlier..some told me about turning the audit level to all will help but it does not give the information about who has did and what did they do...
Is there a way in which we can find out what happened and who did this what command they have executed...
Hello I have the following query set up and I am getting the errors of: Any help on this would be appreciated.
Thanks Stuck !
Server: Msg 107, Level 16, State 3, Line 2 The column prefix 'TEAM3B_PULL_TOTAL_TST' does not match with a table name or alias name used in the query. Server: Msg 107, Level 16, State 1, Line 2 The column prefix 'BUS_REQ_DESCRIPTION_TST' does not match with a table name or alias name used in the query. Server: Msg 107, Level 16, State 1, Line 10 The column prefix 'TEAM3B_PULL_TOTAL_TST' does not match with a table name or alias name used in the query. Server: Msg 107, Level 16, State 1, Line 10 The column prefix 'BUS_REQ_DESCRIPTION_TST' does not match with a table name or alias name used in the query.
Select REQUEST,BUSINESS_REQ_ID,TEST_CASE_SOURCE as SOURCE from TEAM3B_PULL_TOTAL_TST if TEAM3B_PULL_TOTAL_TST.REQUEST<>BUS_REQ_DESCRIPTION_TST.REQUEST begin Insert into TEST_REPORT.dbo.BUS_REQ_DESCRIPTION_TST(request,bu siness_req_id,source) select request,business_req_id,test_case_source as source from TEAM3B_PULL_TOTAL_TST end Else begin if TEAM3B_PULL_TOTAL_TST.REQUEST=BUS_REQ_DESCRIPTION_ TST.REQUEST begin Insert into TEST_REPORT.dbo.RDD_UPDATE_TST(request,business_re q_id,test_case_id,test_case_descr) select request,business_req_id,test_case_id,test_case_des cr from TEST_REPORT.dbo.TEAM3B_PULL_TOTAL_TST order by TEAM3B_PULL_TOTAL_TST.REQUEST,TEAM3B_PULL_TOTAL_TS T.BUSINESS_REQ_ID,TEAM3B_PULL_TOTAL_TST.TEST_CASE_ ID end end
if (select REQUEST from TEST_REPORT.dbo.TEAM3B_PULL_TOTAL_TST) Not In(select REQUEST from TEST_REPORT.dbo.REQUEST_BUS_REQ_TST) begin Insert into TEST_REPORT.dbo.REQUEST_BUS_REQ_TST (b.request,b.business_req_id,b.bus_test,b.test_cas e_id,b.test_case_source,b.test_case_descr) select a.request,a.business_req_id,a.bus_test,a.test_case _id,a.test_case_source,a.test_case as test_case_description from TEST_REPORT.dbo.TEAM3B_PULL_TOTAL_TST AS A INNER JOIN TEST_REPORT.dbo.REQUEST_BUS_REQ_TST AS B ON A.REQUEST = B.REQUEST Order by REQUEST,BUSINESS_REQ_ID,TEST_CASE_ID end
I am getting the error messages of:
Ambiguous column name 'REQUEST'. Ambiguous column name 'BUSINESS_REQ_ID'. Ambiguous column name 'TEST_CASE_ID'.
I am given to install ODBC drivers in two servers and main thing is they are clustered . SO do i have to install in both servers or CLuster will configure that. Urgent help please . Thanks
hi, I am recently upgraded to sql 7.0, my clients are having 6.5 and 7.0 versions means we are still having some 65 servers. When they try to connect to new 70 server it is saying ''login failed''. I think it is trying to connect to old sql 65 version, what i have to do to connect to sql70 for clients.. They are having both 7.0 and 6.5 servers. Can anyone pls assist me regarding this.
Hi all, I have some problem : I use sql server 2000,I have about 20000 records ! I delete all data unfortunately ! So , i need to restore all . Are there way to do this ? I don't setup automatic backup ! My data is very important !
I tried SQL mirroring in beta 1 , then it was gone, until SP1.
Now I can not setup mirror, it is fine if it is just hard to setup, but it seems it is full of bug! The mirroring has to be stable, since I am trying to mirror product db, what a diaster if something goes wrong.
I am trying two servers, both has 9.0.3042. First I tried to setup on my home machine, I VPN to my network, After I config security, I see two connection strings:
and it doesn't show that error anymore, I am not sure why the connection should be like the latter format, but in anyway, how come SMO can not make it right?
then I get another error, SQL server doesn't exist or can not access, I search on the Internet, it seems that error could mean anything, include that the mirror db is not in restore mode.
But I did set the mirror db in restore mode and both sql5 and sql8 are under same domain, pysically close.
Our SSIS package suddenly stopped loading. We have 64 bit server on which we run SSIS packages. We had problem "script task failed to load" so we started to use the 32-bit version of dtexec to run the packages. Package used to run fine.
Today we upgraded our server to Sp1 and 2153 hot fix (x64) and now the package have stopped to load.
we confirmed that the issue is not as inthe KB below: http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B918038
We are still using the 32-bit version of DTExec(as in SQLx86). With 64 bit we get the error "script faield to load". we are going to fix the script failed to load error but, we need help to get going right now.
help would be greatly appreciated
Message:- Executed as user: PHX\_IDSS-OPS. ... Package Utility Version 9.00.1399.06 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 1:13:48 AM Error: 2006-07-28 01:14:50.11 Code: 0xC0010018 Source: Description: Error loading value "<DTS:LogProvider xmlns:DTS="www.microsoft.com/SqlServer/Dts"><DTS:Property DTS:Name="ConfigString">AdCenterExtractionLog</DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property><DTS:Property DTS:Name="ObjectName">SSIS log provider for Text f" from node "DTS:LogProvider". End Error Could not load package "D:adcenterDWApplicationBINACDWExtraction.dtsx" because of error 0xC0010014. Description: The package failed to load due to error 0xC0010014 "One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors.". This occurs when CPackage::LoadFromXML fails. Source: . The step failed.
Dear Friends, I have a IIS 4.0 server ( configured as virtual multi servers), and a sql server containing multiple databases. each virtual server should access a unique database on the sqlserver. How can we configure this setup on both servers? Note:the owner of each multi server (dbo)will own a unique database. they are bound to only with theirs database only. Please help me on this issue? Thank you all and Happy holidays!!!!!
Dear Friends, I have a IIS 4.0 server ( configured as virtual multi servers), and a sql server containing multiple databases. each virtual server should access a unique database on the sqlserver. How can we configure this setup on both servers? Note:the owner of each multi server (dbo)will own a unique database. they are bound to only with theirs database only. Please help me on this issue? Thank you all and Happy holidays!!!!!
I am having a problem getting into SQL 2005. My connection string is as follows:
using System.Data.OleDb;
OleDbConnection conn = new OleDbConnection(@"Provider=SqlOleDb;Data Source=Orange;Initial Catalog=Test;"); //tried with taking out comma after Test as well.
I have tried a lot of different permutations here and I cannot get this to work.
Hi, I'm configuring a maintenance plan for my SQL Server 2005. Is the order of things important here? I can't seem to find any best practices for this anywhere.
hi,If we consider the following scenerio:a school with 500 students.On average student takes [x] courses per year, and [y] tests per course.table of grades:+------------+-----------+---------+-------+| student_id | course_id | term_id | grade |+------------+-----------+---------+-------+| | | | |+------------+-----------+---------+-------+| | | | |+------------+-----------+---------+-------+as average, x = 20, y =6 thennumber of records = 500 * 20 * 6 = 120,000 record per year.is this design correct considering number of records generated per year?Is it important to reduce the "number of records" or no?thank you.
There are twelve more exams will retire on March 31st, 2009. Microsoft has announced this information. These exams focus on technologies will be no longer included in Microsoft mainstream support. The exams are currently required to achieve Microsoft Certified Application Developer (MCAD), Microsoft Certified Solution Developer (MCSD), and Microsoft Certified Database Administrator (MCDBA) certifications. Details: Developer exams that retire on March 31, 2009 ’ Exam 70-300: Analyzing Requirements and Defining Microsoft .NET Solution Architectures ’ Exam 70-301: Managing, Organizing, and Delivering IT Projects by Using Microsoft Solutions Framework 3.0 ’ Exam 70-305: Developing and Implementing Web Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET ’ Exam 70-306: Developing and Implementing Windows-based Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET ’ Exam 70-310: Developing XML Web Services and Server Components with Microsoft Visual Basic .NET and the Microsoft .NET Framework ’ Exam 70-315: Developing and Implementing Web Applications with Microsoft Visual C# .NET and Microsoft Visual Studio .NET ’ Exam 70-316: Developing and Implementing Windows-based Applications with Microsoft Visual C# .NET and Microsoft Visual Studio .NET ’ Exam 70-320: Developing XML Web Services and Server Components with Microsoft Visual C# and the Microsoft .NET Framework ’ Exam 70-330: Implementing Security for Applications with Microsoft Visual Basic .NET ’ Exam 70-340: Implementing Security for Applications with Microsoft Visual C# .NET Microsoft SQL Server exams that retire on March 31, 2009 ’ Exam 70-228: Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition ’ Exam 70-229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition
We're developing a WinForm app that is being deployed via ClickOnce. The application will have the ability to import/export data with the intention of this being done via SSIS. When this app is deployed and run against SQL Express, the following error gets generated:
Retrieving the COM class factory for component with CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to error: 80040154?.
Hi everyone, I have a question. We need to create a server report to display a one product's information at the left (datasource with a one ID of selected product) and other products to compare at the right (second datasource with N of IDs of products to compare). The problem is how to duplicate the first List element with selected product on the every page (by default it renders only on the first page)? Any ideas?
Hello everyone, I've been searching the forum for three hours now and I couldn't find anything that helped me. First I thought I didn't install the SQL server properly, I now found out that it is installed properly. I am using VWD 2008 Express Edition. I could access the aspnetdb in the SQLExpress server. I could modify entries and create new databases. So the server obviously works.
Problem -> I cannot access the WebSiteAdmin modul ... for no apparent reason, it always gives me a timeout.
If you restart the tool by clicking the asp.net icon in the traylist stop it, then retry over the button in the VWD, then I did that a dozen times. I restart the tool and then access it five seconds later, no matter what I do I always get a time out.
Any help is appreciated, I can't solve this and I really really need it. Thanks a lot in advance.
I am trying to perform a performance audit on a SQL Server where I am positive my most likely bottle neck is the disks. I assume the primary metrics I should be interested in are %Disk Activity and Disk Queue Length, right?
What are the actually guidelines for these metrics? Also, Are there other perf mons I should be running against the disks?
Some of you may have read my thread a while back complaining about SQL Server 2005 not being able to install with some errors about assemblies installing due to admin rights or some other type of error.
I am using SSIS 2014 with the below .net framework version and installed in Windows server 2012 R2 . I have installed my client's odbc drivers (both 32 bit and 64 bit) in my production server and created ODBC system DSNs for 32 bit and 64 bit.
When i open SSIS 2014 and tried to create the odbc connection but i can able to see only the 32 bit system DSN connection ,i can't able to see my 64 bit odbc system dsn connection.
Microsoft Visual Studio 2012 Shell (Integrated) Version 11.0.50727.1 RTMREL Microsoft .NET Framework Version 4.5.51650
SQL Server Integration Services Β Β Microsoft SQL Server Integration Services Designer Version 12.0.1524.0
And i installed my client odbc drivers(32,64 bit) and created ODBC system DSNs in my local system and when i open ssis 2014 and i can able to see both the ODBC system DSNS(32,64) connections from SSIS ODBC connection.
I am using below version of .net framework in my local system which was installed in windows 7 and i have SSIS 2012 also installed in my system and i can able to see both ODBC connections using 2012 as well in my local system.
Microsoft Visual Studio 2012 Shell (Integrated) Version 11.0.50727.1 RTMREL Microsoft .NET Framework Version 4.5.50938
SQL Server Integration Services Β Β Microsoft SQL Server Integration Services Designer Version 12.0.1524.0
why i can not see the ODBC 64 bit system DSN connection from SSIS in my production server ?
I am using VB.NET 2005 and set up an ODBC connection via ODBC.ODBCConnection to a MDB database. Therefor, I use the "Microsoft Access ODBC Driver (*.mdb)".
When I set up a ODBCCommand like "ALTER DATABASE..." or "CREATE TABLE..." and issue it with the com.ExecuteNonQuery() command, I get an error from ODBC driver, that a SQL statement has to begin with SELECT, INSERT, UPDATE or DELETE.
How can I use DDL statements via ODBC?
I would appreciate if you could help me to use ODBC for that - no OLE, no ADO.
I apologize if this is not the correct forum for this posting. Looking at the descriptions, it appeared to be the best choice.
I am running Windows XP Pro SP2. I have installed the SQL Native Client for XP. However, when I try to add a new data source through ODBC Connection Manager, SQL Native Client is not listed as an option. I have followed this procedure on three other systems with no problems. What would be causing the SQL Native Client to not show up in the list of available ODBC data sources?
Hi all,I am having trouble getting linked Oracle 9 server in MS SQL Server2005 Express to work properly. My machine is running Windows XP.The Microsoft and Oracle OLE DB Providers have problems dealing withOracle's Numeric Data Type, so I decided to use Microsoft's OLE DB forODBC Provider and an Oracle ODBC source. When using the Microsoft ODBCfor Oracle Driver in my ODBC source I have inconsistent behavior.Sometimes my queries are processed properly, then other times I get thefollowing errorOLE DB provider "MSDASQL" for linked server "ODBCBEAST" returnedmessage "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttrfailed".OLE DB provider "MSDASQL" for linked server "ODBCBEAST" returnedmessage "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttrfailed".OLE DB provider "MSDASQL" for linked server "ODBCBEAST" returnedmessage "[Microsoft][ODBC driver for Oracle][Oracle]".Msg 7303, Level 16, State 1, Line 1Cannot initialize the data source object of OLE DB provider "MSDASQL"for linked server "ODBCBEAST".I have no idea why sometimes I can connect to the linked server with noproblems andwhy other times it performs like this. I'm not changing anything aboutthe system I can think of. When I use an Oracle client (PL/SQL) I haveabsolutely no problems connecting. TNSPING returns that the connectionis good.This is unacceptable so I decided to try my luck with the Oracle 10gODBC driver. However when I use this and perform an openquery selectagainst the linked server I get back only 11 rows, when I know that thedatabase has over 100 rows (in fact when using the Microsoft ODBCdriver and it works that's what I get). I figured maybe the buffersetting needed to be raised in the ODBC configuration so I took it from64000 to 600000 (a magnitude of 10) but I still get back only 11 rows.I'm at my wit's end.Any suggestions on resolving one or the other problem would be muchappreciated.Thanks much
Please help share with me if you know the version compatibility matrix of Ms SQL Server, ODBC driver (sqlsrv32.dll), Driver Manager (odbc32.dll) and ODBC API spec. For instance, how can I know Ms SQL Server 2000 can work with which version of sqlsrv32.dll, a particular version of sqlsrv32.dll can work with which version of odbc32.dll and a certain version of sqlsrv32.dll/odbc32.dll conforms to which version of ODBC API spec (e.g. 3.5).
On localhost this application works fine but when I put on remote server. I am getting following errors. For both localhost and server, I am using same remote sql 2000. I will appreciate any help.
Thanks,
Arif
Server Error in '/' Application. --------------------------------------------------------------------------------
ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: Microsoft.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
I am using the following connecting string in report.aspx.vb and would like to use ODBC (DSN) string, how to? Dim myConnString As String = "server=TESTSQLEXPRESS;database=test;uid=test;pwd=12345"Dim dbConnection As System.Data.IDbConnection = New System.Data.SqlClient.SqlConnection(myConnString)
