Problems MSSQL common_functions.php

[dohertyit]

In Categories\Authentication i changed the DSN path to
c:\Program Files\FirstSpot\datasource\FirstspotSQL.dsn
contents of Firstspotsql.dsn are
[ODBC]
DRIVER=SQL Server
UID=FirstspotSRV
PWD=Int3rn3t!
DATABASE=Firstspot
WSID=SVTAAO11
APP=Microsoft Data Access Components
SERVER=192.168.146.1
Description=Firstspot database on SQL

At save I get error as follows:
Warning: fopen(C:\Program Files\Common Files\ODBC\Data Sources\FirstspotSQL.dsn) [function.fopen]: failed to open stream: No such file or directory in C:\Program Files\FirstSpot\authserv\common_functions.php on line 460
Cannot open DSN source file!

I am using Firstspot 6.0.4 trial in Windows 2003 SP2 connecting to MS SQL2008 on remote server
In the firstspot_gw_srv.log I am getting this error
09/11/2009 18:59:32 ** StartServiceThread: Create Connection Pool
09/11/2009 18:59:32 ** CFirstSpotSQL::connect: Connect to data source failed [0]try
09/11/2009 18:59:32 >--- ERROR -- RetCode [-1] Reported------------
09/11/2009 18:59:32 Total Number of diagnostic records: 1
09/11/2009 18:59:32 SQLSTATE: S1000
09/11/2009 18:59:32 Native Error Code: 556
09/11/2009 18:59:32 Message: General error: Invalid file dsn ''
09/11/2009 18:59:32 ** CFirstSpotSQL::connect: Connecting to Database failed [0]try
09/11/2009 18:59:33 ** CFirstSpotSQL::connect: Connect to data source failed [1]try
09/11/2009 18:59:33 >--- ERROR -- RetCode [-1] Reported------------
09/11/2009 18:59:33 Total Number of diagnostic records: 1
09/11/2009 18:59:33 SQLSTATE: S1000
09/11/2009 18:59:33 Native Error Code: 556
09/11/2009 18:59:33 Message: General error: Invalid file dsn ''
09/11/2009 18:59:33 ** CFirstSpotSQL::connect: Connecting to Database failed [1]try
09/11/2009 18:59:34 ** CFirstSpotSQL::connect: Connect to data source failed [2]try
09/11/2009 18:59:34 >--- ERROR -- RetCode [-1] Reported------------
09/11/2009 18:59:34 Total Number of diagnostic records: 1
09/11/2009 18:59:34 SQLSTATE: S1000
09/11/2009 18:59:34 Native Error Code: 556
09/11/2009 18:59:34 Message: General error: Invalid file dsn ''
09/11/2009 18:59:34 ** CFirstSpotSQL::connect: Connecting to Database failed [2]try
09/11/2009 18:59:35 ** CFirstSpotSQL::connect: Connect to data source failed [3]try
09/11/2009 18:59:35 >--- ERROR -- RetCode [-1] Reported------------
09/11/2009 18:59:35 Total Number of diagnostic records: 1
09/11/2009 18:59:35 SQLSTATE: S1000
09/11/2009 18:59:35 Native Error Code: 556
09/11/2009 18:59:35 Message: General error: Invalid file dsn ''
09/11/2009 18:59:35 ** CFirstSpotSQL::connect: Connecting to Database failed [3]try
09/11/2009 18:59:35 ** CFirstSpotSQL::connect: <= Return FALSE [4]try
09/11/2009 18:59:35 ** CConnectionAdapter::CConnectionAdapter: [Error] CANNOT CREATE DB CONNECTION
09/11/2009 18:59:35 ** CFirstSpotSQL::connect: Connect to data source failed [0]try

Any help woul be appreciated

[alan]

Your DSN file location needs to match the setting at Configuration Manager -> Authentication Server -> File DSN location.

Either you change your dsn file location, or you change the setting within FirstSpot.
_________________
~ Patronsoft Limited ~

[dohertyit]

Sorry the 2 errors were copied at different times. I have the DSN file in both locations.
However I am still getting the error on the Authentication Server page and the same errors in the firstspot_gw_srv log file

[alan]

So can you post the latest log file?
_________________
~ Patronsoft Limited ~

[dohertyit]

Hi Alan
Here is the entire log file at startup of services:

10/11/2009 10:01:31 ** Starting Print Log **
10/11/2009 10:01:31 ** FirstSpot Version (6.0.4) **
10/11/2009 10:01:31 ** Service: Read Session Log: Session Log[ON]
10/11/2009 10:01:31 ** Service: Read DataBase Info: Datasource[FILEDSN=C:\Program Files\FirstSpot\datasource\FirstspotSQL.dsn;]
10/11/2009 10:01:31 ** Service: Read DataBase Info: Datasource driver[]
10/11/2009 10:01:31 ** Service: Read DataBase Info: Datasource type[0]
10/11/2009 10:01:31 ** Service: Read DataBase Info: Datasource Tablename[fsusr]
10/11/2009 10:01:31 ** Service: Read DataBase Info: Datasource Log Tablename[fsusrlog]
10/11/2009 10:01:31 ** Service: Read DataBase Info: Datasource Shared Secret Tablename[fssecret]
10/11/2009 10:01:31 ** Service: PrivateMAC[000c29feb51e]
10/11/2009 10:01:31 ** Service: Read BlockICMP_UDP: Block ICMP[ON]
10/11/2009 10:01:31 ** Service: Read BlockICMP_UDP: Block UDP[ON]
10/11/2009 10:01:31 ** Service: Read Driver Param: Session Time Limit[0]
10/11/2009 10:01:31 ** Service: Read Driver Param: Idle time out[10]
10/11/2009 10:01:31 ** Service: Read Driver Param: Driver Time Out[1]
10/11/2009 10:01:31 ** Service: Read Driver Param: listen port[5786]
10/11/2009 10:01:31 ** Service: Read Driver Param: Authentication port[5788]
10/11/2009 10:01:31 ** Service: Read Driver Param: Https port[5790]
10/11/2009 10:01:31 ** Service: Read Driver Param: Authentication IP[192.168.148.254]
10/11/2009 10:01:31 ** Service: Read Driver Param: Fail to read private gateway domain name, default [firstspot.org]
10/11/2009 10:01:31 ** Service: Read Driver Param: Logout automatically when Infobox is closed [ON]
10/11/2009 10:01:31 ** Service: Read Driver Param: Infobox port[5795]
10/11/2009 10:01:31 ** Service: Read Driver Param: infobox interval[60]
10/11/2009 10:01:31 ** Service: Read Driver Param: Default Instant Keywords port[5801]
10/11/2009 10:01:31 ** Service: Read Global BandWidth Throttle: Upload Throttle is disabled
10/11/2009 10:01:31 ** Service: Read Global BandWidth Throttle: Download Throttle is disabled
10/11/2009 10:01:31 ** Service: Read PW Offloading [OFF]
10/11/2009 10:01:31 ** Service: Read Session Handling: [MAC]
10/11/2009 10:01:31 ** Service: Read Anonymous Login: Anonymous [NO]
10/11/2009 10:01:31 ** Service: Read Anonymous Login: AnonymousSharedSecret [NO]
10/11/2009 10:01:31 ** Service: Read Lisence Path: licensePath[C:\Program Files\FirstSpot\license.key]
10/11/2009 10:01:31 ** Service: Read IP: gatewayIP[192.168.148.254]
10/11/2009 10:01:31 ** Service: Read IP: subnetMask[255.255.255.0]
10/11/2009 10:01:31 ** Service: Read IP: privateIP[192.168.148.0]
10/11/2009 10:01:31 ** Service: ReadMultipleNetworkSegment: Login Page Count[0]
10/11/2009 10:01:31 ** Service: Read Allow Disconnect: allow private disconnect[NO]
10/11/2009 10:01:31 ** Service: Read Allow Disconnect: allow public disconnect[NO]
10/11/2009 10:01:31 ** Service: Read NIC: system default locale [809], user default locale [809]
10/11/2009 10:01:31 ** Service: Read NIC: Current equipment manufacturer (OEM) code page [850], Current Windows ANSI code page [1252]
10/11/2009 10:01:31 ** Service: Read NIC: publicNIC[FirstSpotPublic]
10/11/2009 10:01:31 ** Service: Read NIC: privateNIC[FirstSpotPrivate]
10/11/2009 10:01:31 ** Service: Read Allowed Hosts: hosts key words file path[C:\Program Files\FirstSpot\AllowedHostsKeywords.txt]
10/11/2009 10:01:31 ** Service: Read Allowed Hosts: hosts ip file path[C:\Program Files\FirstSpot\AllowedHostsIps.txt]
10/11/2009 10:01:31 ** Service: Read Default Login Page: [login_select.php]
10/11/2009 10:01:31 ** Service: Read DHCP: mode[0]
10/11/2009 10:01:31 ** Service: Read DHCP: DHCP Path[C:\Program Files\FirstSpot\dhcp\dhcpservice.ini]
10/11/2009 10:01:31 ** Service: Read Skip Nic D/E[Allow]
10/11/2009 10:01:31 ** Service: Packet Drop Period [20]
10/11/2009 10:01:31 ** Service: SMTP Roaming OFF
10/11/2009 10:01:31 ** Service: Read AuthServ: No MAX Attempt
10/11/2009 10:01:31 ** Service: Read Global Data Transfer Download[Disabled]
10/11/2009 10:01:31 ** Service: Read Global Data Transfer Upload[Disabled]
10/11/2009 10:01:31 ** Service: Read Global Data Transfer Download Quota[0]
10/11/2009 10:01:31 ** Service: Read Global Data Transfer Upload Quota[0]
10/11/2009 10:01:31 ** Service: URL Tracking OFF
10/11/2009 10:01:31 ** Service: NAT[Enabled]
10/11/2009 10:01:31 ** Service: NAT TYPE[0]
10/11/2009 10:01:31 ** Service: Read Proxy ARP Count[0]
10/11/2009 10:01:31 ** Service: FSFO: Failover [0]
10/11/2009 10:01:31 ** Service: Scenario2 Technology [OFF]
10/11/2009 10:01:31 ** Service: Read Max Conc User: Maximum number of concurrent users is unlimited
10/11/2009 10:01:31 ** Service: In-browser: iscript file's path [C:\Program Files\FirstSpot\iscript.txt]
10/11/2009 10:01:31 ** Service: In-browser: Proxy port[5796]
10/11/2009 10:01:31 ** Service: In-browser: Script port[5802]
10/11/2009 10:01:31 ** Service: In-browser: In-browser Message [ON]
10/11/2009 10:01:31 ** Service: In-browser Message time reminder[ON ][5]
10/11/2009 10:01:31 ** Service: Internet Surfing Break [OFF]
10/11/2009 10:01:31 ** Service: Pool: min connection [3], max connection [10]
10/11/2009 10:01:31 ** Service: Read Scratch Login: Scratch [NO]
10/11/2009 10:01:31 ** Service: Read Payment Method: [ppal]
10/11/2009 10:01:31 ** Service: Read Preferred DNS server IP for the Visitor Network [0.0.0.0]
10/11/2009 10:01:31 ** Service: Read Alternate DNS server IP for the Visitor Network [0.0.0.0]
10/11/2009 10:01:31 ** System Info for Verification **
10/11/2009 10:01:31 ** System Info for Verification:Microsoft Windows Server 2003 family
10/11/2009 10:01:31 ** System Info for Verification:Server type
10/11/2009 10:01:31 ** System Info for Verification:Enterprise Edition
10/11/2009 10:01:31 ** System Info for Verification:{Service Pack 1} (Build 3790)
10/11/2009 10:01:31 ** SUCCESS **
10/11/2009 10:01:31 ** Virtual Platform Info for Verification **
10/11/2009 10:01:31 IoctlNdisQueryGlobalStats ->
10/11/2009 10:01:31 <- IoctlNdisQueryGlobalStats
10/11/2009 10:01:31 ** GetMacAddress: (mac 00:0c:29:fe:b5:1e) [permanent]
10/11/2009 10:01:31 ** Virtual Platform Info for Verification: MAC prefix [000c29] lies in VMware's range
10/11/2009 10:01:31 ** Virtual Platform Info for Verification: VMware Server
10/11/2009 10:01:31 ** Virtual Platform Info for Verification: Version 7.7.6 build-203138
10/11/2009 10:01:31 ** Hardware Info for Verification **
10/11/2009 10:01:31 ** Hardware Info for Verification: Number of processors: {1}
10/11/2009 10:01:31 ** Hardware Info for Verification: Page size: {4096}
10/11/2009 10:01:31 ** Hardware Info for Verification: Processor type: {Alpha]
10/11/2009 10:01:31 ** Hardware Info for Verification: wProcessorLevel: {Intel Pentium Pro, II, III or 4}
10/11/2009 10:01:31 ** Hardware Info for Verification: CPU Hz {2133}MHz
10/11/2009 10:01:31 ** Hardware Info for Verification: CPU Name {Intel(R) Xeon(R) CPU E5506 @ 2.13GHz}
10/11/2009 10:01:31 ** Hardware Info for Verification: CPU Model {x86 Family 6 Model 26 Stepping 5}
10/11/2009 10:01:31 ** Memory Status: Total Physical Memory 1535 MBytes
10/11/2009 10:01:31 ** Memory Status: Free Physical Memory 1114 MBytes
10/11/2009 10:01:31 ** Memory Status: Total Page File 3436 MBytes
10/11/2009 10:01:31 ** Memory Status: Available Page File 3137 MBytes
10/11/2009 10:01:31 ** Memory Status: Total Virtual Memory 2047 MBytes
10/11/2009 10:01:31 ** Memory Status: Available Virtual Memory 2000 MBytes
10/11/2009 10:01:31 ** Memory Status: Total Memory Loaded 27 Bytes
10/11/2009 10:01:31 ** Memory Mapping: [C:\Program Files\FirstSpot\log\firstspot_gw_srv_2009.11.10_10.01.31.log]
10/11/2009 10:01:31 ** verifyPublicNicStatus=>
10/11/2009 10:01:31 ** firstspotconOperation2=>
10/11/2009 10:01:31 ** firstspotconOperation2: Connection Name[FirstSpotPublic]
10/11/2009 10:01:31 ** firstspotconOperation2: Hardware Name Obtained[VMware Accelerated AMD PCNet Adapter]
10/11/2009 10:01:31 ** firstspotconOperation2: Hardware ID Obtained[PCI\VEN_1022&DEV_2000&SUBSYS_20001022&REV_10\4&47B7341&0&0088]
10/11/2009 10:01:31 ** firstspotconOperation2{STA_PUBLIC_NIC}: Getting Status
10/11/2009 10:01:31 ** firstspotconOperation2{STA_PUBLIC_NIC}: Internet NIC started
10/11/2009 10:01:31 ** <=firstspotconOperation2
10/11/2009 10:01:31 ** <verifyPublicNicStatus>
10/11/2009 10:01:31 ** probePublicIP: Connection Name[FirstSpotPublic]
10/11/2009 10:01:31 ** probePublicIP: Hardware Guid Obtained[{25188F4A-EE1C-422F-8C0E-B6585937865A}]
10/11/2009 10:01:31 ** <probePublicIP>
10/11/2009 10:01:31 ** validate_SubnetAddr <10>
10/11/2009 10:01:31 ** EnableDisableAssignIPs: Skip Disable Visitor NIC
10/11/2009 10:01:31 ** EnableDisableAssignIPs: Configuring Visitor NIC
10/11/2009 10:01:33 ** EnableDisableAssignIPs: Finished Configuring Visitor NIC
10/11/2009 10:01:33 ** EnableDisableAssignIPs: Skip Enable Visitor NIC
10/11/2009 10:01:33 ** <EnableDisableAssignIPs>
10/11/2009 10:01:33 ** firstspotconOperation2=>
10/11/2009 10:01:33 ** firstspotconOperation2: Connection Name[FirstSpotPrivate]
10/11/2009 10:01:33 ** firstspotconOperation2: Hardware Name Obtained[VMware Accelerated AMD PCNet Adapter]
10/11/2009 10:01:33 ** firstspotconOperation2: Hardware ID Obtained[PCI\VEN_1022&DEV_2000&SUBSYS_20001022&REV_10\4&47B7341&0&0088]
10/11/2009 10:01:33 ** firstspotconOperation2{STA_PRIVATE_NIC}: Getting Status
10/11/2009 10:01:33 ** firstspotconOperation2{STA_PRIVATE_NIC}: Visitor NIC started
10/11/2009 10:01:33 ** <=firstspotconOperation2
10/11/2009 10:01:33 ** <verifyPrivateNicStatus>
10/11/2009 10:01:33 <IoctlNdisQueryGlobalStats>
10/11/2009 10:01:33 <IoctlNdisQueryGlobalStats>
10/11/2009 10:01:33 ** showNICComponent: using IPv4
10/11/2009 10:01:33 ** showNICComponent: [BIND] Internet Protocol (TCP/IP)
10/11/2009 10:01:33 ** showNICComponent: [BIND] PatronSoft FirstHop Driver
10/11/2009 10:01:33 ** showNICComponent: [UNBIND] Network Load Balancing
10/11/2009 10:01:33 ** showNICComponent: [BIND] File and Printer Sharing for Microsoft Networks
10/11/2009 10:01:33 ** showNICComponent: [BIND] Client for Microsoft Networks
10/11/2009 10:01:33 ** <showNICComponent>
10/11/2009 10:01:33 <IoctlNdisQueryGlobalStats>
10/11/2009 10:01:33 ** RestartApacheService: restart gracefully
10/11/2009 10:01:35 ** <RestartApacheService>
10/11/2009 10:01:35 ** StopUnusedServices: SharedAccess
10/11/2009 10:01:35 ** StopUnusedServices: DNS
10/11/2009 10:01:35 ** StopUnusedServices: DHCPServer
10/11/2009 10:01:35 ** <StopUnusedServices>
10/11/2009 10:01:35 ** resetRRAS ->
10/11/2009 10:01:36 ** resetRRAS: remove visitor NIC
10/11/2009 10:01:36 ** resetRRAS: add visitor NIC
10/11/2009 10:01:36 ** <resetRRAS>
10/11/2009 10:01:37 ** restartRRAS: OpenService
10/11/2009 10:01:37 ** restartRRAS: Stopping
10/11/2009 10:01:37 ** restartRRAS: starting
10/11/2009 10:01:37 ** <-restartRRAS
10/11/2009 10:01:37 ** <modifyRRAS>
10/11/2009 10:01:37 Preferred DNS List: 208.67.222.222
10/11/2009 10:01:37 DNS List: 208.67.220.220
10/11/2009 10:01:37 using DNS List
208.67.222.222;
208.67.220.220;
10/11/2009 10:01:37 ** WriteBindCfg: bindpath[C:\Program Files\FirstSpot\dns\etc\]
10/11/2009 10:01:37 ** <modifyDNS>
10/11/2009 10:01:38 <IoctlNdisQueryGlobalStats>
10/11/2009 10:01:39 ** setdispatcher : MAC-base session handling
10/11/2009 10:01:39 ** setdispatcher : SMTP Roaming OFF
10/11/2009 10:01:39 ** setdispatcher : Public Adapter IP[192.168.147.253]
10/11/2009 10:01:39 ** setdispatcher : Private IP(192.168.148.0)
10/11/2009 10:01:39 ** setdispatcher : idle timeout(10)
10/11/2009 10:01:39 ** setdispatcher : driver timeout(1)
10/11/2009 10:01:39 ** setdispatcher : Gateway IP(192.168.148.254)
10/11/2009 10:01:39 ** setdispatcher : Listen Port(5786)
10/11/2009 10:01:39 ** setdispatcher : Auth Port(5788)
10/11/2009 10:01:39 ** setdispatcher : Redirect Port(5790)
10/11/2009 10:01:39 ** setdispatcher : Authenicate IP(192.168.148.254)
10/11/2009 10:01:39 ** setdispatcher : Up Load Limit(-1)
10/11/2009 10:01:39 ** setdispatcher : Down Load Limit(-1)
10/11/2009 10:01:39 ** setdispatcher : Interval(1)
10/11/2009 10:01:39 ** setdispatcher : Drop Period(2)
10/11/2009 10:01:39 ** setdispatcher : PKTInterval(20)
10/11/2009 10:01:39 ** setdispatcher : Restricted Redirect ON
10/11/2009 10:01:39 ** setdispatcher : Logout automatically when Infobox is closed ( ON)
10/11/2009 10:01:39 ** setdispatcher : Internet Surfing Break ( OFF)
10/11/2009 10:01:39 ** <setdispatcher>--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:01:39 Total Number of diagnostic records: 1
10/11/2009 10:01:39 SQLSTATE: S1000
10/11/2009 10:01:39 Native Error Code: 556
10/11/2009 10:01:39 Message: General error: Invalid file dsn ''
10/11/2009 10:01:39 ** CFirstSpotSQL::connect: Connecting to Database failed [0]try
10/11/2009 10:01:40 ** CFirstSpotSQL::connect: Connect to data source failed [1]try
10/11/2009 10:01:40 >--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:01:40 Total Number of diagnostic records: 1
10/11/2009 10:01:40 SQLSTATE: S1000
10/11/2009 10:01:40 Native Error Code: 556
10/11/2009 10:01:40 Message: General error: Invalid file dsn ''
10/11/2009 10:01:40 ** CFirstSpotSQL::connect: Connecting to Database failed [1]try
10/11/2009 10:01:41 ** CFirstSpotSQL::connect: Connect to data source failed [2]try
10/11/2009 10:01:41 >--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:01:41 Total Number of diagnostic records: 1
10/11/2009 10:01:41 SQLSTATE: S1000
10/11/2009 10:01:41 Native Error Code: 556
10/11/2009 10:01:41 Message: General error: Invalid file dsn ''
10/11/2009 10:01:41 ** CFirstSpotSQL::connect: Connecting to Database failed [2]try
10/11/2009 10:01:42 ** CFirstSpotSQL::connect: Connect to data source failed [3]try
10/11/2009 10:01:42 >--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:01:42 Total Number of diagnostic records: 1
10/11/2009 10:01:42 SQLSTATE: S1000
10/11/2009 10:01:42 Native Error Code: 556
10/11/2009 10:01:42 Message: General error: Invalid file dsn ''
10/11/2009 10:01:42 ** CFirstSpotSQL::connect: Connecting to Database failed [3]try
10/11/2009 10:01:42 ** CFirstSpotSQL::connect: <Return>--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:01:42 Total Number of diagnostic records: 1
10/11/2009 10:01:42 SQLSTATE: S1000
10/11/2009 10:01:42 Native Error Code: 556
10/11/2009 10:01:42 Message: General error: Invalid file dsn ''
10/11/2009 10:01:42 ** CFirstSpotSQL::connect: Connecting to Database failed [0]try
10/11/2009 10:01:43 ** CFirstSpotSQL::connect: Connect to data source failed [1]try
10/11/2009 10:01:43 >--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:01:43 Total Number of diagnostic records: 1
10/11/2009 10:01:43 SQLSTATE: S1000
10/11/2009 10:01:43 Native Error Code: 556
10/11/2009 10:01:43 Message: General error: Invalid file dsn ''
10/11/2009 10:01:43 ** CFirstSpotSQL::connect: Connecting to Database failed [1]try
10/11/2009 10:01:44 ** CFirstSpotSQL::connect: Connect to data source failed [2]try
10/11/2009 10:01:44 >--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:01:44 Total Number of diagnostic records: 1
10/11/2009 10:01:44 SQLSTATE: S1000
10/11/2009 10:01:44 Native Error Code: 556
10/11/2009 10:01:44 Message: General error: Invalid file dsn ''
10/11/2009 10:01:44 ** CFirstSpotSQL::connect: Connecting to Database failed [2]try
10/11/2009 10:01:45 ** CFirstSpotSQL::connect: Connect to data source failed [3]try
10/11/2009 10:01:45 >--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:01:45 Total Number of diagnostic records: 1
10/11/2009 10:01:45 SQLSTATE: S1000
10/11/2009 10:01:45 Native Error Code: 556
10/11/2009 10:01:45 Message: General error: Invalid file dsn ''
10/11/2009 10:01:45 ** CFirstSpotSQL::connect: Connecting to Database failed [3]try
10/11/2009 10:01:45 ** CFirstSpotSQL::connect: <Return>--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:01:45 Total Number of diagnostic records: 1
10/11/2009 10:01:45 SQLSTATE: S1000
10/11/2009 10:01:45 Native Error Code: 556
10/11/2009 10:01:45 Message: General error: Invalid file dsn ''
10/11/2009 10:01:45 ** CFirstSpotSQL::connect: Connecting to Database failed [0]try
10/11/2009 10:01:46 ** CFirstSpotSQL::connect: Connect to data source failed [1]try
10/11/2009 10:01:46 >--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:01:46 Total Number of diagnostic records: 1
10/11/2009 10:01:46 SQLSTATE: S1000
10/11/2009 10:01:46 Native Error Code: 556
10/11/2009 10:01:46 Message: General error: Invalid file dsn ''
10/11/2009 10:01:46 ** CFirstSpotSQL::connect: Connecting to Database failed [1]try
10/11/2009 10:01:47 ** CFirstSpotSQL::connect: Connect to data source failed [2]try
10/11/2009 10:01:47 >--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:01:47 Total Number of diagnostic records: 1
10/11/2009 10:01:47 SQLSTATE: S1000
10/11/2009 10:01:47 Native Error Code: 556
10/11/2009 10:01:47 Message: General error: Invalid file dsn ''
10/11/2009 10:01:47 ** CFirstSpotSQL::connect: Connecting to Database failed [2]try
10/11/2009 10:01:48 ** CFirstSpotSQL::connect: Connect to data source failed [3]try
10/11/2009 10:01:48 >--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:01:48 Total Number of diagnostic records: 1
10/11/2009 10:01:48 SQLSTATE: S1000
10/11/2009 10:01:48 Native Error Code: 556
10/11/2009 10:01:48 Message: General error: Invalid file dsn ''
10/11/2009 10:01:48 ** CFirstSpotSQL::connect: Connecting to Database failed [3]try
10/11/2009 10:01:48 ** CFirstSpotSQL::connect: <Return>
10/11/2009 10:01:48 ** <InitialCaptureThread>--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:01:48 Total Number of diagnostic records: 1
10/11/2009 10:01:48 SQLSTATE: S1000
10/11/2009 10:01:48 Native Error Code: 556
10/11/2009 10:01:48 Message: General error: Invalid file dsn ''
10/11/2009 10:01:48 ** CFirstSpotSQL::connect: Connecting to Database failed [0]try
10/11/2009 10:01:48 ** MonitorConnectionNumberThread: =>
10/11/2009 10:01:48 ** CFirstSpotSQL::connect: Connect to data source failed [0]try
10/11/2009 10:01:48 >--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:01:48 Total Number of diagnostic records: 1
10/11/2009 10:01:48 SQLSTATE: S1000
10/11/2009 10:01:48 Native Error Code: 556
10/11/2009 10:01:48 Message: General error: Invalid file dsn ''
10/11/2009 10:01:48 ** CFirstSpotSQL::connect: Connecting to Database failed [0]try
10/11/2009 10:01:48 ** PipeListenThread=>
10/11/2009 10:01:48 ** DeviceNotifyDB=>
10/11/2009 10:01:48 ** DeviceNotifyDBLogin=>
10/11/2009 10:01:48 ** ObtainBWReportThread=>
10/11/2009 10:01:48 ** CFirstSpotSQL::connect: Connect to data source failed [0]try
10/11/2009 10:01:48 >--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:01:48 Total Number of diagnostic records: 1
10/11/2009 10:01:48 SQLSTATE: S1000
10/11/2009 10:01:48 Native Error Code: 556
10/11/2009 10:01:48 Message: General error: Invalid file dsn ''
10/11/2009 10:01:48 ** CFirstSpotSQL::connect: Connecting to Database failed [0]try
10/11/2009 10:01:48 ** CFirstSpotSQL::connect: Connect to data source failed [0]try
10/11/2009 10:01:48 >--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:01:48 Total Number of diagnostic records: 1
10/11/2009 10:01:48 SQLSTATE: S1000
10/11/2009 10:01:48 Native Error Code: 556
10/11/2009 10:01:48 Message: General error: Invalid file dsn ''
10/11/2009 10:01:48 ** CFirstSpotSQL::connect: Connecting to Database failed [0]try
10/11/2009 10:01:48 ** CFirstSpotSQL::connect: Connect to data source failed [0]try
10/11/2009 10:01:48 >--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:01:48 Total Number of diagnostic records: 1
10/11/2009 10:01:48 SQLSTATE: S1000
10/11/2009 10:01:48 Native Error Code: 556
10/11/2009 10:01:48 Message: General error: Invalid file dsn ''
10/11/2009 10:01:48 ** CFirstSpotSQL::connect: Connecting to Database failed [0]try
10/11/2009 10:01:49 ** CFirstSpotSQL::connect: Connect to data source failed [1]try
10/11/2009 10:01:49 >--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:01:49 Total Number of diagnostic records: 1
10/11/2009 10:01:49 SQLSTATE: S1000
10/11/2009 10:01:49 Native Error Code: 556
10/11/2009 10:01:49 Message: General error: Invalid file dsn ''
10/11/2009 10:01:49 ** CFirstSpotSQL::connect: Connecting to Database failed [1]try
10/11/2009 10:01:49 ** CFirstSpotSQL::connect: Connect to data source failed [1]try
10/11/2009 10:01:49 >--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:01:49 Total Number of diagnostic records: 1
10/11/2009 10:01:49 SQLSTATE: S1000
10/11/2009 10:01:49 Native Error Code: 556
10/11/2009 10:01:49 Message: General error: Invalid file dsn ''
10/11/2009 10:01:49 ** CFirstSpotSQL::connect: Connecting to Database failed [1]try
10/11/2009 10:01:49 ** CFirstSpotSQL::connect: Connect to data source failed [1]try
10/11/2009 10:01:49 >--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:01:49 Total Number of diagnostic records: 1
10/11/2009 10:01:49 SQLSTATE: S1000
10/11/2009 10:01:49 Native Error Code: 556
10/11/2009 10:01:49 Message: General error: Invalid file dsn ''
10/11/2009 10:01:49 ** CFirstSpotSQL::connect: Connecting to Database failed [1]try
10/11/2009 10:01:49 ** CFirstSpotSQL::connect: Connect to data source failed [1]try
10/11/2009 10:01:49 >--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:01:49 Total Number of diagnostic records: 1
10/11/2009 10:01:49 SQLSTATE: S1000
10/11/2009 10:01:49 Native Error Code: 556
10/11/2009 10:01:49 Message: General error: Invalid file dsn ''
10/11/2009 10:01:49 ** CFirstSpotSQL::connect: Connecting to Database failed [1]try
10/11/2009 10:01:49 ** CFirstSpotSQL::connect: Connect to data source failed [1]try
10/11/2009 10:01:49 >--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:01:49 Total Number of diagnostic records: 1
10/11/2009 10:01:49 SQLSTATE: S1000
10/11/2009 10:01:49 Native Error Code: 556
10/11/2009 10:01:49 Message: General error: Invalid file dsn ''
10/11/2009 10:01:49 ** CFirstSpotSQL::connect: Connecting to Database failed [1]try
10/11/2009 10:01:50 ** CFirstSpotSQL::connect: Connect to data source failed [2]try
10/11/2009 10:01:50 >--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:01:50 Total Number of diagnostic records: 1
10/11/2009 10:01:50 SQLSTATE: S1000
10/11/2009 10:01:50 Native Error Code: 556
10/11/2009 10:01:50 Message: General error: Invalid file dsn ''
10/11/2009 10:01:50 ** CFirstSpotSQL::connect: Connecting to Database failed [2]try
10/11/2009 10:01:50 ** CFirstSpotSQL::connect: Connect to data source failed [2]try
10/11/2009 10:01:50 >--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:01:50 Total Number of diagnostic records: 1
10/11/2009 10:01:50 SQLSTATE: S1000
10/11/2009 10:01:50 Native Error Code: 556
10/11/2009 10:01:50 Message: General error: Invalid file dsn ''
10/11/2009 10:01:50 ** CFirstSpotSQL::connect: Connecting to Database failed [2]try
10/11/2009 10:01:50 ** CFirstSpotSQL::connect: Connect to data source failed [2]try
10/11/2009 10:01:50 >--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:01:50 Total Number of diagnostic records: 1
10/11/2009 10:01:50 SQLSTATE: S1000
10/11/2009 10:01:50 Native Error Code: 556
10/11/2009 10:01:50 Message: General error: Invalid file dsn ''
10/11/2009 10:01:50 ** CFirstSpotSQL::connect: Connecting to Database failed [2]try
10/11/2009 10:01:50 ** CFirstSpotSQL::connect: Connect to data source failed [2]try
10/11/2009 10:01:50 >--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:01:50 Total Number of diagnostic records: 1
10/11/2009 10:01:50 SQLSTATE: S1000
10/11/2009 10:01:50 Native Error Code: 556
10/11/2009 10:01:50 Message: General error: Invalid file dsn ''
10/11/2009 10:01:50 ** CFirstSpotSQL::connect: Connecting to Database failed [2]try
10/11/2009 10:01:50 ** CFirstSpotSQL::connect: Connect to data source failed [2]try
10/11/2009 10:01:50 >--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:01:50 Total Number of diagnostic records: 1
10/11/2009 10:01:50 SQLSTATE: S1000
10/11/2009 10:01:50 Native Error Code: 556
10/11/2009 10:01:50 Message: General error: Invalid file dsn ''
10/11/2009 10:01:50 ** CFirstSpotSQL::connect: Connecting to Database failed [2]try
10/11/2009 10:01:51 ** CFirstSpotSQL::connect: Connect to data source failed [3]try
10/11/2009 10:01:51 >--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:01:51 Total Number of diagnostic records: 1
10/11/2009 10:01:51 SQLSTATE: S1000
10/11/2009 10:01:51 Native Error Code: 556
10/11/2009 10:01:51 Message: General error: Invalid file dsn ''
10/11/2009 10:01:51 ** CFirstSpotSQL::connect: Connecting to Database failed [3]try
10/11/2009 10:01:51 ** CFirstSpotSQL::connect: <Return>
10/11/2009 10:01:51 ** InitFailOver: IOCTL_INIT_FAILOVER SUCCESS
10/11/2009 10:01:51 ** <InitFailOver>
10/11/2009 10:01:51 ** read_client_pass: file name=C:\Program Files\FirstSpot\config.ini, session=0
10/11/2009 10:01:51 ** <read_client_pass>
10/11/2009 10:01:51 ** <read_port_filter>
10/11/2009 10:01:51 ** <read_acl>
10/11/2009 10:01:51 ** ProcURLTrackingRange: (INFO) Type[1]
10/11/2009 10:01:51 ** <ProcURLTrackingRange>
10/11/2009 10:01:51 ** <read_qos_entry>
10/11/2009 10:01:51 ** init_uatoken: file_path{C:\Program Files\FirstSpot\log\..\uaToken.csv}
10/11/2009 10:01:51 ** init_uatoken: Skip row[1] [; Last update in FirstSpot v6.0.2
]
10/11/2009 10:01:51 ** init_uatoken: Skip row[2] [; Modify Date: 16-07-2009
]
10/11/2009 10:01:51 ** init_uatoken: Skip row[3] [; [1]Token String [2]Token Type
]
10/11/2009 10:01:51 ** init_uatoken: Skip row[4] [; d = desktop | m = mobile device
]
10/11/2009 10:01:51 ** init_uatoken: Skip row[5] [; #START
]
10/11/2009 10:01:51 ** init_uatoken: (First) text [Windows CE]
10/11/2009 10:01:51 ** init_uatoken: (Second) m [windows ce] [m]
10/11/2009 10:01:51 ** init_uatoken: (First) text [Symbian]
10/11/2009 10:01:51 ** init_uatoken: (Second) m [symbian] [m]
10/11/2009 10:01:51 ** init_uatoken: (First) text [Android]
10/11/2009 10:01:51 ** init_uatoken: (Second) m [android] [m]
10/11/2009 10:01:51 ** init_uatoken: (First) text [Palm]
10/11/2009 10:01:51 ** init_uatoken: (Second) m [palm] [m]
10/11/2009 10:01:51 ** CFirstSpotSQL::connect: Connect to data source failed [3]try
10/11/2009 10:01:51 ** CFirstSpotSQL::connect: Connect to data source failed [3]try
10/11/2009 10:01:51 >--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:01:51 >--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:01:51 Total Number of diagnostic records: 1
10/11/2009 10:01:51 Total Number of diagnostic records: 1
10/11/2009 10:01:51 SQLSTATE: S1000
10/11/2009 10:01:51 SQLSTATE: S1000
10/11/2009 10:01:51 Native Error Code: 556
10/11/2009 10:01:51 Native Error Code: 556
10/11/2009 10:01:51 Message: General error: Invalid file dsn ''
10/11/2009 10:01:51 Message: General error: Invalid file dsn ''
10/11/2009 10:01:51 ** CFirstSpotSQL::connect: Connecting to Database failed [3]try
10/11/2009 10:01:51 ** CFirstSpotSQL::connect: Connecting to Database failed [3]try
10/11/2009 10:01:51 ** CFirstSpotSQL::connect: <= Return FALSE [4]try
10/11/2009 10:01:51 ** CFirstSpotSQL::connect: <= Return FALSE [4]try
10/11/2009 10:01:51 ** CConnectionAdapter::CConnectionAdapter: [Error] CANNOT CREATE DB CONNECTION
10/11/2009 10:01:51 ** init_uatoken: (First) text [Mobile]
10/11/2009 10:01:51 ** init_uatoken: (Second) m [mobile] [m]
10/11/2009 10:01:51 ** init_uatoken: (First) text [iPhone]
10/11/2009 10:01:51 ** init_uatoken: (Second) m [iphone] [m]
10/11/2009 10:01:51 ** init_uatoken: (First) text [iPod]
10/11/2009 10:01:51 ** init_uatoken: (Second) m [ipod] [m]
10/11/2009 10:01:51 ** init_uatoken: (First) text [blackberry]
10/11/2009 10:01:51 ** init_uatoken: (Second) m [blackberry] [m]
10/11/2009 10:01:51 ** init_uatoken: (First) text [J2ME]
10/11/2009 10:01:51 ** init_uatoken: (Second) m [j2me] [m]
10/11/2009 10:01:51 ** init_uatoken: (First) text [MIDP]
10/11/2009 10:01:51 ** init_uatoken: (Second) m [midp] [m]
10/11/2009 10:01:51 ** init_uatoken: (First) text [playstation]
10/11/2009 10:01:51 ** init_uatoken: (Second) m [playstation] [m]
10/11/2009 10:01:51 ** init_uatoken: (First) text [Xbox]
10/11/2009 10:01:51 ** init_uatoken: (Second) m [xbox] [m]
10/11/2009 10:01:51 ** init_uatoken: (First) text [wii]
10/11/2009 10:01:51 ** init_uatoken: (Second) m [wii] [m]
10/11/2009 10:01:51 ** init_uatoken: (First) text [nintendo]
10/11/2009 10:01:51 ** init_uatoken: (Second) m [nintendo] [m]
10/11/2009 10:01:51 ** init_uatoken: (First) text [sony]
10/11/2009 10:01:51 ** init_uatoken: (Second) m [sony] [m]
10/11/2009 10:01:51 ** init_uatoken: (First) text [Windows Phone]
10/11/2009 10:01:51 ** init_uatoken: (Second) m [windows phone] [m]
10/11/2009 10:01:51 ** init_uatoken: (First) text [IEMobile]
10/11/2009 10:01:51 ** init_uatoken: (Second) unknown type [ m]
10/11/2009 10:01:51 ** init_uatoken: (First) text [Windows NT]
10/11/2009 10:01:51 ** init_uatoken: (Second) d [windows nt] [d]
10/11/2009 10:01:51 ** init_uatoken: (First) text [Macintosh]
10/11/2009 10:01:51 ** init_uatoken: (Second) d [macintosh] [d]
10/11/2009 10:01:51 ** init_uatoken: Skip row[25] [; #END]
10/11/2009 10:01:51 ** <init_uatoken>--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:01:51 >--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:01:51 Total Number of diagnostic records: 1
10/11/2009 10:01:51 Total Number of diagnostic records: 1
10/11/2009 10:01:51 SQLSTATE: S1000
10/11/2009 10:01:51 SQLSTATE: S1000
10/11/2009 10:01:51 Native Error Code: 556
10/11/2009 10:01:51 Native Error Code: 556
10/11/2009 10:01:51 Message: General error: Invalid file dsn ''
10/11/2009 10:01:51 Message: General error: Invalid file dsn ''
10/11/2009 10:01:51 ** CFirstSpotSQL::connect: Connecting to Database failed [3]try
10/11/2009 10:01:51 ** CFirstSpotSQL::connect: Connecting to Database failed [3]try
10/11/2009 10:01:51 ** CFirstSpotSQL::connect: <= Return FALSE [4]try
10/11/2009 10:01:51 ** CFirstSpotSQL::connect: <Return>--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:01:52 Total Number of diagnostic records: 1
10/11/2009 10:01:52 SQLSTATE: S1000
10/11/2009 10:01:52 Native Error Code: 556
10/11/2009 10:01:52 Message: General error: Invalid file dsn ''
10/11/2009 10:01:52 ** CFirstSpotSQL::connect: Connecting to Database failed [0]try
10/11/2009 10:01:52 ** AddPassiveLoginMAC=>
10/11/2009 10:01:52 ** CConnectionPool::findNewConnection: Finish create RetryThread
10/11/2009 10:01:52 ** CFirstSpotSQL::connect: Connect to data source failed [0]try
10/11/2009 10:01:52 >--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:01:52 Total Number of diagnostic records: 1
10/11/2009 10:01:52 SQLSTATE: S1000
10/11/2009 10:01:52 Native Error Code: 556
10/11/2009 10:01:52 Message: General error: Invalid file dsn ''
10/11/2009 10:01:52 ** CFirstSpotSQL::connect: Connecting to Database failed [0]try
10/11/2009 10:01:52 ** MonitorFSR=>
10/11/2009 10:01:52 ** CFirstSpotSQL::connect: Connect to data source failed [0]try
10/11/2009 10:01:52 >--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:01:52 Total Number of diagnostic records: 1
10/11/2009 10:01:52 SQLSTATE: S1000
10/11/2009 10:01:52 Native Error Code: 556
10/11/2009 10:01:52 Message: General error: Invalid file dsn ''
10/11/2009 10:01:52 ** CFirstSpotSQL::connect: Connecting to Database failed [0]try
10/11/2009 10:01:53 ** CFirstSpotSQL::connect: Connect to data source failed [1]try
10/11/2009 10:01:53 >--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:01:53 Total Number of diagnostic records: 1
10/11/2009 10:01:53 SQLSTATE: S1000
10/11/2009 10:01:53 Native Error Code: 556
10/11/2009 10:01:53 Message: General error: Invalid file dsn ''
10/11/2009 10:01:53 ** CFirstSpotSQL::connect: Connecting to Database failed [1]try
10/11/2009 10:01:53 ** CFirstSpotSQL::connect: Connect to data source failed [1]try
10/11/2009 10:01:53 >--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:01:53 Total Number of diagnostic records: 1
10/11/2009 10:01:53 SQLSTATE: S1000
10/11/2009 10:01:53 Native Error Code: 556
10/11/2009 10:01:53 Message: General error: Invalid file dsn ''
10/11/2009 10:01:53 ** CFirstSpotSQL::connect: Connecting to Database failed [1]try
10/11/2009 10:01:53 ** CFirstSpotSQL::connect: Connect to data source failed [1]try
10/11/2009 10:01:53 >--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:01:53 Total Number of diagnostic records: 1
10/11/2009 10:01:53 SQLSTATE: S1000
10/11/2009 10:01:53 Native Error Code: 556
10/11/2009 10:01:53 Message: General error: Invalid file dsn ''
10/11/2009 10:01:53 ** CFirstSpotSQL::connect: Connecting to Database failed [1]try
10/11/2009 10:01:54 ** CFirstSpotSQL::connect: Connect to data source failed [2]try
10/11/2009 10:01:54 >--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:01:54 Total Number of diagnostic records: 1
10/11/2009 10:01:54 SQLSTATE: S1000
10/11/2009 10:01:54 Native Error Code: 556
10/11/2009 10:01:54 Message: General error: Invalid file dsn ''
10/11/2009 10:01:54 ** CFirstSpotSQL::connect: Connecting to Database failed [2]try
10/11/2009 10:01:54 ** CFirstSpotSQL::connect: Connect to data source failed [2]try
10/11/2009 10:01:54 >--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:01:54 Total Number of diagnostic records: 1
10/11/2009 10:01:54 SQLSTATE: S1000
10/11/2009 10:01:54 Native Error Code: 556
10/11/2009 10:01:54 Message: General error: Invalid file dsn ''
10/11/2009 10:01:54 ** CFirstSpotSQL::connect: Connecting to Database failed [2]try
10/11/2009 10:01:54 ** CFirstSpotSQL::connect: Connect to data source failed [2]try
10/11/2009 10:01:54 >--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:01:54 Total Number of diagnostic records: 1
10/11/2009 10:01:54 SQLSTATE: S1000
10/11/2009 10:01:54 Native Error Code: 556
10/11/2009 10:01:54 Message: General error: Invalid file dsn ''
10/11/2009 10:01:54 ** CFirstSpotSQL::connect: Connecting to Database failed [2]try
10/11/2009 10:01:55 ** CFirstSpotSQL::connect: Connect to data source failed [3]try
10/11/2009 10:01:55 >--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:01:55 Total Number of diagnostic records: 1
10/11/2009 10:01:55 SQLSTATE: S1000
10/11/2009 10:01:55 Native Error Code: 556
10/11/2009 10:01:55 Message: General error: Invalid file dsn ''
10/11/2009 10:01:55 ** CFirstSpotSQL::connect: Connecting to Database failed [3]try
10/11/2009 10:01:55 ** CFirstSpotSQL::connect: <Return>--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:01:55 ** CFirstSpotSQL::connect: Connect to data source failed [3]try
10/11/2009 10:01:55 >--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:01:55 Total Number of diagnostic records: 1
10/11/2009 10:01:55 SQLSTATE: S1000
10/11/2009 10:01:55 Native Error Code: 556
10/11/2009 10:01:55 Message: General error: Invalid file dsn ''
10/11/2009 10:01:55 ** CFirstSpotSQL::connect: Connecting to Database failed [3]try
10/11/2009 10:01:55 ** CFirstSpotSQL::connect: <= Return FALSE [4]try
10/11/2009 10:01:55 Total Number of diagnostic records: 1
10/11/2009 10:01:55 SQLSTATE: S1000
10/11/2009 10:01:55 Native Error Code: 556
10/11/2009 10:01:55 Message: General error: Invalid file dsn ''
10/11/2009 10:01:55 ** CFirstSpotSQL::connect: Connecting to Database failed [3]try
10/11/2009 10:01:55 ** CFirstSpotSQL::connect: <= Return FALSE [4]try
10/11/2009 10:01:55 ** CConnectionAdapter::CConnectionAdapter: [Error] CANNOT CREATE DB CONNECTION
10/11/2009 10:01:55 ** CConnectionAdapter::getConnection: return invalid SQL (not connect)
10/11/2009 10:01:55 ** QueryPassiveLoginInfo: SQL1 Connect Fail
10/11/2009 10:01:55 ** AddPassiveLoginMAC: IOCTL_CMD_PL_MAC_RESET SUCCESS
10/11/2009 10:01:55 ** <=AddPassiveLoginMAC
10/11/2009 10:01:55 ** StartServiceThread: Trial Edition
10/11/2009 10:01:55 <batch_fP_RetValue>
10/11/2009 10:01:56 ** CFirstSpotSQL::connect: Connect to data source failed [0]try
10/11/2009 10:01:56 >--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:01:56 Total Number of diagnostic records: 1
10/11/2009 10:01:56 SQLSTATE: S1000
10/11/2009 10:01:56 Native Error Code: 556
10/11/2009 10:01:56 Message: General error: Invalid file dsn ''
10/11/2009 10:01:56 ** CFirstSpotSQL::connect: Connecting to Database failed [0]try
10/11/2009 10:01:57 ** CFirstSpotSQL::connect: Connect to data source failed [1]try
10/11/2009 10:01:57 >--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:01:57 Total Number of diagnostic records: 1
10/11/2009 10:01:57 SQLSTATE: S1000
10/11/2009 10:01:57 Native Error Code: 556
10/11/2009 10:01:57 Message: General error: Invalid file dsn ''
10/11/2009 10:01:57 ** CFirstSpotSQL::connect: Connecting to Database failed [1]try
10/11/2009 10:01:58 ** CFirstSpotSQL::connect: Connect to data source failed [2]try
10/11/2009 10:01:58 >--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:01:58 Total Number of diagnostic records: 1
10/11/2009 10:01:58 SQLSTATE: S1000
10/11/2009 10:01:58 Native Error Code: 556
10/11/2009 10:01:58 Message: General error: Invalid file dsn ''
10/11/2009 10:01:58 ** CFirstSpotSQL::connect: Connecting to Database failed [2]try
10/11/2009 10:01:59 ** CFirstSpotSQL::connect: Connect to data source failed [3]try
10/11/2009 10:01:59 >--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:01:59 Total Number of diagnostic records: 1
10/11/2009 10:01:59 SQLSTATE: S1000
10/11/2009 10:01:59 Native Error Code: 556
10/11/2009 10:01:59 Message: General error: Invalid file dsn ''
10/11/2009 10:01:59 ** CFirstSpotSQL::connect: Connecting to Database failed [3]try
10/11/2009 10:01:59 ** CFirstSpotSQL::connect: <Return>--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:02:00 Total Number of diagnostic records: 1
10/11/2009 10:02:00 SQLSTATE: S1000
10/11/2009 10:02:00 Native Error Code: 556
10/11/2009 10:02:00 Message: General error: Invalid file dsn ''
10/11/2009 10:02:00 ** CFirstSpotSQL::connect: Connecting to Database failed [0]try
10/11/2009 10:02:01 ** CFirstSpotSQL::connect: Connect to data source failed [1]try
10/11/2009 10:02:01 >--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:02:01 Total Number of diagnostic records: 1
10/11/2009 10:02:01 SQLSTATE: S1000
10/11/2009 10:02:01 Native Error Code: 556
10/11/2009 10:02:01 Message: General error: Invalid file dsn ''
10/11/2009 10:02:01 ** CFirstSpotSQL::connect: Connecting to Database failed [1]try
10/11/2009 10:02:02 ** CFirstSpotSQL::connect: Connect to data source failed [2]try
10/11/2009 10:02:02 >--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:02:02 Total Number of diagnostic records: 1
10/11/2009 10:02:02 SQLSTATE: S1000
10/11/2009 10:02:02 Native Error Code: 556
10/11/2009 10:02:02 Message: General error: Invalid file dsn ''
10/11/2009 10:02:02 ** CFirstSpotSQL::connect: Connecting to Database failed [2]try
10/11/2009 10:02:03 ** CFirstSpotSQL::connect: Connect to data source failed [3]try
10/11/2009 10:02:03 >--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:02:03 Total Number of diagnostic records: 1
10/11/2009 10:02:03 SQLSTATE: S1000
10/11/2009 10:02:03 Native Error Code: 556
10/11/2009 10:02:03 Message: General error: Invalid file dsn ''
10/11/2009 10:02:03 ** CFirstSpotSQL::connect: Connecting to Database failed [3]try
10/11/2009 10:02:03 ** CFirstSpotSQL::connect: <Return>--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:02:04 Total Number of diagnostic records: 1
10/11/2009 10:02:04 SQLSTATE: S1000
10/11/2009 10:02:04 Native Error Code: 556
10/11/2009 10:02:04 Message: General error: Invalid file dsn ''
10/11/2009 10:02:04 ** CFirstSpotSQL::connect: Connecting to Database failed [0]try
10/11/2009 10:02:05 ** CFirstSpotSQL::connect: Connect to data source failed [1]try
10/11/2009 10:02:05 >--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:02:05 Total Number of diagnostic records: 1
10/11/2009 10:02:05 SQLSTATE: S1000
10/11/2009 10:02:05 Native Error Code: 556
10/11/2009 10:02:05 Message: General error: Invalid file dsn ''
10/11/2009 10:02:05 ** CFirstSpotSQL::connect: Connecting to Database failed [1]try
10/11/2009 10:02:06 ** CFirstSpotSQL::connect: Connect to data source failed [2]try
10/11/2009 10:02:06 >--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:02:06 Total Number of diagnostic records: 1
10/11/2009 10:02:06 SQLSTATE: S1000
10/11/2009 10:02:06 Native Error Code: 556
10/11/2009 10:02:06 Message: General error: Invalid file dsn ''
10/11/2009 10:02:06 ** CFirstSpotSQL::connect: Connecting to Database failed [2]try
10/11/2009 10:02:07 ** CFirstSpotSQL::connect: Connect to data source failed [3]try
10/11/2009 10:02:07 >--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:02:07 Total Number of diagnostic records: 1
10/11/2009 10:02:07 SQLSTATE: S1000
10/11/2009 10:02:07 Native Error Code: 556
10/11/2009 10:02:07 Message: General error: Invalid file dsn ''
10/11/2009 10:02:07 ** CFirstSpotSQL::connect: Connecting to Database failed [3]try
10/11/2009 10:02:07 ** CFirstSpotSQL::connect: <Return>--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:02:08 Total Number of diagnostic records: 1
10/11/2009 10:02:08 SQLSTATE: S1000
10/11/2009 10:02:08 Native Error Code: 556
10/11/2009 10:02:08 Message: General error: Invalid file dsn ''
10/11/2009 10:02:08 ** CFirstSpotSQL::connect: Connecting to Database failed [0]try
10/11/2009 10:02:09 ** CFirstSpotSQL::connect: Connect to data source failed [1]try
10/11/2009 10:02:09 >--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:02:09 Total Number of diagnostic records: 1
10/11/2009 10:02:09 SQLSTATE: S1000
10/11/2009 10:02:09 Native Error Code: 556
10/11/2009 10:02:09 Message: General error: Invalid file dsn ''
10/11/2009 10:02:09 ** CFirstSpotSQL::connect: Connecting to Database failed [1]try
10/11/2009 10:02:10 ** CFirstSpotSQL::connect: Connect to data source failed [2]try
10/11/2009 10:02:10 >--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:02:10 Total Number of diagnostic records: 1
10/11/2009 10:02:10 SQLSTATE: S1000
10/11/2009 10:02:10 Native Error Code: 556
10/11/2009 10:02:10 Message: General error: Invalid file dsn ''
10/11/2009 10:02:10 ** CFirstSpotSQL::connect: Connecting to Database failed [2]try
10/11/2009 10:02:11 ** CFirstSpotSQL::connect: Connect to data source failed [3]try
10/11/2009 10:02:11 >--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:02:11 Total Number of diagnostic records: 1
10/11/2009 10:02:11 SQLSTATE: S1000
10/11/2009 10:02:11 Native Error Code: 556
10/11/2009 10:02:11 Message: General error: Invalid file dsn ''
10/11/2009 10:02:11 ** CFirstSpotSQL::connect: Connecting to Database failed [3]try
10/11/2009 10:02:11 ** CFirstSpotSQL::connect: <Return>--- ERROR -- RetCode [-1] Reported------------
10/11/2009 10:02:12 Total Number of diagnostic records: 1
10/11/2009 10:02:12 SQLSTATE: S1000
10/11/2009 10:02:12 Native Error Code: 556
10/11/2009 10:02:12 Message: General error: Invalid file dsn ''
10/11/2009 10:02:12 ** CFirstSpotSQL::connect: Connecting to Database failed [0]try

Hope this helps

[alan]

Same error really. Please make sure your dsn file is in location:

C:\Program Files\FirstSpot\datasource\FirstspotSQL.dsn
_________________
~ Patronsoft Limited ~

[dohertyit]

Hi Alan

As I said earlier the DSN is in the correct location
C:\Program Files\FirstSpot\datasource

I will reply to the forum email address with an attachment showing that the file is in the above path[/img]

[alan]

Received your attachment.

Looks like there is a spelling error in your dsn file name. You put in FirstpotSQL.dsn, and it should be FirstspotSQL.dsn instead.
_________________
~ Patronsoft Limited ~

[dohertyit]

Many thanks, that fixed it.
I must have looked at that file 50 times and not spotted the spelling mistake