RE: [cobalt-users] livesupport ASP scripts bombs - need help

["Ligard, Vidar" <vligard@xxxxxxxxx>]

> Subject: [cobalt-users] livesupport ASP scripts bombs - need help
> 
> 
> 
> ADODB.Connection.1 error '80004005'
> 
> SQLState: IM002
> Native Error Code: 0
> [INTERSOLV][ODBC lib] Data source name not found and no 
> default driver specified
> 
> 
> /checkChat.asp, line 41
> 
> HERE IS THE SCRIPT...... ANY IDEAS?
> 
> <%
> 'Include this file on every page on your website, EXCEPT the 
> livesupport pages 'Checks to see if the user is wanted in a 
> chat room by the admin and updates active users table 'You 
> will need to change DB path and name
> 
> 'Set the script timeout in seconds
> Server.ScriptTimeout = 90
> 
> 'Set Dimension Variables
> Dim strDataBasePath      'Holds the path to the database
> Dim cString                 'Holds the entire connection string
> Dim adoCon                'Holds the ado connection
> Dim SQL                    'Holds SQL statement
> Dim strIPAddress           'Holds the current users IP address
> Dim rs_Active_Users       'Record sheet for the active users table
> Dim chatwanted            'Holds 0 if admin doesnt to chat 
> with them, 5 if
> the admin does
> Dim usrID                   'Holds user ID
> 
> Set adoCon = Server.CreateObject("ADODB.Connection")
> 
> '-------------------------------------------------------------
> --------------
> ---------
> 'Change this value to the path of the database
> strDataBasePath = "LiveSupport.mdb"

There is no ODBC driver for an access database on linux.
You need to export your data to DBASE, MySQL or something you have a driver for on the cobalt.
This script is written for MS ASP on Windows. It should still work on Linux, but you must export your data to another format. I've seen an Access Linux Driver project out there, but I don't think it is finished yet (Read only)
Vidar
> '-------------------------------------------------------------
> --------------
> ---------
> 
> 'Connection string for the database
> 'If the following line does not work comment it out with a ' 
> at the start of the line and uncomment another string 
> cString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
> Server.MapPath(strDataBasePath)
> 
> 'Uncomment this connection string if you are using Access 
> Database 2000 or 2002 'cString = 
> "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" &
> Server.MapPath(strDataBasePath)
>