Connect To A Cloud (Online) Database 关注

0
Avatar
Legacy Poster

Is there a good way to connect to and print from a database hosted online? Current application uses an Excel file, but I am under the impression that could be converted if need be. Of course, the database hosted remotely must be secure to non-authorized users. Thanks.

3 评论

0
Avatar
Shotaro Ito
版主
评论操作 固定链接

Hi nRyder,
BarTender doesn't have a connection setup for any cloud based database at the moment.
Logically - you can connect to database which can be connected via ODBC / OLEDB, if such database provides driver.
You can enter ODBC / OLEDB login ID and password every time you connect to Database, or keep that in BTW format.

Before I've connected to MS SQL Azure database and print, via SQL 2008 Native Client ODBC driver - the driver coming with SQL Management Studio Express 2008 etc. I didn't have extensive testing, though.

If not about cloud service - you can connect to remote database such as Oracle or SQL server over network.
0
Avatar
Legacy Poster
评论操作 固定链接

Thanks. Unfortunately, I'm inexperienced with any type of offsite ODBC or SQL database. You say that, theoretically, it should be connectable via the internet if we have the right address and credentials?
0
Avatar
Shotaro Ito
版主
评论操作 固定链接

[quote name='nRyder' timestamp='1330459627' post='1848']
Thanks. Unfortunately, I'm inexperienced with any type of offsite ODBC or SQL database. You say that, theoretically, it should be connectable via the internet if we have the right address and credentials?
[/quote]
Yes. you also need a ODBC/OLEDB driver which works over Internet. ODBC/OLEDB driver is adapter to connect specific database.
Unfortunately I don't know such combination much. MS SQL Azure + SQL Native Client ODBC driver was one option.

请先登录再写评论。