
25/05/2003, 16:26
|
| | Fecha de Ingreso: mayo-2003
Mensajes: 8
Antigüedad: 22 años Puntos: 0 | |
esto es el enlace de mi base de datos SIENTO LAS MOLESTIAS:
'-----------------------------------------------
'DATABASE CONNECTION SETTINGS
'-----------------------------------------------
'Database type - access, sql or mysql
'DBType = "mysql"
'DBType = "sql"
'DBType = "access"
'MS Access OLEDB Connection String
pathtodatabase = "manugut.mdb"
databasepassword = "manugut"
datasourcename = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&server.mappath(pathtodatabase)&";Jet OLEDB:Database Password=" & databasepassword
'MS SQLServer Connection String (for connecting on port 1433 - the standard port for SQL Server)
'datasourcename="Provider=sqloledb;Data Source=yourhost.com,1433;Network Library=DBMSSOCN;Initial Catalog=yourdatabase;User ID=yourID;Password=Yourpassword;"
'datasourcename="Provider=sqloledb;Data Source=cactusserver1,1433;Network Library=DBMSSOCN;Initial Catalog=cactushop45SQL;Trusted_Connection=yes;"
'MySQL ODBC Connection String
'datasourcename = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=yourserver;DATABASE=cactushop46;USE R=username;PASSWORD=password;OPTION=3;"
'datasourcename = "DRIVER={MySQL};SERVER=cactushost6;DATABASE=cactus hop46;USER=username;PASSWORD=password;OPTION=3;"
'Cursor type for executing queries - change to 1 for SQL Server if the site misbehaves after upsizing
cursortype = 3
'-----------------------------------------------
'DATABASE CONNECTION SETTINGS
'-----------------------------------------------
Set DataConn = Server.CreateObject("ADODB.Connection")
DataConn.Open datasourcename=AQUI ES DONDE NO SE QUE ES LO QUE HE DE PONER Set cmdTemp = Server.CreateObject("ADODB.Command")
Set rs_main = Server.CreateObject("ADODB.Recordset")
Set rs_main2 = Server.CreateObject("ADODB.Recordset") |