Errors on starup of plugin.

MLDatabase allows MLServer3 to interact with any ODBC database that you create or attach to. Intended for advanced users only.
User avatar
rondepping
Expert
Expert
Posts: 638
Joined: Sat Jan 08, 2005 9:18 pm
Location: Grand Blanc, Mi
Contact:

Errors on starup of plugin.

Postby rondepping » Sun Jun 24, 2007 9:04 am

I'm getting errors in MLDatabase when I start MLServer.

Here is the log:

MLdatabase Log:
Error 429(ActiveX component can't create object) @ Line 250 in procedure Form_Load of frmMain
Error 3265(Item cannot be found in the collection corresponding to the requested name or ordinal.) @ Line 140 in procedure LoadListView of ModsharedCode
Error 3265(Item cannot be found in the collection corresponding to the requested name or ordinal.) @ Line 140 in procedure LoadListView of ModsharedCode
Error 3265(Item cannot be found in the collection corresponding to the requested name or ordinal.) @ Line 140 in procedure LoadListView of ModsharedCode

When I try to execute a Process_Command I then get the following errors in the log.

Error -2147217904([Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.) @ Line 810 in procedure doCmd of frmMain
Error 3704(Operation is not allowed when the object is closed.) @ Line 850 in procedure doCmd of frmMain
Error 3704(Operation is not allowed when the object is closed.) @ Line 860 in procedure doCmd of frmMain
Error 3704(Operation is not allowed when the object is closed.) @ Line 880 in procedure doCmd of frmMain
Error 3704(Operation is not allowed when the object is closed.) @ Line 890 in procedure doCmd of frmMain
Error 3704(Operation is not allowed when the object is closed.) @ Line 910 in procedure doCmd of frmMain
Error 3704(Operation is not allowed when the object is closed.) @ Line 920 in procedure doCmd of frmMain
Error 3704(Operation is not allowed when the object is closed.) @ Line 940 in procedure doCmd of frmMain


Any Ideas?

System details:
MLServer version 3.0.286
MLDatabase 3.0.12

Thanks,

Ron

User avatar
DavidL
Simply Incredible
Simply Incredible
Posts: 11071
Joined: Sat Feb 08, 2003 9:39 am
Location: Metamora, Michigan
Contact:

Postby DavidL » Sun Jun 24, 2007 9:39 am

Don't know if it will help, but Version 3.0.13 just posted. Try it and repost back

User avatar
rondepping
Expert
Expert
Posts: 638
Joined: Sat Jan 08, 2005 9:18 pm
Location: Grand Blanc, Mi
Contact:

Postby rondepping » Sun Jun 24, 2007 11:12 am

Thanks I'll give it a try and let you know.

Ron

User avatar
rondepping
Expert
Expert
Posts: 638
Joined: Sat Jan 08, 2005 9:18 pm
Location: Grand Blanc, Mi
Contact:

Postby rondepping » Sun Jun 24, 2007 11:29 am

Installed 3.0.13

On startup I'm just getting this now :

Error 429(ActiveX component can't create object) @ Line 250 in procedure Form_Load of frmMain

When I run a process command I'm getting:

Error -2147217904([Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.) @ Line 830 in procedure doCmd of frmMain
Error 3704(Operation is not allowed when the object is closed.) @ Line 870 in procedure doCmd of frmMain
Error 3704(Operation is not allowed when the object is closed.) @ Line 890 in procedure doCmd of frmMain
Error 3704(Operation is not allowed when the object is closed.) @ Line 920 in procedure doCmd of frmMain
Error 3704(Operation is not allowed when the object is closed.) @ Line 930 in procedure doCmd of frmMain
Error 3704(Operation is not allowed when the object is closed.) @ Line 960 in procedure doCmd of frmMain
Error 3704(Operation is not allowed when the object is closed.) @ Line 970 in procedure doCmd of frmMain
Error 3704(Operation is not allowed when the object is closed.) @ Line 990 in procedure doCmd of frmMain


Also when I click on the Available Databases Tab then click the ODBC tab I don't see any of my ODBC DSN's. Based on the message I geting on startup could I be missing an active X control?

I haven't tried to connect to a SQL db, I'll try that and post back with those results.

Thanks,

Ron

User avatar
rondepping
Expert
Expert
Posts: 638
Joined: Sat Jan 08, 2005 9:18 pm
Location: Grand Blanc, Mi
Contact:

Postby rondepping » Sun Jun 24, 2007 11:42 am

Ok this is with a call to a Local SQL Express DB:

MLDatabase Log
Error 429(ActiveX component can't create object) @ Line 250 in procedure Form_Load of frmMain
Error -2147467259([Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified) @ Line 820 in procedure doCmd of frmMain
Error 3709(The connection cannot be used to perform this operation. It is either closed or invalid in this context.) @ Line 830 in procedure doCmd of frmMain
Error 3704(Operation is not allowed when the object is closed.) @ Line 870 in procedure doCmd of frmMain
Error 3704(Operation is not allowed when the object is closed.) @ Line 890 in procedure doCmd of frmMain
Error 3704(Operation is not allowed when the object is closed.) @ Line 960 in procedure doCmd of frmMain
Error 3704(Operation is not allowed when the object is closed.) @ Line 970 in procedure doCmd of frmMain
Error 3704(Operation is not allowed when the object is closed.) @ Line 990 in procedure doCmd of frmMain


Its interesting that I'm getting an ODBC error on calls to the SQL Database. Still thinking it has something to do with the 429 error at Startup.

Thanks,

Ron

90CE
Developer
Developer
Posts: 573
Joined: Mon Nov 28, 2005 1:19 am
Location: Waukee, Iowa
Contact:

Postby 90CE » Mon Jun 25, 2007 1:10 pm

It appears you are missing ODBCTOOL.DLL. This is the dll that allows access the ODBC library. It is likely that your errors are occuring from there. I will be posting version .14 sometime today. I think it will address the reason you are having problems the SQL connection.

Tracy

User avatar
DavidL
Simply Incredible
Simply Incredible
Posts: 11071
Joined: Sat Feb 08, 2003 9:39 am
Location: Metamora, Michigan
Contact:

Postby DavidL » Mon Jun 25, 2007 5:48 pm

MLDatabase 3.0.14 uploaded for download.

User avatar
rondepping
Expert
Expert
Posts: 638
Joined: Sat Jan 08, 2005 9:18 pm
Location: Grand Blanc, Mi
Contact:

Postby rondepping » Mon Jun 25, 2007 6:25 pm

Progress! This is good.

Installed the odbctool.dll and it eliminated the 429 error on startup and the ODBC Connections tab populates. You may want to include this dll with the install program as it is seems to be only available as part of the VB6 compiler.

I can now run queries against SQL server with no problem.

When running ODBC queries I'm getting the following errors :

MLDatabase log:
CMD: Process_Command~MLCDJ~SELECT Title FROM Albums WHERE Artist Like "Meat*"~MLDB_CDJ FROM:
Error -2147467259([DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.) @ Line 120 in procedure CreateConnection of ModsharedCode
Error 3709(The connection cannot be used to perform this operation. It is either closed or invalid in this context.) @ Line 880 in procedure doCmd of frmMain
Error 3704(Operation is not allowed when the object is closed.) @ Line 1010 in procedure doCmd of frmMain
Error 3704(Operation is not allowed when the object is closed.) @ Line 1030 in procedure doCmd of frmMain
Error 3704(Operation is not allowed when the object is closed.) @ Line 1100 in procedure doCmd of frmMain
Error 3704(Operation is not allowed when the object is closed.) @ Line 1110 in procedure doCmd of frmMain
Error 3704(Operation is not allowed when the object is closed.) @ Line 1130 in procedure doCmd of frmMain

Looks like now its always trying to make an SQL server call.

Thanks,

Ron

90CE
Developer
Developer
Posts: 573
Joined: Mon Nov 28, 2005 1:19 am
Location: Waukee, Iowa
Contact:

Postby 90CE » Mon Jun 25, 2007 7:23 pm

Is this using 3.14 or 3.13?

User avatar
DavidL
Simply Incredible
Simply Incredible
Posts: 11071
Joined: Sat Feb 08, 2003 9:39 am
Location: Metamora, Michigan
Contact:

Postby DavidL » Mon Jun 25, 2007 7:35 pm

3.0.18 posted. w/ odbctool.dll driver in the installer (ooops).

User avatar
rondepping
Expert
Expert
Posts: 638
Joined: Sat Jan 08, 2005 9:18 pm
Location: Grand Blanc, Mi
Contact:

Postby rondepping » Tue Jun 26, 2007 4:41 pm

Sorry I didn't post the version. That was with 3.0.16. I'll give 3.0.18 a try and post back.

User avatar
rondepping
Expert
Expert
Posts: 638
Joined: Sat Jan 08, 2005 9:18 pm
Location: Grand Blanc, Mi
Contact:

Postby rondepping » Thu Jun 28, 2007 3:59 pm

Version 3.0.18
Command :MLServeCmd.MLDatabase|Process_Command~MLCDJ~SELECT Title FROM Albums~MLDB_CDJ

MlDatabase Log:
Error 13(Type mismatch) @ Line 1070 in procedure doCmd of frmMain
Error 13(Type mismatch) @ Line 1070 in procedure doCmd of frmMain
Error 13(Type mismatch) @ Line 1070 in procedure doCmd of frmMain
Error 13(Type mismatch) @ Line 1070 in procedure doCmd of frmMain
Error 13(Type mismatch) @ Line 1070 in procedure doCmd of frmMain
Error 13(Type mismatch) @ Line 1070 in procedure doCmd of frmMain
Error 13(Type mismatch) @ Line 1070 in procedure doCmd of frmMain
Error 13(Type mismatch) @ Line 1070 in procedure doCmd of frmMain
Error 13(Type mismatch) @ Line 1070 in procedure doCmd of frmMain
Error 13(Type mismatch) @ Line 1070 in procedure doCmd of frmMain

But it returned data. That was a simple query, change the Command to
Command:MLServeCmd.MLDatabase|Process_Command~MLCDJ~SELECT Title FROM Albums Where Artist like "Meat*"~MLDB_CDJ

No data returned and the following in the log:
Error -2147217904([Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.) @ Line 920 in procedure doCmd of frmMain
Error 3704(Operation is not allowed when the object is closed.) @ Line 1020 in procedure doCmd of frmMain
Error 3704(Operation is not allowed when the object is closed.) @ Line 1040 in procedure doCmd of frmMain
Error 3704(Operation is not allowed when the object is closed.) @ Line 1070 in procedure doCmd of frmMain
Error 3704(Operation is not allowed when the object is closed.) @ Line 1080 in procedure doCmd of frmMain
Error 3704(Operation is not allowed when the object is closed.) @ Line 1110 in procedure doCmd of frmMain
Error 3704(Operation is not allowed when the object is closed.) @ Line 1120 in procedure doCmd of frmMain
Error 3704(Operation is not allowed when the object is closed.) @ Line 1140 in procedure doCmd of frmMain


That query work in access returning 19 records so i don't think its a problem with the query.

90CE
Developer
Developer
Posts: 573
Joined: Mon Nov 28, 2005 1:19 am
Location: Waukee, Iowa
Contact:

Postby 90CE » Thu Jun 28, 2007 4:20 pm

Ron:
I think you need to remove the " from the query.

Try this.

Process_Command~MLCDJ~SELECT Title FROM Albums WHERE Artist Like 'Meat*'~MLDB_CDJ

Tracy

90CE
Developer
Developer
Posts: 573
Joined: Mon Nov 28, 2005 1:19 am
Location: Waukee, Iowa
Contact:

Postby 90CE » Thu Jun 28, 2007 4:56 pm

Ron:
I think the errors in the first query are due to NULL values in the database. I added some code to catch that error, it will be in the next version.

Tracy

User avatar
DavidL
Simply Incredible
Simply Incredible
Posts: 11071
Joined: Sat Feb 08, 2003 9:39 am
Location: Metamora, Michigan
Contact:

Postby DavidL » Thu Jun 28, 2007 5:40 pm

Version 3.0.23 updated.


Return to “MLDatabase”

Who is online

Users browsing this forum: No registered users and 1 guest