Anonymous KH
asked on
Microsoft ODBC
Dear Experts,
My client using Win 7 Pro x64 bit are able to access their inhouse software.
Now with the new Processor, we cannot downgrade to Win 7.
It is a Win 10 Pro x64.
The issue now is in the odbcad32, System DNS, I tried to add the SQL server
It says
"Connection failed:
SQLState: '08002'
SQL Server Error: 0
[Microsoft]ODBC SQL Server Driver]SQL Server version 6.5 and all previous versions are no longer supported
My client using Win 7 Pro x64 bit are able to access their inhouse software.
Now with the new Processor, we cannot downgrade to Win 7.
It is a Win 10 Pro x64.
The issue now is in the odbcad32, System DNS, I tried to add the SQL server
It says
"Connection failed:
SQLState: '08002'
SQL Server Error: 0
[Microsoft]ODBC SQL Server Driver]SQL Server version 6.5 and all previous versions are no longer supported
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi! Guys,
I don't think I can suggest to my client to upgrade their SQL version as they are using some in-house software to manage their client database and matters.
In Win7 Pro x64, I will go to C:\Windows\SysWOW64\odbcad 32.exe
The System DNS tab which is empty I will add 3 records, they are
account, acct2000, and infobase
Under which SQL server to connect to I will select
WLAWSQL, WLAWSQL and X.x.x.x
Click Next
I select With SQL Server authentication using a login ID and password entered by the user user
In Connect to SQL Server to obtain default settings for the additional configuration options,
I enter Login ID: sa and the password.
I will put a tick to Change the default database is Account, Account and Infobase
Click Next and Finish.
Click on Test Data Source -> TESTS COMPLETED SUCCESSFULLY!
Click Ok and Ok
The record will display
Name Driver
account SQL Server
acct2000 SQL Server
infobase SQL Server
When I did this for Win 10 Pro x64, only infobase was added successfully, the other two had the error.
I don't think I can suggest to my client to upgrade their SQL version as they are using some in-house software to manage their client database and matters.
In Win7 Pro x64, I will go to C:\Windows\SysWOW64\odbcad
The System DNS tab which is empty I will add 3 records, they are
account, acct2000, and infobase
Under which SQL server to connect to I will select
WLAWSQL, WLAWSQL and X.x.x.x
Click Next
I select With SQL Server authentication using a login ID and password entered by the user user
In Connect to SQL Server to obtain default settings for the additional configuration options,
I enter Login ID: sa and the password.
I will put a tick to Change the default database is Account, Account and Infobase
Click Next and Finish.
Click on Test Data Source -> TESTS COMPLETED SUCCESSFULLY!
Click Ok and Ok
The record will display
Name Driver
account SQL Server
acct2000 SQL Server
infobase SQL Server
When I did this for Win 10 Pro x64, only infobase was added successfully, the other two had the error.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi! Lee,
I know what you mean. The server is virtualised in a VMWare environemnt.
The thing is that the developer of the company has left a few years so there is no one who has the knowledge of upgrading their SQL servers to a new version.
We are hoping to get the user connected to the SQL database first, the upgrading will come until Microsoft ends the use of Win 7 Pro.
I know what you mean. The server is virtualised in a VMWare environemnt.
The thing is that the developer of the company has left a few years so there is no one who has the knowledge of upgrading their SQL servers to a new version.
We are hoping to get the user connected to the SQL database first, the upgrading will come until Microsoft ends the use of Win 7 Pro.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
My boss told me that the Windows 7 Pro is using a different driver
In the SQL Server driver, - it shoud be version 6.01.7601.17514, hopefully can find this driver for Win10 is there any compatibility issue where it does not Win10?
In the SQL Server driver, - it shoud be version 6.01.7601.17514, hopefully can find this driver for Win10 is there any compatibility issue where it does not Win10?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi! Qlemo,
I am tring to find v6.01.7601.17514 for Windows 10.
I am tring to find v6.01.7601.17514 for Windows 10.
ASKER
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
We are thinking of installing a Virtual Winj7 Pro PC inside Win10.
ASKER
The server version is Microsoft SQL Server 6.5