Subject Creating an sql link from dbase From Michael <michael@itntgroup.com.au> Date Fri, 20 Jul 2018 19:42:38 -0400 Newsgroups dbase.getting-started Hi Guys, I need to write to a dbase table on the web for an interface, can anyone translate these instruction in english step by step so I know what i am doing? How do I do this from DBASE 11? This is the data to translate, Create a direct connection or a odbc connections as below The working connection strings are below 1.        Connecting direct ( sample string below ) The DBMSSOCN  may not be required as it simply forces to use TCP "Network Library=DBMSSOCN;MultipleActiveResultSets=True;Data Source=202.183.123.24,52590;Initial Catalog=z_test;User Id=KeyAddOnSAPTest;Password=password" 2.        Connecting ODBC The connection string should be as below for Local PC ( residing in the network )  - port is not mandatory if you are specifying server as Server\instancename "Driver={SQL Server};Server=SQLServerName;UID=sa;PWD=password;Database=SBODemoAU;PORT=1000" The connections string should be as below for remote ( ZT sample below ) "Server=ipaddress,sqlport;UID=sa;PWD=password;Database=demo" The credentials for the test database Sever ip = 202.183.123.24 Port = 52590 Database name= z_test SQL User id  = KeyAddOnSAPTest Sql password = will sms this one How do i do it? Regards, Michael.