SQL DB connection to autoit.

[ViditTiwary25]

Hi All ,

I am facing an issue while connecting sql db with autoit . Actually I have tried all the solutions on this site but non of them worked .

Specification : 

 - Win 7

 - AutoIt V3

 - SciTE ( to wirte the code )

 - database (HeidiSql )

Now I have the following DB description :-

 - Schema Name - Vidit

 - DB name - vidit

 - Table Name - test .

   -  Columns name Datatype ( Int , Varchar , Varchar , Varchar , Varchar , Varchar )

Now I have data , which is stored in variable in SciTE , to be stored in the DB.

I have tried _SQLite function but bot able to to the task .

task :-

1. make connection .

2. store data in db.

4. Retrive data from db.

3. End connection .

Please Help me !! 

 

[0xdefea7]

Would you please post some code so that we can see where you are having trouble?

[JLogan3o13]

And have you actually done a search of the forum? I recently had to write a lengthy script which included connecting to a sql db, and know for a certain there are a number of topics on the subject.

[jchd]

SQLite is a serverless RMSDB but it won't work with non-SQLite DBs like MySQL.

There are a number of ready-to-use UDFs for connecting to a MySQL DB, directly or thru an ADO (ODBC) driver.