Inserting to a database

[Kyle.Davies]

Hi i need some help i have installed SQL and set it up on a test VM, when i run Aida64 from command line to insert into the database it gives me this error: Warning: Error occured during report generation process

 

SQL is installed on a windows 7 pr 32bit VM, and i tried aida on XP, Win7, Win8.

 

Please i need help

[GPeti07]

Hi Kyle,

Could you send me, or attach here, your aida64.ini setup file? Maybe something is wrong in the configuration. Which SQL database do you use (what is the name of the database)?

[Fiery]

Also, did you initialize your database tables using the appropriate SQL schema?  E.g. DB - SQL Server.sql for Microsoft SQL Server.

[Kyle.Davies]

Also, did you initialize your database tables using the appropriate SQL schema?  E.g. DB - SQL Server.sql for Microsoft SQL Server.

 

How do i do that?

 

 

 

Hi Kyle,

Could you send me, or attach here, your aida64.ini setup file? Maybe something is wrong in the configuration. Which SQL database do you use (what is the name of the database)?

Sorry about the copy and paste not sure on how to attach files.

 

 

[Generic]

 

NoGUI=0

ControlPanelIcon=0

LoadWithWindows=0

SplashScreen=1

MinimizeToTray=0

CloseToTray=0

IconStyle=7

AppStart=Normal

NetUpdateFreq=0

NetUpdateType=S

NetUpdateSavePkg=0

NetUpdatePkgFolder=

PersonalFullName=

PersonalEmailAddress=

Language=en

LoadKD=1

LowLevelMSR=1

LowLevelPCI=1

LowLevelSMBus=1

LowLevelSensor=1

LowLevelFanDivConf=1

LowLevelSMART=1

LowLevelRAIDEnum=1

LowLevelRAIDSMART=1

LowLevelNVDRVSMBUS=1

LowLevelNV3DMode=1

LowLevelACPISMBus=0

LowLevelAppleSMC=1

LowLevelATKEX=1

LowLevelDellSMI=1

LowLevelHIDUPS=1

LowLevelKoolance=0

LowLevelTBalancer=1

LowLevelDIMMTS=0

LowLevelTVALZ=1

LowLevelVolterra=1

LowLevelGPUSensor=1

LowLevelGPUFan=1

LowLevelMultiGPU=1

ReportFileName=Report

ReportExtensionAutomatic=1

ReportFileExtension=txt

ReportFileFolder=\\kyle\c$\aida64\Reports\new

ReportTitle=AIDA64 Business Edition

XMLStyleFile=

ReportHeader=1

ReportFooter=1

ReportDebugInfo=1

ReportDebugInfoCSV=0

ReportHostInFPC=0

ReportCompressFile=0

ReportCompressEmail=1

ReportCompressFTPUpload=1

EmailProtocol=MAPI

EmailTo=

EmailCc=

EmailBcc=

EmbedTXTReports=0

SMTPDisplayName=

SMTPEmailAddress=

SMTPServer=

SMTPPort=25

SMTPAuth=0

SMTPUser=

SMTPPassword=

ELFilter=PastDays

ELFilterDays=7

ELFilterInfo=0

ELFilterWarn=1

ELFilterError=1

ELFilterAudit=1

ICBHFilter=PastDays

ICBHFilterDays=7

ICBHFilterFile=1

ICBHFilterHTTP=1

ScheduleLimit=0

ScheduleStore=RegM

ScheduleStoreCustomFile=\\server\share\folder\$HOSTNAME.tag

FTPServer=

FTPPort=21

FTPUser=

FTPPassword=

FTPRemoteFolder=

FTPPassiveMode=0

ADOProvider=MSSQL

ADODataSource=

ADOServer=SQLTest

ADOServerPort=

ADODatabase=Aida64

ADODriver=

ADOUser=kyle

ADOPassword=6314B3AA558BD0CF1DED398D975ED0143B990D8DF166DF58B4F43B62AB8176AA4A2528633DB9812F3BFF2F77F7AC55D7D0ED3313FF7B6B264A6F1149A150F60E0F25D3EAEB7043D0396ABDB19DDFECFC6280258764576361E26483D670D24C1FD25D3B0676EDA0F0D0118C41E80019600D812B7E694E86CFDDB41C26AC7EE91CEE83C728CB4CFF65EAB58DDAAF8C5C8A206EEAA68986188D49E82694569708B45787A09279268C895032979F63EEE9A0440398EA4180B4F8BBC58F34324841698BEC75D18586B2932D6F0D78285E367158444CD7FA96B4D5AB1B84BC0496583DACF188CC23BB2394972324D483B6C387FF97DEA3E67BCEB0F821DEE06744F61373BD3819A1CDED54E815FBC9BA218B22994E3B30E8C3A6F12CA4105A37E9527C048B72C435F56A6E77D60C6B3ED12454A1B016274907BDE5B76B465A50BA2F97FB11D1EE4162F78230D47BA28160ED9AAC47B3A602612D30ED62C88BE48B0ECCCA642180AD83274E2DCE1951743C9103DC043C6B675C21C3000D9B4C5BD8A8878548E3F51BC60E76B407FD92A6EC0C70586E87A6C33AC33BDB0AB47202EB4C3AB3F4FE6E14290E271C81AAD2704FE7E12E8A17294AB12553323EDFFCD5F8555A5384CC88DD0FD6CD9D990C25F10F9FB386A79C4486464774052C0FB4865290824B9B38BC237ABBF0D3317A4B466DD000515A7E56BD5EB8DCCD2D874F97DF8C39C42C476D980F7BC1665C4EC9B71B3C5EDBAB0346A907124299A4324A89CD61D1D07426497ECDCE4CDB1835954276EB451C8486F758CDD39D2C33A6B24A067E0A6EA469E44DDC7539265F43E25050583E8759E267CCD81A221A0675154F343AEFF676508BE45A4347CD87D6054167A798362CF5C064DD24B895C9ADE1CD119080DE5DC6ECA393CE747300BD077EFA09BBAE4646CED8F217E42E94049A3B0907ABD537E43C

ADOWinSec=1

ADOAutoID=1

ADOMySQLOpt=0

ADOBULKINSERT=0

ADOBULKFolder=C:\aida64\reports\new

TableNameReport=Report

TableNameItem=Item

TableNameNextID=NextID

RemotePortI=2345

RemotePortM=2346

RemotePortR=2347

RemotePortC=2348

RemotePasswordI=

RemotePasswordM=

RemotePasswordR=

RemotePasswordC=

RemoteSecurityRule=All

ShotType=Full

ShotQuality=50

RCDithering=0

RCDisableUIFX=1

RCRemoveDesktopWP=1

RCDesktopRes=0

RCDesktopCD=0

RCViewOnly=0

FileScannerScope=No

FileScannerFilterAll=1

FileScannerFilterCOMEXE=0

FileScannerFilterDLL=0

FileScannerFilterAudio=0

FileScannerFilterVideo=0

FileScannerFilterMisc=0

FileScannerFilterMiscMask=

FileScannerFileSizeMode=Any

FileScannerFileSize=1000

FilePropFolder=1

FilePropFileName=1

FilePropFileSize=1

FilePropCreationTime=1

FilePropLastModifTime=1

FilePropLastAccessTime=1

FilePropCompany=1

FilePropFileDesc=1

FilePropFileVer=1

FilePropInternal=1

FilePropLegal=1

FilePropOrigFN=1

FilePropProductName=1

FilePropProductVer=1

AlertCheckFreq=2

AlertRepeatFreq=2

AlertStore=UserTemp

AlertMethodDisplayWindow=0

AlertMethodSendEmail=0

AlertMethodLogToServer=0

AlertMethodSendWinMsg=0

AlertMethodLogToTXT=0

AlertMethodLogToHTM=0

AlertMethodEmailAddress=

AlertMethodLogServer=

AlertMethodWinMsgDest=

AlertMethodTXTLogFile=.txt

AlertMethodHTMLogFile=.htm

AlertTriggerVirDB=1,7

AlertTriggerSysDrvSpace=1,10

AlertTriggerLocDrvSpace=0,10

AlertTriggerLocDrvTemp=0,55

AlertTriggerInstPrg=1,

AlertTriggerService=1,

AlertTriggerAutoStart=1,

AlertTriggerShare=1,

AlertTriggerPCIDev=1,

AlertTriggerUSBDev=1,

AlertTriggerSMARTFail=1,

AlertTriggerSysMemSize=1,

AlertTriggerHostName=1,

AlertTriggerWinlogonShell=1,

 

[Layout]

 

ASPIPage=1

AudioCodecsPage=0

DMIPage=1

OpenALPage=0

OpenGLPage=0

DirectXMenu=1

ConfigMenu=1

DatabaseMenu=1

BenchmarkMenu=1

SortMenu=0

SilentMode=0

RememberWindowPos=1

RememberWindowSize=1

RememberPageMenuState=0

RememberLastPage=0

HideUnits=0

ShowOrigCPUClock=0

LimitBenchRef=0

EmailCommentLargeFont=0

 

[RptLook]

 

NFName=Verdana

NFSize=80

NFColor=0

NFBold=0

NFItalic=0

PCFName=Verdana

PCFSize=140

PCFColor=8388608

PCFBold=1

PCFItalic=0

DCFName=Verdana

DCFSize=110

DCFColor=8388608

DCFBold=1

DCFItalic=0

BGColor=16777215

 

[sum]

 

group_computer=1

 computertype=1

 os=1

 ossp=1

 ieversion=1

 directxversion=1

 hostname=1

 username=1

 smtpemail=1

 logondomain=1

 datetime=1

group_mobo=1

 cputype=1

 moboname=1

 mobochipset=1

 sysmem=1

 spdmodules=0

 biostype=1

 commport=1

group_display=1

 videoadapter=1

 3dacc=1

 monitor=1

group_multimedia=1

 audioadapter=1

group_storage=1

 idectrl=1

 scsictrl=1

 floppydrive=1

 diskdrive=1

 cddvddrive=1

 smartstatus=1

group_partitions=1

group_input=1

 keyboard=1

 mouse=1

 gamectrl=1

group_net=1

 primaryip=1

 primarymac=1

 netadapter=1

 modem=1

group_periph=1

 printer=1

 fwctrl=1

 irctrl=1

 usb1ctrl=1

 usb2ctrl=1

 usb3ctrl=1

 usbdev=1

 battery=1

group_dmi=1

 dmibiosvendor=1

 dmibiosversion=1

 dmisystemmanuf=1

 dmisystemproduct=1

 dmisystemversion=1

 dmisystemserial=1

 dmisystemuuid=1

 dmimobomanuf=1

 dmimoboproduct=1

 dmimoboversion=1

 dmimoboserial=1

 dmichassismanuf=1

 dmichassisversion=1

 dmichassisserial=1

 dmichassisasset=1

 dmichassistype=1

 dmimemsockets=1

group_customvars=1

 customvar1=0

 customvar2=0

 customvar3=0

 customvar4=0

 customvar5=0

 customvar6=0

 customvar7=0

 customvar8=0

 customvar9=0

 customvar10=0

 customvar11=0

 customvar12=0

 customvar13=0

 customvar14=0

 customvar15=0

 customvar16=0

 customvar17=0

 customvar18=0

 customvar19=0

 customvar20=0

 customvar21=0

 customvar22=0

 customvar23=0

 customvar24=0

 customvar25=0

 customvar26=0

 customvar27=0

 customvar28=0

 customvar29=0

 customvar30=0

 customvar31=0

 customvar32=0

 customvar33=0

 customvar34=0

 customvar35=0

 customvar36=0

 customvar37=0

 customvar38=0

 customvar39=0

 customvar40=0

 customvar41=0

 customvar42=0

 customvar43=0

 customvar44=0

 customvar45=0

 customvar46=0

 customvar47=0

 customvar48=0

 customvar49=0

 customvar50=0

[GPeti07]

Hi Kyle,

 

The settings seem ok.

 

 

 

How do i do that?

 

You can read about the database initialization and other in this document (read section 3.7.4):

http://www.aida64.co.uk/sites/default/files/public/download/documents/en/aida64business-manual.pdf

[Kyle.Davies]

@ newbie

 

you are the best  i have been struggling for a week to get that working.