My Complicated Problem
I need to basically transfer an existing site to my personal pc,
when i copy everything to my wwwroot folder then preview it, I get errors such as:
--
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
--
Microsoft VBScript runtime (0x800A01A8)
Object required
--
Microsoft VBScript runtime (0x800A000D)
Type mismatch: '[string: ""]'
--
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.
--
I know the site uses mysql, I've transfered every database/table/data to my localhost database.
One thing I don't understand is the ODBC (DSN) setup. The cpanel on the site lists 4 data sources with databases, I can't seem to find the mdb databases in the directory specified in the ODBC info panel (perhaps the mdb files are linked with mysql?)
View Replies
I have a table in my DB called members. In that table, I have 2 tables I
will be using "username" and "points"
Now, I also have a table called all_matches. This table contains every match
report. Over 25,000 of them. I have a "username" field an "outcome" field an
"username1" field and "extra_match" field.
What I need to do, is make a query that takes the username from table
"members" and find :
using the "username" field in the members table, i need to obtain stats
that give me the following. Code:
View Replies
View Related
I have a system that works on line without any problems. Problem is i need something in place that blends on line information with offline. i want to do something similar to the following if it is possible.User saves to an offline database using a dsn-less connection When the user goes on the web site, they have the option to upload their database contents.
It then copies the information from the offline version of the database to the online version of the database.Then it deletes the information off the offline version, (to prevent same information being uploaded, probably use sql to do this)The user also has the option to download a zipped copy of the main database so they are up-to-dateIs this possible?
View Replies
View Related
I've two tables:
First Table Player
tbl_player (fld_id, fld_dor, fld_tname, fld_tpass, fld_name, fld_email, fld_mobile)
Second Table Attempt
tbl_attempt (fld_attempt_id, fld_dop, fld_tname, fld_pid, fld_pscore)
Relation of First Table with Second Table is fld_tname and fld_pid of tbl_attempt with fld_id of tbl_player
Basically this is a 2-player game in which tbl_player contains both player a and player b details (they are identified by same Team Name). Table Attempt (tbl_attempt) holds individual scores which again can be grouped as a team score by the field fld_tname. Code:
View Replies
View Related
