Search found 5 matches

by MCblogiz
Wed Feb 05, 2020 8:36 am
Forum: General Discussions
Topic: SQL statements variable on *.mdb
Replies: 4
Views: 1092

Re: SQL statements variable on *.mdb

Question simple, but answer not :(
Image
by MCblogiz
Thu Jan 30, 2020 3:23 pm
Forum: Label Printing Integration & Programming
Topic: 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
Replies: 3
Views: 954

Re: 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

Because I want to use that in the function to get data without using events SQL statement.
by MCblogiz
Thu Jan 30, 2020 10:31 am
Forum: Label Printing Integration & Programming
Topic: 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
Replies: 3
Views: 954

'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

Hi, i am trying some code with ironpython odbc connection, but always getting Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine Tried mdb instead of accdb file with ODBC provider, tried other versions of access database engine, tried x86 and x64 versions. No success. Maybe ni...
by MCblogiz
Wed Jan 15, 2020 2:56 pm
Forum: General Discussions
Topic: SQL statements variable on *.mdb
Replies: 4
Views: 1092

Re: SQL statements variable on *.mdb

Saso wrote:
Wed Jan 15, 2020 2:26 pm
The EXEC() statement used in the KB article is not supported for queries inside Microsoft Access. You need Microsoft SQL server.
Is it any way to use variables on *.mdb (access db) files?
by MCblogiz
Wed Jan 15, 2020 1:12 pm
Forum: General Discussions
Topic: SQL statements variable on *.mdb
Replies: 4
Views: 1092

SQL statements variable on *.mdb

Hi everyone, few days trying to find correct SQL statement for *.mdb file query. Found some samples: https://www.nicelabel.com/support/knowledge-base/article/executing-variable-sql-statements but no success maybe in case of using access DB instead of MS SQL Server. SELECT :variable FROM Augalai1 WHE...