Hi,
My problem is that when I deploy my windev app, I wish to specify the Connection Details for my database.
I have made a small test program using SQLEXPRESS as my data base. I specified 1 file in the analysis and created only 1 window with a table component on it.
When testing my program from within windev it works fine. When creating my setup I specify that I wish to change the details for the server for my database.
In the Hyper File C/S part of the Setup Editor I specify MyConnection1 with default values ( the ones I used to test my program with ).
Firstly there is an extra connection (Automatic Connection) used for replication. I do not use that in my application but it seems there is no way to remove this connection. When I do not specify any parameters for this Automatic Connection, the setup fails with a message : Automatic Connection cannot be changed and no values specified. So I ended up specifying the same values for Automatic Connection that I used for MyConnection1.
When running the setup it now continues and installs my application. When running my application after this installation it fails with error :
==================================================================================
Unable to initialize 'TABLE_DATA_PRICE_FILE_SETUP' control. Hyper File Error:
=============================
OLE DB access error.
Error Number = 170124
Failure opening connection:
Data Source: <CTDEVNL09\SQLEXPRESS:4900>
OLEDB Provider: <SQLOLEDB>
=============================
System Error Details:
Description = [DBNETLIB][ConnectionOpen (ParseConnectParams()).]Invalid connection.
Source = Microsoft OLE DB Provider for SQL Server
SQL State = 08001
Error Number = -2147467259
Native Error Number = 14
Technical Information
Project : DBTEST3
Dump error of module <WD120OBJ.DLL> <12.00Pxe>.
- Level: fatal error (EL_FATAL)
- Error Code: 10085
- WD55 Error Code: 3001
- No system error code
- System Error Message:
Description = [DBNETLIB][ConnectionOpen (ParseConnectParams()).]Invalid connection.
Source = Microsoft OLE DB Provider for SQL Server
SQL State = 08001
Error Number = -2147467259
Native Error Number = 14
- What happened?
Unable to initialize 'TABLE_DATA_PRICE_FILE_SETUP' control. Hyper File Error:
=============================
OLE DB access error.
Error Number = 170124
Failure opening connection:
Data Source: <CTDEVNL09\SQLEXPRESS:4900>
OLEDB Provider: <SQLOLEDB>
=============================
- Debug Information:
IEWDOLDB=105003
Module=<WDOLDB>
Version=<12.00Bg>
MDAC Version = <6.0.6001.18000>.
[Connection parameters]
DataSource = <CTDEVNL09\SQLEXPRESS:4900>
Initial Catalog = <>
Provider = <SQLOLEDB>
User = <sa>
Password = <,###>
Extended Info = <Initial Catalog=PeresysMDS;;Initial Catalog=peresysmds;Initial Catalog=peresysmds;Initial Catalog=peresysmds;Initial Catalog=peresysmds;Initial Catalog=peresysmds;Initial Catalog=peresysmds;Initial Catalog=peresysmds;Initial Catalog=peresysmds;Initial Catalog=peresysmds;Initial Catalog=peresysmds;Initial Catalog=peresysmds;Initial Catalog=peresysmds;Initial Catalog=peresysmds;Initial Catalog=peresysmds;Initial Catalog=peresysmds;Initial Catalog=peresysmds>
Access = <Read/Write>
[Connection settings]
ConnectionTimeout = <-1>
CommandTimeout = <-1>
[Data format]
Query Parameter Checked = <0> = <>
Query Parameter Needing conversion = <64> = <DECIMAL>
DecimalSeparator = <Undefined>
DateFormat = <>
[Cursor settings Match]
LockType = <adLockUnspecified>, Location = <adUseNone>, Type = <adOpenUnspecified>, Capacities = <ffffffff>
LockType = <adLockUnspecified>, Location = <adUseNone>, Type = <adOpenUnspecified>, Capacities = <ffffffff>
LockType = <adLockUnspecified>, Location = <adUseNone>, Type = <adOpenUnspecified>, Capacities = <ffffffff>
- Attached Information:
EIT_ADOCODE : <-2147467259>
EIT_BASECODE : <14>
EIT_ODBCDESCRIPTION : <[DBNETLIB][ConnectionOpen (ParseConnectParams()).]Invalid connection.>
EIT_ODBCCODE : <08001>
EIT_NATIVECODE : <170124>
EIT_LOGICALTABLENAME : <DATA_PRICE_FILE_SETUP>
- Identifier in .err: 10085
Help
- Consult Hyper File help for this error.
- Use HOpen() to check Hyper File correctness.
- When using a query, check whether it is properly initialized.
- Initialization must not occur in the table code but in the "global declarations" code of
the current window.
==================================================================================
Even changing the port number to 1433 which is used by SQLEXPRESS in the MyTest.wx file does not solve the problem.
Can anyone please shed some light on why this can be happening and how to solve it.
Thanks
Andre.
Message forwarded from pcsoft.us.windev