Diese Seite mit anderen teilen ...

Informationen zum Thema:
Forum:
WinDev Forum
Beiträge im Thema:
5
Erster Beitrag:
vor 8 Jahren, 2 Monaten
Letzter Beitrag:
vor 3 Jahren, 3 Monaten
Beteiligte Autoren:
Sohan, vani, Milton, Arie

Need WD120SQS.DLL for OLEDB connect to SQL Server?

Startbeitrag von Sohan am 16.04.2010 03:25

Hi,

Up till now I have always used native acces to connect to sql server.
Using:

SQLConnect(server, user, pwd, database, "sql server")
Now I want to experiment with connecting through OLEDB.
I tried:

SQLConnect(server, user, pwd, database, "sql server", hOledbSQLServer)
SQLConnect(server, user, pwd, database, "sql server", "SQLNCLI")
But in both cases I get the error:

Unable to load the access DLL "WD120SQS.DLL" or the access DLL "WD120SQLServer.DLL".
WD120SQS.DLL is the library that handles native access to sql server, right? I thought that by using the OLEDB parameter of the SQLConnect command (6th argument), that Windev is instructed not to use native access. So why is it complaining about the DLL? I don't have it. I purchased sql server native access for wd11 some time ago, and I don't want to upgrade. So I have a WD110SQS.DLL but not a WD120SQS.DLL.

Surely I am doing something wrong.

Greetz,
/sohan

Antworten:

Hi Sohan,

If you leave out the argument (6th argument) "sql server" does it work?

I have never used native access but have no problems using oledb to connect to MSSQL databases.

Milton

von Milton - am 16.04.2010 04:25
I believe you should change the "sql server" parameter to "oledb"

SQLConnect(server, user, pwd, database, "oledb", hOledbSQLServer)
or
SQLConnect(server, user, pwd, database, "oledb", "SQLNCLI")
or (depends on the version of sql-client)
SQLConnect(server, user, pwd, database, "oledb", "SQLNCLI10")


von Arie - am 16.04.2010 08:02
Many thanx, Arie, "oledb" did the trick. I have it running now.

Cheers,
/sohan

von Sohan - am 16.04.2010 11:35
Hi ,

gSourceName=gserver+ "\"+gInstance
nTempEXPRESS is an int =SQLConnect( gSourceName, gUsername,gPassword,gDatabase,"OLEDB",hOledbSQLServer)

IF nTempEXPRESS0 THEN
// The connection was successful
Info("The connection was successful")
ELSE
// The connection failed: displaying an error message
SQLInfo()
Error("The connection to the data source failed." + CR + ...
"Error code: " + SQL.Error + CR + SQL.MesError)
END


NOTE:and we need to make sure the SourceName,Username,Password,Database...

von vani - am 02.03.2015 07:47
Zur Information:
MySnip.de hat keinen Einfluss auf die Inhalte der Beiträge. Bitte kontaktieren Sie den Administrator des Forums bei Problemen oder Löschforderungen über die Kontaktseite.
Falls die Kontaktaufnahme mit dem Administrator des Forums fehlschlägt, kontaktieren Sie uns bitte über die in unserem Impressum angegebenen Daten.