SearchSearch   ProfileProfile   Log inLog in   RegisterRegister 

Problems MSSQL common_functions.php

 
Post new topic   Reply to topic    FirstSpot Forum Index -> Pre-sales Support Forum
View previous topic :: View next topic  
Author Message
dohertyit



Joined: 09 Nov 2009
Posts: 5
Location: London

PostPosted: Mon Nov 09, 2009 7:02 pm    
Post subject: Problems MSSQL common_functions.php

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
Back to top
alan
Forum facilitator


Joined: 26 Sep 2003
Posts: 4435

PostPosted: Tue Nov 10, 2009 8:58 am    
Post subject:

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 ~
Back to top
dohertyit



Joined: 09 Nov 2009
Posts: 5
Location: London

PostPosted: Tue Nov 10, 2009 9:51 am    
Post subject:

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
Back to top
alan
Forum facilitator


Joined: 26 Sep 2003
Posts: 4435

PostPosted: Tue Nov 10, 2009 9:55 am    
Post subject:

So can you post the latest log file?
_________________
~ Patronsoft Limited ~
Back to top
dohertyit



Joined: 09 Nov 2009
Posts: 5
Location: London

PostPosted: Tue Nov 10, 2009 10:03 am    
Post subject:

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
Back to top
alan
Forum facilitator


Joined: 26 Sep 2003
Posts: 4435

PostPosted: Tue Nov 10, 2009 10:53 am    
Post subject:

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

C:\Program Files\FirstSpot\datasource\FirstspotSQL.dsn
_________________
~ Patronsoft Limited ~
Back to top
dohertyit



Joined: 09 Nov 2009
Posts: 5
Location: London

PostPosted: Tue Nov 10, 2009 12:07 pm    
Post subject:

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]
Back to top
alan
Forum facilitator


Joined: 26 Sep 2003
Posts: 4435

PostPosted: Tue Nov 10, 2009 1:40 pm    
Post subject:

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 ~
Back to top
dohertyit



Joined: 09 Nov 2009
Posts: 5
Location: London

PostPosted: Tue Nov 10, 2009 1:50 pm    
Post subject:

Many thanks, that fixed it. Very Happy
I must have looked at that file 50 times and not spotted the spelling mistake Rolling Eyes
Back to top
Display posts from previous:   
Post new topic   Reply to topic    FirstSpot Forum Index -> Pre-sales Support Forum All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group