error using adox

**marvinklein** · Dec 27th, 2003, 09:01 AM

i followed pirates instructions from this post

in line 6, which is
ADOXcatalog.Create "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "c:\newdata.mdb"
i get unhandled exception of type #System.runtime.InteropServices.COMException'
Additional Information: Could not find installable ISAM.

pirate or somebody else: any ideas what is going on and how to fix this?

**Pirate** · Dec 27th, 2003, 09:19 AM

Umm , weird ! What's your OS ?

**Pirate** · Dec 27th, 2003, 10:12 AM

Anyhow , download this update (MDAC 2.8) to update Access Components on Windows 2000, Windows 98, Windows ME, Windows NT, Windows XP

http://www.microsoft.com/downloads/d...DisplayLang=en

**marvinklein** · Dec 27th, 2003, 12:01 PM

what if i want the app to run on a comp without the update or msaccess though?

btw, i use win xp.

**marvinklein** · Dec 27th, 2003, 12:02 PM

pirate- are you going to write new code like you said in the tutorials section, or should i go somewhere else for the code?

**Pirate** · Dec 27th, 2003, 12:05 PM

Yes , I'll start rewriting the code after couple of hours . It has little bugs besides its poor UI

.

**Pirate** · Dec 27th, 2003, 12:07 PM

Originally posted by marvinklein
what if i want the app to run on a comp without the update or msaccess though?
btw, i use win xp.

I use XP too and have no problems . Are you sure you have MCAD 2.7 at least installed on your machine ?

If you don't have it then you must include it in your deployment project ,just in case the client doesn't have it . Most of application bear in mind this seriously .

**Pirate** · Dec 27th, 2003, 12:10 PM

oh

Goto Control Panel--->Administrative Tools------>Data Sources (ODBC)------>Drivers Tab-----> check how many mdb drivers are installed on your machine ?

**marvinklein** · Dec 27th, 2003, 12:16 PM

Driver do Microsoft Access
Microsoft Access Driver
Microsoft Access-Treiber --- i live in germany. this is the german version i guess....

**marvinklein** · Dec 27th, 2003, 12:18 PM

i now get an error in the activeconnection line:
arguments are of the wrong type, are out of acceptible range, or are in conflict with each other.

**Pirate** · Dec 27th, 2003, 12:23 PM

Originally posted by marvinklein
i now get an error in the activeconnection line:
arguments are of the wrong type, are out of acceptible range, or are in conflict with each other.

That's the nasty line . It's easy to fix(already fixed ) though but give me sometime to code it again in graceful way . I'll post it here when I'm done .

So what did you do to solve the the ISAM problem ?

**marvinklein** · Dec 27th, 2003, 12:24 PM

I turned "DataSource" into "Data Source"

sorry, but i can't cut and paste, remember. i have to type everything by hand.

**Pirate** · Dec 27th, 2003, 02:35 PM

If you did make that again , I'm ganna kick your butt .

**marvinklein** · Dec 27th, 2003, 02:41 PM

ha. but the arguments are of the wrong type error is still there, and i'm really looking forward to see your revised code...

**Pirate** · Dec 27th, 2003, 02:48 PM

Originally posted by marvinklein
ha. but the arguments are of the wrong type error is still there, and i'm really looking forward to see your revised code...

Don't be too hasty , I've just started . If you want a quick fix , just remove this :

VB Code:

ADOXcatalog.ActiveConnection

**marvinklein** · Dec 27th, 2003, 02:56 PM

take your time pirate...
and thanks a million times for all the help..

**Pirate** · Dec 27th, 2003, 06:56 PM

updated .

Thread: error using adox

Thread Tools

Display

error using adox

Posting Permissions