Executing a Query to Insert Data from VBA to MySQL and What Will Said Data Look Like -

-

i'm trying insert snippets of word document mysql database. did in java, lost formatting of microsoft document, i'm trying same in vba (i'm hoping keep formatting?!). find out if will, need try.. i've set connection , table in mysql can't insert values. throws syntax error on "conn.execute" line. 

sub connecttodatabase()  ' '  dim conn new adodb.connection  dim server_name string  dim database_name string  dim user_id string  dim password string  '  dim long ' counter  dim sqlstr string ' sql perform various actions  dim table1 string, table2 string  dim field1 string, field2 string  dim rs adodb.recordset  dim vtype variant  '    server_name = "127.0.0.1" ' enter server name here -  database_name = "rmp" ' enter database name here  user_id = "root" ' enter user id here  password = "password1" ' enter password here   set conn = new adodb.connection conn.open "driver={mysql odbc 3.51 driver}" _  & ";server=" & server_name _  & ";database=" & database_name _  & ";uid=" & user_id _  & ";pwd=" & password _  & ";option=16427" ' option 16427 = convert longlong int:    strsql = "insert  parts(idparts, part 1, part 2, part 3, part 4,   part 5) " & _             "values (' " & 2 & " ' , '" & 1 & "' , '" & 2 & "' , '" &     3 & "' , '" & 4 & "' , '" & 5 & "' )"  conn.execute strsql   close connections on error resume next rs.close set rs = nothing conn.close set conn = nothing on error goto 0  end sub

the .net connector uses uid odbc connector used vba uses user. i've ever used option=3 well.

conn.open "driver={mysql odbc 3.51 driver}" _     & ";server=" & server_name _     & ";database=" & database_name _     & ";user=" & user_id _     & ";pwd=" & password _     & ";option=16427" ' option 16427 = convert longlong int:

you can test connection running simple sql query.

strsql = "select * parts;" conn.execute strsql

if throws error, still have issue.

also, in code have spaces either side of 2. correct?

"values (' " & 2 & " ' ,


Comments

Post a Comment

Popular posts from this blog

python - pip install -U PySide error -

-
does know how avoid following error when running pip install -u pyside per official website instructions here: https://pypi.python.org/pypi/pyside/#installing-pyside-on-a-mac-os-x-system note have done brew install qt successfully. you using pip version 7.0.3, version 7.1.2 available. should consider upgrading via 'pip install --upgrade pip' command. collecting pyside using cached pyside-1.2.4.tar.gz installing collected packages: pyside running setup.py install pyside complete output command /applications/anaconda/bin/python -c "import setuptools, tokenize;__file__='/private/var/folders/dy/ttgqhqqx3g9bsbsnqnxsk2z80000gq/t/pip-build-cpxemt/pyside/setup.py';exec(compile(getattr(tokenize, 'open', open)(__file__).read().replace('\r\n', '\n'), __file__, 'exec'))" install --record /var/folders/dy/ttgqhqqx3g9bsbsnqnxsk2z80000gq/t/pip-0r7hri-record/install-record.txt --single-version-externally-managed --compile: ...
Read more

arrays - C++ error: a brace-enclosed initializer is not allowed here before ‘{’ token -

-
simple question: i'm trying initialize array within c++ class declaration: using namespace std; #include <string> class myclass{ public: string myarray[] = {"a","b","c"}; }; and i'm getting error: error: brace-enclosed initializer not allowed here before ‘{’ token no, without complied c++11 compiler, cannot initialize member array in declaration. have initialize array member in constructor. , don't use open array if know number of elements initialize array.
Read more

cytoscape.js - How to add nodes to Dagre layout with Cytoscape -

-
i trying add nodes dagre graph through cityscape.js. problem nodes not painted. code have: cy.add({ group: "nodes", data: { id:"n0",name:"n0",weight: 75 }, }); $.ajax(url).done(function(jsontree){ var newnodes=[]; for(var i=1;i<6;i++){ //var child = jsontree.result[i]; newnodes.push( { group: "nodes", data: { id: "n"+i, name:"n"+i}}, { group: "edges", data: { id: "e"+i, source: "n0", target: "n"+i } } ); } cy.add(newnodes); any ideas? have used loaded function reload graph not work. not know if have use specific function reload graph. thank in advance. you need add positions new nodes. cytoscape.js docs : it important note positions of newly added nodes must defined when calling cy.add(). nodes can not placed in graph without valid position — otherwise not displayed. yo...
Read more