Home > database >  SQL Anywhere from 12 other computer local area network (LAN) to connect to the service parameters ho
SQL Anywhere from 12 other computer local area network (LAN) to connect to the service parameters ho

Time:09-27

On the client how to write the connection parameters in the registry,

The Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE \ SOFTWARE \ ODBC \ ODBC.ini \ aQC]
"AutoStop"="YES"
"Description"="aQC"
"Driver"="D: \ \ PROGRA ~ 1 \ \ SQLANY ~ 1 \ \ Bin32 \ \ dbodbc12 DLL"
"UserID"="DBA"
"EncryptedPassword"="25 a8c008641a8b"
"Server"="aQC"
"The Host"="192.200.67.197:2372
"
Server paragraph to start the database parameters:
Dbsrv12. Exe - x tcpip (PORT=2372)

Client side how to write? I can't connect

CodePudding user response:

I use a developer version,

CodePudding user response:

If profilestring (is_app_path + '\ salesystem ini', 'SYSTEM PROFILE', 'ERGEDIT', '0')='1' then
RegistrySet (" HKEY_LOCAL_MACHINE \ SOFTWARE \ ODBC \ ODBCINST SQL Anywhere INI \ 11.0 "and" Driver ", RegString! , is_app_path + "\ \ dbodbc11 DBMS DLL")
RegistrySet (" HKEY_LOCAL_MACHINE \ SOFTWARE \ ODBC \ ODBCINST SQL Anywhere INI \ 11.0 ", "Setup", RegString! , is_app_path + "\ \ dbodbc11 DBMS DLL")
RegistrySet (" HKEY_LOCAL_MACHINE \ SOFTWARE \ ODBC \ ODBCINST SQL Anywhere INI \ 11.0 the Translator "and" Driver ", RegString! , is_app_path + "\ \ dbctrs11 DBMS DLL")
RegistrySet (" HKEY_LOCAL_MACHINE \ SOFTWARE \ ODBC \ ODBCINST SQL Anywhere INI \ 11.0 the Translator ", "Setup", RegString! , is_app_path + "\ \ dbctrs11 DBMS DLL")
RegistrySet (" HKEY_LOCAL_MACHINE \ SOFTWARE \ ODBC \ ODBCINST SQL Anywhere INI \ 11.0 the Translator ", "the Translator", RegString! , is_app_path + "\ \ dbctrs11 DBMS DLL")
RegistrySet (" HKEY_LOCAL_MACHINE \ SOFTWARE \ ODBC \ ODBCINST INI \ ODBC Drivers ", "11.0" SQL Anywhere, RegString! , "Installed")
RegistrySet (" HKEY_LOCAL_MACHINE \ SOFTWARE \ ODBC \ ODBCINST INI \ ODBC Translator ", "11.0 the Translator SQL Anywhere," RegString! , "Installed")
RegistrySet (" HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Windows \ CurrentVersion \ App Paths \ dbeng11 exe ", "path", RegString! , is_app_path)
RegistrySet (" HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Windows \ CurrentVersion \ App Paths \ dbeng11 exe ", "", RegString! , is_app_path + "\ \ dbeng11 DBMS exe")
RegistrySet (" HKEY_CURRENT_USER \ Software \ ODBC \ ODBC.ini \ ODBC Data Sources ", "WRM," RegString! SQL Anywhere, "11.0")
RegistrySet (" HKEY_CURRENT_USER \ Software \ ODBC \ ODBC.ini \ WRM ", "AutoStop," RegString! , "yes")
RegistrySet (" HKEY_CURRENT_USER \ Software \ ODBC \ ODBC.ini \ WRM ", "DatabaseFile", RegString! , is_app_path + "\ \ sale DBMS db")
RegistrySet (" HKEY_CURRENT_USER \ Software \ ODBC \ ODBC.ini \ WRM ", "DatabaseName", RegString! The "Sale")
RegistrySet (" HKEY_CURRENT_USER \ Software \ ODBC \ ODBC.ini \ WRM "and" Driver ", RegString! , is_app_path + "\ \ dbodbc11 DBMS DLL")
RegistrySet (" HKEY_CURRENT_USER \ Software \ ODBC \ ODBC.ini \ WRM ", "PWD", RegString! , "SQL")
RegistrySet (" HKEY_CURRENT_USER \ Software \ ODBC \ ODBC.ini \ WRM ", "Start", RegString! , is_app_path + "\ \ dbeng11 DBMS exe")
RegistrySet (" HKEY_CURRENT_USER \ Software \ ODBC \ ODBC.ini \ WRM ", "UID", RegString! , "dba")
Setprofilestring (is_app_path + '\ salesystem ini', 'SYSTEM PROFILE', 'ERGEDIT', '0')
end if

CodePudding user response:

The above is the native way, local area network (LAN) should be the same, just different parameters

CodePudding user response:

Upstairs, the machine is connected to the database of writing, I see the content of local area network (LAN) connection reference

CodePudding user response:

Give you a reference:

The Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER \ Software \ ODBC \ ODBC.ini \ WellSoft]
"AutoStop"="yes"
"Driver"="dbodbc8. DLL"
"The AutoCommit mode"="false"
"Language"="useful"
"EngineName"="ASAServer"
"Commlinks"="TCPIP {}"

LAN I can connect,

CodePudding user response:

Account password I write in the program

CodePudding user response:

Useless, you even you don't configure odbc remote connection? You don't have to dbodbc11. These DLL DLL?

CodePudding user response:

My client is using Delphi and odbc to connect to the Internet database, you can write registry:
[HKEY_LOCAL_MACHINE \ SOFTWARE \ ODBC \ ODBC.ini \ JZXJ]
"Driver"="D: \ \ \ \ motor vehicle driving license applicants admitted to the university archives management information system dbodbc8. DLL"
"UID=" DBA "
"EncryptedPassword"="0 d3ac2a255ebe294f1f194ed57"
"EngineName"="JZXJ"
"AutoStop"="Yes"
"Integrated"="No"
"Delphi"="Yes"
"Compress"="No"
"DisableMultiRowFetch"="No"
"Debug"="No"
"CommLinks"="TCPIP={host 51.17.189.215}"
  • Related