Applications that create databases   

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

date: Wed, 11 Jan 2006 14:56:04 -0800   author:   Rafael

Re: Applications that create databases   

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

date: Wed, 11 Jan 2006 22:06:46 -0800   author:   Michael Nemtsev

Re: Applications that create databases   

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:

> 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
> 
> 
>

date: Thu, 12 Jan 2006 15:03:02 -0800   author:   Rafael