Using ADO to create a database (solved)

[DerFarm]

I give up. I've looked for 2 hours now,

how do you create a new database (not a table) in ADO?


also, how do I delete this thread because my stupid *($#&*#$& is so slow I hit the submit button twice?

[Serge]

What database type are you trying to create?? Access, SQL Server, Oracle, Sybase ?

[gab2001uk]

Use ADOX

Dim catADO    As ADOX.Catalog
 
catADO.Create "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=TestDatabase.mdb"

for details see my site...

[DerFarm]

Only works when the string is explicit:

Dim catADO As ADOX.Catalog
Dim str_Temp As String

Set catADO = New ADOX.Catalog
catADO.Create "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\xsxx.mdb"

works fine, but

Dim catADO As ADOX.Catalog
Dim str_Temp As String

Set catADO = New ADOX.Catalog
str_Temp = "Provider=Microsft.Jet.OLEDB.4.0;Data Source=c:\xsxx.mdb"  

catADO.Create (str_Temp)

gets an error: Class not registered

Any ideas?

[gab2001uk]

If it is just the name of the new db you want to change then

Dim catADO As ADOX.Catalog
Dim str_Temp As String
 
Set catADO = New ADOX.Catalog
str_Temp = "c:\xsxx.mdb"  
 
catADO.Create "Provider=Microsft.Jet.OLEDB.4.0;Data Source=" & str_Temp

[Beacon]

Or see your chit chat thread!
I answered it there!
later
b

[DerFarm]

I'm an idiot.
I'm dumber than snails.
I talk to squirrels.
I can't spell MICROSOFT.

That's the error in the above. The word Microsoft in the connection string is spelled MICROSFT.

damn machines.

[gab2001uk]

Oh dear...

Perhaps we should have looked at the obvious first.

[DerFarm]

We did Gab. It's just that looking for your own errors in spelling is difficult under the best of circumstances. That's why a good editor is more precious than a good author.