API to make connection of UDL with mdb

[Prashant_S1]

API to make connection of UDL with mdb,

by programming in run time i want to make mdb file and make Link with UDL file. programmatically.

[ricky chauvin]

Do you have the database connectivity toolkit?

[Prashant_S1]

yes i have...

[ricky chauvin]

Ok then, linking to a udl should be fairly straightforward then.

I'll have a think, not going to have a chance to properly look until monday mind...

Have you got any progress of your own?

[Dennis_Knutson]

Since you have the toolkit, you just to look at the shipping examples in order to learn how to use a udl file. As far as creating a database itself, as opposed to a new table, I don't think you can do that. It would be specific to whatever database you are using and is not part of the SQL language. So, in your case, you could use Access's ActiveX interface to create a new jet database.

[ricky chauvin]

Been thinking this over in my head...

For creating a table you could link to a stored procedure using a parameterized query vi.

One of the parameters would have to be table name, another would have to be target database.

Im really unsure about creating the UDL programatically, I think this may be your sticking point.

[Dennis_Knutson]

Creating a new table is simply done with the CREATE TABLE command. The op however, stated a desire to create a new database and that is an entirely different task.

[smercurio_fc]

Well, there is a CREATE DATABASE command in SQL, but I've never used it, as I use Enterprise Manager to create database in SQL Server.

However, I agree that the poster really needs to explain better. These terse statements are too ambiguous.