PC SOFT

FORUMS PROFESSIONNELS
WINDEVWEBDEV et WINDEV Mobile

Accueil → WINDEV 2024 → i have create the databese
i have create the databese
Débuté par Shubham vijay, 17 déc. 2014 10:20 - 5 réponses
Posté le 17 décembre 2014 - 10:20
Error at line 29 of Global Procedure file_connection process.
HCreationIfNotFound function called.
OLE DB access error.
Error Number = 170124

Failure opening connection:
Data Source:
OLEDB Provider: <>
sir;
sir i have create the database then hdescription connection function defind the date file My datebase.db and then oledb provider is none then error show and thatb error show so what oledb have create so that was error not show
Error at line 29 of Global Procedure file_connection process.
HCreationIfNotFound function called.
OLE DB access error.
Error Number = 170124

Failure opening connection:
Data Source:
OLEDB Provider:
Failure creating database.

System Error Details:

Description = Provider cannot be found. It may not be properly installed.
Source = ADODB.Connection
Help File = C:\Windows\HELP\ADO270.CHM
Help Context = 1240655 (0x12ee4f)
Error Number = -2146824582 (0x800a0e7a)


**********************************************

----- Technical Information -----

WL call:
Process of 'Global Procedure file_connection' (save_customername.file_connection), line 29, thread 0
'HCreationIfNotFound' function, syntax 1

What happened?
OLE DB access error.
Error Number = 170124

Failure opening connection:
Data Source:
OLEDB Provider:
Failure creating database.

Error code: 73001
Level: fatal error (EL_FATAL)
Posté le 17 décembre 2014 - 10:27
What type of database? HF,MYSQL,SQLSERVER,....?

How do you defined the connections? In the analysis, by code?

Can you post the definition of the connection?
Posté le 17 décembre 2014 - 10:55
sir
i have build Android application so i have used sqlite connection
Posté le 17 décembre 2014 - 11:07
Hello Shubham Vijay

When you make a request, please define the PCSoft product you are using and the Version in the header of the request. This is usually in the following manner:

[WD18] for WINDEV version 18
[WM17] for WINMOBILE version 17
[WB19] for WEBDEV version 19

This is important as the versions can vary greatly and it means you get more accurate answers that are relevant to your version.

Read the answers you are given and respond to them with the information that is requested, so if you are asked to post code then please do so.

In this case please give the proper answers to Paulo's questions.

Regards
Al
Posté le 17 décembre 2014 - 11:19
Did you checked this help page?
<a class="ExternalLink" rel="nofollow" target="_blank" href="http://doc.windev.com/en-US/?9000123">http://doc.windev.com/en-US/&hellip;</a>
Posté le 17 décembre 2014 - 13:04
sDatabase is string = CompleteDir(fDataDir()) + "yourdatabase.db" IF HDescribeConnection("aConnection","","",sDatabase,"",hAccessSQLiteAndroid,hOReadWrite) = False THEN Error("Unable to describe the connection", HErrorInfo(hErrMessage)) //EndProgram(True) END // Changes the connection of the application files IF NOT HChangeConnection("*","aConnection") THEN Error("Unable to change the connection", HErrorInfo(hErrMessage)) //EndProgram(True) END IF NOT HOpenConnection("aConnection") THEN Error("Unable to open the database connection", HErrorInfo(hErrMessage)) END IF NOT HCreationIfNotFound("*") THEN Error("Unable to create the datafiles", HErrorInfo(hErrMessage)) END