Guten Abend,
habe eben Update von WAWI 842 auf 844 durchgeführt.
ODBC System-DNS und globale Einstellungen in WAWI (AMILO217\JTLWAWI) sind laut Manuel in Ordnung.
Bei Erstart nach Update wird aber weiterhin lacal/wawi abgefragt.
Wenn ich DSN-user-password im WAWI -im Abfragefenster erneuert habe, ist alles wieder ok
und die WAWI startet ohne Probleme bis zum nächsten Update.
Testumgebung ist winxp-sql2005-lokale Installation.
Grüsse
Thomas
00000001 0.00000000 [3820] JTLcorelib.dll loaded.
00000002 0.00016153 [3820] Namespace: JTLmisc
00000003 0.00021799 [3820] Class: CJTLmisc
00000004 0.19921674 [3820] DSN: AMILO217\JTLWAWI
00000005 0.19927828 [3820] DBN: eazybusiness
00000006 0.19933502 [3820] User: sa
00000007 0.19939153 [3820] Pass:
00000008 13.30893612 [3820] DataSource=AMILO217\JTLWAWI, InitialCatalog=eazybusiness, UserID=sa: DB-Verbindung: {0}
00000009 16.06933022 [3820] SELECT cValue FROM [eazybusiness].[dbo].[tOptions] WHERE cKey='BackupErzwingen'
00000010 21.77280998 [3820] SELECT * FROM eazybusiness.dbo.tMandant
00000011 29.95248795 [3820] SELECT cValue FROM [eazybusiness].[dbo].[tOptions] WHERE cKey='BackupErzwingen'
00000012 29.97485161 [3820] SELECT (CASE WHEN SERVERPROPERTY('MACHINENAME') = HOST_NAME() THEN 'local' ELSE 'remote' END) AS instance
00000013 32.86885452 [3820] xp_fixeddrives
00000014 33.37507629 [3820] SELECT cValue FROM [eazybusiness].[dbo].[tOptions] WHERE cKey='BackupErzwingen'
00000015 38.91092300 [3820] SELECT TOP(1) cVersion FROM [eazybusiness].[dbo].[tVersion];
00000016 39.00579071 [3820] DBCC CHECKDB (eazybusiness) WITH NO_INFOMSGS, TABLERESULTS
00000017 39.83374786 [3820] xp_fixeddrives
00000018 44.76089478 [3820] xp_fixeddrives
00000019 49.76102066 [3820] xp_fixeddrives
00000020 54.77693176 [3820] xp_fixeddrives
00000021 59.78166580 [3820] xp_fixeddrives
00000022 64.77742767 [3820] xp_fixeddrives
00000023 69.77760315 [3820] xp_fixeddrives
00000024 74.79340363 [3820] xp_fixeddrives
00000025 79.79362488 [3820] xp_fixeddrives
00000026 84.79376984 [3820] xp_fixeddrives
00000027 89.79401398 [3820] xp_fixeddrives
00000028 94.79421997 [3820] xp_fixeddrives
00000029 99.79435730 [3820] xp_fixeddrives
00000030 135.39070129 [3708] Open PIPE
00000031 135.90110779 [3708] -> WaitingForConnection
00000032 136.12022400 [3708] ---------------------- init form core0
00000033 136.41407776 [3820] DataSource=AMILO217\JTLWAWI, InitialCatalog=eazybusiness, UserID=sa: DB-Verbindung: {0}
00000034 136.42280579 [3820] SELECT cValue FROM tOptions WHERE cKey='MYHASH'
00000035 136.43217468 [3820] SELECT SERVERPROPERTY('edition')
00000036 137.69180298 [3820] SELECT * FROM tsigportal
00000037 138.74755859 [3820] JTLWawi.DLL gestartet.
00000038 138.74761963 [3820] DSN: eazybusiness
00000039 138.74768066 [3820] DBN: eazybusiness
00000040 138.74772644 [3820] User: sa
00000041 138.76876831 [3820] DataSource=AMILO217\JTLWAWI, InitialCatalog=eazybusiness, UserID=sa: DB-Verbindung: {0}
00000042 168.36589050 [3820] JTLWawi.DLL gestartet.
00000043 168.36596680 [3820] DSN: eazybusiness
00000044 168.36602783 [3820] DBN: eazybusiness
00000045 168.36608887 [3820] User: sa
00000046 168.36634827 [3820] DataSource=AMILO217\JTLWAWI, InitialCatalog=eazybusiness, UserID=sa: DB-Verbindung: {0}
00000047 168.97206116 [3820] SELECT TOP 1 * FROM tOptions WHERE tOptions.cKey = 'EingangsrechnungNutzen'
00000048 169.96865845 [3820] SELECT * FROM tSpracheUsed
00000049 170.05372620 [3820]
00000050 170.05372620 [3820] SELECT
00000051 170.05372620 [3820] myColumns.name AS [Name],
00000052 170.05372620 [3820] myType.name AS [DataType],
00000053 170.05372620 [3820] ISNULL(myBaseType.name, N'') AS [SystemType],
00000054 170.05372620 [3820] CAST(CASE WHEN myBaseType.name IN (N'nchar', N'nvarchar') AND myColumns.max_length <> -1 THEN
00000055 170.05372620 [3820] myColumns.max_length/2 ELSE myColumns.max_length END AS int) AS [Length],
00000056 170.05372620 [3820] CAST(myColumns.precision AS int) AS [NumericPrecision]
00000057 170.05372620 [3820] FROM
00000058 170.05372620 [3820] sys.tables AS myTable
00000059 170.05372620 [3820] INNER JOIN sys.all_columns AS myColumns ON myColumns.object_id=myTable.object_id
00000060 170.05372620 [3820] LEFT OUTER JOIN sys.types AS myType ON myType.user_type_id = myColumns.user_type_id
00000061 170.05372620 [3820] LEFT OUTER JOIN sys.types AS myBaseType ON myBaseType.user_type_id = myColumns.system_type_id and
00000062 170.05372620 [3820] myBaseType.user_type_id = myBaseType.system_type_id
00000063 170.05372620 [3820] WHERE
00000064 170.05372620 [3820] (myTable.name='tLieferant' and SCHEMA_NAME(myTable.schema_id)=N'dbo')
00000065 170.05372620 [3820] ORDER BY
00000066 170.05372620 [3820] myColumns.column_id ASC
00000067 176.13676453 [3820]
00000068 176.13676453 [3820] SELECT
00000069 176.13676453 [3820] myColumns.name AS [Name],
00000070 176.13676453 [3820] myType.name AS [DataType],
00000071 176.13676453 [3820] ISNULL(myBaseType.name, N'') AS [SystemType],
00000072 176.13676453 [3820] CAST(CASE WHEN myBaseType.name IN (N'nchar', N'nvarchar') AND myColumns.max_length <> -1 THEN
00000073 176.13676453 [3820] myColumns.max_length/2 ELSE myColumns.max_length END AS int) AS [Length],
00000074 176.13676453 [3820] CAST(myColumns.precision AS int) AS [NumericPrecision]
00000075 176.13676453 [3820] FROM
00000076 176.13676453 [3820] sys.tables AS myTable
00000077 176.13676453 [3820] INNER JOIN sys.all_columns AS myColumns ON myColumns.object_id=myTable.object_id
00000078 176.13676453 [3820] LEFT OUTER JOIN sys.types AS myType ON myType.user_type_id = myColumns.user_type_id
00000079 176.13676453 [3820] LEFT OUTER JOIN sys.types AS myBaseType ON myBaseType.user_type_id = myColumns.system_type_id and
00000080 176.13676453 [3820] myBaseType.user_type_id = myBaseType.system_type_id
00000081 176.13676453 [3820] WHERE
00000082 176.13676453 [3820] (myTable.name='CONVERT(VARCHAR(1000), tLieferant' and SCHEMA_NAME(myTable.schema_id)=N'dbo')
00000083 176.13676453 [3820] ORDER BY
00000084 176.13676453 [3820] myColumns.column_id ASC
00000085 186.20915222 [3820] SELECT *
00000086 186.20915222 [3820] FROM tListViewExHeader
00000087 186.20915222 [3820] WHERE nListViewID = 36
00000088 186.20915222 [3820] AND kBenutzer = 1
00000089 186.20915222 [3820] AND cRechnername = 'AMILO217'
00000090 186.28442383 [3820] SELECT *
00000091 186.28442383 [3820] FROM tListViewExHeader
00000092 186.28442383 [3820] WHERE nListViewID = 36
00000093 186.28442383 [3820] AND kBenutzer = 0
00000094 186.28442383 [3820] AND cRechnername = 'AMILO217'
00000095 186.28579712 [3820] SELECT *
00000096 186.28579712 [3820] FROM tListViewExHeader
00000097 186.28579712 [3820] WHERE nListViewID = 36
00000098 186.28579712 [3820] AND kBenutzer = 1
00000099 186.28579712 [3820] AND cRechnername = ''
00000100 186.28703308 [3820] SELECT *
00000101 186.28703308 [3820] FROM tListViewExHeader
00000102 186.28703308 [3820] WHERE nListViewID = 36
00000103 186.28703308 [3820] AND kBenutzer = 0
00000104 186.28703308 [3820] AND (cRechnername = '' OR cRechnername IS NULL)
00000105 186.40411377 [3820] SELECT COUNT(*) FROM
00000106 186.40411377 [3820] (
00000107 186.40411377 [3820] SELECT TOP 100 PERCENT tLieferant.kLieferant, tLieferant.cLieferantID, tLieferant.cFirma, tLieferant.cFirmenZusatz, tLieferant.cKontakt, tLieferant.cTelZentralle, tLieferant.cTelDurchwahl, tLieferant.cFax, tLieferant.cOrt, tLieferant.cLand, tLieferant.cLiefNr
00000108 186.40411377 [3820] FROM tLieferant
00000109 186.40411377 [3820] WHERE (tLieferant.cAktiv = 'Y')
00000110 186.40411377 [3820] GROUP BY tLieferant.kLieferant, tLieferant.cLieferantID, tLieferant.cFirma, tLieferant.cFirmenZusatz, tLieferant.cKontakt, tLieferant.cTelZentralle, tLieferant.cTelDurchwahl, tLieferant.cFax, tLieferant.cOrt, tLieferant.cLand, tLieferant.cLiefNr
00000111 186.40411377 [3820] )
00000112 186.40411377 [3820] countTable
00000113 186.49205017 [3820]
00000114 186.49205017 [3820] #######################################################################
00000115 186.49205017 [3820] Der jtlSQLHandlerEx hat für das getDataCount() folgende Daten abgesetzt
00000116 186.49205017 [3820] ListView: lvLieferanten
00000117 186.49205017 [3820] SQL Statement:
00000118 186.49205017 [3820] #######################################################################
habe eben Update von WAWI 842 auf 844 durchgeführt.
ODBC System-DNS und globale Einstellungen in WAWI (AMILO217\JTLWAWI) sind laut Manuel in Ordnung.
Bei Erstart nach Update wird aber weiterhin lacal/wawi abgefragt.
Wenn ich DSN-user-password im WAWI -im Abfragefenster erneuert habe, ist alles wieder ok
und die WAWI startet ohne Probleme bis zum nächsten Update.
Testumgebung ist winxp-sql2005-lokale Installation.
Grüsse
Thomas
00000001 0.00000000 [3820] JTLcorelib.dll loaded.
00000002 0.00016153 [3820] Namespace: JTLmisc
00000003 0.00021799 [3820] Class: CJTLmisc
00000004 0.19921674 [3820] DSN: AMILO217\JTLWAWI
00000005 0.19927828 [3820] DBN: eazybusiness
00000006 0.19933502 [3820] User: sa
00000007 0.19939153 [3820] Pass:
00000008 13.30893612 [3820] DataSource=AMILO217\JTLWAWI, InitialCatalog=eazybusiness, UserID=sa: DB-Verbindung: {0}
00000009 16.06933022 [3820] SELECT cValue FROM [eazybusiness].[dbo].[tOptions] WHERE cKey='BackupErzwingen'
00000010 21.77280998 [3820] SELECT * FROM eazybusiness.dbo.tMandant
00000011 29.95248795 [3820] SELECT cValue FROM [eazybusiness].[dbo].[tOptions] WHERE cKey='BackupErzwingen'
00000012 29.97485161 [3820] SELECT (CASE WHEN SERVERPROPERTY('MACHINENAME') = HOST_NAME() THEN 'local' ELSE 'remote' END) AS instance
00000013 32.86885452 [3820] xp_fixeddrives
00000014 33.37507629 [3820] SELECT cValue FROM [eazybusiness].[dbo].[tOptions] WHERE cKey='BackupErzwingen'
00000015 38.91092300 [3820] SELECT TOP(1) cVersion FROM [eazybusiness].[dbo].[tVersion];
00000016 39.00579071 [3820] DBCC CHECKDB (eazybusiness) WITH NO_INFOMSGS, TABLERESULTS
00000017 39.83374786 [3820] xp_fixeddrives
00000018 44.76089478 [3820] xp_fixeddrives
00000019 49.76102066 [3820] xp_fixeddrives
00000020 54.77693176 [3820] xp_fixeddrives
00000021 59.78166580 [3820] xp_fixeddrives
00000022 64.77742767 [3820] xp_fixeddrives
00000023 69.77760315 [3820] xp_fixeddrives
00000024 74.79340363 [3820] xp_fixeddrives
00000025 79.79362488 [3820] xp_fixeddrives
00000026 84.79376984 [3820] xp_fixeddrives
00000027 89.79401398 [3820] xp_fixeddrives
00000028 94.79421997 [3820] xp_fixeddrives
00000029 99.79435730 [3820] xp_fixeddrives
00000030 135.39070129 [3708] Open PIPE
00000031 135.90110779 [3708] -> WaitingForConnection
00000032 136.12022400 [3708] ---------------------- init form core0
00000033 136.41407776 [3820] DataSource=AMILO217\JTLWAWI, InitialCatalog=eazybusiness, UserID=sa: DB-Verbindung: {0}
00000034 136.42280579 [3820] SELECT cValue FROM tOptions WHERE cKey='MYHASH'
00000035 136.43217468 [3820] SELECT SERVERPROPERTY('edition')
00000036 137.69180298 [3820] SELECT * FROM tsigportal
00000037 138.74755859 [3820] JTLWawi.DLL gestartet.
00000038 138.74761963 [3820] DSN: eazybusiness
00000039 138.74768066 [3820] DBN: eazybusiness
00000040 138.74772644 [3820] User: sa
00000041 138.76876831 [3820] DataSource=AMILO217\JTLWAWI, InitialCatalog=eazybusiness, UserID=sa: DB-Verbindung: {0}
00000042 168.36589050 [3820] JTLWawi.DLL gestartet.
00000043 168.36596680 [3820] DSN: eazybusiness
00000044 168.36602783 [3820] DBN: eazybusiness
00000045 168.36608887 [3820] User: sa
00000046 168.36634827 [3820] DataSource=AMILO217\JTLWAWI, InitialCatalog=eazybusiness, UserID=sa: DB-Verbindung: {0}
00000047 168.97206116 [3820] SELECT TOP 1 * FROM tOptions WHERE tOptions.cKey = 'EingangsrechnungNutzen'
00000048 169.96865845 [3820] SELECT * FROM tSpracheUsed
00000049 170.05372620 [3820]
00000050 170.05372620 [3820] SELECT
00000051 170.05372620 [3820] myColumns.name AS [Name],
00000052 170.05372620 [3820] myType.name AS [DataType],
00000053 170.05372620 [3820] ISNULL(myBaseType.name, N'') AS [SystemType],
00000054 170.05372620 [3820] CAST(CASE WHEN myBaseType.name IN (N'nchar', N'nvarchar') AND myColumns.max_length <> -1 THEN
00000055 170.05372620 [3820] myColumns.max_length/2 ELSE myColumns.max_length END AS int) AS [Length],
00000056 170.05372620 [3820] CAST(myColumns.precision AS int) AS [NumericPrecision]
00000057 170.05372620 [3820] FROM
00000058 170.05372620 [3820] sys.tables AS myTable
00000059 170.05372620 [3820] INNER JOIN sys.all_columns AS myColumns ON myColumns.object_id=myTable.object_id
00000060 170.05372620 [3820] LEFT OUTER JOIN sys.types AS myType ON myType.user_type_id = myColumns.user_type_id
00000061 170.05372620 [3820] LEFT OUTER JOIN sys.types AS myBaseType ON myBaseType.user_type_id = myColumns.system_type_id and
00000062 170.05372620 [3820] myBaseType.user_type_id = myBaseType.system_type_id
00000063 170.05372620 [3820] WHERE
00000064 170.05372620 [3820] (myTable.name='tLieferant' and SCHEMA_NAME(myTable.schema_id)=N'dbo')
00000065 170.05372620 [3820] ORDER BY
00000066 170.05372620 [3820] myColumns.column_id ASC
00000067 176.13676453 [3820]
00000068 176.13676453 [3820] SELECT
00000069 176.13676453 [3820] myColumns.name AS [Name],
00000070 176.13676453 [3820] myType.name AS [DataType],
00000071 176.13676453 [3820] ISNULL(myBaseType.name, N'') AS [SystemType],
00000072 176.13676453 [3820] CAST(CASE WHEN myBaseType.name IN (N'nchar', N'nvarchar') AND myColumns.max_length <> -1 THEN
00000073 176.13676453 [3820] myColumns.max_length/2 ELSE myColumns.max_length END AS int) AS [Length],
00000074 176.13676453 [3820] CAST(myColumns.precision AS int) AS [NumericPrecision]
00000075 176.13676453 [3820] FROM
00000076 176.13676453 [3820] sys.tables AS myTable
00000077 176.13676453 [3820] INNER JOIN sys.all_columns AS myColumns ON myColumns.object_id=myTable.object_id
00000078 176.13676453 [3820] LEFT OUTER JOIN sys.types AS myType ON myType.user_type_id = myColumns.user_type_id
00000079 176.13676453 [3820] LEFT OUTER JOIN sys.types AS myBaseType ON myBaseType.user_type_id = myColumns.system_type_id and
00000080 176.13676453 [3820] myBaseType.user_type_id = myBaseType.system_type_id
00000081 176.13676453 [3820] WHERE
00000082 176.13676453 [3820] (myTable.name='CONVERT(VARCHAR(1000), tLieferant' and SCHEMA_NAME(myTable.schema_id)=N'dbo')
00000083 176.13676453 [3820] ORDER BY
00000084 176.13676453 [3820] myColumns.column_id ASC
00000085 186.20915222 [3820] SELECT *
00000086 186.20915222 [3820] FROM tListViewExHeader
00000087 186.20915222 [3820] WHERE nListViewID = 36
00000088 186.20915222 [3820] AND kBenutzer = 1
00000089 186.20915222 [3820] AND cRechnername = 'AMILO217'
00000090 186.28442383 [3820] SELECT *
00000091 186.28442383 [3820] FROM tListViewExHeader
00000092 186.28442383 [3820] WHERE nListViewID = 36
00000093 186.28442383 [3820] AND kBenutzer = 0
00000094 186.28442383 [3820] AND cRechnername = 'AMILO217'
00000095 186.28579712 [3820] SELECT *
00000096 186.28579712 [3820] FROM tListViewExHeader
00000097 186.28579712 [3820] WHERE nListViewID = 36
00000098 186.28579712 [3820] AND kBenutzer = 1
00000099 186.28579712 [3820] AND cRechnername = ''
00000100 186.28703308 [3820] SELECT *
00000101 186.28703308 [3820] FROM tListViewExHeader
00000102 186.28703308 [3820] WHERE nListViewID = 36
00000103 186.28703308 [3820] AND kBenutzer = 0
00000104 186.28703308 [3820] AND (cRechnername = '' OR cRechnername IS NULL)
00000105 186.40411377 [3820] SELECT COUNT(*) FROM
00000106 186.40411377 [3820] (
00000107 186.40411377 [3820] SELECT TOP 100 PERCENT tLieferant.kLieferant, tLieferant.cLieferantID, tLieferant.cFirma, tLieferant.cFirmenZusatz, tLieferant.cKontakt, tLieferant.cTelZentralle, tLieferant.cTelDurchwahl, tLieferant.cFax, tLieferant.cOrt, tLieferant.cLand, tLieferant.cLiefNr
00000108 186.40411377 [3820] FROM tLieferant
00000109 186.40411377 [3820] WHERE (tLieferant.cAktiv = 'Y')
00000110 186.40411377 [3820] GROUP BY tLieferant.kLieferant, tLieferant.cLieferantID, tLieferant.cFirma, tLieferant.cFirmenZusatz, tLieferant.cKontakt, tLieferant.cTelZentralle, tLieferant.cTelDurchwahl, tLieferant.cFax, tLieferant.cOrt, tLieferant.cLand, tLieferant.cLiefNr
00000111 186.40411377 [3820] )
00000112 186.40411377 [3820] countTable
00000113 186.49205017 [3820]
00000114 186.49205017 [3820] #######################################################################
00000115 186.49205017 [3820] Der jtlSQLHandlerEx hat für das getDataCount() folgende Daten abgesetzt
00000116 186.49205017 [3820] ListView: lvLieferanten
00000117 186.49205017 [3820] SQL Statement:
00000118 186.49205017 [3820] #######################################################################