ADODB.Connection
(1)
MySQL
(1)
Windows Server
(1)
Server.CreateObject
(1)
Server.MapPath
(1)
ADODB
(1)
IIS
(1)
HeidiSQL
(1)
Need help setting up a database server on win2k.
Asked By SpreadTooThin
26-Oct-09 03:53 PM
I have a microsoft access mdb file that is accessed by asp files
hosted on the same server.
These asp files were originally hosted by an ISP but are now being
hosted by a computer on my network.
The web pages and database are hosted on a Windows 2000 machine
running IIS.
The web server is working but I get errors (-1) whenever i try to
access the database.
I think it is because I have not setup ODBC properly from the ODBC
Datasource Administrator.
Can someone guide me through this?
The code that connects to the database (If indeed a connection is
needed when the database is on the same server as the web server.)
when hosted by my ISP is:
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "C:\inetpub\wwwroot\MySite\myDatabase.mdb"
Gazing into my crystal ball I observed SpreadTooThin <bjobrien62This is what I
Asked By Adrienne Boswell
26-Oct-09 03:53 PM
Gazing into my crystal ball I observed SpreadTooThin <bjobrien62
This is what I use:
dim oConn, serverpath
serverpath = "myDatabase.mdb"
Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
--
Adrienne Boswell at Home
Arbpen Web Site Design Services
http://www.cavalcade-of-coding.info
Please respond to the group so others can share
In addition to that, make sure that the permissions on the folder where theMDB
Asked By Douglas J. Steele
16-Aug-09 05:46 PM
In addition to that, make sure that the permissions on the folder where the
MDB file exists are set appropriate for the security context under which ASP
runs (typically IUSER_<nameofmachine>)
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
Gazing into my crystal ball I observed "Douglas J.
Adrienne Boswell replied to Douglas J. Steele
26-Oct-09 03:53 PM
Gazing into my crystal ball I observed "Douglas J. Steele"
I have also had issues with the temp folder that IUSER needs to have
write permission as well.
--
Adrienne Boswell at Home
Arbpen Web Site Design Services
http://www.cavalcade-of-coding.info
Please respond to the group so others can share
I wonder if I can connect to my MySQL database instead of the mdbfile...
SpreadTooThin replied to Adrienne Boswell
26-Oct-09 03:53 PM
I wonder if I can connect to my MySQL database instead of the mdb
file...
I think that is a great idea.
Adrienne Boswell replied to SpreadTooThin
26-Oct-09 03:53 PM
I think that is a great idea. If you are going to be testing on your own
machine, you will have to download the driver for it. MySQL Migration Kit
will also convert all your access tables to MySQL. If you do not already
have it, I also highly recommend HeidiSQL MySQL client.
--
Adrienne Boswell at Home
Arbpen Web Site Design Services
http://www.cavalcade-of-coding.info
Please respond to the group so others can share
ASP DB problem. I am trying to connect to a MySQL database on a windows server using ASP / ADODB I keep getting unable to display page http: / / www.desmond is the entire code for the page. This is a MYSQL database Set connection = Server.CreateObject("ADODB.Connection") Set rsResult = Server.CreateObject("ADODB.Recordset") sqlconn = connection.Open sqlconn sqlResults = "SELECT * FROM
to have an error somewhere ??? I am connecting to a MySQL server (works fine) hit-marker = Varchar hit_date = Date hit-browser = Varchar hitdate) dd = Day(hitdate) S_date = yy & " / " & mm & " / " & dd Set adoDataConn = Server.CreateObject("ADODB.Connection") adoDataConn.Open conn_string uSQL = "INSERT INTO Webwiz (hit-marker, hit_date error: - -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- - Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [MySQL][ODBC 3.51 Driver][mysqld-4.1.22-standard]You your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-marker, hit_date hit-browser) VALUES ('1', 2007 / 6 / 5, 'Mozilla / 5.0 (Windows; U; W' at line 1 / hitwise.asp, line 20 _ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ _ great help :-) Thanks in advance David I don't use MySQL, but I suspect you are passing the date incorrectly. To
IIS Need help setting up a database server on win2k. I have a microsoft access mdb file that is accessed by asp files hosted on the same server. These asp files were originally hosted by an ISP but network. The web pages and database are hosted on a Windows 2000 machine running IIS. The web server is working but I get errors (-1) whenever i try The code that connects to the database (If indeed a connection is needed when the database is on the same server as the web server.) when hosted by my ISP is: set conn Server.CreateObject("ADODB.Connection") conn.Provider = "Microsoft.Jet.OLEDB.4.0" conn.Open "C
IIS iis7 on windows server 2003 r2 Is iis7 available on windows server 2003 r2? IIS7 is only available on Windows Vista and Windows Server 2008. There are enough HTTP kernel driver changes required by it will be nearly impossible to make IIS7 available on Windows Server 2003 platform. / / David http: / / w3-4u.blogspot.com http: / / blogs.msdn.com / David.Wang / / keywords: iis7, on, windows, server, 2003, r2 description: Is iis7 available on windows server
IIS Windows Update related to IIS Hello: My IT department pushed the folllowing updates to the server. Windows Internet Explorer 7 Dynamic Installer Cumulative Security Update for Internet Explorer 7 Dynamic Installer for Windows Server 2003 (KB953838) Wednesday, August 13, 2008 Other Source Windows Server 2003 Update for Windows Server 2003 (KB951072) Wednesday, August 13, 2008 Automatic Updates Windows Server 2003 Cumulative Security Update for Internet Explorer 6 for
IIS Windows Server 2008 ftp issue Hello, We recently upgraded one of our file ftp routine from a Windows Server 2003 to a Windows Server 2008. Previously we would get the response to the ftp commands like this: 150 Opening BINARY mode data connection for CCA_150278.HL7(528 bytes). 226 Transfer complete. ftp: 528 formatting issues with the message: 150 Opening BINARY mode data connection for CCA_150248.HL7(506 bytes). 226 Transfer complete. ftp: 506 help on this would be appreciated. Thank you! -Roberto keywords: Windows, Server, 2008, ftp, issue description: Hello, We recently upgraded one of
IIS IIS anon acess and NTFS folder resource Help! Server: Windows server 2k3, Client: XP Pro I am trying to set up keywords: IIS, anon, acess, and, NTFS, folder, resource description: Help! Server: Windows server 2k3, Client: XP Pro I am trying to set up
IIS Installing ISS on Windows Server 2003 R2 Hi, I'm trying to install ISS under windows Server 2003 - I go to the windows components on add / remove programs and select Application Server - Which includes IIS in its details - I click next and it asks for the Windows Server Standard edition CD1 to be put in the cd drive it on both cd's and my exist installation of Server 2003 - I then have to back out of the install installation, then something seems wrong with the source of your Windows Server 2003 and would explain why you are having problems