Currently viewing the tag: "connect"
Question: How to connect to a mySQL database on a Linux machine from Windows terminals?
Im planning on a new setup for our office, a Linux server that will have the mySQL database, all other terminals have windows OS like WIn98, Win2000 and tey will need to access the database from the Linux server how to do it?
Answer:
Answer by Linux OS
There are so many ways, but I’d recommend making your application web-based and server-side only and access via a web browser. Ancient, unsupported systems like Microsoft Windows 98 are barely able to function in todays world.
Go for a LAMP system.
With a data warehouse on Microsoft SQL Server and analysis cubes running on Microsoft SQL Server Analysis Services, you can analyse, perform what-if analysis, prepare projections and budgets etc using Microsoft Excel. This particular video shows how you can establish a data connection from Microsoft Excel to analysis cubes running on Microsoft SQL Server Analysis Services.
Question: How to connect my simple website to a mysql database?
I need to connect my site to a mysql database with some php code. Is there any advice out there that could assist me? I have created my database tables but yet to implement, do i need to download mysql and implement the tables in mysql then connect to my site with some php code???
sorry but new to this, thanks in advance.
Answer:
Answer by MsTisay
is your website php base? if so then there should be a config.php on your files open it and enter your mysql database username, password and host.
Question: How do i connect a windows C# application to a remote Mysql database?
I’m currently connected to a local Microsoft SQL server. I’m new to windows programming and i need the code snippets to connect my windows C# application to a remote Mysql database. I have a website which is connected to my web host’s Mysql database. I want to be able to connect my windows C# app. to that same data base. Need your expert advice. By the way, I’m using visual studio.
Answer:
Answer by wallmeister
It’s the same for a remote database as local. When you set up the data source, just specify the remote server.
Discusses how to connect a KPI dashboard to Microsoft SQL Server Analysis Services (2005 and 2008) when using Dundas Dashboard. Microsoft SQL Server Analysis Services is just one of the data sources that can be used for a Dundas dashboard. For a complete listing of all data sources that Dundas Dashboard supports please go to www.dundas.com
Question: How do I connect to MySQL with PHP remotely?
Here’s my situation. I got one site up that has a mysql database, works fine… Now I purchased a new domain name and am trying to use the same database for the new site. Any idea’s on what the host would be?
For my other site I use
$ host = “localhost”;
But that doesn’t seem to work any ideas on what would work?
Answer:
Answer by arbpen
You will have to use the FQDN, eg:
$ db = mysql_connect(“example.com”,”usename”,”password”);
$ dbname = “db name”;
Some hosts do not allow you to connect from a remote site, the site has to be on the same server of hosting company. Check CPanel and see if it’s even available.
Question: How do I connect to two MySQL databases at two different servers from a single php page?
I need to extract data from 2 MySQL databases located at two different servers. How is it possible from one single PHP page?
Answer:
Answer by joe.attaboy
This requires more detail than one can provide here, but all you really need to do is create two connections in the script.
You create a connection the mysql_connect(), right? Well, you can do this for as many separate connections as you need, as long as you uniquely identify each one with a different variable name:
$ conn1 = mysql_connect(server, user, password)…
$ conn2 = mysql_connect(server2, user2, password2)…
Now, you use the resource name (the variable name) to send database requests to each server.
The script doesn’t care how many systems you connect to, as long as each one is uniquely identified.
Question: HOW to connect (ODBC) VB to SQL database but on local pc and not with server?
i already knw some syntax here it is , if u hv some idia about this pls do let me know
****************************************************************
Public con As New ADODB.Connection
Public rst As New ADODB.Recordset
*********************************************************************
Public Sub connectsql()
con.ConnectionString = “provider=sqloledb.1 ; user id = prasad ; password = ********** ; initial catalog = student ;
data source = C:\Program Files\Microsoft Visual Studio\VB98\table_student.sql;”
con.Open
End Sub
*****************************************************************
Public Sub disconnectsql()
con.Close
con.Cancel
i hv doubt on data source and initial catalog
wat r they
i hv entered the initial catalog as table name and data source is the path for that file i.e. table student
In my college , server is there so i used to write data source as server overthere but wat should i write in my home ….
pls help me out
Answer:
Answer by techyashish
nitial catalog is refered as name of database and data source is uar s
Dim strConnection As String = _
“Data Source=localhost;Initial Catalog=Northwind;” _
& “Integrated Security=True”
erver name and u can use word localhost