error: Could not find installable ISAM (create database)

[jennyek2000]

I am trying to create a new database programmatically using ADO ext 2.7 (in vb.NET) using the following code:

Dim mycatalog As New Catalog()
Try
mycatalog.Create("Provider=Microsoft.Jet.oledb.4.0;DataSource=Q:\Job" & CmboxJobnos.Text & ".mdb&quot

Catch ex As System.Runtime.InteropServices.COMException
MsgBox("Error creating database archive. " & ex.Message, MsgBoxStyle.Exclamation)

Finally
mycatalog = Nothing
End Try

However when I run the code, I get the exception "could not find the installable ISAM".

How can I fix this?

Thanks, Jenny

 

[sunaj]

Hi,

DataSource is not one word in the connection string. Try changing your string to:
"Provider=Microsoft.Jet.oledb.4.0;Data Source=Q:\Job" & CmboxJobnos.Text & ".mdb"

Sunaj
'The gap between theory and practice is not as wide in theory as it is in practice'