Showing posts with label delphi. Show all posts
Showing posts with label delphi. Show all posts

Sunday, March 25, 2012

Connecting to sql from Delphi 5

I try to connect (locally) to SQLServer Express from Delphi5. On my developer computer, which has Windows XP, SQLServer 2000, VisualStudio2005 (and with that, SQLExpress 2005), it is no problem. However, when I transfer my program and the database to other computers with Windows 2000/WindowsServer2003 and a more recent standalone-version of SQLExpress, I get error messages like:

'Db-Library error 10004: No connection possible: SQL Server not available or not existing'

It does not matter which protocols I activate at the Server or whether the Server Browser service is running or not.

Does anybody have an idea how this might be fixed? Or whether it is a problem of the operating system?

Didi you try making a connecting without any Delphi tools like sqlcmd.exe at the command prompt ?

HTH, Jens K. Suessemeyer.

http://www.sqlserver2005.de
|||

Yes, all MS SQL 2005 tools work.

Meanwhile I found a solution myself: Everything works fine, if I install SQL Server 2000 additionally -- the client suffices. I don't like talking to a new 2005 database via an old 2000 client library, but at least it works.

Thanks very much for helping.

Lucia Lehr

Sunday, March 11, 2012

Connecting to Delphi

Somenone can help me to connect a MSSQL to a Delphi App.what are you want to know? explain please...|||well, my problem its that i build the data bases in MSSQL, i already setup a DNS in OBDC, but whe in try to call that DNS from a Delphi application this throw me an error on conection, you can help me explaining me the steps to make a good setup of a simple database in MSSQL for use with Delphi

Thanks|||Hi,

Here is a simple way to connect to sql server using ODBC DSN & Delphi.
I hope this will help you.

1. Drop a Database Component from DataAccess Tab

2. Set the following properties for Database Component
1. AliasName - The DSN name created with ODBC
2. DatabaseName - The database you want to connect to sql server for example give "PUBS"
3. Login Prompt - False
4. Name - "PUBS_DB"
5. Params - USER NAME=SA
DATABASE NAME=PUBS

3. Now Drop a Table Component from DataAccess Tab

4. Set the following properties for Table Component
1. DatabaseName - PUBS
2. Now in "Table", select the table name you want
3. Active - True

5. Drop a DataSource and Link the dataset to Table

6. Now drop a DBGrid from DataControls and link the datasource.

Regards,
Selva Balaji B.|||i made it
thankz
i got another question, what about connecting to a server in my LAN, what should i configurate
thankz again

Saturday, February 25, 2012

Connecting SQL Server with Delphi 7

Hi,
How can i connect to an sql server db file. I have the server's ip number.
I'm using Delphi 7.
Thanks...
:)Can't you use BDE configuration tool in Control Panel?|||There are three easy methods in delphi7 u can choose:
1 BDE
2 ADO
3 DBExpress