creating fake database

[venomstyle]

I am working on a site and I don't have my access for the database yet, and a lot of the site is database dirven, so I am wondering if there is a way I can create like a fake database in XML or something and have it work the same. That way when I do get my database access I can just change a few things around and have it work the same. Is this possible?

thanks for the help,

Venom

[buntine]

Well, there is no XML equivelant for SQL. There are technologies like XPATH, but they differ greatly.

You could emulate your database via XML -- provided it was somewhat simple. Read up on reading and writing to an XML file with ASP. It's very easy.

Regards.

[SpectreReturns]

A.I.Bot from http://aibots.net wrote an XML Database (xdb), which accepts SQL queries. I don't actually think it's on his site, so you'll have to send him an email.

[buntine]

Interesting. I will check that out, too.

[wardo]

If by not having "my access" yet you mean you dont have the Microsoft Access application, disregard this message.

Is there any reason that you cant simply create like a MS access database file, and use a connection string to connect to it? It seems there couldn't be anything preventing you from doing that.

As long as Access is installed on the server, you should have no problems.

PM me for better instructions if you think this may apply

[Bullschmidt]

You can connect to a csv file (which can be opened in Excel and which an Excel file can be converted into) in good form just as you can to a regular database.

The .csv file needs to be uploaded to the server.

And you can have two recordsets open at the same time.

And for help connecting to a text file using the Jet OLE DB provider:
http://www.carlprothman.net/Default.aspx?tabid=87#OLEDBProviderForTextFiles

And based on the above link realize that the actual filename does NOT go in the connection string - rather it goes in the SQL statement (definitely a little tricky).

And you may want to check this out:

TableEditoR
http://www.2enetworx.com/dev/projects/tableeditor.asp

[venomstyle]

Thanks for the help guys. The reason I was asking was because I am working on a site for work. Kind of a learn it as I work it project and the person that has to give me the rights to the MSQL database is on vacation and I was just wanting a temp database so I could still work on it while he was on vacation and then when he gets back and sets me up my rights I could just change around a few things in the code and have it point to the official database.
Again thanks for all the ideas,

Venom

[Bullschmidt]

the person that has to give me the rights to the MSQL database is on vacation and I was just wanting a temp database so I could still work on it while he was on vacation


Then I'd suggest the "copycat" be an Access database, and here is a good site for connection strings to databases:

Connection String Home Page
http://www.carlprothman.net/Default.aspx?tabid=81