I have to login TWICE to get to the Internet

timwil · Joined: 12 Aug 2005 Posts: 13

Internet Explorer 6 with SP2.

I believe the problem is related to the SQL Server - when it was running on the .dbf file it was okay. I am using two machines right now - one as the SQL server the other as the Gateway Access Server. I am going to try both on the same machine to see if that makes a difference.

timwil · Joined: 12 Aug 2005 Posts: 13

I have loaded FirstSpot onto the SQL Server machine and that has eliminated the internet access drop outs that were occurring however it is still giving the same problem with loggin in - I have to do it twice

jason · Posted: Mon Sep 05, 2005 2:48 am **Post subject:**

You might not have your database setup correctly. Make sure the user account have enough permission to excute sql statments.

I suggest you test your database without installing Firstspot , you may want to use the same dsn file to do so.
_________________
~ Patronsoft Limited ~

timwil · Joined: 12 Aug 2005 Posts: 13

the user account is setup as the owner of the database

jason · Posted: Mon Sep 05, 2005 3:47 am **Post subject:**

Could you please post your config.ini and the .dsn file again?

By the way, is there any table called "fsinst" in your sql server database.
_________________
~ Patronsoft Limited ~

hans · **Forum facilitator** Joined: 14 May 2004 Posts: 63

I've analysed your new log.

You need to add fsinst table to your MS SQL

create table fsinst
(
ipormac varchar(40),
firstspotm varchar(40)
);
_________________
~ Patronsoft Limited ~

timwil · Joined: 12 Aug 2005 Posts: 13

I have the fsinst table but the second field name is firstspot not firstspotm

I have made the table change I will now try it again