| |
| Publicado el 20,octubre 2014 - 04:19 |
Hi All
It is possible to use WD with SQL native Access on Windows 64 bit to MS-SQL-2000 ?
WD Current configuration use SQL OLE DB with Windows 32 bit to MS-SQL-2000,
Fail to use SQL OLE DB with Windows 64 bit (not supported) to MS-SQL-2000.
Note: MS-SQL-2000 (share database with non windev application)
Thanks in advance
Toddy |
| |
| |
| | | |
|
| | |
| |
| Publicado el 20,octubre 2014 - 10:39 |
If you generate you app for 32 bits you can use the native access if you choose the dbnetlib option.
In 64 bits mode the only option for the native access is sqlncli.
You have to check in the microsoft site if you can find any version of sqlncli that supports mssql 2000. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 20,octubre 2014 - 17:08 |
Hi, Paulo
The help for Native SQL Server Access:
SQL2000 version does not support sqlncli
Thanks and Regards
Toddy |
| |
| |
| | | |
|
| | |
| |
| Publicado el 20,octubre 2014 - 19:20 |
I don´t know if it's possible in WD19 but in WD18 it is, i'm using WD18 with sql server native access and mssql 2000. The clients are windows 8.1 64 bits and the mssql is in windows 2000 server, my app is generated for 64 bits.
The only thing i had to use was WD CLIENT VERSION=2000 in the extended information of the connection. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 21,octubre 2014 - 04:20 |
Paulo
Thanks for the info.
Current SQL-2000 sp4 on Windows Server 2008 (64 bits).
I will ask PC Soft to make sure this, before buying SQL native access.
Regards
Toddy |
| |
| |
| | | |
|
| | |
| |
| Publicado el 22,octubre 2014 - 14:43 |
Toddy
From my understandings, correct me if I'm not, the native needs sqlserver client and
it is same as using native progress driver and pcsoft sql native access driver is backward
capatible but we all know that you have to stick to the latest native version if you're
using latest wx.
That's all I have as I do have both native progress/sqlserver2012 (but I don't see
much different in speed while using sqlClient 11)
Regs
King |
| |
| |
| | | |
|
| | |
| |
| Publicado el 23,octubre 2014 - 03:26 |
King
The problem is SQL2000 client connectivity do not support windows64 bits.
It is imposible to upgrade SQL2000 because old non wd application still running.
I just want to make sure before buying SQL native access,
it's can run in windows64 bits and use existing SQL2000
Thanks and Regards
Toddy |
| |
| |
| | | |
|
| | |
| |
| Publicado el 23,octubre 2014 - 03:59 |
Toddy
The SQL native access comes with 64-bit/32-bit of v19,18,17,16 and
if SQL2000 dun hv 64-bit then you have to use v19.32bit SqlNative to talk
to SQL2000-32-bit's. I have both 32/64-bit tested in windows 64 bits.
HTH
Cheers
King |
| |
| |
| | | |
|
| | |
| |
| Publicado el 23,octubre 2014 - 10:07 |
King
Thanks for your info
I will ask to Pc Soft support further.
Regards
Toddy |
| |
| |
| | | |
|
| | |