collegamento a database

[teo3]

ciao, qualcuno saprebbe darmi indicazioni su cosa significa questa frase che mi appare quando tento di collegarmi alla prima pagina .asp che ho inserito nel mio sito?

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/magicmusic/inserisci.asp, line 90

per quanto riguarda i vari settaggi della connessione al database credo che siano giuste, se mi arriva anche solo un suggerimento posso capire come cercare di risolvere il mio problema. grazie a tutti qualli che mi risponderanno

[Supergeniux]

potresti postare il codice?

ciao

ps
lo spazio dove tieni ti e' fornito da un servizio gratuito o e' un hosting a pagamento?

[teo3]

lo spazio fornitomi è di un hosting a pagamento.
il codice a chi dovrei spedirlo? a te personalmente a o al forum?
a proposito, grazie per l'interessamento.

[Supergeniux]

posta sul forum!

ciao

[teo3]

pronti!!

<%@LANGUAGE="JAVASCRIPT"%>
<!--#include file="../Connections/conncatalogo.asp" -->
<%
// *** Edit Operations: declare variables

// set the form action variable
var MM_editAction = Request.ServerVariables("URL");
if (Request.QueryString) {
MM_editAction += "?" + Request.QueryString;
}

// boolean to abort record edit
var MM_abortEdit = false;

// query string to execute
var MM_editQuery = "";
%>
<%
// *** Insert Record: set variables

if (String(Request("MM_insert")) != "undefined") {

var MM_editConnection = MM_conncatalogo_STRING;
var MM_editTable = "Foglio1";
var MM_editRedirectUrl = "";
var MM_fieldsStr = "titolo|value|registaattori_principali|value|attori _secondari_1|value|supporto|value|codice|value|gen ere|value|durata|value|fotobig|value|fotosmall|val ue|trama|value";
var MM_columnsStr = "titolo|',none,''|[regista-attori principali]|',none,''|[attori secondari 1]|',none,''|supporto|',none,''|codice|',none,''|gen ere|',none,''|durata|',none,NULL|fotobig|',none,'' |fotosmall|',none,''|trama|',none,''";

// create the MM_fields and MM_columns arrays
var MM_fields = MM_fieldsStr.split("|");
var MM_columns = MM_columnsStr.split("|");

// set the form values
for (var i=0; i+1 < MM_fields.length; i+=2) {
MM_fields[i+1] = String(Request.Form(MM_fields[i]));
}

// append the query string to the redirect URL
if (MM_editRedirectUrl && Request.QueryString && Request.QueryString.length > 0) {
MM_editRedirectUrl += ((MM_editRedirectUrl.indexOf('?') == -1)?"?":"&") + Request.QueryString;
}
}
%>
<%
// *** Insert Record: construct a sql insert statement and execute it

if (String(Request("MM_insert")) != "undefined") {

// create the sql insert statement
var MM_tableValues = "", MM_dbValues = "";
for (var i=0; i+1 < MM_fields.length; i+=2) {
var formVal = MM_fields[i+1];
var MM_typesArray = MM_columns[i+1].split(",");
var delim = (MM_typesArray[0] != "none") ? MM_typesArray[0] : "";
var altVal = (MM_typesArray[1] != "none") ? MM_typesArray[1] : "";
var emptyVal = (MM_typesArray[2] != "none") ? MM_typesArray[2] : "";
if (formVal == "" || formVal == "undefined") {
formVal = emptyVal;
} else {
if (altVal != "") {
formVal = altVal;
} else if (delim == "'") { // escape quotes
formVal = "'" + formVal.replace(/'/g,"''") + "'";
} else {
formVal = delim + formVal + delim;
}
}
MM_tableValues += ((i != 0) ? "," : "") + MM_columns[i];
MM_dbValues += ((i != 0) ? "," : "") + formVal;
}
MM_editQuery = "insert into " + MM_editTable + " (" + MM_tableValues + ") values (" + MM_dbValues + ")";

if (!MM_abortEdit) {
// execute the insert
var MM_editCmd = Server.CreateObject('ADODB.Command');
MM_editCmd.ActiveConnection = MM_editConnection;
MM_editCmd.CommandText = MM_editQuery;
MM_editCmd.Execute();
MM_editCmd.ActiveConnection.Close();

if (MM_editRedirectUrl) {
Response.Redirect(MM_editRedirectUrl);
}
}

}
%>
<%
var rsGeneri = Server.CreateObject("ADODB.Recordset");
rsGeneri.ActiveConnection = MM_conncatalogo_STRING;
rsGeneri.Source = "SELECT * FROM Foglio1";
rsGeneri.CursorType = 0;
rsGeneri.CursorLocation = 2;
rsGeneri.LockType = 3;
rsGeneri.Open();
var rsGeneri_numRows = 0;
%>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<form method="post" action="<%=MM_editAction%>" name="form1">
<table align="center">
<tr valign="baseline">
<td nowrap align="right">Titolo:</td>
<td>
<input type="text" name="titolo" value="" size="32">
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Regista</td>
<td>
<input type="text" name="registaattori_principali" value="" size="32">
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Attori principali:</td>
<td>
<input type="text" name="attori_secondari_1" value="" size="32">
</td>
</tr>
<tr>
<td nowrap align="right" valign="top">Supporto:</td>
<td valign="baseline">
<table align="left">
<tr>
<td>
<input type="radio" value="vhs" name="supporto" >
vhs
<td>
</tr>
<tr>
<td>
<input type="radio" value="dvd" name="supporto" >
dvd
<td>
</tr>
</table>
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Codice:</td>
<td>
<input type="text" name="codice" value="" size="32">
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Genere:</td>
<td>
<select name="genere">
<%
while (!rsGeneri.EOF)
{
%>
<option value="<%=(rsGeneri.Fields.Item("genere").Value)%>" ><%=(rsGeneri.Fields.Item("genere").Value)%></option>
<%
rsGeneri.MoveNext();
}
if (rsGeneri.CursorType > 0) {
if (!rsGeneri.BOF) rsGeneri.MoveFirst();
} else {
rsGeneri.Requery();
}
%>
</select>
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Durata:</td>
<td>
<input type="text" name="durata" value="" size="32">
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Fotobig:</td>
<td>
<input type="text" name="fotobig" value="" size="32">
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Fotosmall:</td>
<td>
<input type="text" name="fotosmall" value="" size="32">
</td>
</tr>
<tr>
<td nowrap align="right" valign="top">Trama:</td>
<td valign="baseline">
<textarea name="trama" cols="50" rows="5"></textarea>
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right"> </td>
<td>
<input type="submit" value="Insert Record">
</td>
</tr>
</table>
<input type="hidden" name="MM_insert" value="true">
</form>
<p> </p>
</body>
</html>
<%
rsGeneri.Close();
%>

[Supergeniux]

a me serve il codice di questa pagina:
<!--#include file="../Connections/conncatalogo.asp" -->


ciao

[teo3]

pardon...

<%
// FileName="Connection_odbc_conn_dsn.htm"
// Type="ADO"
// HTTP="false"
// Catalog=""
// Schema=""
var MM_conncatalogo_STRING = "dsn=catalogo;"
%>

[Supergeniux]

dammi la riga 90 adesso :)

ciao

[teo3]

di che cosa scusa?