SQL Server Management Studio: following

Showing posts with label following. Show all posts

Friday, March 30, 2012

Migrating ext drive array

Please consider the following scenario
I have sql 7 NT server the application is on the C:\
and the databases are stored on a external drive array
i.e D:\
What i want to do is migrate the external drive array
from the above server to a new sql7 NT server of higher
spec.
Has anyone attempted this before or any ideas on how to
do this. I believe that i will have to start sql in
single user mode after the arrray is attached and run a
attach comand within query analyzer.
Any help would be much appreciated.You won't have to start the server in single-user mode... But you will have
to put the database in single-user mode to detach it (if that's how you
choose to get it over to the new server.) Your options are to detach it
from the old server, copy it, and re-attach it, or back it up and restore it
on the new server... Pretty much equivalent options except that backup will
double the disc space required (as you will have the database files as well
as the backup file to deal with); detach/attach, on the other hand, will
require you to A) put the database into single-user mode, and B) take it
offline while you copy the files, which you will not have to do with a
backup. So weigh your options carefully...
"Jonathan Gray" <jonathan.gray@.exel.com> wrote in message
news:0dbc01c3adda$7e102950$a101280a@.phx.gbl...
> Please consider the following scenario
> I have sql 7 NT server the application is on the C:\
> and the databases are stored on a external drive array
> i.e D:\
> What i want to do is migrate the external drive array
> from the above server to a new sql7 NT server of higher
> spec.
> Has anyone attempted this before or any ideas on how to
> do this. I believe that i will have to start sql in
> single user mode after the arrray is attached and run a
> attach comand within query analyzer.
>
> Any help would be much appreciated.

Wednesday, March 28, 2012

Migrating DTS Active X/ADO script to SSIS

Hi All,

In SQL Server 2000 DTS, I had an Active X script that, using ADO, performed the following basic operation:

Retrieve a list of account numbers through Recordset1
While Not Recordset1.eof
Build a sql statement based on fields from current row of Recordset1
Open Recordset2 based on the sql statement built
Run an update query based on results from recordset 2
Loop

I want to bring this over to SSIS, but i'd like to take advantage of the most current "ways of doing things" instead of just using SSIS's activex script.

Does anyone have any recommendations on the best way to handle this type of thing in SSIS? A script task? A script component? I've never really worked w/ ADO.net so if it involves that I'd have to pick up some pointers... any suggestions?

Thanks in advance
Jeff

A script task would be one way to do this. You could use an ADO.Net connection in the Script. You can then use that to help manager the connection information, and it will return a SqlConnection for use in the script. For example-

Public Sub Main()

Dim connection As SqlClient.SqlConnection = CType(Dts.Connections("MyAdoSqlClient").AcquireConnection(Dts.Transaction), SqlClient.SqlConnection)

Dim command As New SqlClient.SqlCommand("EXEC ProcName", connection)

command.ExecuteNonQuery()

Dts.Connections("MyAdoSqlClient").ReleaseConnection(connection)

Dts.TaskResult = Dts.Results.Success

End Sub

A script component is only used inside the data flow, and this doesn't seem like it is moving data anywhere really. You could use a data flow, OLE-DB Source to Recordset Destination, but then what. I think this fits into the over engineered category as does the option below.

Alternative methods could be to use the Execute SQL task to get the recordset and the For Each Loop to process the recordset. I'd be tempted by this option. I'd use a script task maybe to just build teh SQL statement inside the loop, then store it in a variable. I don't quite get the Recordet2 and Update steps, but maybe an Execute SQL Task would do this. If you don't end up with any real worker tasks inside the For Each Loop, then I would just do it all in a Script Task again, but using VB.Net and the nice things it gives over ActiveX Script.

Monday, March 12, 2012

Migartion issue with ORDER BY Clause

Please help me how to write the following query in SQL Server 2005

SELECT 3,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
CONVERT(char(10), fulldate, 126),
CONVERT(char(8), fulldate, 108),
flag = CASE Invalid WHEN 'Y' THEN 2 ELSE 1 END,
srk
FROM #raw
ORDER BY tag, parent, 'Value!3!date' asc

HUH?

What's the error?

And what's

Code Snippet

'Value!3!date' asc

|||

Sorry. i had not copied full query.Actually i am migrating Database from SQL Server 2000 to SQL Server 2005.I used SQL Server 2005 upgrade advisor.It shows where i need to modify the query.

Error is:Upgrade Advisor detected the use of noninteger constants in the ORDER BY clause of one or more statements. Noninteger constants are allowed (and ignored) in the ORDER BY clause when the database compatibility mode is set to 80 and earlier. Noninteger constants in the ORDER BY clause will cause the statement to fail when the database compatibility mode is set to 90.Upgrade Advisor detected the use of noninteger constants in the ORDER BY clause of one or more statements. Noninteger constants are allowed (and ignored) in the ORDER BY clause when the database compatibility mode is set to 80 and earlier. Noninteger constants in the ORDER BY clause will cause the statement to fail when the database compatibility mode is set to 90.

SELECT 1 AS tag,
NULL AS parent,
ISNULL(wmeWWTWMeter.wmeEARefNo,'not set')
AS [Station!1!stationReference],
sitSite.sitDescription AS [Station!1!stationName],
NULL AS [SetofValues!2!parameter],
NULL AS [SetofValues!2!qualifier],
NULL AS [SetofValues!2!dataType],
NULL AS [SetofValues!2!period],
NULL AS [SetofValues!2!characteristic],
NULL AS [SetofValues!2!units],
NULL AS [SetofValues!2!startDate],
NULL AS [SetofValues!2!startTime],
NULL AS [SetofValues!2!endDate],
NULL AS [SetofValues!2!endTime],
NULL AS [SetofValues!2!dayOrigin],
NULL AS [SetofValues!2!valuesPerDay],
NULL AS [Value!3!date],
NULL AS [Value!3!time],
NULL AS [Value!3!flag1],
NULL AS [Value!3!!element]
FROM sitsite INNER JOIN wmewwtwmeter ON sitsite.sitIdentifier = wmewwtwmeter.sitidentifier
WHERE sitSite.sitIdentifier = @.sitID
UNION ALL
SELECT 2,1,NULL,NULL,parameter,qualifer,dataType,period,characteristic,units,
CONVERT(char(10), mindate, 126),CONVERT(char(8), mindate, 108),
CONVERT(char(10), maxdate, 126),CONVERT(char(8), maxdate, 108),
dayOrigin,valuesPerDay,NULL,NULL,NULL,NULL
FROM #huwj INNER JOIN #minmax ON dummyKey = 'EA'
UNION ALL
SELECT 3,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
CONVERT(char(10), fulldate, 126),
CONVERT(char(8), fulldate, 108),
flag = CASE Invalid WHEN 'Y' THEN 2 ELSE 1 END,
Reading
FROM #raw
ORDER BY tag, parent, 'Value!3!date' asc

Could you please help in this.

Thank you,

Regards

Srikar

midian calculation

Hi guys,
I have a dilemma, I used the following query to find the Q-by-q median. It
uses a temporary table. I think it's because it has no index and foreign
key, it takes over 5 minutes to run. When we look at subquestions, there are
over 10,000 records and cross join takes forever. I don't know if I can
create indexes on temp table and wonder if the process will take long
anyway.
--Put the course marks in temp table
--DROP TABLE #QBYQ
CREATE TABLE #QBYQ (QUESTION_ID INT, QUESTION_POINT_MARK DECIMAL)
INSERT INTO #QBYQ
SELECT QM.QUESTION_ID, QM.QUESTION_POINT_MARK
from QUESTION_MARK QM, Question q, Enrollment e
where
e.ENROLLMENT_ID = qm.ENROLLMENT_ID
and q.QUESTION_ID = qm.QUESTION_ID
and e.COURSE_YEAR = 2005
and e.COURSE_SESSION = 1
and e.COURSE_CODE = 'FA4'
--and q.PARENT_QUESTION_ID is null
AND QM.QUESTION_POINT_MARK IS NOT NULL
and q.QUESTION_TYPE_CODE = 'EN'
ORDER BY QM.QUESTION_ID, QM.QUESTION_POINT_MARK
-- It is currently doing statistical median, the smaller of the two if even
rows
-- Get this working first before calculating the financial median (avg of
middle 2 rows)
SELECT Q.LABEL AS QUESTION,
QM1.QUESTION_POINT_MARK AS MEDIAN
from QUESTION Q,
#QBYQ QM1 CROSS JOIN #QBYQ QM2
WHERE QM1.QUESTION_ID = QM2.QUESTION_ID
AND Q.QUESTION_ID = QM1.QUESTION_ID
GROUP BY Q.LABEL, QM1.QUESTION_POINT_MARK
HAVING sum(CASE WHEN QM2.QUESTION_POINT_MARK <= QM1.QUESTION_POINT_MARK
THEN 1 ELSE NULL END)>=(COUNT(*)+1)/2
AND sum(CASE WHEN QM2.QUESTION_POINT_MARK >= QM1.QUESTION_POINT_MARK
THEN 1 ELSE NULL END)>=(COUNT(*)+1)/2
ORDER BY Q.LABEL
I then try to put the select in-line but didn't get the correct results. Can
you tell what's wrong? Looks like HAVING is not doing what it is supposed to
do.
SELECT Q.LABEL AS QUESTION,
QM1.QUESTION_POINT_MARK AS MEDIAN
from QUESTION_MARK QM1, QUESTION_MARK QM2, ENROLLMENT E, QUESTION Q
WHERE
QM1.QUESTION_ID = QM2.QUESTION_ID
AND QM1.QUESTION_ID = Q.QUESTION_ID
AND QM1.ENROLLMENT_ID = E.ENROLLMENT_ID
AND QM2.QUESTION_ID = Q.QUESTION_ID
AND QM2.ENROLLMENT_ID = E.ENROLLMENT_ID
and e.COURSE_YEAR = 2005
and e.COURSE_SESSION = 1
and e.COURSE_CODE = 'FA4'
and q.PARENT_QUESTION_ID is null
and q.QUESTION_TYPE_CODE = 'EN'
GROUP BY
Q.LABEL,
QM1.QUESTION_POINT_MARK
HAVING sum(CASE WHEN QM2.QUESTION_POINT_MARK <= QM1.QUESTION_POINT_MARK
THEN 1 ELSE NULL END)>=(COUNT(*)+1)/2
AND sum(CASE WHEN QM2.QUESTION_POINT_MARK >= QM1.QUESTION_POINT_MARK
THEN 1 ELSE NULL END)>=(COUNT(*)+1)/2
ORDER BY Q.LABEL, QM1.QUESTION_POINT_MARK
ThanksHi Ray5531,
Medians have been discussed many times in this newsgroup. You may want
to google past threads.
Maybe the following two threads help you out:
http://tinyurl.com/7ba4w
http://tinyurl.com/7fsjr
Hope this helps,
Gert-Jan
Ray5531 wrote:
> Hi guys,
> I have a dilemma, I used the following query to find the Q-by-q median. It
> uses a temporary table. I think it's because it has no index and foreign
> key, it takes over 5 minutes to run. When we look at subquestions, there a
re
> over 10,000 records and cross join takes forever. I don't know if I can
> create indexes on temp table and wonder if the process will take long
> anyway.
> --Put the course marks in temp table
> --DROP TABLE #QBYQ
> CREATE TABLE #QBYQ (QUESTION_ID INT, QUESTION_POINT_MARK DECIMAL)
> INSERT INTO #QBYQ
> SELECT QM.QUESTION_ID, QM.QUESTION_POINT_MARK
> from QUESTION_MARK QM, Question q, Enrollment e
> where
> e.ENROLLMENT_ID = qm.ENROLLMENT_ID
> and q.QUESTION_ID = qm.QUESTION_ID
> and e.COURSE_YEAR = 2005
> and e.COURSE_SESSION = 1
> and e.COURSE_CODE = 'FA4'
> --and q.PARENT_QUESTION_ID is null
> AND QM.QUESTION_POINT_MARK IS NOT NULL
> and q.QUESTION_TYPE_CODE = 'EN'
> ORDER BY QM.QUESTION_ID, QM.QUESTION_POINT_MARK
> -- It is currently doing statistical median, the smaller of the two if eve
n
> rows
> -- Get this working first before calculating the financial median (avg of
> middle 2 rows)
> SELECT Q.LABEL AS QUESTION,
> QM1.QUESTION_POINT_MARK AS MEDIAN
> from QUESTION Q,
> #QBYQ QM1 CROSS JOIN #QBYQ QM2
> WHERE QM1.QUESTION_ID = QM2.QUESTION_ID
> AND Q.QUESTION_ID = QM1.QUESTION_ID
> GROUP BY Q.LABEL, QM1.QUESTION_POINT_MARK
> HAVING sum(CASE WHEN QM2.QUESTION_POINT_MARK <= QM1.QUESTION_POINT_MARK
> THEN 1 ELSE NULL END)>=(COUNT(*)+1)/2
> AND sum(CASE WHEN QM2.QUESTION_POINT_MARK >= QM1.QUESTION_POINT_MARK
> THEN 1 ELSE NULL END)>=(COUNT(*)+1)/2
> ORDER BY Q.LABEL
> I then try to put the select in-line but didn't get the correct results. C
an
> you tell what's wrong? Looks like HAVING is not doing what it is supposed
to
> do.
> SELECT Q.LABEL AS QUESTION,
> QM1.QUESTION_POINT_MARK AS MEDIAN
> from QUESTION_MARK QM1, QUESTION_MARK QM2, ENROLLMENT E, QUESTION Q
> WHERE
> QM1.QUESTION_ID = QM2.QUESTION_ID
> AND QM1.QUESTION_ID = Q.QUESTION_ID
> AND QM1.ENROLLMENT_ID = E.ENROLLMENT_ID
> AND QM2.QUESTION_ID = Q.QUESTION_ID
> AND QM2.ENROLLMENT_ID = E.ENROLLMENT_ID
> and e.COURSE_YEAR = 2005
> and e.COURSE_SESSION = 1
> and e.COURSE_CODE = 'FA4'
> and q.PARENT_QUESTION_ID is null
> and q.QUESTION_TYPE_CODE = 'EN'
> GROUP BY
> Q.LABEL,
> QM1.QUESTION_POINT_MARK
> HAVING sum(CASE WHEN QM2.QUESTION_POINT_MARK <= QM1.QUESTION_POINT_MARK
> THEN 1 ELSE NULL END)>=(COUNT(*)+1)/2
> AND sum(CASE WHEN QM2.QUESTION_POINT_MARK >= QM1.QUESTION_POINT_MARK
> THEN 1 ELSE NULL END)>=(COUNT(*)+1)/2
> ORDER BY Q.LABEL, QM1.QUESTION_POINT_MARK
> Thanks|||On Mon, 25 Apr 2005 10:26:30 -0700, Ray5531 wrote:
(snip)
>I don't know if I can
>create indexes on temp table
Hi Ray,
You can. The best way is to use CREATE TABLE to create the table (with
PRIMARY KEY and UNIQUE constraints; accompanying indexes will be generated
automatically), then use CREATE INDEX to add extra (non-unique) indexes,
then use INSERT INTO ... SELECT to load the temp table with data. (This
order of creation minimizes the number of recompiles). OTOH, there might
be cases where definin g an index after loading the table with data might
be quicker - test all variation to find the quickest way in your scenario.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)

Friday, March 9, 2012

Microsoft.VC80.CRT.mui

I have SQL 2005, 64bit version installed with SP1. I am seeing the following
errors in the Windows event log:
Source: SideBySide Event ID: 59
Resolve Partial Assembly failed for Microsoft.VC80.CRT.mui. Reference error
message: Access is denied.
Source: SidebySide EventID: 59
Generate Activation Context failed for D:\Program Files\Microsoft SQL
Server\MSSQL.2\OLAP\bin\msmdctr90.DLL. Reference error message: Access is
denied.
Source: PerfLib EventID: 1023
Windows cannot load extensible counter DLL MSSQLServerOLAPService, the first
DWORD in data section is the Windows error code.
Does anyone know what the problem is?
Thanks
--
LehrSJHello LehrSJ,
I understand that you found some SQL related events on a SQL 2005 SP1 64bit
server, and you'd like to know what this problem is.
Based on my experience, this issue could occur if the "Performance Logs and
Alerts" service runs as "Network Service", which is member of "Performance
Log Users" local user group, does not have enough permission to SQL setup
folder.
SQL Setup grants read/execute permissions to "Performance Log Users" local
user group for the DLL only. "Performance Log Users" doesn?t have any
permissions for the containing folder. Granting "List folder contents"
permission to "Performance Log Users" for the containing folder (SQL Server
binn directory) may fix this problem:
D:\Program Files\Microsoft SQL Server\MSSQL.1\mssql\bin
D:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\bin
If you have any update or the issue is not resolved, please feel free to
let's know. I look forward to your reply.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Thanks. That solved the problem.
--
LehrSJ
""privatenews"" wrote:
> Hello LehrSJ,
> I understand that you found some SQL related events on a SQL 2005 SP1 64bit
> server, and you'd like to know what this problem is.
> Based on my experience, this issue could occur if the "Performance Logs and
> Alerts" service runs as "Network Service", which is member of "Performance
> Log Users" local user group, does not have enough permission to SQL setup
> folder.
> SQL Setup grants read/execute permissions to "Performance Log Users" local
> user group for the DLL only. "Performance Log Users" doesnâ't have any
> permissions for the containing folder. Granting "List folder contents"
> permission to "Performance Log Users" for the containing folder (SQL Server
> binn directory) may fix this problem:
> D:\Program Files\Microsoft SQL Server\MSSQL.1\mssql\bin
> D:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\bin
> If you have any update or the issue is not resolved, please feel free to
> let's know. I look forward to your reply.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications
> <http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> <http://msdn.microsoft.com/subscriptions/support/default.aspx>.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||I was having this problem as well on a 32 bit system and that fixed it.
Can you explain why that fixed it? I'm asking because I was also having
2 other problems that I think this fixed as well.
first one: There is a Java program that inserts updates and deletes
records in a very large table on the sql server. It spawns 12 processes
that each have a connection to the DB and every time this program ran,
2 of them would hang up and would not receive any errors. I looked and
they were no longer connected.
second one: The users of this server have pocket pcs that connect using
sql ce server with RDA. They use an app that we wrote to replicate
their data. Along with all the pushing and pulling of tables, there is
one stored procedure that the client runs on the server. Apparently
randomly this stored procedure stops working for about 30 minutes at a
time. What happens on the client is when it calls that sp, it just
hangs there maintaining it's connection until all the sudden the sp
start working again. During the 30 minutes nobody can run the sp.
Both of these problems did not exist before we got Error 59 or after it
was fixed.
Does anybody have any clue as to why this would fix these 2 problems or
has anybody experienced anything like this?
thanks,
cob

Microsoft.SqlServer.Dts.Runtime.DtsRuntimeException HResult -2146233088

i get the following exception HResult -2146233088

[Microsoft.SqlServer.Dts.Runtime.DtsRuntimeException] {"No description found"} Microsoft.SqlServer.Dts.Runtime.DtsRuntimeException

when i try to use this following code snippet

try

{

ConnectionManager objOLEDBConnection;

Microsoft.SqlServer.Dts.Runtime.Package objPackage = new Microsoft.SqlServer.Dts.Runtime.Package();

objOLEDBConnection = objPackage.Connections.Add("OLEDB");

}

catch(Exception ex)

{

ex.Message ;

}

could you please help me out with this ?

Moving to the SSIS forum.|||

Have you seen this help article that shows adding an OLE-DB connection to a package - http://msdn2.microsoft.com/en-us/library/d90716d1-4c65-466c-b82c-4aabbee1e3e5(SQL.90).aspx

What is the actual line that throws the exception?

The code looks OK, but knowing where the exception is raised may help.

Is SSIS correctly installed on your PC?

Is the OLE-DB connection available if you use the designer?

Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the

Hi,

I am getting the following errors in my reporting server log. Can anyone help me?

ReportingServicesService!processing!11!8/22/2006-01:04:04:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 10., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 10.
ReportingServicesService!processing!11!8/22/2006-01:04:04:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 14., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 14.
ReportingServicesService!processing!11!8/22/2006-01:04:04:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 18., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 18.
ReportingServicesService!processing!11!8/22/2006-01:04:04:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 22., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 22.

This error message is usually caused by a missing field in the dataset (it is defined in the dataset, but the query does not return it). It is OK if you don't use the field in your report. But if you do, then you'd get a "#error" in the textbox, or the report fails if it's used in a group/sort/filter expression.

Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for

Hi,

I am getting the following errors in my reporting server log. Can anyone help me?

Wednesday, March 7, 2012

Microsoft.NET Framework 2.0 on EM64T

Hi All,

I am trying to install the 64-bit version of Microsoft.NET Framework 2.0 on my machine (EM64T processor), however, I am getting the following error message:

Error creating process <C:\DOCUME~1\sanfil\LOCALS~1\Temp\IXP000.TMP.exe>. Reason: C:\WINDOWS\system32\advpack.dll

Could anyone, please, help me to find what I am missing/
Thanks!
Sanfil

If you are running Windows 2003 x64 edition or Windows XP x64 edition, make sure you are installing the x64 edition of .NET 2.0 (http://www.microsoft.com/downloads/details.aspx?familyid=B44A0000-ACF8-4FA1-AFFB-40E78D788B00&displaylang=en)

If you are running a 32 bit Windows version, you need ot install the 32 bit version of .NET 2.0 (http://www.microsoft.com/downloads/details.aspx?familyid=0856EACB-4362-4B0D-8EDD-AAB15C5E04F5&displaylang=en)

When it comes to x64, the OS edition installed determines what installs you do, not the processor family.

Regards

Mike

Microsoft.Jet.OLEDB.4.0" has not been registered

I'm trying to import an access database into a sql express database (32 bit system) and get the following error

Msg 7403, Level 16, State 1, Line 1

The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.

my script is as follows

SELECT *

FROM OPENDATASOURCE(

'Microsoft.Jet.OLEDB.4.0',

'Data Source="k:\armycwy.mdb";

User ID=Admin;Password='

)...CWAM_ROSTER

Anyone got an idea what is wrong?

TIA

Kevin

I noticed you mentioned 32-bit: is everything 32-bit - i.e. tha machine, Windows, and SQL Express, or is something perhaps 64-bit? We saw similar issues if running 32-bit SQL Server/SQL Express on a 64-bit machine (or vice versa).

What is the Windows version - e.g., XP, Winwdows Server 2000, 2003, etc.?

|||

hi kevin,

pleas try downloading and installing the latest driver
found on this site
http://msdn.microsoft.com/data/mdac/downloads/default.aspx

Joey

Microsoft.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL S

Hi Everybody,

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.

Stack Trace:

[OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'.]
Microsoft.Data.Odbc.OdbcConnection.HandleError(IntPtr hHandle, SQL_HANDLE hType, RETCODE retcode) +27
Microsoft.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method) +838
Microsoft.Data.Odbc.OdbcCommand.ExecuteNonQuery() +80
Calgary.venues.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\Calgary\Site\venues\venues.aspx.vb:32
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731are you using ODBC to connect to sql server ??if so you should be using sqlclient...its much better integrated into .net...

hth|||Hi,

Thanks for reply. I am doing some maintaince on some existing code. Somebody else wrote the code. Application was runing againt MySQL but I am converting over to SQL 2000.

Thanks,

Arif|||Here are the Code: Its failing on myCommand.ExecuteNonQuery(). It was working fine before. Even now its works fine on my localhost.

Thanks,

Arif

Dim strSQL As String

' strSQL = "SELECT * from tblbands where name = "

' strSQL = "SELECT tblAdminUsers_ID as Expr1, RealName as Expr2 From tblAdminUsers order by RealName"

Dim sBandName = Request("bandID")

If sBandName = "09" Then

strSQL = "select name, location, genre from tblbands,tbllocation,tblgenre

WHERE(tblbands.Location_ID = tbllocation.tblLocation_ID)AND tblgenre.tblGenre_ID =

tblbands.Genre_ID and tblbands.isapproved=1 and tblbands.name between '0'

AND '9'ORDER BY name "

End If

If sBandName = "AK" Then

strSQL = "select name, location, genre from tblbands,tbllocation,tblgenre

WHERE(tblbands.Location_ID = tbllocation.tblLocation_ID)AND tblgenre.tblGenre_ID =

tblbands.Genre_ID and tblbands.isapproved=1 and tblbands.name between 'A' AND 'K'

ORDER BY name"

End If

If sBandName = "LZ" Then

strSQL = "select name, location, genre from tblbands,tbllocation,tblgenre

WHERE(tblbands.Location_ID = tbllocation.tblLocation_ID)AND tblgenre.tblGenre_ID =

tblbands.Genre_ID and tblbands.isapproved=1 and tblbands.name between 'L' AND 'Z'

ORDER BY name "

End If

Dim myConnString = ConfigurationSettings.AppSettings("ConnectionString")

Dim myConn As New OdbcConnection(myConnString)

Dim myCommand As New OdbcCommand(strSQL, myConn)

myConn.Open()

myCommand.ExecuteNonQuery()

Dim myReader As OdbcDataReader = myCommand.ExecuteReader()

Repeater1.DataSource = myReader

Repeater1.DataBind()

myReader.Close()

myConn.Close()|||remove tht line...you are already using the execute reader...
comment out this line
myCommand.ExecuteNonQuery()

hth|||Same code was working before. Thanks and let me test again.

best regards,

arif

Microsoft VBScript Runtime error 800a001c

I was editing my website and added a feature in error. I tried deleting it
all to no avail. Then I began getting the following error message:
Microsoft VBScript runtime error '800a001c'
Out of stack space: 'Val'
/admin/content/pages.asp, line 7
The part in /admin/content/pages.asp, line 7 reads:
For I = 0 To UBound(arrArray)
If Val(arrArray(I)) = Val(varValue) Then
Array_Exists = True
Exit Function
End If
Next
Array_Exists = False
End Function
I have no idea what to do about it. Any hint or link to the right direction
will be appreciated.
Thanks.
Answered elseewhere. Pick a more appropriate NG and don't post the same
message independently to multiple newsgroups.

Microsoft VBScript Runtime error 800a001c

I was editing my website and added a feature in error. I tried deleting it
all to no avail. Then I began getting the following error message:
Microsoft VBScript runtime error '800a001c'
Out of stack space: 'Val'
/admin/content/pages.asp, line 7
The part in /admin/content/pages.asp, line 7 reads:
For I = 0 To UBound(arrArray)
If Val(arrArray(I)) = Val(varValue) Then
Array_Exists = True
Exit Function
End If
Next
Array_Exists = False
End Function
I have no idea what to do about it. Any hint or link to the right direction
will be appreciated.
Thanks.Answered elseewhere. Pick a more appropriate NG and don't post the same
message independently to multiple newsgroups.

Friday, February 24, 2012

Microsoft VBScript Runtime error 800a001c

I was editing my website and added a feature in error. I tried deleting it
all to no avail. Then I began getting the following error message:
Microsoft VBScript runtime error '800a001c'
Out of stack space: 'Val'
/admin/content/pages.asp, line 7
The part in /admin/content/pages.asp, line 7 reads:
For I = 0 To UBound(arrArray)
If Val(arrArray(I)) = Val(varValue) Then
Array_Exists = True
Exit Function
End If
Next
Array_Exists = False
End Function
I have no idea what to do about it. Any hint or link to the right direction
will be appreciated.
Thanks.Answered elseewhere. Pick a more appropriate NG and don't post the same
message independently to multiple newsgroups.

Microsoft VBScript runtime error

Hello,

I am currently getting the following error:

Microsoft VBScript runtime error '800a000d'

Type mismatch: 'QueryString'

/admin/equipment/addequipment.asp, line 128

This is when i try to submit a new database item in Dreamweaver. The DB I am using is SQL Server 2005.

My code is as follows:

Dim equipspec__urlid
equipspec__urlid = "1"
If (QueryString("ID") <> "") Then
equipspec__urlid = QueryString("ID")
End If
%>
<%
Dim equipspec
Dim equipspec_numRows

Set equipspec = Server.CreateObject("ADODB.Recordset")
equipspec.ActiveConnection = MM_intranet_STRING
equipspec.Source = "SELECT * FROM EquipSpec WHERE " + Replace(equipspec__urlid, "'", "''") + " = EquipSpec.ID"
equipspec.CursorType = 0
equipspec.CursorLocation = 2
equipspec.LockType = 1
equipspec.Open()

Would be greatful if anybody could help, let me know if you need more info.

Many thanks.This is not a TSQL issue. You have a type mismatch in your VB code. The error message contains the line in your source code so check that to see the problem.

Microsoft SQL-DMO(ODBC SQLState:42000)

I am getting the following error message in SQL 2K when I try to give
database access to a login Id "LogInId1".
*****************************************************
Microsoft SQL-DMO(ODBC SQLState:42000)
Error 15023: User or role 'LogInId1' already exists in the current database.
****************************************************************************
*
The "public" role in the above "current database" has a user Id "LogInId1".
This is the one it is generating the above error message. I can not remove
the above user ID from that role (public).
What I did to generate the above error message?
I restored one user database on SQL 2K (running under windows 2003) from the
backup of SQL2K running under Win2K. The user Id "LogInId1" existed in the
database from which back was ran.
How to add database access permissions to the login Id ""LogInId1"?
Thank you,
SmithYou can try:
exec sp_changedbowner 'LogInId1'
"John Smith" wrote:
> I am getting the following error message in SQL 2K when I try to give
> database access to a login Id "LogInId1".
>
> *****************************************************
> Microsoft SQL-DMO(ODBC SQLState:42000)
> Error 15023: User or role 'LogInId1' already exists in the current database.
> ****************************************************************************
> *
>
> The "public" role in the above "current database" has a user Id "LogInId1".
> This is the one it is generating the above error message. I can not remove
> the above user ID from that role (public).
>
> What I did to generate the above error message?
> I restored one user database on SQL 2K (running under windows 2003) from the
> backup of SQL2K running under Win2K. The user Id "LogInId1" existed in the
> database from which back was ran.
>
> How to add database access permissions to the login Id ""LogInId1"?
> Thank you,
> Smith
>
>
>|||Take a look at sp_resolve_logins in BOL, etc.
The internal (to the database) user tables have entries that are either not
in the Master SYSLOGINS table or have different pointers to that table. You
need to either repoint(resolve) or remove those logins.
--
Joseph R.P. Maloney, CSP,CCP,CDP
"Fahim" wrote:
> You can try:
> exec sp_changedbowner 'LogInId1'
>
> "John Smith" wrote:
> > I am getting the following error message in SQL 2K when I try to give
> > database access to a login Id "LogInId1".
> >
> >
> >
> > *****************************************************
> >
> > Microsoft SQL-DMO(ODBC SQLState:42000)
> >
> > Error 15023: User or role 'LogInId1' already exists in the current database.
> >
> > ****************************************************************************
> > *
> >
> >
> >
> > The "public" role in the above "current database" has a user Id "LogInId1".
> > This is the one it is generating the above error message. I can not remove
> > the above user ID from that role (public).
> >
> >
> >
> > What I did to generate the above error message?
> >
> > I restored one user database on SQL 2K (running under windows 2003) from the
> > backup of SQL2K running under Win2K. The user Id "LogInId1" existed in the
> > database from which back was ran.
> >
> >
> >
> > How to add database access permissions to the login Id ""LogInId1"?
> >
> > Thank you,
> >
> > Smith
> >
> >
> >
> >
> >

Microsoft SQL-DMO(ODBC SQLState:42000)

Microsoft SQL-DMO

I got an error as following while I am trying to restore a database:
Microsoft SQL-DMO (ODBC SQLState:42000)
Device activation error: The physical file name ... may be incorrect.
Please help how to solve this problem. Thanks.Allen,
Check your spelling of the file name you are trying to restore from.
They do not match.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
"Allen Iverson" wrote:
> I got an error as following while I am trying to restore a database:
> Microsoft SQL-DMO (ODBC SQLState:42000)
> Device activation error: The physical file name ... may be incorrect.
>
> Please help how to solve this problem. Thanks.
>|||Mark,
But I use the browser to open the file. So the spelling should
be OK.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:%23VqEGHKpEHA.1308@.TK2MSFTNGP14.phx.gbl...
> Allen,
> Check your spelling of the file name you are trying to restore from. They
> do not match.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> "Allen Iverson" wrote:
>> I got an error as following while I am trying to restore a database:
>> Microsoft SQL-DMO (ODBC SQLState:42000)
>> Device activation error: The physical file name ... may be incorrect.
>>
>> Please help how to solve this problem. Thanks.|||Note that the restore is performed on the server. Are you sitting on the server when you use
explorer to get the file name?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
""Allen Iverson"" <no_spam@.bk.com> wrote in message news:ejiY39OpEHA.3324@.TK2MSFTNGP15.phx.gbl...
> Mark,
> But I use the browser to open the file. So the spelling should
> be OK.
> "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
> news:%23VqEGHKpEHA.1308@.TK2MSFTNGP14.phx.gbl...
> > Allen,
> >
> > Check your spelling of the file name you are trying to restore from. They
> > do not match.
> >
> > --
> > Mark Allison, SQL Server MVP
> > http://www.markallison.co.uk
> >
> > Looking for a SQL Server replication book?
> > http://www.nwsu.com/0974973602m.html
> >
> >
> > "Allen Iverson" wrote:
> >> I got an error as following while I am trying to restore a database:
> >>
> >> Microsoft SQL-DMO (ODBC SQLState:42000)
> >>
> >> Device activation error: The physical file name ... may be incorrect.
> >>
> >>
> >> Please help how to solve this problem. Thanks.
>|||No, I am working on a client PC. But I did this before and no problem.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:erRDI7SpEHA.4004@.TK2MSFTNGP10.phx.gbl...
> Note that the restore is performed on the server. Are you sitting on the
> server when you use
> explorer to get the file name?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> ""Allen Iverson"" <no_spam@.bk.com> wrote in message
> news:ejiY39OpEHA.3324@.TK2MSFTNGP15.phx.gbl...
>> Mark,
>> But I use the browser to open the file. So the spelling
>> should
>> be OK.
>> "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
>> news:%23VqEGHKpEHA.1308@.TK2MSFTNGP14.phx.gbl...
>> > Allen,
>> >
>> > Check your spelling of the file name you are trying to restore from.
>> > They
>> > do not match.
>> >
>> > --
>> > Mark Allison, SQL Server MVP
>> > http://www.markallison.co.uk
>> >
>> > Looking for a SQL Server replication book?
>> > http://www.nwsu.com/0974973602m.html
>> >
>> >
>> > "Allen Iverson" wrote:
>> >> I got an error as following while I am trying to restore a database:
>> >>
>> >> Microsoft SQL-DMO (ODBC SQLState:42000)
>> >>
>> >> Device activation error: The physical file name ... may be incorrect.
>> >>
>> >>
>> >> Please help how to solve this problem. Thanks.
>>
>|||The filename specified is seen from SQL Server's perspective. If the file isn't on the SQL Server
machine you have to specify an UNC path for the file.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
""Allen Iverson"" <no_spam@.bk.com> wrote in message news:OceVUrbqEHA.2764@.TK2MSFTNGP11.phx.gbl...
> No, I am working on a client PC. But I did this before and no problem.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:erRDI7SpEHA.4004@.TK2MSFTNGP10.phx.gbl...
>> Note that the restore is performed on the server. Are you sitting on the server when you use
>> explorer to get the file name?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> ""Allen Iverson"" <no_spam@.bk.com> wrote in message news:ejiY39OpEHA.3324@.TK2MSFTNGP15.phx.gbl...
>> Mark,
>> But I use the browser to open the file. So the spelling should
>> be OK.
>> "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
>> news:%23VqEGHKpEHA.1308@.TK2MSFTNGP14.phx.gbl...
>> > Allen,
>> >
>> > Check your spelling of the file name you are trying to restore from. They
>> > do not match.
>> >
>> > --
>> > Mark Allison, SQL Server MVP
>> > http://www.markallison.co.uk
>> >
>> > Looking for a SQL Server replication book?
>> > http://www.nwsu.com/0974973602m.html
>> >
>> >
>> > "Allen Iverson" wrote:
>> >> I got an error as following while I am trying to restore a database:
>> >>
>> >> Microsoft SQL-DMO (ODBC SQLState:42000)
>> >>
>> >> Device activation error: The physical file name ... may be incorrect.
>> >>
>> >>
>> >> Please help how to solve this problem. Thanks.
>>
>>
>

Friday, March 30, 2012

Migrating ext drive array

Wednesday, March 28, 2012

Migrating DTS Active X/ADO script to SSIS

Monday, March 12, 2012

Migartion issue with ORDER BY Clause

midian calculation

Friday, March 9, 2012

Microsoft.VC80.CRT.mui

Microsoft.SqlServer.Dts.Runtime.DtsRuntimeException HResult -2146233088

Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the

Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for

Wednesday, March 7, 2012

Microsoft.NET Framework 2.0 on EM64T

Microsoft.Jet.OLEDB.4.0" has not been registered

Microsoft.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL S

Microsoft VBScript Runtime error 800a001c

Microsoft VBScript Runtime error 800a001c

Friday, February 24, 2012

Microsoft VBScript Runtime error 800a001c

Microsoft VBScript runtime error

Microsoft SQL-DMO(ODBC SQLState:42000)

Microsoft SQL-DMO(ODBC SQLState:42000)

Microsoft SQL-DMO(ODBC SQLState:42000)

Microsoft SQL-DMO

Microsoft SQL-DMO

SQL Server Management Studio

Blog Archive

About Me