AutoHotkey Community

Yes. I am pretty sure it isnt the permissions, as the permissions are the same for everyone. Its a small access DB i created myself.

The ADO code in VBA form submits the SQL without any permission issues.

I just need to work out how to tweak Seans ADO code so that I can use the Execute method.

http://www.w3schools.com/ado/met_conn_execute.asp

you dont understand you dont need to do that
you can just bas the create drop etc query the same as the select

_________________
No matter what your oppinion Please join this discussion
Formal request to Polyethene

Any idea how I can get a database schema using the ADO functions?

I'm trying to build a simple tool to manipulate a database when MS Access isnt available.

Woudnt you use use a show,describe,explain type of sql command. Did you even think about this first? You may better go to google and check how its done. Ado purpose is to provide an entry point not replace sql

_________________
No matter what your oppinion Please join this discussion
Formal request to Polyethene

It may depend a bit on your provider, but the SQLDataReader usually has a method called GetSchemaTable that returns a DataTable object that has the column metadata describing the SQLDataReader's result set.

SqlDataReader.GetSchemaTable Method

this is for dql server i beleive. this question is directed towards an access database

_________________
No matter what your oppinion Please join this discussion
Formal request to Polyethene

I believe it's dependent on the provider. I know SQL Server and Oracle both support it, and it's supported by the OLEDBDataReader: OleDbDataReader.GetSchemaTable Method

I don't have Access and haven't used it so I'm not speaking from experience. However it looks to me like it probably supports it. Whether or not this is what doyle nli actually wanted I'm not sure, but it does greatly simplifies getting schema information about specific tables.

it would if so i dont have time to dig in now tho so lets hope he can do it with either your suggestion or sql commands

_________________
No matter what your oppinion Please join this discussion
Formal request to Polyethene

Sweeeee3333t! This is exactly what I wanted/needed now, good to get synced data from online. Now, however, I can't quite get my head wrapped around this. I have used MySQL with PHP before, and basic COM, but nothing advanced (I really don't understand it 100%).

1) On page 7, there was an example by infogulch of an attempt of a wrapper for SQL calls for AHK_L. It didn't work however. Has anyone got a wrapper function that works for AHK_L (or AHK v2)?
2) Does that require some other library apart from the correct COM?
3) The input is SqlQuery(sql, connStr). What is connStr, my credentials? In which format? What is sql, the sqlquery? In PHP the query is:



Would the equalivent in AHK be:



Or what?

Very grateful for replies, as this acquired knowledge will be used to make the world a better place. *sings*

_________________
~sumon • Appifyer• AHK Nova halted • Recommended: AHK_L (Why?)

hi, I worked recently on a SQLLite OOP Wrapper. I plan also to support ADO over COM:
DBA 0.3 (OOP-SQL DataBase in AHK {SQLite})

Usage:


Recordset (currently readonly)


See the download in the linked Thread for a out of the box working example.

_________________
http://securityvision.ch
AHK 2D GAME ENGINE

If it's of help to anyone I've posted three simple functions for working with an Access database. They use the native COM in AHK_L and can be found here:

http://www.autohotkey.com/forum/viewtopic.php?p=455415#455415

_________________
The sooner you fall behind, the more time you have to catch up.

I know this has been a dead thread for awhile, but after 4 hours of trying things, I used this code to successfully connect to a SQL server using my windows NT credentials. To most of you it's common sense, but in case there's someone else out there like me: