I am designing a site for a friend using dreamweaver and unfortunately my link has gone down to my test server. I use dreamweaver to generate most of my asp but since I can;t do this with a broken connection I wondered if anyone would be kind enough to help me with a very simple bit of code.
I simply need an asp page. That reads the first record in a db (db.mdb).
the record has two fields ID (whish is 1) and news (a memo field).
This memo field then needs can then be updated via a simple html form.
Essentially its just a page that allows the user to update the memo field in the first record of the database.
i have a search engine which contains all of the links in an access db.
basically what i am wanting to know is:
is there some code i can make to query all the results for a matching word such as "elephant" all the results (url) in the database would be opened and checked, Any broken links would be removed.
does any one know how to do this. what i was thinking of doing was creating some code to open all the pages that match a search....say 50 open
i could then click through them closing them individually to check all urls rather than doing it manually
We created an asp.net 2.0 app, which sends smtp email using System.Web.mail. The app is in an IIS 6 application pool isolated to 2.0 apps on a 2003 server.
The app worked fine for a few days; recently however it began failing when sending to external addresses (it works fine if the recipient is inside our internal domain).
Comparing the logfiles, I notice when it was working both versions of the CLR appear in log entries, for example:
Using Dreamweaver MX 2004 and HTML pages graphics show fine. Just trying some ASP pages (a template) and graphics always show as the broken link red square.
Pages are inserted relative to document ../ and the properties of the broken link gives:
What do you call it when search results are broken up into page numbers across the bottom? I want to try that instead of getting a long list of results. I was going to search but none of the terms I tried returned anything.
Not sure if this can be done with ASP but I would like to find a way to detect if an image is missing and replace it with a default image instead of the dreaded RED X showing up.
on our Windows 2000 server (SP4) all ASP pages which utilise Javascript have stopped working with the following error
Active Server Pages error 'ASP 0129' Unknown scripting language /whateverfile.asp, line 2 The scripting language 'JavaScript' is not found on the server.
i have my sql server 2000 installed properly on the server. everything goes fine yersterday..i can create new database, tables and so on. but i couldn't connect to it since this morning. it keep on prompting the msg" cannot connect to the sql server because of incorrect logon " <something like this> in fact, i never set any passwod in order to connect to the sql server.
I have a site on 1and1. The site has a simple login as well as other asp applications. This site uses an access DB. Last week all the scripts that accessed any database resulted in this error: Code:
I recently moved to Visual Web Developer Express. I need to create a simple page that connects to my Database.mdf and runs a stored procedure. I have tried a million times but i simply cannot create a connection. I need to create an ADODB connection as i need control over the CONNECTION TIMEOUT and the COMMANDTIMEOUT properties.
I'm using the following string: Data Source=.SQLEXPRESS;AttachDbFileName=e:dataCusto mers.mdf;Integrated Security=True;User Instance=True
I have problem on data connection to a SQL Server by Asp Statement. It's Very strange that my asp statement can connect to one remote SQL server but can't connect to other remote SQL server. The statement written like this :
Set DBLBX=Server.CreateObject("ADODB.Connection") DBLBX.Open "DSN=DBWEB;UID=opn;PWD=opn;"
It show the follows:
Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
I would like to connect to another server and execute my query from my asp page. But how can I initiate the connection string to another server DB? For example Code:
ConnString = "dsn=abc;uid=xyz;pwd=123"
What will be the way to issue the connection string to another server? Using SQL Server 2000.
I ALWAYS forget this cause we ALWAYS turn our db connections into COM components. That said... I need one for this project . Here's my base Access one:
DBPath ="C:datastoresmediacd.mdb" Set Con = Server.CreateObject( "ADODB.Connection" ) Con.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & DBPath
I just don't quite remember the SQL Server variation.
My ASP page needs to connect to the SQL using Windows Authentication.
I have research this topic and I think the pieces of the puzzle are here, but they are not coming together correctly.
Users are separated into groups with different levels of security, Group 1, Group 2, Group 3. Each group can only view, update or delete specific pages. Code:
I have a site with the directory structure like this:
wwwroot (where the default.asp and other pages sit)inc (where the includes are)login (where login pages are)otherDirs (where other pages are)datafiles (where database is)
I usually hard code the db connection path but want to use the MapPath now in case in the future my site moves servers (have been though that and having to manually change all db connection strings - Not Fun ) Code:
Wondered if anyone could help me out with some simple connection string problems I'm having.
Ive got this on the page so far and it works: ---------------------------------------------- Dim strConnString set strConnString = server.createobject("adodb.connection") strConnString.ConnectionString="DRIVER={Microsoft Access Driver (*.mdb)};" & "DBQ=c:Inetpubwwwrootdlnforumforumadminwwforum.mdb" strConnString.open ----------------------------------------------- But I want to change it to a Server.MapPath method, so I tried the following: ------------------------------------------------ Dim strConnString set strConnString = server.createobject("adodb.connection") strConnString.ConnectionString="DRIVER={Microsoft Access Driver (*.mdb)};" & Server.MapPath("forum/admin/wwforum.mdb") strConnString.open --------------------------------------------------- But now I get the following error: ------------------------------------------- Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E4E) Operation was canceled.
I've got a UAPortal (asp freeware intranet) on a godaddy hosting package that comes with a free mysql database. I can't connect the asp site to the godaddy sql server.
They give me the connection strings, but don't tell me where or how to use them! Support does no good, they tell me that is programming, get an expert.
UAPortal comes with an Access database, so when installed it works fine, but its only Access. I want to use the mysql database which is faster, larger and more useful. I opened the Common.asp file and added the info from the connection strings, but now I get an error message:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[MySQL][ODBC 3.51 Driver]Access denied for user: 'jwyss@winhostecn82.prod.mesa1.secureserver.net' (Using password: NO)
I work with ASP for several weeks now and i really like it! But until now i have just used it in connection with my localhost. I made connections to a SQL Database and to an ACESS Database with using the ODBC Tool from WIndows!!
Now i want to publish my website but i don't know how to handle the connection string kind of thing. My MySQL-Database is on a different server than the website and i need a connection string where i can type in the server, a password and a username and it should then connect.
