Connect To A Cloud (Online) Database
-
Shotaro Ito
★ BarTender Hero ★
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 -
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 -
Shotaro Ito
★ BarTender Hero ★
[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 -
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.
0
请先登录再写评论。
评论
4 条评论