How to check the connectivity is in place between the iVend component and the corresponding database
Query:
How to check the connectivity is in place between the iVend component and the corresponding database?
Resolution:
One of the ways is, Create the data link (UDL) file.
Below are the steps to create a data link (UDL) file:
1) Right-click on the Windows desktop screen >> point to New >> and then click "Text Document" >> A new Notepad file will be created >> by default is will be "New Text Document.txt"
2) Open Windows Explorer, and on the Tools menu, click Folder Options. On the View tab, clear the Hide file extensions for known file types check box and then click OK.
3) Right-click the Text Document which you created in step 1, choose Rename, and then change the name and extension of the file to: connection.udl
4) A warning might appear, explaining that changing file extensions could cause files to become unusable. Disregard this warning.
5) You can store the (connection.udl) file anywhere on your system or network.
6) Double-click the (connection.udl) file or you can optionally right-click it, and then click Properties.
7) Fill in the information as per the attached test connectivity file.
8) Click on Test connection.
If the connection is working then you will get a message "Test connection is succeded"
Else you may get any error, like as below:
Or any other error stating that the connection is not working.
This KB article concludes here.
Related Articles
How to check the connectivity is in place between the iVend component and the corresponding database
Version: Not the version-specific Query: How to check the connectivity is in place between the iVend component and the corresponding database? Resolution: One of the ways is, Create the data link (UDL) file. Below are the steps to create a data link ...Cannot open database 'CXSIntegration' login failed
Environment: iVend 6.6 Problem Statement: Cannot open database 'CXSIntegration' login failed Symptoms: Environment Specific Resolution/Work Around: It seems wrong SQL password is entered for user "sa". So need to check correct password for SQL login ...ISSUES WHEN INTIALIZING MASTER TABLES FROM SAP: "iVend 6.*.*.* add-on failed to update the database"
Product version 6.5 Update 6 Problem statement Getting Error "iVend 6.*.*.* add-on failed to update the database" when initializing master tables from SAP Reason CXSINTEGRATION DATABASE IS DELETED SAP database, already initialized with iVend database ...Database health check & Optimization steps
Steps and walkthrough to do a health check and optimization of iVend database. The entire process broadly consists of 8 steps: Step 1: Take Backup of DB. Open SQL Server Management Studio Express and connect to the SQL server. Expand Databases. ...General Settings in SAP Business One
Introduction The iVend Add-on helps in setting up some configurations required for integrating iVend with SAP Business One. The following sections of this document capture the functionality of the new screens created and new fields added to the SAP ...