SQL toolkit error 100

[ckonio]

Hello
I use CVI 8.0.1 on Win2000.
I wrote an application by use SQL Toolkit, because I nedd to store my data on MySQL DB.
As usual I need to configure ODBC driver : MySQL Connector/ODBC 5.00.11.
Everything work fine, but... When I made an Install version of my application
and I go to other PC with MySQL Connector configured in the same way
I get an error number -100.
I didn't find this error number in the CVI SQL Toolkit Ref Manual.
I reinstall Connector to version 3.5.1 and the problem still exists.
I check the connection with DB by use other appllication- correct, test.udl file - correct.

I can't find the answer- on my PC everything work fine.

The part of my code responsible for connection is typicall:
DBInit();
hdbc = DBNewConnection();  - here I get error -100.

What could be a reson of such behavior ?

Konrad

[James M]

Hi Konrad,

What error message is returned if you add the following code as discussed in Why Do I Get "Native error code message" When I Call A LabWindows/CVI SQL Toolkit Function In My Pro...:

if (hdbc <= 0) {
    errorCode = DBError();
    errorMsg = DBErrorMsg();
    printf("Error number %d\n%s\n", errorCode, errorMsg);
}

Regards,

[ckonio]

Hi James
I have such a code in my soft.
Error -100 dosn't have any message.
But I'v solved it. I think...
If I want that my application works on other PC I need to install SQL Toolkit.
I think, I don't need full SQL Toolkit but some part which install some ODBC components.
But I don't know which one and how to separate it.
This is what I made: first I tried to run my soft and I got error -100.
Then I install SQL Toolkit (there was not any NI soft before, no CVI etc.)
and then I run my soft again and ... IT WORKED. Conclusion is -> this is solution.

This is my question: How to build distribution kit which cover this hole ?
What I need extra to add or install before run my app on given PC to allow run my soft?

Best Regards
Konrad

[ckonio]

James

I get it.
I need to install 2 .dll files when I want to use SQL Toolkit functions.
In the distribution kit I have to lauch instalation of these two dlls.
That is all.

Konrad

[Paul_Knight_Lockheed_Mart]

I know this is an old thread, but I am getting the same error.  The thread mentions two dlls need to be loaded on the target computer, but does not mention them by name.  Does anyone know which two dlls are need? 

Do we need to purchase a SQL Toolkit for every target machine?

[Koza]

Dear Paul,

Have you checked the document:

"Cannot find cvi_db.dll" When Creating a Stand-alone Executable with LW/CVI SQL Toolkit ?

http://digital.ni.com/public.nsf/allkb/6B188E57306B84ED86256234007AE184?OpenDocument

Also, there is a help topic:

Distributing an SQL Toolkit Executable or DLL in LabWindows/CVISQL Toolkit Help, available in Start Menu.

Best regards,

Koza

[Paul_Knight_Lockheed_Mart]

I found the link, but there is no document attached.

[Paul_Knight_Lockheed_Mart]

The solution was in the link, I was thinking the problem would be more difficult.