I've tried everything I could find in this forum related to my issue. Below you will see my log files:

ISAMOpen
Database: E:\GOLDTECH\Scott\Idea Nuova\Data\IdeaNuovaCanada.QBW
DSN:
UserName:
Password:
DeveloperCode:
ApplicationCode:
OpenMode: F
UseDCOM: N
IBizRemoteConnection: N
IBizRemoteURL: http://localhost:2080
    IBizRemoteUserName: admin
IBizRemotePassword:
IBizRemoteAskPassword: Y
IBizRemoteSSLAcceptServerCert:
IBizRemoteConnectionTimeOut: 120
IBizRemoteForce2002_2003: N
IBizOEConnection: N
IBizOETicketGUID:
IBizOELoginGUID:
IBizOELoginAsk: Y
IBizReconnectionDelay: 0
ColumnNameLen: 50
UseCaseSensitiveRefNumber: Y
OptimizerOn: Y
OptimizerDBFolder: C:\Program Files\QODBC Driver for
QuickBooks\Optimizer
OptimizerCurrency: C
OptimizerEncrytionOn: Y
IAppLaunchQBUI: N
IAppAutomaticLogin: Y
IAppReadOnly: N
IAppAllowPersonalData: Y
OleInitialize - Returned OK
Logged In User:    Tony
Is a Service:      No
Registration Name: Antonio La Corte
RegSerial:         R06U10014490
QODBC Version:     6.00.00.155
DLL:               C:\WINDOWS\system32\FQQB32.DLL
Driver Name:       FQQB32.DLL
Process Count:     1
Thread Count:      0
OpenMode:          Follow Company
Include Raw:       No
Version Type:      QODBC Desktop Read Only 2006
Access Method:     QBXMLRP2.DLL (IAuth2)
2006-06-22 12:31:39 QODBC Ver:  6.00.00.155
*********************************************************************************************************************
IsAService: False
Open Connection Failed. S0000 00000 [QODBC] QB Open Connection Failed.
Error = 8004042f, The requested connection type could not be found.
SDK Module: QBXMLRP2.DLL (IAuth2)
Open Connection Failed. S0000 00000 [QODBC] QB Open Connection
Failed. Error = 8004042f, The requested connection type could not be found.
0x00000000 [ISAM]
S0000 00000 [QODBC] QB Open Connection Failed. Error = 8004042f,
The requested connection type could not be found.
ISAM_OPENCONNECTFAIL S0000 00000 [QODBC] QB Open Connection Failed.

2006-06-22 12:31:39 QODBC Ver:  6.00.00.155
*********************************************************************************************************************
IsAService: False
Open Connection Failed. S0000 00000 [QODBC] QB Open Connection Failed.
Error = 8004042f, The requested connection type could not be found.
SDK Module: QBXMLRP2.DLL (IAuth2)

This is a known problem with the Canadian 2006 edition of QuickBooks.

The workaround for this is fairly simple -- if you go to your QuickBooks program files directory and COPY qbw32.exe to qbw32<flavor>.exe where <flavor> is the flavor of QuickBooks you have installed:

Pro
Premier
PremierAccountant
PremierContractor
etc.

Then your QODBC connection issue should go away...

For example, if you have QB Premier, contractor edition installed, then you would copy QBW32.exe to QBW32PremierContractor.exe in the QuickBooks program files directory.

If the Update QuickBooks option is configured for Automatic Update, then you should already have the following small files placed in the directory where QuickBooks 2006 (Canadian edition) was installed:

qbw32premieraccountant.exe
qbw32premiercontractor.exe
qbw32premiergeneric.exe
qbw32premiernonprofit.exe
qbw32premierprofessional.exe
qbw32premierretail.exe
qbw32premierwholesale.exe
qbw32pro.exe
qbw32simplestart.exe

If those files have not been automatically installed, the QuickBooks 2006 user can cause them to be downloaded and installed by doing the following:

Open QuickBooks 2006 (Canadian edition)

Choose the menu
File > Update Quickbooks…

In the "Update Quickbooks" window, click "Update now" then click on "Get Updates" button.

Thnxs, that worked.