|
FOROS PROFESIONALES
WINDEV, WEBDEV y WINDEV Mobile |
| | | | | |
| OLE DB access error / WINDEV Error Code 73001 |
| Iniciado por JMichels.jmc, 23,sep. 2015 16:11 - 7 respuestas |
| |
| | | |
|
| |
| Publicado el 23,septiembre 2015 - 16:11 |
I despair!!!!
I've pulled several database tables from MS SQL in my analysis. In the Connection I use the OLE DB Provider for SQL Server. In the development environment that works without problems. The parameters for HOpenConnection are in an ini file. This is read at startup and purifier for registration. If the application is installed on another drive, I get the error message "Invalid connection". I have no idea was, could be the problem and need urgent help. It would be nice if I could get from you a tip.
Anyone had similar problems? Who can help me? Thanks for your support in advance ever.
// Parameters of the connection
LIAS_GTR..Provider = hOledbSQLServer
LIAS_GTR..User = gsDBUser
LIAS_GTR..Password = gsDBpw
LIAS_GTR..Server = gsDBServer
LIAS_GTR..Database = gsDBName
LIAS_GTR..Access = hOReadWrite
// Opening the connection
gbConnectionOK = HOpenConnection(LIAS_GTR) |
| |
| |
| | | |
|
| | |
| |
| Publicado el 23,septiembre 2015 - 17:41 |
Hi
from your description, it looks like the OLEDB connector is not
installed on the other machine.
But why use the OLE DB for mysql when native access is available and free?
Best regards
--
Fabrice Harari
Consultant WinDev, WebDev et WinDev Mobile International
Disponible : WXShowroom.com, WXReplication (open source)
Bientôt : WXEDM (open source)
Plus d'information sur http://fabriceharari.com
On 9/23/2015 8:11 AM, "ÿÿÿÿÿÿÿÿÿ" wrote:
I despair!!!!
I've pulled several database tables from MS SQL in my analysis. In the
Connection I use the OLE DB Provider for SQL Server. In the development
environment that works without problems. The parameters for
HOpenConnection are in an ini file. This is read at startup and purifier
for registration. If the application is installed on another drive, I
get the error message "Invalid connection". I have no idea was, could be
the problem and need urgent help. It would be nice if I could get from
you a tip.
Anyone had similar problems? Who can help me? Thanks for your support in
advance ever.
// Parameters of the connection
LIAS_GTR..Provider = hOledbSQLServer
LIAS_GTR..User = gsDBUser
LIAS_GTR..Password = gsDBpw
LIAS_GTR..Server = gsDBServer
LIAS_GTR..Database = gsDBName
LIAS_GTR..Access = hOReadWrite
// Opening the connection
gbConnectionOK = HOpenConnection(LIAS_GTR) |
| |
| |
| | | |
|
| | |
| |
| Publicado el 23,septiembre 2015 - 18:53 |
Can you please post the full error message using ErrorInfo(errFullDetails)?
Can you tel us what are the diferences between the development environment and the production one?
In the production environment you use another MS SQL instance, server or only another db?
Your app runs on another macihne in the production environment? |
| |
| |
| | | |
|
| | |
| |
| Publicado el 24,septiembre 2015 - 11:12 |
Here is the complete error message:
DB-Connection
Die Anmeldung an dem Server JMLAP\MSSQLSERVER2012 - Datenbank LIAS_GTR hat nicht funktioniert
WL call:
Process of 'Global Procedure DB_Connection_durchführen' (COL_GlobalProcedures.DB_Connection_durchführen), line 50, thre
'HOpenConnection' function, Syntax 0
What happened?
OLE DB access error.
Error NUmber = 170124
Failure opening connection:
Data Source: <JMLAP\MSSQLSERVER2012:4900>
OLEDB Provider: <SQLOLEDB>
Error code: 73001
Level: non-fatal error (EL_ONRETURN)
WD55 error code: 3001
System error message:
Description [DBNETLIB][ConnectionOpen (ParseConnectParams0).]Ungültige Verbindung.
Source = Microsoft OLE DB Provider for SQL Server
SQL State 08001
Error Number = -2147467259 (0x8.0004005)
Native Error Number 14 (Oxe)
Dump of the error of ‘WD190HF.DLL’ module (19.0.102.2)
Identifier of detailed information (.err): 72801
Debugging information:
IEWDOLDB=105.3
Module= <WDOLDB>
Version, <19.0.14.0>
Provider: SQLOLEDB
User: sa
Data source: JMLAP\MSSQLSERVER2012:4900
Database: LIAS GTR
Unicode supported: 1
Page code of WL: 1252
Page code of the connection: UTF-16
MDAC Version = < 6.3.9600.16384> .
[Data format]
Query Parameter Checked = <0> = <>
Query Parameter Needing conversion <96> <BOOLDECIMAL>
DecimalSeparator = <Undefined>
DateFormat = <Undefined>
[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>
Fonction (721C.)
Additional Information:
EIT_NATIVECODE : <170124>
EIT_ADOCODE: <-2147467259>
EIT_BASECODE : <14>
EIT_ODBCDESCRIPTION: <[DBNETLIB][ConnectionOpen (ParseConnectParms()).]Ungültige Verbindung.>
EIT_ODBCCODE <08001>
EIT_PILEWL
Global Procedure DB_Connection_durchführen (COL_GlobalProcedures.DB_Connection_durchführen) line 50
Initializing LIAS_Blanccosupport (), line 3
EIT_DATEHEURE : 24/09/2015 10:45:03
The only difference between the developing and the production environment is another drive letter (Development D :, productive E  . I use the same DB and the same server. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 24,septiembre 2015 - 11:14 |
I use a MS SQL server. The OILS DB Connector is installed.
Best regards |
| |
| |
| | | |
|
| | |
| |
| Publicado el 24,septiembre 2015 - 12:41 |
The only strange thing i can find in your error message is the name of the DB, in one case is LIAS_GTR in another is LIAS GTR
What is the real db name?
If the name have spaces try to enclose it with square brackets.
Did you try to connect to another DB in the same server?
Sorry to ask but are you sure that the ini files in D and E have the same information? |
| |
| |
| | | |
|
| | |
| |
| Publicado el 24,septiembre 2015 - 14:36 |
This is the content of the ini:
D: and E:
DBServer=JMLAP\MSSQLSERVER2012
Database=LIAS_GTR
UserName=sa
Userpw=sa
I have now used in the INI another DB (LIAS_neXchance). A I have found that in the error message back to the previously used DB reference (LIAS_GTR). This is the DB that was used during the installation process. Obviously, it does not matter what values I put in the INI. Is this possible?
regards
Jürgen |
| |
| |
| | | |
|
| | |
| |
| Publicado el 25,septiembre 2015 - 14:55 |
Probably you have one connection in the analisys with those values.
Try using HChangeConnection("*",LIAS_GTR) |
| |
| |
| | | |
|
| | | | |
| | |
| | |
| |
|
|
|