I'm developing an application that lets the user to create a database and use
it.

I use the ADOX function NewCatalog, and it works fine.

But I'd like to design databases with the graphic interface of VS (schemas,
xsd, and so forth) and also datasets with strong types (to have all fields of
each table being properties of the datable object), but if I do so, I have to
create the database in my machine and "connect" the user to it by dropping
the database in a form. What if I want to develop the application with all
these capabilities, but still letting the end user to create and open the
databases in his own machine?

--
Thanks in advance

Rafael

Hello Rafael,

Just keep all connection strings/SQL Queries and etc. in the external file.
General in XML

R> I'm developing an application that lets the user to create a database
R> and use it.
R>
R> I use the ADOX function NewCatalog, and it works fine.
R>
R> But I'd like to design databases with the graphic interface of VS
R> (schemas, xsd, and so forth) and also datasets with strong types (to
R> have all fields of each table being properties of the datable
R> object), but if I do so, I have to create the database in my machine
R> and "connect" the user to it by dropping the database in a form. What
R> if I want to develop the application with all these capabilities, but
R> still letting the end user to create and open the databases in his
R> own machine?
R>
R> Rafael
R>
---
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/members/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche

Thank you Michael for your time.

Actually I figured out that I can modify the connection string, and all the
designing I did works with the other Database, of course, given that the
structures are the same.
--

Rafael


"Michael Nemtsev" wrote: