Hi There
I have done a bit of research on the net, I know that IM001 means function not supported. But here is my problem:
I am trying to connect to a SQL Database on my server using ODBC. I can connect to the database using Excel and Access, but not by using my program.
When I use the DSN I created (the working one), I get the IM001 Error. When I use a Connection String, I get the error ' Dataset doesn't have table 0' or something to that effect.
Is there anything else that I can try? Is there anything I am overlooking?
The system on which the program has to run is a Windows 2000 machine, it has the latest .Net Framework updates, MDAC 2.8 updates, U/SQL Client v3.10.0400 for 32-Bit Windows.
The SQL statment I am trying to execute looks like this:
"SELECT a.Job, a.JobDescription, a.CustomerName, a.StockCode,
a.StockDescription, a.QtyToMake, a.QtyManufactured, b.Operation,
b.IExpUnitRunTim, b.IExpSetUpTime, b.IExpStartUpTime, b.IMaxWorkOpertrs, b.PiecesCompleted,
b.PlannedStartDate, b.PlannedEndDate, b.WorkCentre, b.WorkCentreDesc
FROM WipMaster a INNER JOIN WipJobAllLab b ON a.Job = b.Job
WHERE a.Complete = 'N' AND
b.OperCompleted = 'N' AND
a.QtyToMake - a.QtyManufactured > 0 "
I have tried removing the last calculation (QtyToMake - QtyManufactured) but that didn't work.
PS. I am using Visual Basic.Net to write the program.
Thanks in advance for any help
I have done a bit of research on the net, I know that IM001 means function not supported. But here is my problem:
I am trying to connect to a SQL Database on my server using ODBC. I can connect to the database using Excel and Access, but not by using my program.
When I use the DSN I created (the working one), I get the IM001 Error. When I use a Connection String, I get the error ' Dataset doesn't have table 0' or something to that effect.
Is there anything else that I can try? Is there anything I am overlooking?
The system on which the program has to run is a Windows 2000 machine, it has the latest .Net Framework updates, MDAC 2.8 updates, U/SQL Client v3.10.0400 for 32-Bit Windows.
The SQL statment I am trying to execute looks like this:
"SELECT a.Job, a.JobDescription, a.CustomerName, a.StockCode,
a.StockDescription, a.QtyToMake, a.QtyManufactured, b.Operation,
b.IExpUnitRunTim, b.IExpSetUpTime, b.IExpStartUpTime, b.IMaxWorkOpertrs, b.PiecesCompleted,
b.PlannedStartDate, b.PlannedEndDate, b.WorkCentre, b.WorkCentreDesc
FROM WipMaster a INNER JOIN WipJobAllLab b ON a.Job = b.Job
WHERE a.Complete = 'N' AND
b.OperCompleted = 'N' AND
a.QtyToMake - a.QtyManufactured > 0 "
I have tried removing the last calculation (QtyToMake - QtyManufactured) but that didn't work.
PS. I am using Visual Basic.Net to write the program.
Thanks in advance for any help