Here is the deal breaker. I figure out how to connect VIDA 2014D to my (new
) 2016 S60 and I think this procedure (reserve at least an hour if you're confident with changing data in a database) should work for all P3 cars.Before I provide detailed instructions, enter don't do this warning:
I provide NO guarantee and if you damage your computer/car I'm not taking any responsibility for this.
Here is the guide:
- Download and install Microsoft SQL Server Express 2014 (if using windows 7)
- https://www.microsoft.com/en-us/downloa ... x?id=42299
- Download SQL Management Studio (MgmtStudio 64BIT\SQLManagementStudio_x64_ENU.exe for 64bit system)
- Open the SQL Server Management Studio and open the “basedata” database
- I will provide directions to add 2016 S60 to the database. Read through the following and modify the information for your own car. You might have to modify the bold text.
- Note that the VIN: LYV402FM7GB092244 in not accepted by VIDA. We will modify the database to recognize this VIN.
- Note that the VIN: LYV402FM7GB092244 in not accepted by VIDA. We will modify the database to recognize this VIN.
- We will tell VIDA that this VIN is a part of 2015 model year. First we have to find ID of 2015 model year in “dbo.ModelYear”. Right click on dbo.ModelYear and select “Select Top 1000 Rows”. 2015 model year has ID “1205”.
- Similarly list “dbo.VehicleModel” and find the ID of your car. S60 has the ID 1038.
- Similarly list “dbo.VINDecodemodel”. This table is used to determine the model and year of a car based on your VIN. We will have to locate a similar car (understand VIN comparisons) that fails ONLY because of the year code in the VIN. We will modify a record that matches our car in everything but the YearCode field.
- Modify the SELECT statement to add a filter on your vehicle model by adding “where fkVehicleModel=1038” at the end of the statement. Click F5 to apply this filter.
- Scroll through the fields until you find your ModelYear (in the fkModelYear column). Now you have to compare your VIN. Read the data in VinCompare column. This string has to match your car’s VIN between the VinStartPos and VinEndPos positions. Below you can see that the highlighted row matches my VIN since FM is at 7th and 8th position in the VIN.
- Looking at the rest of the row, the ChassisNoFrom and ChassisNoTo (chassis number from and to) doesn’t contain our car. The chassis number (last 6 digits, 092244 in our case) is lower than 332000.
- The YearCodePos tells you the position of the year code in the VIN. The highlighted row doesn’t correspond to our car because our 10th digit is “G”.
- Modify the SELECT statement to add a filter on your vehicle model by adding “where fkVehicleModel=1038” at the end of the statement. Click F5 to apply this filter.
- We now modify this row to match our VIN. We will lower the ChassisNoFrom to include 092244 and change the YearCode. Fortunately, I don’t need VIDA to read 2015 cars so I’m going to modify this row. It might be the case that VIDA will stop reading 2015 S60 cars because of this modification. The row ID is -2042382967 (from the picture the first number in the row)
- Right click on dbo.VINDecodeModel and select “Edit Top 200 Rows”
.
- We need to add a filter to show only the one particular row. Click on Show SQL Pane button (in red box)
- Add “WHERE ID = -2042382967” and execute the statement by Ctrl+R or by hitting this button:
- Edit the fields as mentioned before.
- Click on the next row for the changes to save. The red exclamation marks should disappear.
- Restart your computer (or restart SQL server and VIDA), enter your VIN.
- Right click on dbo.VINDecodeModel and select “Edit Top 200 Rows”
- Enjoy VIDA and if you feel thankful you can buy me a beer: https://www.buymeacoffee.com/jewY8ab
Cheers!
