[ant_87]

Помогите написать сканер sql-серверов в локальной сети(MYSQL,MSSQL,ORACLE), или кто знает какими способами возможно подключиться к определенному удаленному sql-порту и запросить инфу версии СУБД?

[Страдалецъ]

Попробуйте посмотреть функцию NetServerEnum

[ant_87]

Сообщение от Страдалецъ

Попробуйте посмотреть функцию NetServerEnum

а по конкретнее мона?

[Страдалецъ]

Неа, сам тоже на нее поиском наткнулся. Так-что вам флаг в руки. Потом раскажете чем все закончилось.
Есть пример использования на С.

Код:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114

#ifndef UNICODE #define UNICODE #endif   #include <stdio.h> #include <assert.h> #include <windows.h> #include <lm.h>   int wmain(int argc, wchar_t *argv[]) {    LPSERVER_INFO_101 pBuf = NULL;    LPSERVER_INFO_101 pTmpBuf;    DWORD dwLevel = 101;    DWORD dwPrefMaxLen = MAX_PREFERRED_LENGTH;    DWORD dwEntriesRead = 0;    DWORD dwTotalEntries = 0;    DWORD dwTotalCount = 0;    DWORD dwServerType = SV_TYPE_SERVER; // all servers    DWORD dwResumeHandle = 0;    NET_API_STATUS nStatus;    LPTSTR pszServerName = NULL;    DWORD i;      if (argc > 2)    {       fwprintf(stderr, L"Usage: %s [\\\\ServerName]\n", argv[0]);       exit(1);    }    // The server is not the default local computer.    //    if (argc == 2)       pszServerName = argv[1];    //    // Call the NetServerEnum function to retrieve information    //  for all servers, specifying information level 101.    //    nStatus = NetServerEnum(pszServerName,                            dwLevel,                            (LPBYTE *) &pBuf,                            dwPrefMaxLen,                            &dwEntriesRead,                            &dwTotalEntries,                            dwServerType,                            NULL,                            &dwResumeHandle);    //    // If the call succeeds,    //    if ((nStatus == NERR_Success) || (nStatus == ERROR_MORE_DATA))    {       if ((pTmpBuf = pBuf) != NULL)       {          //          // Loop through the entries and          //  print the data for all server types.          //          for (i = 0; i < dwEntriesRead; i++)          {             assert(pTmpBuf != NULL);               if (pTmpBuf == NULL)             {                fprintf(stderr, "An access violation has occurred\n");                break;             }               printf("\tPlatform: %d\n", pTmpBuf->sv101_platform_id);             wprintf(L"\tName:     %s\n", pTmpBuf->sv101_name);             printf("\tVersion:  %d.%d\n",                    pTmpBuf->sv101_version_major,                    pTmpBuf->sv101_version_minor);             printf("\tType:     %d", pTmpBuf->sv101_type);             //             // Check to see if the server is a domain controller;             //  if so, identify it as a PDC or a BDC.             //             if (pTmpBuf->sv101_type & SV_TYPE_DOMAIN_CTRL)                wprintf(L" (PDC)");             else if (pTmpBuf->sv101_type & SV_TYPE_DOMAIN_BAKCTRL)                wprintf(L" (BDC)");                           printf("\n");             //             // Also print the comment associated with the server.             //             wprintf(L"\tComment:  %s\n\n", pTmpBuf->sv101_comment);               pTmpBuf++;             dwTotalCount++;          }          // Display a warning if all available entries were          //  not enumerated, print the number actually          //  enumerated, and the total number available.            if (nStatus == ERROR_MORE_DATA)          {             fprintf(stderr, "\nMore entries available!!!\n");             fprintf(stderr, "Total entries: %d", dwTotalEntries);          }            printf("\nEntries enumerated: %d\n", dwTotalCount);       }    }    else       fprintf(stderr, "A system error has occurred: %d\n", nStatus);    //    // Free the allocated buffer.    //    if (pBuf != NULL)       NetApiBufferFree(pBuf);      return 0; }