Mysql error code 2147467259

Содержание

Форум пользователей MySQL
#1 25.12.2007 05:46:28
Ошибка -2147467259
PRB: Error -2147467259 When You Try to Open the Same MDB File from Multiple Instances
Symptoms
Cause
Resolution
Status
More Information
References
Mysql error code 2147467259
BullZip Home
Error: -2147467259
Error: -2147467259
Re: Error: -2147467259
Re: Error: -2147467259
Re: Error: -2147467259
Re: Error: -2147467259
Mysql error code 2147467259
Answered by:
Question
Answers
All replies

Форум пользователей MySQL

Задавайте вопросы, мы ответим

Страниц: 1

#1 25.12.2007 05:46:28

Ошибка -2147467259

Помогите справится с проблемой!

Купил я один сайт написаный на ASP. Он поддерживает 3 БД(MSAccess,MSSQL,MySQL). По умолчанию все настроено на Базу Данных MS ACCESS, но так как мне нужно было переделать его на 3 языка (English, Russian, Latvian), то сталкнулся с проблемой кодировки на UTF-8. Решил перейти на MySQL. В мануале написанно:

MySQL Database Configuration.
Create a new database at web hosting Control Panel (refer to hosting documentation for procedures). In config/config.asp configuration file find ‘*** MySQL DATABASE *** section and change variables for MySQL server name, User ID, Password and Database Name.
If for instance you have server name — mysql1.myhosting.net, database name – xx_database, User ID – xx_user and password – cryptic_word, then configuration variables would look like:
‘# MySQL SERVER NAME (PROVIDED BY YOUR HOST)
MySQLServer = «mysql1.myhosting.net»
‘# MySQL USER ID (AUTHENTICATION)
MySQLUser = «xx_user»
‘# MySQL PASSWORD (AUTHENTICATION)
MySQLPassword = «cryptic_word»
‘# MySQL DATABASE NAME
MySQLDBName = «xx_database» Save config.asp and transfer it to the web server. Continue with the next step in “New Setup Instructions” (previous chapter).

посавил я MySQL последную версию. но не фига в ней неразбираюсь. Как то создал пустую базу xx_database.

‘# MySQL SERVER NAME (PROVIDED BY YOUR HOST)
MySQLServer = «127.0.0.1»
‘# MySQL USER ID (AUTHENTICATION)
MySQLUser = «xx_user»
‘# MySQL PASSWORD (AUTHENTICATION)
MySQLPassword = «cryptic_word»
‘# MySQL DATABASE NAME
MySQLDBName = «xx_database»

дальше . как я понимаю. я должен указать путь в config.asp на созданную БД
но проблема такая что я не знаю как ето сделать. и где вообще эта БД находится.

вот кусок из config.asp

dbFolder = «db/»
upload = «cl_upload/»
bnrLocation = «banners/»
ad_cache = «ads/»
logo = «img/logo.gif»

MySQL ставил все по умолчанию, по идее БД должна наверное находится тут:

C:/Program Files/MySQL/MySQL Server 5.0/Data/xx_database

но если я пишу в config.asp так:

dbFolder = «C:/Program Files/MySQL/MySQL Server 5.0/Data/xx_database/»
upload = «cl_upload/»
bnrLocation = «banners/»
ad_cache = «ads/»
logo = «img/logo.gif»
то мне выдает такую ошибку:

-2147467259 [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Current Database Provider Connection String is:

strConn = «Driver=;server=127.0.0.1;uid=xx_user;database=xx_database;»
Подскажите пожалуста что делать.

Источник

PRB: Error -2147467259 When You Try to Open the Same MDB File from Multiple Instances

Symptoms

If you try to use a Microsoft Jet (Access) database from multiple instances of the same application either on the same computer or on different computers, you receive the following error message:

-2147467259 Error ODBC Microsoft Access Driver: The database has been placed in a state by an unknown user that prevents it from being opened or locked.

This error occurs with both the Microsoft ODBC Driver for Access and the OLE DB Provider for Jet.

Cause

To run an .mdb file by multiple instances, Jet makes use of a lock delay and retry interval. However, under high load conditions, you may exceed these intervals.

Resolution

Microsoft provides programming examples for illustration only, without warranty either expressed or implied, including, but not limited to, the implied warranties of merchantability and/or fitness for a particular purpose. This article assumes that you are familiar with the programming language being demonstrated and the tools used to create and debug procedures. Microsoft support professionals can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific needs.
If you have limited programming experience, you may want to contact a Microsoft Certified Partner or Microsoft Advisory Services. For more information, visit these Microsoft Web sites:

For more information about the support options that are available and about how to contact Microsoft, visit the following Microsoft Web site:http://support.microsoft.com/default.aspx?scid=fh;EN-US;CNTACTMSThe following workaround extends the retry delay for Jet so that you can use additional instances. However, it is not recommended that you use this workaround if a high number of updates are being formed; this workaround is intended only for reading databases.

You can add the following sample error handler to your code. Please note that this handler only works with ADO and uses the Sleep function, which you must declare in your general declarations section.

Status

This behavior is by design.

More Information

The above-mentioned workaround is only for read-only mode. Microsoft does not support placing Jet .mdb files under high user load. Microsoft strongly recommends that you use Microsoft SQL Server or Microsoft Data Engine (MSDE) instead of Access when high user loads (that is, more than 15 instances) are required or anticipated, especially when updating is required.

References

For more information about the Sleep function, refer to the MSDN Library documentation.

Источник

on executing the following

System.Data.SqlServerCe.SqlCeException was unhandled
HResult=-2147467259
Message=There was an error parsing the query. [ Token line number = 1,Token line offset = 1,Token in error = IF ]
Source=SQL Server Compact ADO.NET Data Provider
ErrorCode=-2147467259
NativeError=25501

StackTrace:
at System.Data.SqlServerCe.SqlCeCommand.ProcessResults(Int32 hr)
at System.Data.SqlServerCe.SqlCeCommand.CompileQueryPlan()
at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options)
at System.Data.SqlServerCe.SqlCeCommand.ExecuteScalar()
at ieNotepadDotNetTabbed.DBStorage.needAlterRepository4M2()
at ieNotepadDotNetTabbed.MainForm.MainForm_Load(Object sender, EventArgs e)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Windows.Forms.Form.OnLoad(EventArgs e)
at System.Windows.Forms.Form.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.SafeNativeMethods.ShowWindow(HandleRef hWnd, Int32 nCmdShow)
at System.Windows.Forms.Control.SetVisibleCore(Boolean value)
at System.Windows.Forms.Form.SetVisibleCore(Boolean value)
at System.Windows.Forms.Control.set_Visible(Boolean value)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.Run(Form mainForm)
at ieNotepadDotNetTabbed.Program.Main(String[] args)
at System.AppDomain._nExecuteAssembly(RuntimeAssembly assembly, String[] args)
at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()
InnerException:

I tried searching the web to see if used any sql not usable on ce, but did not find any the list of not to use

it’s not the system table like schema_name and table__name, I hope.

is there any other way acceptable to sql ce 4 to find is a column not exists in a table?

Источник

BullZip Home

This is the Bullzip forums where you can exchange information on the Bullzip products.

Error: -2147467259

Moderator: jr

Error: -2147467259

Post by ssmony » Wed Oct 15, 2008 1:45 am

Pls help, I am getting the following error:

Program Version: 3.0.0.97
ODBC Version: 5.1.5.0
Function: modMySql.MoveData2MySql
Error: -2147467259
Reason: [MySQL][ODBC 5.1 Driver][mysqld-5.0.41-community-log]Access denied for user ‘xxx’@’%’ to database ‘zzzzz’
SQL: CREATE DATABASE IF NOT EXISTS `zzzzz`

Thanks for any assistance in advance.

Re: Error: -2147467259

Post by navjyotiu » Wed May 13, 2009 4:01 pm

Re: Error: -2147467259

Post by slgoetze » Fri May 29, 2009 10:34 pm

Re: Error: -2147467259

Post by Kim » Sun Jul 11, 2010 5:54 pm

I get this same error.

Reason: [MySQL][ODBC 5.1 Driver]Access denied for user ‘mlmnetwo_mlmcafe’@’dyn-dsl-to-76-75-114-131.nexicom.net’ (using password: YES)

I have checked and re-checked my user name and password and still get this error.

Re: Error: -2147467259

Post by williamjacobs » Tue Nov 15, 2011 9:35 pm

With a similar error message:

SETTINGS
———
Moving data directly to MySQL server

TABLES
————
Error connecting to destination database.
Connection: Provider=MSDASQL.1;Driver=;Extended Properties=»SERVER=localhost;UID=stoner;PWD=;PORT=3306;OPTION=0;STMT=;»
Program Version: 3.0.0.148
ODBC Version: 5.1.8.0
Function: modMySql.MoveData2MySql
Error: -2147467259
Reason: [MySQL][ODBC 5.1 Driver]Access denied for user ‘stoner’@’localhost’ (using password: NO)

I found that my end user was using his Windows ID in the Bullzip Access to MySQL setup wizard where you are asked to enter credentials for the MySQL database.
MySQL may not have been setup with the end user’s Windows ID as his login id. The command line may not even ASK for a ID. It only asks for password.
Defaults for MySQL during setup are the ID «root» and a blank password (Just hit «Enter»)

Using the ID of «root» in the MySQL configuration portion allowed Bullzip to convert the MS Access database to MySQL.

Источник

Mysql error code 2147467259

This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.

Answered by:

Question

Unable to install SQL Server (setup.exe.)

Exit code (Decimal): -2147467259Error description: The system cannot find the path specified

Answers

i found article «Cleanly Uninstalling Stubborn SQL Server Components» and follow through step on this article

It is work for me and then I re install SQL Server 2019 again but this time my install work very well.

Sorry for my English and I can’t post link directly

>>Error description: The system cannot find the path specified

The error message «The system cannot find the path specified» showed that there are some files of SQL Server basic component couldn’t be located. It is possible that these files are corrupted or the access for these files is denied.

I would suggest you running the SQL Server installation media as administrator. When you reinstalling the SQL Server, on server configuration page, please change the SQL Server Database Engine account and SQL Server Agent account to local System(NT AUTHORITYSYSTEM) to ensure these accounts have enough permission.

Источник

Option Compare Database
Option Explicit
 
'--------------------------------------------------------------------------
' Module    : modLink_MySQL_ADOX
' Author    : es
' Date      : 24.07.2017
' Purpose   : Переподключение таблиц MySQL без DSN
'--------------------------------------------------------------------------
' - Требует установки MySQL ODBC ODBC MySQL драйвера
'--------------------------------------------------------------------------
'Требуются ссылки на:
'    Microsoft ADO Ext. for DDL and Security. (Version 2.1 or higher)
'    Microsoft ActiveX Data Objects Library. (Version 2.1 or higher)
'--------------------------------------------------------------------------
 
 
Public ConnStr$
Private cat As ADOX.Catalog
Private tbl As ADOX.Table
Private AConnectionString_ADOX As String
Private i%, s$
 
Public Sub StartReLink_MySQL_ADOX(Optional bDelOnly As Boolean)
'Собственно процедура подключения (основная)
 
Dim arrTables() As Variant
Dim arrTables_1() As Variant
 
'--------------------------------------------------------------------------
On Error GoTo StartReLink_MySQL_ADOX_Err
    DoCmd.Hourglass True 'Показать часики
 
 
'Массив табличек:
    arrTables = Array("Amper", "Baza", "Baza_Pitatel", "Cat_Empl", "Chet", "Chet_Kompl", "Cklad", "Vid_Nomenkl_ERP", "Klaccif_Nomenkl_ERP", "Uroven_Ctrykt_ERP", _
        "Cklad_Dvig_Izd", "Cod_Empl", "Cotrydnik", "Cpecifikaciy", "Cpecifikaciy_Pza1", "Cpr_Nomenkl_ERP", "Ctryktyra_Izdely_ERP", _
        "Cpocob_Per_Zak", "Cpr_Dorabotok", "Ctr_Izd_Modyl", "Ctr_Izd_Ocnov", "Ctrana", "Licev_Nakl_Izdelie", "Licev_Nakl_Plan_Vipycka_Izd", "Licev_Nakl_Prixod", "Licev_Nakl_Racxod", "Izdelie_Licev", _
        "Ctryktyra_Izdely", "Cvoictva_Znach", "Cvoictvo_Detali", "Dolznoct", "Dop_Zamena", "Operacii_ERP", "Izdely_Operacii_ERP", _
        "Edinicy_Izmereny", "Forma_Cobctv", "Funk_Claim", "Funk_Otvetctv_Za_Vip", _
        "Funk_Pol_Inform", "Funk_Procecc", "Funk_Structure", "Funk_View", "Funk_Ychactv_V_Vip", _
        "Gorod", "Grup_Empl", "Gryp_Clozn_Rem", "Icpolnenie", "Identifikator_Izd", _
        "Invent_Cklad", "Izdelie", "Izdelie_copy", "Izdelie_Komplekty", "Izd_Preemnik", "Izdelie_Modifikaciy", "Izdelie_TO", _
        "Izdely_Gryp", "Izv_Cogl", "Izv_Cogl_Jyrnal_Cob", "Izv_Ctatyc", "Izv_Formylirovki", _
        "Izv_Izdelie", "Izv_Jyrnal_Cob", "Izv_Koment", "Izv_Koment_Jyrnal_Cob", "Izv_Modul", "Izv_Kritichnoct", _
        "Izv_Vid_Cogl", "Izveshenie", "Level_Competence", "Mecto_Xraneniy", "Modifikaciy", _
        "Modyl", "Name_Funk", "Name_Group", "NameFunk", "Necootvetctv", "Oboryd_TO", _
        "Oborydovanie", "Ogr_Cpicok", "ooDecim_Nomer", "ooGryppa_Izd", "ooKlacc_Izd", _
        "ooPodgryppa_Izd", "ooPodklacc_Izd", "ooPor_Regictr_Nomer", "ooVid_Izd", "Operaciy_Cklad", _
        "Operaciy_Oboryd", "Operaciy_Texnol", "Operaciy_Vipol", "Opicanie_Cvoictv", "Org_Ctrykt", _
        "Organizat_Role", "Otdel", "Pitatel", "Bab_Fid_Yct", "Fider", "Fider_Kompon_Progr", "Fider_Pit", _
        "Racpolozenie", "Pitatel_Partia", "Pitatel_Xarakter", "Plata_Defekt", "Poctavchik", _
        "Porycheniy", "Prichina_Vozvr_Iz_OTK", "Privyzka_Coctava", "Process", "Process_A", "Progr", "TP_Mex", "TP_Mex_Vibor", "TP_Mex_Vipoln", "Partiy_Mex", "Peremesh_Mex", _
        "Proizvod", "R_RA", "Rabota_Robotov", "Requ_For_Specialty", "Site", "Sites_1", "Texprocecc", _
        "Tip_Dokym", "Tip_Operaciy", "To_I_R", "To_I_R_Prichina", "To_I_R_Cherez_Cklad", "To_I_R_Cherez_Cklad_copy", "Obmenniy_Fond", "To_Izd", "Imiy_Shkafa", "To_Izd_Cpicok_Rab", _
        "To_Obor_Cpicok_Rab", "Verciy_PO", "Verciy_Po_Aktualn", "Vid_Rabot", "Vid_Rabot_To", _
        "Vizm_Neicpr_Napominal", "Vozm_Neicpr_Priborov", "Volt", "Vozvrat_Iz_Otk", "Vxod_Kontrol", "Zakaz", "Zakazchik", "Bx_Kontr_Nomenkl", "Bx_Kontr_Zyrnal", "Cootvetctvie", _
        "Zip", "Zip_Cklad", "Zip_Cklad_Racxod", "Zip_Dvigenie", "Zip_Imia", "Zip_Mex_Cbor", "Klacter_Remonta", "Klacter_Remonta_Org", _
        "Zip_Partiy", "Zip_Partiy_Brem_Nakleika", "Zip_Poctavshik", "Zip_Vid", "Zip_Ynikaln", "Izdelie_Verciy_PO", "Dokyment", _
        "Imenovanie", "Klassif_Schtrix", "Texprocecc_Izd", "Klaccif_Nomer_PO", "Reviziy_PO", "Tip_Failov_PO", "Remont", "Kod_1_Panel_IHM", "Kod_2_Panel_IHM", "Kod_3_Panel_IHM", "Kod_4_Panel_IHM", "Kod_Coctav_Modyley_VV", "Kod_Tip_Mezonina_Cviazi", "Kod_Tip_Modyl_Proceccora", "Kod_Tip_Razmeri_Korpyca", "Kod_Vercii_PO", "Ciriyc_New", "Ciriyc_New_Racborka")
    'arrTables = Array("Uroven_Ctrykt_ERP", "Cpr_Nomenkl_ERP", "Ctryktyra_Izdely_ERP", "Operacii_ERP", "Izdely_Operacii_ERP")
 
'--------------------------------------------------------------------------
'Предварительный промсмотр (если нужно):
    Debug.Print String(74, "-")
    For i = LBound(arrTables) To UBound(arrTables)
        s = arrTables(i)
        Debug.Print Format(i + 1, "000"); ".  " & s
    Next i
    Debug.Print String(74, "-")
    Debug.Print "Всего: " & Format(i, "00") & " таблиц " & Now
    Debug.Print String(74, "-")
'--------------------------------------------------------------------------
    'GoTo StartReLink_MySQL_ADOX_Bye
    
'Запуск
    'ReLinkTables_ADOX arrTables, "00_", bDelOnly    ' Полное переподключение
    ReLinkTables_ADOX arrTables, , bDelOnly    ' Полное пере-подключение
 
StartReLink_MySQL_ADOX_Bye:
    DoCmd.Hourglass False 'Вернуть нормальный курсор
    Exit Sub
 
StartReLink_MySQL_ADOX_Err:
    MsgBox "Error: " & Err.Number & vbCrLf & Err.Description & vbCrLf & _
    "in procedure: StartReLink_MySQL_ADOX in module: modLink_MySQL_ADOX", _
    vbCritical, "Error in Application!": Err.Clear
    Resume StartReLink_MySQL_ADOX_Bye
        
End Sub
 
Private Sub ReLinkTables_ADOX(arrTables() As Variant, Optional sTblLocalPrefix$ = "", Optional bDelOnly As Boolean)
' Вспомогательная -  Переподключение таблиц по массиву
'--------------------------------------------------------------------------
'Аргументы:
'   arrTables()      = Массив табличек
'   sTblLocalPrefix  = Локальный префикс названий
'   bDelONly         = Только удалить и не подключать если = True (-1)
'--------------------------------------------------------------------------
Dim sTblName$
Dim sDriver As String
Dim sServerAdr As String
Dim sCharset As String
Dim sServPort As String
Dim sDbName As String
Dim sUser As String
Dim sPassWord As String
Dim l&
 
On Error GoTo ReLinkTables_ADOX_Err
 
    
    If Dir("C:Program FilesMySQLConnector ODBC 3.51", vbDirectory) <> "" Then
        sDriver = "{MySQL ODBC 3.51 Driver}" 'Папка Connector ODBC 3.51 существует. Драйвер для 32 разрядной операционной системы(для устаревших компьютеров- где дополниетльные программы (требующиеся для работы этого драйвера) плохо или не ставятся вовобще)
    ElseIf Dir("C:Program FilesMySQLConnector ODBC 5.3", vbDirectory) <> "" Then
        sDriver = "{MySQL ODBC 5.3 Unicode Driver}" 'Драйвер для 32 или драйвер для 64 разрядного MS Office - в зависимости , что установлено. Имя папки одинаковое.
    Else
        MsgBox "Нет драйвера ODBC для работы с  MySQL"
        Exit Sub
    End If
    
    'sServerAdr = "localhost"
    sServerAdr = "managementdb.rza.ru"   ' Адрес (Имя) сервера
    sServPort = "3306"         ' Порт соединения = 3306 (Обычно так и есть)
    sDbName = "management" ' Название базы
    sUser = "management"             ' Имя пользователя
    sPassWord = "123456"    ' Пароль
 
s = ""
'Создаю строку подключения:
 ConnStr = ";DRIVER=" & sDriver & _
        ";SERVER=" & sServerAdr & _
        ";Port=" & sServPort & _
        ";DATABASE=" & sDbName & _
        ";USER=" & sUser & _
        ";PASSWORD=" & sPassWord & _
        ";OPTION=3" & _
        ";stmt=set names cp1251"
        Debug.Print ConnStr
        Debug.Print String(74, "-")
    
    
'Строим строку подключения ... - добавляем "ODBC;" в начало уже готовой (см выше)
    AConnectionString_ADOX = "ODBC;" & ConnStr
 
'Катплог
    Set cat = New ADOX.Catalog
    'Открываем каталог текущей базы
    Set cat.ActiveConnection = CurrentProject.Connection
 
'Удаление всех таблиц по именам
     For i = LBound(arrTables) To UBound(arrTables)
        sTblName = arrTables(i)
        s = sTblLocalPrefix & sTblName
        DelTable_ADOX s
    Next i
    cat.Tables.Refresh
    Debug.Print String(74, "-")
 
    If bDelOnly = True Then GoTo ReLinkTables_ADOX_Bye
'Подключение  всех по именам
    For i = LBound(arrTables) To UBound(arrTables)
        sTblName = arrTables(i)
        'Debug.Print Format(i, "000") & " - " & sTblName
        LinkTable_ADOX sTblName, AConnectionString_ADOX, sTblLocalPrefix & sTblName
    Next i
    
'Отчёт о проделанной работе
    'Debug.Print String(74, "-")
    Debug.Print "Подключено: " & Format(i, "000") & " таблиц " & Now
    Debug.Print String(74, "-")
 
    
ReLinkTables_ADOX_Bye:
    On Error Resume Next
    'Обновляем список таблиц
    cat.Tables.Refresh
    
    cat.ActiveConnection.Close
    Set cat = Nothing
    Set tbl = Nothing
    
    'Keep_ADO_Connection
    Exit Sub 'Ура!!!
 
ReLinkTables_ADOX_Err:
    s = "Error " & Err.Number & vbCrLf & Err.Description & vbCrLf & _
    "In procedure: ReLinkTables_ADOX in module: modCommon_ADOX"
    Debug.Print s
    MsgBox s, vbCritical, "Error in Application!"
    Err.Clear
    Resume ReLinkTables_ADOX_Bye
End Sub
Private Sub DelTable_ADOX(s$)
'Удаление подлинковки.
    On Error Resume Next
    cat.Tables.Delete s
    If Err = 0 Then Debug.Print s & " ... Deleted!"
    Err.Clear
End Sub
 
Private Sub LinkTable_ADOX(stRemTName As String, strConnect As String, Optional strLocalTableName As String = "")
'es 08.05.2017
'Подлинковка таблички MySQL Server с автоматическим созданием DSN (ADOX)
'Использует общие переменные данного модуля (так короче и возможно быстрее)
'-------------------------------------------------------------------------
'Аргументы:
'   stRemTName  = Имя таблицы на сервере
'   strConnect  = Строка подключения к серверу с "ODBC:DRIVER = ..."
'   strLocalTableName = Локальное Имя Таблицы
'-------------------------------------------------------------------------
 
On Err GoTo LinkTable_ADOX_Err
'Если локальное имя не указанно
    If strLocalTableName = "" Then strLocalTableName = stRemTName
    
     Set tbl = New ADOX.Table
 
'Установка параметров таблицы
    With tbl
        .Name = strLocalTableName
        Set .ParentCatalog = cat
        .Properties("Jet OLEDB:Link Provider String") = strConnect
        .Properties("Jet OLEDB:Remote Table Name") = stRemTName
        .Properties("Jet OLEDB:Create Link") = True
    End With
    
'Создаём новый обьект
    cat.Tables.Append tbl
    'cat.Tables.Refresh
    
LinkTable_ADOX_Bye:
    Exit Sub
 
LinkTable_ADOX_Err:
    'LinkTable_ADOX = Err.Number
    Debug.Print "Error " & Err.Number & vbCrLf & Err.Description & vbCrLf & _
            "in Function: esLinkTable_ADOX"
    Resume LinkTable_ADOX_Bye
End Sub

Источник

Remove From My Forums

Question
First, I have got an ODBC connection to MySQL working both from within the ‘ODBC sources’ program provided within Windows, and from within Excel itself by going through the ‘Data Sources’ tab on the ribbon and using the wizard.

I can therefore pull in data from my MySQL into my workbook using this latter method. My issue is however that I cannot get PowerQuery working even following the instructions on the office site.

1. When I click the Power Query tab I select the option to choose ‘From database‘ >
‘From MySQL Database’

2. At this point I am asked for the Server Name and the
Database Name; for the server name I am entering in the IP address at which the database can be reached, for the Database name I am putting the name of the database to which I wish to connect.

3. I then get asked to enter the user credentials which I do, the same ones that I’m using for the working ODBC connection I already have.

Once I have down this it opens the query editor window and I get the following error:

«DataSource. Error: MySQL: Unable to connect to any of the specified MySQL hosts. Details: Message=unable to…, ErrorCode=-2147467259»

Why might I not be able to connect? Also, once connected what should I see. When I see screenshots of functional PowerQuery windows it appears that the database tables appear in the left hand column of the Query Window, should this be the indication I’m
looking for to know that it is successful?

Answers

Hi Dingle, unfortunately I don’t think I’m going to be much help since it genuinely just started working all by itself.

One thing that I did try is instead of putting an IP directly as 94.xx.xxx.x or whatever yours is, I put mine as
http://94.xx.xxx.x, I don’t think this was actually what fixed it but it is worth trying regardless.

What is an m script and how do I produce it? I’ve not had to do that before.

James
- Proposed as answer by
  
  Wednesday, September 11, 2013 6:05 PM
- Marked as answer by
  Elvis Long
  Wednesday, September 18, 2013 1:39 AM

Источник

Помогите справится с проблемой!

посавил я MySQL последную версию…но не фига в ней неразбираюсь. Как то создал пустую базу xx_database.

зделал я так:

дальше …как я понимаю…я должен указать путь в config.asp на созданную БД
но проблема такая что я не знаю как ето сделать….и где вообще эта БД находится???

вот кусок из config.asp

dbFolder = «db/»
upload = «cl_upload/»
bnrLocation = «banners/»
ad_cache = «ads/»
logo = «img/logo.gif»

MySQL ставил все по умолчанию, по идее БД должна наверное находится тут:

C:/Program Files/MySQL/MySQL Server 5.0/Data/xx_database

но если я пишу в config.asp так:

-2147467259 [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Current Database Provider Connection String is:

strConn = «Driver={MySQL ODBC 3.51 Driver};server=127.0.0.1;uid=xx_user;database=xx_database;»
Подскажите пожалуста что делать???

Источник

Hello.

I have been trying to install SQL Express 2008, 3 different editions on a Windows 2008 Standard Server. All of the installers failed just after the install file had finished unpacking itself in a temp folder. No errors or logs were found.

.Net3.5sp1, Windows Installer 4.5 and PowerShell 1.0 were all installed.

I was only able to find a log file when I used the SqlExpressWrapper.exe to drive the installation.

The error displayed from the wapper is : An error occurred during installation of SQL Server 2008 Express. Installation failed with exit code -2147467259

thank you for your help.

Naim

Here is the complete log.

C:ProgramDataMicrosoftSQL Server 2008 Express Install2008-11-12_14-27-41-519LogsInstall Wrapperlog.txt

Info: [T1][14:27:41.519] Program.Main                            Install Wrapper started, log initialized.
Verbose: [T1][14:27:41.550] Program.Main                            Executable path: C:ProgramDataMicrosoftSQL Server 2008 Express Install2008-11-12_13-56-59-277SqlExpressWrapper.exe
Verbose: [T1][14:27:41.550] Program.Main                            Command line arguments: (none)
Verbose: [T1][14:27:41.550] Program.Main                            Environment:
    Current UI culture: en-US
    Installed culture: en-US
    OS: Windows Server 2008 Service Pack 1 (Microsoft Windows NT 6.0.6001 Service Pack 1), product type: 3
    Architecture: x86
Verbose: [T1][14:27:41.550] Program.Main                            Running UI.
Verbose: [T1][14:27:41.550] LocaleCollection.GetLocaleForCulture    Start — cultureName=en-US
Verbose: [T1][14:27:41.550] LocaleCollection.GetLocaleForCulture    End — returned [Id=en, EnglishName=English]
Verbose: [T1][14:27:42.924] Wizard.Window_Loaded                    Start — sender=Microsoft.SqlServer.SqlExpressWrapper.UI.Wizard; e=System.Windows.RoutedEventArgs
Verbose: [T1][14:27:42.924] Wizard.Window_Loaded                    End
Info: [T1][14:27:43.845] InstallState.get_ComponentsToInstall    Determining components to install.
Verbose: [T1][14:27:43.845] ComponentInfo.get_IsInstalled           Start
    Info: [T1][14:27:43.845] ComponentInfo.get_IsInstalled           Checking whether Windows Installer 4.5 is installed.
    Verbose: [T1][14:27:43.845] ComponentInfo.get_IsInstalled           Checking version of file C:Windowssystem32msi.dll; minimum version is 4.5
    Verbose: [T1][14:27:43.845] ComponentInfo.get_IsInstalled           Detected version 4.5.6001.22162
    Verbose: [T1][14:27:43.845] ComponentInfo.get_IsInstalled           File version check PASSED.
    Info: [T1][14:27:43.845] ComponentInfo.get_IsInstalled           Windows Installer 4.5 is installed.
Verbose: [T1][14:27:43.845] ComponentInfo.get_IsInstalled           End — returned True
Verbose: [T1][14:27:43.845] InstallState.get_ComponentsToInstall    Windows Installer 4.5 — No (already installed)
Verbose: [T1][14:27:43.845] ComponentInfo.get_IsInstalled           Start
    Info: [T1][14:27:43.845] ComponentInfo.get_IsInstalled           Checking whether Windows Powershell 1.0 is installed.
    Verbose: [T1][14:27:43.845] ComponentInfo.CheckRegistryValues       Start — path=HKEY_LOCAL_MACHINESoftwareMicrosoftPowershell1:Install; data=1
        Verbose: [T1][14:27:43.845] ComponentInfo.CheckRegistryValue        Start — path=HKEY_LOCAL_MACHINESoftwareMicrosoftPowershell1:Install; data=1
            Verbose: [T1][14:27:43.861] ComponentInfo.ParseRegKeyPath           Start — path=HKEY_LOCAL_MACHINESoftwareMicrosoftPowershell1:Install; keyName=NULL; valueName=NULL
            Verbose: [T1][14:27:43.861] ComponentInfo.ParseRegKeyPath           End
            Verbose: [T1][14:27:43.861] ComponentInfo.CheckRegistryValue        Checking registry key HKEY_LOCAL_MACHINESoftwareMicrosoftPowershell1:Install for 1
        Verbose: [T1][14:27:43.861] ComponentInfo.CheckRegistryValue        End — returned True
    Verbose: [T1][14:27:43.861] ComponentInfo.CheckRegistryValues       End — returned True
    Verbose: [T1][14:27:43.861] ComponentInfo.get_IsInstalled           Registry check PASSED.
    Info: [T1][14:27:43.861] ComponentInfo.get_IsInstalled           Windows Powershell 1.0 is installed.
Verbose: [T1][14:27:43.861] ComponentInfo.get_IsInstalled           End — returned True
Verbose: [T1][14:27:43.861] InstallState.get_ComponentsToInstall    Windows Powershell 1.0 — No (already installed)
Verbose: [T1][14:27:43.861] ComponentInfo.get_IsInstalled           Start
Verbose: [T1][14:27:43.861] ComponentInfo.get_IsInstalled           End — returned False
Verbose: [T1][14:27:43.861] InstallState.get_ComponentsToInstall    SQL Server 2008 Express with Tools — Yes
Verbose: [T1][14:27:43.861] InstallState.get_ComponentsToInstall    SQL Server 2008 Express with Advanced Services — No (not selected or required)
Verbose: [T1][14:27:43.861] InstallState.get_ComponentsToInstall    SQL Server 2008 Express — No (not selected or required)
Verbose: [T1][14:27:43.908] StartPage.Page_Loaded                   Start — sender=Microsoft.SqlServer.SqlExpressWrapper.UI.StartPage; e=System.Windows.RoutedEventArgs
Verbose: [T1][14:27:43.908] StartPage.Page_Loaded                   End
Verbose: [T1][14:27:46.546] StartPage.ButtonInstall_Click           Start — sender=System.Windows.Controls.Button: Install; e=System.Windows.RoutedEventArgs
    Verbose: [T1][14:27:46.546] LocaleCollection.GetLocaleForCulture    Start — cultureName=en-US
    Verbose: [T1][14:27:46.546] LocaleCollection.GetLocaleForCulture    End — returned [Id=en, EnglishName=English]
    Verbose: [T1][14:27:46.562] InstallController.InstallCommand_ExecutedStart — sender=Microsoft.SqlServer.SqlExpressWrapper.UI.StartPage; e=System.Windows.Input.ExecutedRoutedEventArgs
    Verbose: [T1][14:27:46.562] InstallController.InstallCommand_ExecutedEnd
Verbose: [T1][14:27:46.562] StartPage.ButtonInstall_Click           End
Verbose: [T3][14:27:46.562] InstallController.InstallWorker         Start
    Verbose: [T3][14:27:46.562] LocaleCollection.GetLocaleForCulture    Start — cultureName=en-US
    Verbose: [T3][14:27:46.562] LocaleCollection.GetLocaleForCulture    End — returned [Id=en, EnglishName=English]
    Info: [T3][14:27:46.562] InstallController.InstallWorker         Starting install session.
    Verbose: [T3][14:27:46.562] InstallState.GetIncompatibleComponents Start
        Info: [T3][14:27:46.562] InstallState.GetIncompatibleComponents Checking components for system compatibility.
        Info: [T3][14:27:46.562] ComponentInfo.get_TargetDeployment      Determining best deployment of SQL Server 2008 Express with Tools for this system.
        Verbose: [T3][14:27:46.562] ComponentInfo.get_TargetDeployment      Target locale: en
        Info: [T3][14:27:46.577] ComponentInfo.get_TargetDeployment      Best deployment: [LocaleId=en, OS=5.1.2600-5.1.9999.9999,5.2.3790.3959-, Architecture=x86, DownloadUrl=http://go.microsoft.com/fwlink/?LinkID=119768&clcid=0x409]
        Info: [T3][14:27:46.577] InstallState.GetIncompatibleComponents Found 0 incompatible component(s).
    Verbose: [T3][14:27:46.577] InstallState.GetIncompatibleComponents End — returned System.Collections.ObjectModel.Collection`1[Microsoft.SqlServer.SqlExpressWrapper.Configuration.ComponentInfo]
    Verbose: [T3][14:27:46.577] InstallController.DownloadComponents    Start
        Info: [T3][14:27:46.577] InstallController.DownloadComponents    Download phase started.
        Info: [T3][14:27:46.577] InstallState.get_ComponentsToDownload   Determining components to download.
        Verbose: [T3][14:27:46.577] ComponentInfo.get_IsInstalled           Start
        Verbose: [T3][14:27:46.577] ComponentInfo.get_IsInstalled           End — returned True
        Verbose: [T3][14:27:46.577] InstallState.get_ComponentsToDownload   Windows Installer 4.5 — No (already installed)
        Verbose: [T3][14:27:46.577] ComponentInfo.get_IsInstalled           Start
        Verbose: [T3][14:27:46.577] ComponentInfo.get_IsInstalled           End — returned True
        Verbose: [T3][14:27:46.593] InstallState.get_ComponentsToDownload   Windows Powershell 1.0 — No (already installed)
        Verbose: [T3][14:27:46.593] ComponentInfo.get_IsInstalled           Start
        Verbose: [T3][14:27:46.593] ComponentInfo.get_IsInstalled           End — returned False
        Verbose: [T3][14:27:46.593] ComponentInfo.get_IsDownloaded          Start
            Verbose: [T1][14:27:47.608] ProgressPage.Page_Loaded                Start — sender=Microsoft.SqlServer.SqlExpressWrapper.UI.ProgressPage; e=System.Windows.RoutedEventArgs
Verbose: [T1][14:27:47.608] ProgressPage.Page_Loaded                End
Verbose: [T3][14:27:47.639] ComponentInfo.get_IsDownloaded          File C:ProgramDataMicrosoftSQL Server 2008 Express InstallDownloadsSqlExpressWithToolsSQLEXPRWT_x86_ENU.exe is already downloaded.
        Verbose: [T3][14:27:47.639] ComponentInfo.get_IsDownloaded          End — returned True
        Verbose: [T3][14:27:47.639] InstallState.get_ComponentsToDownload   SQL Server 2008 Express with Tools — No (already downloaded)
        Verbose: [T3][14:27:47.639] InstallState.get_ComponentsToDownload   SQL Server 2008 Express with Advanced Services — No (not selected or required)
        Verbose: [T3][14:27:47.639] InstallState.get_ComponentsToDownload   SQL Server 2008 Express — No (not selected or required)
        Info: [T3][14:27:47.639] InstallController.DownloadComponents    Download phase ended.
    Verbose: [T3][14:27:47.639] InstallController.DownloadComponents    End
    Verbose: [T3][14:27:47.639] InstallController.InstallComponents     Start
        Info: [T3][14:27:47.639] InstallController.InstallComponents     Install phase started.
        Verbose: [T3][14:27:47.639] InstallController.SetForRestart         Start — restart=True
            Verbose: [T3][14:27:47.654] InstallController.CopyProgramFiles      Start
                Verbose: [T3][14:27:47.654] InstallController.CopyProgramFiles      Copying wrapper files from C:ProgramDataMicrosoftSQL Server 2008 Express Install2008-11-12_13-56-59-277 to C:ProgramDataMicrosoftSQL Server 2008 Express Install2008-11-12_14-27-41-519
            Verbose: [T3][14:27:47.701] InstallController.CopyProgramFiles      End
            Verbose: [T3][14:27:47.701] InstallController.SetForRestart         Setting registry key for restart.
        Verbose: [T3][14:27:47.701] InstallController.SetForRestart         End
        Verbose: [T3][14:27:47.717] ComponentInstaller.Install              Start
            Info: [T3][14:27:47.717] ComponentInstaller.Install              Preparing to install SQL Server 2008 Express with Tools.
            Verbose: [T3][14:27:47.717] ComponentInstaller.ValidateFile         Start
                Info: [T3][14:27:47.717] ComponentInstaller.ValidateFile         Validating SQLEXPRWT_x86_ENU.exe.
                Verbose: [T3][14:27:47.717] ComponentInstaller.GetFileCertificate   Start — file=C:ProgramDataMicrosoftSQL Server 2008 Express InstallDownloadsSqlExpressWithToolsSQLEXPRWT_x86_ENU.exe
                    Verbose: [T3][14:27:47.717] ComponentInstaller.GetFileCertificate   Retrieved certificate: CN=Microsoft Corporation, O=Microsoft Corporation, L=Redmond, S=Washington, C=US
                Verbose: [T3][14:27:47.717] ComponentInstaller.GetFileCertificate   End — returned [Subject]
CN=Microsoft Corporation, O=Microsoft Corporation, L=Redmond, S=Washington, C=US

[Issuer]
CN=Microsoft Code Signing PCA, O=Microsoft Corporation, L=Redmond, S=Washington, C=US

[Serial Number]
610F784D000000000003

[Not Before]
2007-08-22 20:23:13

[Not After]
2009-02-22 19:33:13

[Thumbprint]
D57FAC60F1A8D34877AEB350E83F46F6EFC9E5F1

Verbose: [T3][14:27:47.717] ComponentInstaller.IsValidCertificate Start — cert=[Subject]
CN=Microsoft Corporation, O=Microsoft Corporation, L=Redmond, S=Washington, C=US

[Issuer]
CN=Microsoft Code Signing PCA, O=Microsoft Corporation, L=Redmond, S=Washington, C=US

[Serial Number]
610F784D000000000003

[Not Before]
2007-08-22 20:23:13

[Not After]
2009-02-22 19:33:13

[Thumbprint]
D57FAC60F1A8D34877AEB350E83F46F6EFC9E5F1

                    Verbose: [T3][14:27:47.779] ComponentInstaller.IsValidCertificate   Looking in certificate chain for public key 3082010A0282010100A2DB0A8DCFC2C1499BCDAA3A34AD23596BDB6CBE2122B794C8EAAEBFC6D526C232118BBCDA5D2CFB36561E152BAE8F0DDD14A36E284C7F163F41AC8D40B146880DD98194AD9706D05744765CEAF1FC0EE27F74A333CB74E5EFE361A17E03B745FFD53E12D5B0CA5E0DD07BF2B7130DFC606A2885758CB7ADBC85E817B490BEF516B6625DED11DF3AEE215B8BAF8073C345E3958977609BE7AD77C1378D33142F13DB62C9AE1AA94F9867ADD420393071E08D6746E2C61CF40D5074412FE805246A216B49B092C4B239C742A56D5C184AAB8FD78E833E780A47D8A4B28423C3E2F27B66B14A74BD26414B9C6114604E30C882F3D00B707CEE554D77D2085576810203010001
                    Verbose: [T3][14:27:47.779] ComponentInstaller.IsValidCertificate   Checking certificate: [Subject] CN=Microsoft Corporation, O=Microsoft Corporation, L=Redmond, S=Washington, C=US [Issuer] CN=Microsoft Code Signing PCA, O=Microsoft Corporation, L=Redmond, S=Washington, C=US [Serial Number] 610F784D000000000003 [Not Before] 2007-08-22 20:23:13 [Not After] 2009-02-22 19:33:13 [Thumbprint] D57FAC60F1A8D34877AEB350E83F46F6EFC9E5F1
                Verbose: [T3][14:27:47.779] ComponentInstaller.IsValidCertificate   End — returned True
                Info: [T3][14:27:47.779] ComponentInstaller.ValidateFile         File validation PASSED.
            Verbose: [T3][14:27:47.779] ComponentInstaller.ValidateFile         End — returned True
            Info: [T3][14:27:47.779] ComponentInstaller.Install              Installing SQL Server 2008 Express with Tools.
            Verbose: [T3][14:27:47.795] ComponentInstaller.Install              Executing command line «C:ProgramDataMicrosoftSQL Server 2008 Express InstallDownloadsSqlExpressWithToolsSQLEXPRWT_x86_ENU.exe» /ACTION=Install
            Verbose: [T3][14:27:47.795] ComponentInstaller.ParseCommandLine     Start
            Verbose: [T3][14:27:47.795] ComponentInstaller.ParseCommandLine     End — returned System.Diagnostics.ProcessStartInfo
            Verbose: [T3][14:27:48.903] ComponentInstaller.Install              Waiting for process to exit.
            Verbose: [T3][14:28: 0. 97] ComponentInstaller.Install              Process returned exit code -2147467259.
            Error: [T3][14:28: 0. 97] ComponentInstaller.Install              Command line ‘»C:ProgramDataMicrosoftSQL Server 2008 Express InstallDownloadsSqlExpressWithToolsSQLEXPRWT_x86_ENU.exe» /ACTION=Install ‘ returned unexpected error code -2147467259.
        Verbose: [T3][14:28: 0. 97] ComponentInstaller.Install              End — returned NULL
        Error: [T3][14:28: 1.159] InstallController.InstallComponents     Error: Microsoft.SqlServer.SqlExpressWrapper.Controller.InstallException was thrown: Installation failed with exit code -2147467259.
Source: SqlExpressWrapper
Stack:   at Microsoft.SqlServer.SqlExpressWrapper.Controller.ComponentInstaller.Install()
   at Microsoft.SqlServer.SqlExpressWrapper.Controller.InstallController.InstallComponents()

INNER EXCEPTION:
<NONE>
        Verbose: [T3][14:28: 1.159] Wizard.controller_Error                 Start — sender=Microsoft.SqlServer.SqlExpressWrapper.Controller.InstallController; e=Microsoft.SqlServer.SqlExpressWrapper.Controller.ErrorEventArgs
            Verbose: [T1][14:28: 1.159] Wizard.controller_Error                 Start — sender=Microsoft.SqlServer.SqlExpressWrapper.Controller.InstallController; e=Microsoft.SqlServer.SqlExpressWrapper.Controller.ErrorEventArgs
    Verbose: [T1][14:28: 1.190] ErrorDialog.Window_Loaded               Start — sender=Microsoft.SqlServer.SqlExpressWrapper.UI.ErrorDialog; e=System.Windows.RoutedEventArgs
    Verbose: [T1][14:28: 1.190] ErrorDialog.Window_Loaded               End
    Verbose: [T1][14:28: 3.688] InstallController.ViewLogCommand_ExecutedStart — sender=Microsoft.SqlServer.SqlExpressWrapper.UI.ErrorDialog; e=System.Windows.Input.ExecutedRoutedEventArgs
    Verbose: [T1][14:28: 3.688] InstallController.ViewLogCommand_ExecutedEnd
    Verbose: [T1][14:30:18.832] InstallController.ViewLogCommand_ExecutedStart — sender=Microsoft.SqlServer.SqlExpressWrapper.UI.ErrorDialog; e=System.Windows.Input.ExecutedRoutedEventArgs
    Verbose: [T1][14:30:18.847] InstallController.ViewLogCommand_ExecutedEnd

Источник

Форум пользователей MySQL

#1 25.12.2007 05:46:28

Ошибка -2147467259

PRB: Error -2147467259 When You Try to Open the Same MDB File from Multiple Instances

Symptoms

Cause

Resolution

Status

More Information

References

Mysql error code 2147467259

BullZip Home

Error: -2147467259

Error: -2147467259

Re: Error: -2147467259

Re: Error: -2147467259

Re: Error: -2147467259

Re: Error: -2147467259

Mysql error code 2147467259

<img decoding="async" onError="javascript: wp_broken_images = window.wp_broken_images || function(){}; wp_broken_images(this);" src="https://i1.social.s-msft.com/globalresources/Images/trans.gif" />

Answered by:

Question

Answers

Question

Answers