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.

4 评论

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.
0
Avatar
Adam Flores Sr
评论操作 固定链接

First Open odbcad32.exe - to access the Data Source Administrator, then you will see a few Connections already (assuming there are

many connections in the system)

Click on the Add Button and it will display a list of ODBC Drivers already installed in your computer,

I Selected MySQL ODBC Driver (you might have to install the driver for your database).

and Click Finish Button

Then you will be presented with the following screen

in Data Source Name: Make a meaningful Name (Like MY-DATA or so)

Description you can leave blank unless you want to have a note of your connection

in TCP/IP Server, Fill it your Cloud IP Address (The box is small but you can insert a lot of characters)

Note: your Cloud Service Company should be able to provide you with the address to reach you database.

The port is default (3306) unless you are told otherwise)

Then fill in the User assigned to you and the Password as well

then enter the Name of the Remote Cloud Database Table,

Then press Test to confirm if the connection is Valid.

(From here on The following screen is specific to MySQL, you screen will be different but

should be similar requirements)

Hopefully this will help someone who lands in this post that no one has responded in 8 years

and give you at least a starting point.

请先登录再写评论。