OK heres the deal, I just purchased a new dell and uninstalled the sql server. Now i am getting- Execution cannot continue as the language dependent resource fil could not be loaded. Any ideas where i could download it or where to get some answers??? My laptop is only 3months old what the fudge!!!!!!!!!!!
View 2 RepliesI hope someone can help me here. Here is some background.
As I was attempting to download SQL Express, the download dialog box timed out. When I x-ed out of the download, Windows XP Professional 2002 threw up an error message indicating that the dialog box was non-responsive, and I elected to close it.
I downloaded SQL again successfully, and installed with no errors. I then attempted to create a new db through Visual Web Developer. Instead of creating a database, Visual Studio returned an error saying that I did not allow for new database objects, and that I should change my permission settings. I could not figure out how to do this, so I uninstalled SQL Express.
After re-starting, I got the following message: €œYour SQL Server Installation is either corrupt or has been tampered with (could not open SQLEVN70.RLL). Please uninstall then re-run setup to correct this option.€?
I uninstalled MS SQL again from the Add/Delete Programs on my Control Panel. On re-start, I received the same error again. On my Programs list, MS SQL is not present, there are several MS SQL files in the path C:Program FilesMicrosoft SQL Server.
So I located the Visual Studio uninstall tool and attempted to run it. I received the same error: €œYour SQL Server Installation is either corrupt or has been tampered with (could not open SQLEVN70.RLL). Please uninstall then re-run setup to correct this option.€?
Any ideas on how to uninstall the files in my program files so I can load a clean copy of SQL?
Hi All,
I have enterprise version software CD1 and CD2 of SQL server 2005
when i try to run setup.exe..the following error pops -up
The image file Setup.exe is valid, but is for a machine type other than the current machine
MY OS version is windows 2003 32bit Operating system...
I am suspecting the binarie may be of 64bit.. How do we check the binaries are 32 bit and 64 bit software
Thanks for your Help
Mohan
I am trying to install SQL Server 2000 on a Win2K OS machine but Iget this error message:"A previous program installation created pending file operations onthe installation machine. You must restart the computer before runningsetup."I see others have had this problem but have fixed it using the solutionin:http://support.microsoft.com/defaul...kb;en-us;312995I have tried the solution but to no avail. The registry key:HKEY_LOCAL_MACHINESYSTEMCurrentControlSetContro lSessionManagerPendingFileRenameOperations keeps reappearing as soon as Iclose RegEdit.Any ideas?Thanks,lq
View 3 Replies View RelatedHi all,
I have a 400MB Excel file that I consume from another automated process (don't ask). I copy this file down locally to my server, and I am attempting to create an SSIS package that points to this file via a connection manager. My computer starts gobbling up massive amounts of memory (devenv.exe gets up to about 800MB or so, then drops back down to 100MB) even when I attempt to rename the connection in the connection managers tab.
I have set all BypassPrepare to TRUE and ValidateExternalMetadata properties to FALSE, and still it can take up to 3 to 6 minutes for BI Dev Studio to respond. My specs:
Intel Centrino Duo 2.00 GHz
2GB RAM
XP Pro SP2
There MUST be a way for me to work effectively on a file of this size. Please help! Thanks much for any assistance.
Sincerely,
Brian Pulliam
We have two instances of SQL Server 2005 - SP1 installed on one server. The default instance starts very slowly. When looking at the log I can see the delay is due to Resource Manager based upon the following error.
Message
Resource Manager Creation Failed: 0x8004d102(XACT_E_DUPLICATE_GUID)
What does this mean?
What would cause this to happen?
How do I resolve the problem?
Thanks, Dave
we are using sql server 2005 standard edition with sp1
From last couple of days, I am getting lot of these errors-
Process 304 unlocking unowned resource: OBJECT: 2:792809934:0
Process ID 304 attempted to unlock a resource it does not own: OBJECT: 2:792809934:0 . Retry the transaction, because this error may be caused by a timing condition. If the problem persists, contact the database administrator.
A user request from the session with SPID 304 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory.
SqlDumpExceptionHandler: Process 304 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
2007-05-23 05:31:58.74 spid76 * *******************************************************************************
2007-05-23 05:31:58.74 spid76 *
2007-05-23 05:31:58.74 spid76 * BEGIN STACK DUMP:
2007-05-23 05:31:58.74 spid76 * 05/23/07 05:31:58 spid 76
2007-05-23 05:31:58.74 spid76 *
2007-05-23 05:31:58.74 spid76 *
2007-05-23 05:31:58.74 spid76 * Exception Address = 00000000015F4502 Module(sqlservr+00000000005F4502)
2007-05-23 05:31:58.74 spid76 * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
2007-05-23 05:31:58.74 spid76 * Access Violation occurred reading address 0000000000000018
2007-05-23 05:31:58.74 spid76 * Input Buffer 68 bytes -
2007-05-23 05:31:58.74 spid76 * 16 00 00 00 12 00 00 00 02 00 00 00 00 00 00 00 00 00
2007-05-23 05:31:58.74 spid76 * S G L M e s 01 00 00 00 15 00 53 00 47 00 4c 00 4d 00 65 00 73 00
2007-05-23 05:31:58.74 spid76 * s a g e Q u e u e 73 00 61 00 67 00 65 00 51 00 75 00 65 00 75 00 65 00
2007-05-23 05:31:58.74 spid76 * S e l e c t 53 00 65 00 6c 00 65 00 63 00 74 00 00 00
2007-05-23 05:31:58.74 spid76 *
2007-05-23 05:31:58.74 spid76 *
2007-05-23 05:31:58.74 spid76 * MODULE BASE END SIZE
2007-05-23 05:31:58.74 spid76 * sqlservr 0000000001000000 00000000035FBFFF 025fc000
2007-05-23 05:31:58.74 spid76 * ntdll 0000000078EC0000 0000000078FF8FFF 00139000
2007-05-23 05:31:58.74 spid76 * kernel32 0000000078D40000 0000000078EB1FFF 00172000
2007-05-23 05:31:58.74 spid76 * MSVCR80 0000000078130000 00000000781FEFFF 000cf000
2007-05-23 05:31:58.74 spid76 * msvcrt 000007FF7FC00000 000007FF7FC85FFF 00086000
2007-05-23 05:31:58.74 spid76 * MSVCP80 000000007C420000 000000007C530FFF 00111000
2007-05-23 05:31:58.74 spid76 * ADVAPI32 000007FF7FEE0000 000007FF7FFE4FFF 00105000
2007-05-23 05:31:58.74 spid76 * RPCRT4 000007FF7FD30000 000007FF7FED8FFF 001a9000
2007-05-23 05:31:58.74 spid76 * USER32 0000000078C30000 0000000078D3BFFF 0010c000
2007-05-23 05:31:58.74 spid76 * GDI32 000007FF7FC90000 000007FF7FD28FFF 00099000
2007-05-23 05:31:58.74 spid76 * CRYPT32 000007FF7D180000 000007FF7D2DEFFF 0015f000
2007-05-23 05:31:58.74 spid76 * MSASN1 000007FF7D150000 000007FF7D179FFF 0002a000
2007-05-23 05:31:58.74 spid76 * Secur32 000007FF7E7F0000 000007FF7E811FFF 00022000
2007-05-23 05:31:58.74 spid76 * MSWSOCK 000007FF76FE0000 000007FF7705BFFF 0007c000
2007-05-23 05:31:58.74 spid76 * WS2_32 000007FF77150000 000007FF7717FFFF 00030000
2007-05-23 05:31:58.74 spid76 * WS2HELP 000007FF77140000 000007FF7714BFFF 0000c000
2007-05-23 05:31:58.74 spid76 * USERENV 000007FF7C4A0000 000007FF7C5A8FFF 00109000
2007-05-23 05:31:58.74 spid76 * opends60 00000000333E0000 00000000333E7FFF 00008000
2007-05-23 05:31:58.74 spid76 * NETAPI32 000007FF771B0000 000007FF77247FFF 00098000
2007-05-23 05:31:58.74 spid76 * SHELL32 000007FF7F190000 000007FF7FB97FFF 00a08000
2007-05-23 05:31:58.74 spid76 * SHLWAPI 000007FF7EF60000 000007FF7EFFAFFF 0009b000
2007-05-23 05:31:58.74 spid76 * comctl32 0000000000AF0000 0000000000C76FFF 00187000
2007-05-23 05:31:58.74 spid76 * psapi 000007FF7E1B0000 000007FF7E1BFFFF 00010000
2007-05-23 05:31:58.74 spid76 * instapi 0000000048060000 000000004806CFFF 0000d000
2007-05-23 05:31:58.74 spid76 * CLUSAPI 000007FF7B1C0000 000007FF7B1E3FFF 00024000
2007-05-23 05:31:58.74 spid76 * ole32 000007FF7ECE0000 000007FF7EF51FFF 00272000
2007-05-23 05:31:58.74 spid76 * OLEAUT32 000007FF7E9F0000 000007FF7EB03FFF 00114000
2007-05-23 05:31:58.74 spid76 * RESUTILS 000007FF7B310000 000007FF7B32BFFF 0001c000
2007-05-23 05:31:58.74 spid76 * sqlevn70 000000004F610000 000000004F7A3FFF 00194000
2007-05-23 05:31:58.74 spid76 * SQLOS 00000000344D0000 00000000344D5FFF 00006000
2007-05-23 05:31:58.74 spid76 * NTMARTA 000007FF7E2F0000 000007FF7E32BFFF 0003c000
2007-05-23 05:31:58.74 spid76 * SAMLIB 000007FF76F80000 000007FF76F95FFF 00016000
2007-05-23 05:31:58.74 spid76 * WLDAP32 000007FF7E780000 000007FF7E7E5FFF 00066000
2007-05-23 05:31:58.74 spid76 * rsaenh 000000000FFB0000 000000000FFEDFFF 0003e000
2007-05-23 05:31:58.74 spid76 * AUTHZ 000007FF7E2C0000 000007FF7E2ECFFF 0002d000
2007-05-23 05:31:58.74 spid76 * MSCOREE 000006427EE60000 000006427EED3FFF 00074000
2007-05-23 05:31:58.75 spid76 * msv1_0 000007FF7E330000 000007FF7E373FFF 00044000
2007-05-23 05:31:58.75 spid76 * iphlpapi 000007FF57250000 000007FF57280FFF 00031000
2007-05-23 05:31:58.75 spid76 * kerberos 000007FF77410000 000007FF774C2FFF 000b3000
2007-05-23 05:31:58.75 spid76 * cryptdll 000007FF7DAB0000 000007FF7DABEFFF 0000f000
2007-05-23 05:31:58.75 spid76 * schannel 000007FF7DB70000 000007FF7DBB0FFF 00041000
2007-05-23 05:31:58.75 spid76 * COMRES 000007FF7E920000 000007FF7E9E5FFF 000c6000
2007-05-23 05:31:58.75 spid76 * XOLEHLP 000007FF5C560000 000007FF5C566FFF 00007000
2007-05-23 05:31:58.75 spid76 * MSDTCPRX 000007FF67140000 000007FF67210FFF 000d1000
2007-05-23 05:31:58.75 spid76 * msvcp60 000000000AD30000 000000000AE19FFF 000ea000
2007-05-23 05:31:58.75 spid76 * MTXCLU 000007FF7B540000 000007FF7B569FFF 0002a000
2007-05-23 05:31:58.75 spid76 * VERSION 000007FF7FBF0000 000007FF7FBFAFFF 0000b000
2007-05-23 05:31:58.75 spid76 * WSOCK32 000007FF770F0000 000007FF770F9FFF 0000a000
2007-05-23 05:31:58.75 spid76 * DNSAPI 000007FF7E720000 000007FF7E76DFFF 0004e000
2007-05-23 05:31:58.75 spid76 * winrnr 000007FF7E820000 000007FF7E82AFFF 0000b000
2007-05-23 05:31:58.75 spid76 * rasadhlp 000007FF7E830000 000007FF7E836FFF 00007000
2007-05-23 05:31:58.75 spid76 * hnetcfg 000007FF6D1F0000 000007FF6D280FFF 00091000
2007-05-23 05:31:58.75 spid76 * wshtcpip 000007FF76FA0000 000007FF76FAAFFF 0000b000
2007-05-23 05:31:58.75 spid76 * security 000007FF77530000 000007FF77534FFF 00005000
2007-05-23 05:31:58.75 spid76 * msfte 0000000049980000 0000000049D2DFFF 003ae000
2007-05-23 05:31:58.75 spid76 * dbghelp 000000000D7F0000 000000000D949FFF 0015a000
2007-05-23 05:31:58.75 spid76 * WINTRUST 000007FF7E210000 000007FF7E25DFFF 0004e000
2007-05-23 05:31:58.75 spid76 * imagehlp 000007FF7E2A0000 000007FF7E2B2FFF 00013000
2007-05-23 05:31:58.75 spid76 * dssenh 000000000FF70000 000000000FFABFFF 0003c000
2007-05-23 05:31:58.75 spid76 * ntdsapi 000007FF7DAD0000 000007FF7DAF3FFF 00024000
2007-05-23 05:31:58.75 spid76 * xpsp2res 000007FF5C210000 000007FF5C4D6FFF 002c7000
2007-05-23 05:31:58.75 spid76 * CLBCatQ 0000000003600000 00000000036DDFFF 000de000
2007-05-23 05:31:58.75 spid76 * sqlncli 00000000337A0000 0000000033A5DFFF 002be000
2007-05-23 05:31:58.75 spid76 * COMCTL32 0000000003700000 00000000037EDFFF 000ee000
2007-05-23 05:31:58.75 spid76 * comdlg32 000007FF7D360000 000007FF7D3D6FFF 00077000
2007-05-23 05:31:58.75 spid76 * SQLNCLIR 0000000035000000 0000000035032FFF 00033000
2007-05-23 05:31:58.75 spid76 * msftepxy 000000000F130000 000000000F150FFF 00021000
2007-05-23 05:31:58.75 spid76 * xpstar90 0000000053C30000 0000000053CB4FFF 00085000
2007-05-23 05:31:58.75 spid76 * SQLSCM90 0000000053AD0000 0000000053ADBFFF 0000c000
2007-05-23 05:31:58.75 spid76 * ODBC32 000007FF63EB0000 000007FF63F16FFF 00067000
2007-05-23 05:31:58.75 spid76 * BatchParser90 00000000520C0000 00000000520ECFFF 0002d000
2007-05-23 05:31:58.75 spid76 * ATL80 000000007C630000 000000007C64DFFF 0001e000
2007-05-23 05:31:58.75 spid76 * odbcint 000007FF63DC0000 000007FF63DD7FFF 00018000
2007-05-23 05:31:58.75 spid76 * xpstar90 0000000010CC0000 0000000010CE5FFF 00026000
2007-05-23 05:31:58.75 spid76 * msxmlsql 0000000078800000 0000000078963FFF 00164000
2007-05-23 05:31:58.75 spid76 * msxml3 000007FF78A20000 000007FF78C2DFFF 0020e000
2007-05-23 05:31:58.75 spid76 * xpsqlbot 000000004A7C0000 000000004A7C7FFF 00008000
2007-05-23 05:31:58.75 spid76 * xplog70 0000000034730000 000000003473FFFF 00010000
2007-05-23 05:31:58.75 spid76 * xplog70 00000000125B0000 00000000125B2FFF 00003000
2007-05-23 05:31:58.75 spid76 *
2007-05-23 05:31:58.75 spid76 * P1Home: FFFFFADEC275F600:
2007-05-23 05:31:58.75 spid76 * P2Home: 0000000017F4DEA0: FFFFFADEC275F600 0000000017F4DEA0 0000000000000000 0000000017F4E660 0000800000000000 FFFFFADEC275F940
2007-05-23 05:31:58.75 spid76 * P3Home: 0000000000000000:
2007-05-23 05:31:58.75 spid76 * P4Home: 0000000017F4E660: FFFFFFFF00000001 0000000000000000 0000000100ECCEA8 0000000100ECCF60 0000000000000000 00000000E226E9C0
2007-05-23 05:31:58.75 spid76 * P5Home: 0000800000000000:
2007-05-23 05:31:58.75 spid76 * P6Home: FFFFFADEC275F940:
2007-05-23 05:31:58.75 spid76 * ContextFlags: 000000000010001F:
2007-05-23 05:31:58.75 spid76 * MxCsr: 0000000000001FA0:
2007-05-23 05:31:58.75 spid76 * SegCs: 0000000000000033:
2007-05-23 05:31:58.75 spid76 * SegDs: 000000000000002B:
2007-05-23 05:31:58.75 spid76 * SegEs: 000000000000002B:
2007-05-23 05:31:58.75 spid76 * SegFs: 0000000000000053:
2007-05-23 05:31:58.75 spid76 * SegGs: 000000000000002B:
2007-05-23 05:31:58.75 spid76 * SegSs: 000000000000002B:
2007-05-23 05:31:58.75 spid76 * EFlags: 0000000000010202: 0065002E0064006D 0046000000650078 004F004E005F0050 0053004F0048005F 00480043005F0054 003D004B00430045
2007-05-23 05:31:58.75 spid76 * Rax: 0000000100ECCF60: 0000000000000000 0000000100ECCEA8 0000000000000000 0065006300630041 0000000000000000 0000000000000000
2007-05-23 05:31:58.75 spid76 * Rcx: 0000000000000000:
2007-05-23 05:31:58.75 spid76 * Rdx: 0000000000000000:
2007-05-23 05:31:58.75 spid76 * Rbx: 0000000000000000:
2007-05-23 05:31:58.75 spid76 * Rsp: 0000000017F4E440: 0000000001B30DC0 FFFFFFFFFF000000 0000000000000000 0000000078D6E31C 00000000D44421C0 00000000015E8750
2007-05-23 05:31:58.75 spid76 * Rbp: 0000000017F4E660: FFFFFFFF00000001 0000000000000000 0000000100ECCEA8 0000000100ECCF60 0000000000000000 00000000E226E9C0
2007-05-23 05:31:58.75 spid76 * Rsi: 0000000273C15900: 0000000000000000 0000000000000000 0000000000000000 0000000000000000 0000000000000000 0000000000000000
2007-05-23 05:31:58.75 spid76 * Rdi: 0000000000000000:
2007-05-23 05:31:58.75 spid76 * R8: 00000000D44421C0: 0000000000000000 0000000000000000 00000000D039C1D0 00000000E892C1D0 0000000000000001 00000000038203A0
2007-05-23 05:31:58.75 spid76 * R9: 0000000000000000:
2007-05-23 05:31:58.75 spid76 * R10: 0000000001000000: 0000000300905A4D 0000FFFF00000004 00000000000000B8 0000000000000040 0000000000000000 0000000000000000
2007-05-23 05:31:58.75 spid76 * R11: 0000000017F4E5C8: 00000000015E5847 00000000063C8080 00000000063C8130 0000000192CED0F0 0000000001541382 FFFFFFFFFFFF0002
2007-05-23 05:31:58.75 spid76 * R12: 0000000017F4E608: 00000000063C4C58 0000000000000000 0000000000000000 00000000000002AA 0000000017F4E890 0000000100ECCE70
2007-05-23 05:31:58.75 spid76 * R13: 0000000000000001:
2007-05-23 05:31:58.75 spid76 * R14: 0000000000000000:
2007-05-23 05:31:58.75 spid76 * R15: 0000000000000000:
2007-05-23 05:31:58.75 spid76 * Rip: 00000000015F4502: 086F8B4C187A8B48 C1F6434FB60F2074 44004E814E850F02 0F04C1F660244C89 4C894C004E815985 30250C8B48657824
2007-05-23 05:31:58.75 spid76 * *******************************************************************************
2007-05-23 05:31:58.75 spid76 * -------------------------------------------------------------------------------
2007-05-23 05:31:58.75 spid76 * Short Stack Dump
2007-05-23 05:31:58.75 spid76 00000000015F4502 Module(sqlservr+00000000005F4502)
2007-05-23 05:31:58.75 spid76 00000000015E5847 Module(sqlservr+00000000005E5847)
2007-05-23 05:31:58.75 spid76 000000000158A7CE Module(sqlservr+000000000058A7CE)
2007-05-23 05:31:58.75 spid76 00000000024796E7 Module(sqlservr+00000000014796E7)
2007-05-23 05:31:58.75 spid76 000000000247A0E5 Module(sqlservr+000000000147A0E5)
2007-05-23 05:31:58.75 spid76 0000000001A2F32F Module(sqlservr+0000000000A2F32F)
2007-05-23 05:31:58.75 spid76 0000000001625988 Module(sqlservr+0000000000625988)
2007-05-23 05:31:58.75 spid76 0000000001736E0B Module(sqlservr+0000000000736E0B)
2007-05-23 05:31:58.75 spid76 000000000161BC5B Module(sqlservr+000000000061BC5B)
2007-05-23 05:31:58.75 spid76 00000000016126D1 Module(sqlservr+00000000006126D1)
2007-05-23 05:31:58.75 spid76 0000000001614BB6 Module(sqlservr+0000000000614BB6)
2007-05-23 05:31:58.75 spid76 000000000268C3CA Module(sqlservr+000000000168C3CA)
2007-05-23 05:31:58.75 spid76 000000000268DCB4 Module(sqlservr+000000000168DCB4)
2007-05-23 05:31:58.75 spid76 000000000161FC5E Module(sqlservr+000000000061FC5E)
2007-05-23 05:31:58.75 spid76 00000000015C80E8 Module(sqlservr+00000000005C80E8)
2007-05-23 05:31:58.75 spid76 00000000015CAD6D Module(sqlservr+00000000005CAD6D)
2007-05-23 05:31:58.75 spid76 00000000015E0232 Module(sqlservr+00000000005E0232)
2007-05-23 05:31:58.75 spid76 00000000015DE73E Module(sqlservr+00000000005DE73E)
2007-05-23 05:31:58.75 spid76 00000000015D66CE Module(sqlservr+00000000005D66CE)
2007-05-23 05:31:58.75 spid76 00000000015D7129 Module(sqlservr+00000000005D7129)
2007-05-23 05:31:58.75 spid76 00000000015CE674 Module(sqlservr+00000000005CE674)
2007-05-23 05:31:58.75 spid76 00000000014CE4C7 Module(sqlservr+00000000004CE4C7)
2007-05-23 05:31:58.75 spid76 00000000017A0B89 Module(sqlservr+00000000007A0B89)
2007-05-23 05:31:58.75 spid76 0000000001785C90 Module(sqlservr+0000000000785C90)
2007-05-23 05:31:58.75 spid76 00000000017D08F8 Module(sqlservr+00000000007D08F8)
2007-05-23 05:31:58.75 spid76 00000000781337A7 Module(MSVCR80+00000000000037A7)
2007-05-23 05:31:58.77 spid76 0000000078133864 Module(MSVCR80+0000000000003864)
2007-05-23 05:31:58.77 spid76 0000000078D6B66A Module(kernel32+000000000002B66A)
Can anyone help me these errors? Why I am getting these errors ? And how do i resolve this issue?
Thanks
Hi all,
I am running Sql 7.0 with sp2. I have a memory 4GB. When i am running some batch jobs and replications i am getting following error number:
ERROR NUMBER : 8645
A time out occurred while waiting for memory resources to execute the query. Rerun the query.
Can anyone suggest me how i have to resolve the above error, because i was facing this error very often. Pls suggest me a permanent solution.
Thanks!
--Kavira
I have a page that was working but now I am getting the following errors.
Server Error in '/' Application.
ERROR [HY001] [Microsoft][ODBC Text Driver] System resource exceeded.ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended PropertiesERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDRERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMTERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended PropertiesERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDRERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMTERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended PropertiesERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDRERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMTERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended PropertiesERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDRERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMTERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended PropertiesERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDRERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMTERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failedERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended PropertiesERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDRERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMTERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended PropertiesERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDRERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMTERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended PropertiesERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDRERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMTERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended PropertiesERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDRERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMTERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended PropertiesERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDRERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMTERROR [HY001] [Microsoft][ODBC Text Driver] System resource exceeded.
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: System.Data.Odbc.OdbcException: ERROR [HY001] [Microsoft][ODBC Text Driver] System resource exceeded.ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended PropertiesERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDRERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMTERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended PropertiesERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDRERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMTERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended PropertiesERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDRERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMTERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended PropertiesERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDRERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMTERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended PropertiesERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDRERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMTERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failedERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended PropertiesERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDRERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMTERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended PropertiesERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDRERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMTERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended PropertiesERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDRERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMTERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended PropertiesERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDRERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMTERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended PropertiesERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDRERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMTERROR [HY001] [Microsoft][ODBC Text Driver] System resource exceeded.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 (0x80131937): ERROR [HY001] [Microsoft][ODBC Text Driver] System resource exceeded.
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended Properties
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDR
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMT
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended Properties
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDR
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMT
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended Properties
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDR
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMT
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended Properties
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDR
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMT
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended Properties
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDR
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMT
ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended Properties
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDR
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMT
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended Properties
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDR
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMT
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended Properties
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDR
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMT
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended Properties
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDR
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMT
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended Properties
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDR
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMT
ERROR [HY001] [Microsoft][ODBC Text Driver] System resource exceeded.]
System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) +35
System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle) +131
System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) +98
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) +27
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +47
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.Odbc.OdbcConnection.Open() +37
DevSite_ImportStep1.btnUpload_Click(Object sender, EventArgs e) +219
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102
I am uploading a text file to a MS SQL 2000 database using an ODBC driver. Here is the code:
<code>
FileUpload1.SaveAs(fpath + "" + fn)
litStep1.Visible = TrueDim FieldCount As Int16
Dim FileType As Int16Dim cmd As SqlCommand
Dim dr As SqlDataReaderDim conn2 As OdbcConnection
Dim dr2 As OdbcDataReader
Dim cmd2 As OdbcCommand
conn2 = New OdbcConnection("Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=" + fpath + ";Extended Properties='text;HDR=YES;FMT=Delimited'")
conn2.ConnectionTimeout = 200
cmd2 = New OdbcCommand("Select top 5 * from [" + fn + "] ", conn2)
cmd2.CommandType = CommandType.Text
cmd2.CommandTimeout = 300
conn2.Open()
dr2 = cmd2.ExecuteReader()
FieldCount = dr2.FieldCount
conn2.Close()
</code>
Before when this happened a reboot of the sql server resolved the problem. That's not working this time and it's certainly not a practical solution.
Any suggestions?
We have two instances of SQL Server 2005 - SP1 installed on one server. The default instance starts very slowly. When looking at the log I can see the delay is due to Resource Manager based upon the following error.
Message
Resource Manager Creation Failed: 0x8004d102
(XACT_E_DUPLICATE_GUID)
What does this mean?
What would cause this to happen?
How do I resolve the problem?
Thanks, Dave
I am using SQL 2000 (Standard Edition, SP4) and have created a linked server to access a Access MDB file. When I run a simple query against that server, I get the error:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
[OLE/DB provider returned message: System resource exceeded.]
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' ICommandText::Execute returned 0x80004005: ].
I am able to connect to this same Access MDB file from another SQL server (SQL 2000 Enterprise Edition, SP4). I have compared the two servers and they both have the same version of MDAC (2.8) and the same version of the Jet OLE DB Provider.
Any idea why this would work from one server and not from the other. Also, I was able to perform the same queries from the first server a week back.
Thanks in advance for you help.
Amir
Hello,
One of our lovely NA's decided to remove IIS and the reinstall it while RS was installed before trying to uninstall RS. So RS broke. We then tried to uninstall RS to start over and get this error:
The setup failed to read IIsMimeMap table. The error code is -2147024893
Anyone have a work around to get us to uninstall RS? This way we can install IIS 6.0 from scratch and try to install RS afterwards. Thanks.
Hi all
After deploying my report on the report Server, I try to access it on the browser which gives me the following error.
The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.
A name was started with an invalid character. Error processing resource 'http://localhost/reports/Pages/Folder.aspx'. Line...<%@ Page language="c#" Codebehind="Folder.aspx.cs" AutoEventWireup="false" Inherits="Microsoft.ReportingServices.UI.Folde...
How can I trouble shoot this error.?
Please help me out.
Thanx in advance.
Ronald
Hello
I wonder if someone could help me.
I am currenltly working on a scripted install of SQL 2005 Express SP2 with Cumulative update 5 and am experiencing some very frustrating problems.
I need to provide the ability to script the install and script the deinstall, both of which are fine. However..
When i try to uninstall SQL from the script (or manually from add/remove programs) i get the following error
The installer has encountered an unexpected error. The error code is 2709. The specified Component name ('SxSComp.42B34EA79EE84812AF478E608EA6C2F8') not found in Component table.
The error occurs when the SQL 2005 uninstaller attempts to uninstall the workstation components, the result is a partial uninstall of SQL 2005 which becomes very difficult to uninstall.
Would appreciate any assistance anyone could provide me.
Thanks
James Hodgson
Dear All:
When i try to debug the northwindoledb example with VS2005 i get the foolwing error message.
Is there a way to configure the solution to run witn WM5 emulator.
The application run with wm5 emulator when i set the plataform to Windows Mobile 2003, but i want to use the wm5 platform to debug my application with wm5 emulator.
------ Rebuild All started: Project: northwindoledb, Configuration: Debug Windows Mobile 5.0 Pocket PC SDK (ARMV4I) ------
Deleting intermediate and output files for project 'northwindoledb', configuration 'Debug|Windows Mobile 5.0 Pocket PC SDK (ARMV4I)'
Compiling...
Employees.cpp
northwindoledb.cpp
stdafx.cpp
Generating Code...
Compiling resources...
Linking...
coredll.lib(COREDLL.dll) : fatal error LNK1112: module machine type 'THUMB' conflicts with target machine type 'ARM'
Build log was saved at "file://d:Proyectos_VS2005Northwindoledb_WM2003_SQLEW_Windows Mobile 5.0 Pocket PC SDK (ARMV4I)DebugBuildLog.htm"
northwindoledb - 1 error(s), 0 warning(s)
========== Rebuild All: 0 succeeded, 1 failed, 0 skipped ==========
Trying to use WMI to monitor a SQLExpress DB and not getting anywhere. In fact, wmiprvse.exe croaks.
Here's the query I'm running from within CIM Studio:
select * from Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSDatabases
(Just did a search for SQL and found this class)
When trying to get an instance, WMIPRVSE throws this exception:
The exception unknown software exception (0xc000000d) occurred int he application at location 0x7814454d.
Ok to that, then another msgBox shows up with a title of
"Multiview Message" and text as below:
Win32: The remote procedure call failed.
An error occurred while attempting to retrieve the list of objects.
Any suggestions on this would be appreciated. Or perhaps another WMI class to use?
(XP Pro SP2, current with the patches; SQLExpress and MSDE both running)
thanks
Hi, I get the following error message error : "the setup failed to read IISmimemaptable the server code is 2147024893" and I cannot uninstall SQL Server 2005. Any idea this is happening. thanks!
chi
Hi,
I m new to SQL,I have created a Stored Procedure that writes a file on SQL server,but I want that it should write file on another machine.How can it be done.
Hi, i wondered if anyone could help me with my stored procedure.
It updates a table with users messageboard and saves the Title, Line 1, Line 2 and so on into a XML thats stored in the column named XML_Data.
How can i then output this xml to a file on my local machine?
T-SQL :-
ALTER PROCEDURE [dbo].[prUpdateMessageBoardVetted]
(PARAMS GO HERE)
UPDATE CustomerData
SET Title = @Title,
Line1 = @Line1,
Line2 = @Line2,
Line3 = @Line3,
Line4 = @Line4,
Line5 = @Line5,
Line6 = @Line6,
XmlFileName = @XmlFileName,
FlashFileName = @FlashFileName,
HtmlFileName = @HtmlFileName,
Vetted = @Vetted,
ClientName = @ClientName
WHERE
(UserRef = @original_UserRef)
END
BEGIN
IF @Vetted = 1
DECLARE @xmlData AS XML
SET @xmlData = (SELECT
UserRef,
Title,
Line1,
Line2,
Line3,
Line4,
Line5,
Line6
FROM dbo.CustomerData
WHERE (UserRef = @original_UserRef) FOR XML RAW('Message'), ELEMENTS)
SELECT @xmlData
UPDATE [dbo].[CustomerData]
SET
XML_Data = @xmlData
WHERE
(UserRef = @original_UserRef)
(THEN HERE DO SOME SORT PROCEDURE TO OUTPUT @xmlData to a XML FILE ON MY LOCAL MACHINE,
BUT ALSO NAME THE XML FILE VIA @XmlFileName BY DOING SOME SORT OF CONCANTENATION)
any ideas?
Thanks in advance !
Neil
Hi All,I have a requirement to create the database with data and log files ina different machine on the network.Googling, I got a link which said Mapped drives do not work but UNC pathswork. However in my case, both are failing.Any advices or links on net will be highly useful.Thanks and Regards,Chandra Mohan
View 5 Replies View RelatedI have the following command in a .bat file
osql -E -S localhost sp_grantlogin 'GREGASPNET'"
What I would like to do is replace GREG with the name of the local computer this .bat file is being run on.
Is there any string for this... i.e [LOCALMACHINE]ASPNET or something like that?
Greg
How to create a db in clients local machine with sql server ce and .net?Is any sample applications available?so,that later i can sync the data to the sql server db.
Please help.I am new to sql server ce.
I posted this question in the past and did not get any answer.
I put all my sources on a remote server mainly for backup purposes (the remote server is backuped every day) but when I have the .sdf file I can not open it from the visual studio 2005 configuration server here is the description of the problem:
I have an application that runs on a PDA and manage a database (.sdf) file I use C# with visual studio 2005
What I want to do is to add the database file (.sdf) to my project files and open a connection to it.
The problem is that all my source file are stored on remote machine and not locally on my machine and the .sdf file is also stored with the project source files.
When I try to add the file to the project I get the following error fro the data source configuration wizard :
"An error occured while retrieving the information from the database"
DRIVE_REMOTE
Parameter Name : N:
I get the same error also when I try to open a new connection to the file from the server explorer. When i copy the file to drive "C:" I can open a connection to it with no errors.
Hi,
I need to export some data from SQL 2005 to a flat file, The data and flat file names will be dynamic and will be be fired programaticaly so I can't use DTS or SSIS.
In SQL2000 I did it using bcp, but that's quite a security hole so I don't want to use external utilities. I'll need to do something similar on another machine to import the data as well.
I find it strange there's no easy way to do this!
Thanks.
I am using BIDS 2012.I am getting this error: Unable to load assembly U2.
Data.Client, Version=2.1.0.0, Culture=neutral , PublicKeyToken=9ab9148678f4f448, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error.Â
---> System.IO.FileNotFoundException: Could not load file or assembly 'U2.Data.Client, Version=2.1.0.0, Culture=neutral, PublicKeyToken=9ab9148678f4f448' or one of its dependencies. The system cannot find the file specified.
[code]....
I am expecting
C:WindowsMicrosoft.NETFramework64v4.0.30319configmachine.config
how can I force SSRS to use "C:WindowsMicrosoft.NETFramework64v4.0.30319configmachine.config".
I am getting the "Error Locating Server/Instance Specified" message. The part I find most confusing is that I am connecting to my database locally. I have read the recommendations on the blog posted here:
http://blogs.msdn.com/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx
and implemented them to no avail. The confusing part is that I only have this problem on one particular application, which I am not the original author of. When I build my connection to the very same server (different database) using the Data Source configuration wizard, it works just fine. Any help would be greatly appreciated.
Hello All
Just wondered if someone could help me with a bit of T-SQL, i have a application in ASP.NET/VB that allows the user to update a message board by clicking a button "update" this in turn triggers my Stored Procedure for inserting this data into a table, which works great.
It inserts the data into its respective fields and also takes The Title, Line 1, Line 2 and so on and creates a XML file (Using FOR XML) which is stored in the same Table under a column call XML_Data. Which again works great.
My problem now is how do i output this XML_Data to an actual XML file that is on my local machine, i.e. It be created in say C:Inetpubwwwrootxmlfiles("xml file name inserted here from another column that holds xml file name").xml
Any help on this would be greatfully apreciated
Thanks In Advance
Neil
Help!
I am using Script Transformation to output a new column as image[DT_IMAGE]
field to store serialized object. In the VB script, the sample code as
Row.serializedobject.AddBlobData ( binaryArrayReturnedFromC#dll )
The package always runs fine on my developing machine and will halt on other
machine at AddBlobData after certain number row records were processed. I am
stuck here. Anyone has any suggestion?
What I need is reading data from mutiple tables in one database and writing
into a single table in another datable. In order preserve all the columns
data, I use input column fields to construct a new object and then serialize
it, and store the serialize data into detination db table. (The object and
serialization function is coming from c# dll.)
Dim b As BusinessLicense = New BusinessLicense()
b.ApprovalDate = Row.approvaldate
b.BusinessId = Row.busid
b.BusinessName = Row.busname
b.NaicsCode = Row.naicscode
b.NaicsDescription = Row.naicsdescr
b.OwnerName = Row.ownername
b.Phone = Row.phone
b.Pkey = Row.pkey
b.RenewalDate = Row.renewaldate
b.StartDate = Row.startdate
b.Suite = Row.suite
Row.serializedobject.AddBlobData(Serializer.Serialize(b)) '''----This is blocking line
Row.infoType = BusinessLicense.TYPE
Both machine is xp with sp2. and standard SQL Server 2005 - 9.00.1399.06
Thanks!
I have done this many times in the past but now I am seeing a error when I try to move my db from my local machine to the server and try to re attach it. The error I am receiving is:
TITLE: Microsoft SQL Server Management Studio Express------------------------------ Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476 ------------------------------ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo) ------------------------------ CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataCuddleUpCabinRentals.mdf'. (Microsoft SQL Server, Error: 5123) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.2047&EvtSrc=MSSQLServer&EvtID=5123&LinkId=20476 ------------------------------BUTTONS: OK
------------------------------
When I right click the files and check their permissions I am noticing when its moved to the server it adds a few new ones and I can't make changes to them or anyting else. That is the only difference I am seeing from the ones I did earlier this week and now with the ones that are not working. I can't find anything in sql on what might cause this so any direction would be great.
ThanksRusty
hi ..
i install sqlserver and make app with vb6 using ADO to connect to the database and successfully
i put that application on another pc on the network
when i open it it says "can't login computernameguest" ??!!
any help
thanks in advance.
Hi to everyone,
I'm facing a problem that drives me crazy. I've a web application that has the following problem. When I test the application on my developement machine all runs fine, but when I put into production server there is a problem in connection pooling. Look at the following image, the blue line is the number of connection in the pool and the violet line is the number of connection reclaimed. From the image it is clear that connection are returned on the pool only in block, maybe when the garbage collection pass and reclaim the object. The strange thing is that on my developement machine all is good, and also I'm using Enterprise Library and the connection are managed internally.- Thanks to everyone for any help.
Hullo all
I have two machines,
One is a standalone machine and the other is on a domain network. How can I run a stored procedure/job on the standalone machine from the domain machine ?
running the procedure as a Domain user results in a failed job/stored proc.
also creating an sql login and attempting to run it as that user also fails. How can I solve this problem ?
please e-mail me at wayde@sunnygrp.com if you have any thoughts...
Hi All;We are going to change our application server. We will copy all of ourDatabase from Mic 2000 Server OS to Mic 2003 Server OS. I found anarticle that how to move all the folders from same OS. My question isthat Would the 2003 OS be a problem when we copy all of the MC SQL 2000folders to New OS ? Has anybody done this before? Could you gimme yoursuggestions please?ThanksASA
View 1 Replies View Related