Hello,

I'm do my first steps with the trial and like to show a table from some existing databases. MySql or MSSql.
After some troubles with the connection strings, I see some data in the preview table, but only with selection table.

1. If I try to set a query, I run into the trouble attached. I try with and without single and double quotes. Maybe the $ sign in the table name is the problem, but it is valid in MSSql.

2. Never I see the data wenn the application run (local). But when I only switch the table to demos in my application I see the data.

Please help

Harald,

<< I'm do my first steps with the trial and like to show a table from some
existing databases. MySql or MSSql. After some troubles with the connection
strings, I see some data in the preview table, but only with selection
table.

1. If I try to set a query, I run into the trouble attached. I try with and
without single and double quotes. Maybe the $ sign in the table name is the
problem, but it is valid in MSSql. >>

Can you email me the database that you're testing with along with the query
that you're trying to use ?  I suspect that the problem is simply an issue
with the connection string or some other configuration item.

Thanks,

Tim Young
Elevate Software
www.elevatesoft.com

Hello Tim,

I cannot send the mail below with attachments and pictures (return: unsolicited attachments or other errors), pls. download all in one *.zip from:

http://www.filek.net/download.html           pls. use only the link   elevatesoft

BR
Harald

From: Filek Harald
Sent: Tuesday, April 23, 2013 2:48 PM
To: 'timyoung@elevatesoft.com'
Cc: 'office@filek.net'
Subject: Troubles with ADO Connection

Hello Tim,

thank you for your answer. I cannot send you the database from the forum entry, because it is 340 GB.

First: I found the table vs. query problem, this was a simple typing error and a unclear error message. Sorry, now I see the preview.

But the problem when I run the Application still exists with the attached database too, pls. see the second picture. This is SQlite and need no server.
Attached is the database, my used odbc driver and the project.
I don’t know where you store the dataset setups, pls. see the picture below. Preview show the data correct. Windows 7 32 bit is used.


Thank you in advance
BR
Harald


RowSource is:    select * from WBELZEIL

Provider=MSDASQL.1;Persist Security Info=False;Extended Properties="DSN=sqlite;Database=C:\_D\_temp5\Wawi\DatenSQLite\SQLI_AS1_DEMO.DB;StepAPI=0;SyncPragma=NORMAL;NoTXN=0;Timeout=;ShortNames=0;LongNames=0;NoCreat=1;NoWCHAR=0;FKSupport=0;JournalMode=;OEMCP=0;LoadExt=;BigInt=0;"

Harald,

<< I cannot send the mail below with attachments and pictures (return:
unsolicited attachments or other errors), pls. download all in one *.zip
from: >>

Which table are you trying to access ?  Are you using a direct table or a
query ?

Tim Young
Elevate Software
www.elevatesoft.com