Database Connection???How to connect a Database in an other server?
How to connect a Database(.mdb) in an other server?
Can I use the connection string like below?
mycon.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=http://www.****.com/***/mydb.mdb"
You can not.
Access is file based. No a client/server architecture.Thomas TomiczekPowerNodes ApS(Microsoft MVP C#/.NET)---Building a Website? Try the PowerNodes CMS - http://www.powernodes.com/
Correction: you can. Just make sure you can reach the acces db file - through a file share that is bound as drive.
Not that you should. Performance will be horrib...Delphi XE2 database connection demo?
I have just come across Delphi XE2 for IOS mobile development, and i wanted to know if there are any examples to connect to mysql database on the cloud?
This i example if for SQLite (http://blogs.devart.com/dac/index.php/how-to-develop-ios-database-applications-in-delphi-xe2-using-devart-data-access-components.html)
i tried searching on the net but i could not find any example
can any tell me where can i get some examples for using mysql(cloud) with Ios?
Le 07/12/12 09:59, Presley Dias a écrit :
> I have just come across Delphi XE2 for IOS mobile development, and i w...Good (Free) Database Choice For Simple Local Database For Delphi 2009
For years I have used the BDE and dVolga ( no longer abailable ) but want to
learn how to use other third-party and/or Delphi 2009 vcl components for
For a simple local database with only one table and 6-8 string fields with
graphic field support for one field what is a good choice?
What is available to do this without buying anything or possibly with a
Should I use DBExpress?
Is a commercial database application necessary to create the database?
Is something available from Microsoft as a free download to create and
possibly edit a...Connection String for ADO Database in delphi prism
I want to connect to a database with ADO and aspx.
from VB code what is the equivalent in delphi prism ?
Dim MyReader as sqldatareader
Dim MyConnection as sqlconnection = new sqlconnection()
Dim mycommand as sqlcommand = new sqlcommand()
mycommand.commandtext="select * from mytable"
mycommand.commandtype = commandtype.text
mycommand.connection = myconnection
Myreader=mycommand.executereader(commandbehavior.closeconnec...Open client app with Delphi
I am very new to SQL Anywhere and to client server in general. I am
developing an app in delphi which has a native driver for Sybase SQL
Anywhere. I have created a database file with some tables in it but
when I try to connect to it I get this error: 'vendor initialization
failed'. Does anyone know what is wrong? I think it has something to
do with configuring the interfaces file. I installed the 'personal
server' option to my pc when I installed SQL Anywhere as I can't put it
on the server yet as we are currently in the process of setting up a new
server. The...mysql database, delphi 2010 and connection charset
I want to write an application which will use a MySQL database. I made a basci connection and queries. Everything is ok, except viewing data from database on a website generated with php. I'm polish and using my national letters and this is problem. When i add text into database in my app written in delphi and then view it in app, everything is ok, national letter are correct. But, when i want to view this data on a website i see strange things where were national letters. Fields in database are defined i
n UTF-8, website uses UTF too. I can see on website data added from delphi on...How To Connect to a Database from Delphi XE2? ( newbie ) [Edit]
I'm thinking on using Firebird or Microsoft SQL Server Express - I want a free database - to create a database application.
How do I connect the database from Delphi XE2?
I was looking on the Tool Palette, and I've found "dbExpress" and "dbGo" ( I think that this last one if for ADO connection ... ).
What is the diference between "dbExpress" and an ADO connection? What is the best?
Do I need third-party components to connect to Firebird or Microsoft SQL Server Express, from Delphi XE2?
Thanks a lot in advance.
Is there any way to fix the delphi connecting to the database only through IPv4, I am using the component of Devart ODAC.
Daniel Junior wrote:
> Is there any way to fix the delphi connecting to the database only through IPv4, I am using the component of Devart ODAC.
> thank you
If you a driver from Devart, you should contact them. Perhaps someone
else here has used it though.
...Connecting to a MS Access database in Delphi XE5?
Does anyone have a simple code example for connecting to an Access database from a VCL Forms application using XE5?
Originally, we used the dbExpress Open ODBC driver in XE2 but that no longer works. The DbxXXDrv unit references Dbx34Drv, which in turn references DBXMetaDataCommand, which does not exist in my XE5 Enterprise install.
So I thought I'd try FireDAC, as there is Connect to Microsoft Access Database (FireDAC) topic in the docwiki. I dropped a TFDPhysMSAccessDriverLink onto a form, set the DriverID to MSAcc and the ODBCDriver to MS Access (*.mdb), but could not find the Dat...Database File Version vs Database Engine Version
Hi. I was recently visiting a customer site and noticed, from Sybase
Central, that the customer's database file displayed a 5.x version number,
even though the ASA engine was version 7.0.2.
This customer is running our pb6.5 / ASA 7 application under Citrix and is
having problems which are not appearing at other customer sites. I would
like to rule-out any possibility of these problems being generated by our
Has anyone eliminated problems by upgrading the database file to the same
version as the database engine?
Does Sybase recommend that the file be kept &quo...which database does the database refer in "Not connected to a database" of the second paragraph
I. 01/01 02:30:40. Synchronization Started
I. 01/01 02:30:40. Adaptive Server Anywhere MobiLink Synchronization Version
I. 01/01 02:30:40.
I. 01/01 02:30:40. Copyright _ 1989-2002 Sybase, Inc.
Portions Copyright _ 2002, iAnywhere Solutions, Inc.
I. 01/01 02:30:40. All rights reserved. All unpublished rights reserved.
I. 01/01 02:30:40.
I. 01/01 02:30:40. This software contains confidential and trade secret
I. 01/01 02:30:40. iAnywhere Solutions, Inc.
Use, duplication or disclosure of the software and
I. ...SqlConnection not connect to database in Delphi XE 2(mysql).
SqlConnection not connect to database in Delphi XE 2(mysql).
Note: The machine was installed with Delphi 2007.
First chance exception at $7576D36F. Exception class TDBXError with message 'DBX Error: Driver could not be properly initialized. Client library may be missing, not installed properly, of the wrong version, or the driver may be missing from the system path.'. Process Project6.exe (5732)
Aldnet Brasil wrote:
> SqlConnection not connect to database in Delphi XE 2(mysql).
> Note: The machine was installed with Delphi 2007.
> First...How do to connect database server with Delphi 7 and ASA dbexpress driver.
How do to connect database server?
I used Borland Delphi, version 7 with driver dbExpress and
ASA version 9.
I only Connected in localhost.
It's been a while, but I believe there is a ConnectString property in the
ASA dbExpress connection object. You can set the ConnectionString property
when you develop your application using the IDE, or you can set it in code.
Your ConnectionString can either be something like:
In the first case, your ODBC DSN ...How can I change my connection to a different database...it is not connecting to the database I created.
My data is connected to the ASPNETDB.MDF database. Is this a must that I have it connected to this database or can I have it connected to a database that I created.
You can connect to different database such as sql or other access files.
All you have to do is to define which connection string to use within your web.config file.
If you want to make sure that your database is prepared to be used, use features such as ASPNET_REGSQL.EXE at VS Command Prompt.
Hope this helps.
I'm in the Army...here in Georgia. Is it cold there..