Solved

Basics of connecting to a local MSSQL server with Delphi

Posted on 2008-10-13
4
1,068 Views
Last Modified: 2013-11-23
Hi,
Although I know nothing about database programming, I need to connect to a local MSSQL Server Express 2008 using Delphi 2009 Trial to create a database that will in turn contain 1 table with 2 columns. First column holds the key second column contains long text like an article for example.
few lines will be more than helpful
thanks in advance
0
Comment
Question by:Alavna
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 1

Expert Comment

by:Praveen_WS
ID: 22701149

Try to use ADO. Connection string is the same as for MS SQL Server 2000 but
Provider=SQLNCLI instead of Provider=SQLOLEDB.

Try to connect to master at first. Enabled Windows authentication
(for Integrated Security=SSPI)?
If not, use user name/password. Later you will be able to create more databases.
0
 

Author Comment

by:Alavna
ID: 22701203
thanks for the reply. I added an ADOConnection component. And configured the connection string. What else do I need to do? As I said this is my first attempt at database programming. I created the database and the table manually. Just need to connect to these. Queries etc..are another story....
thanks
0
 

Author Comment

by:Alavna
ID: 22701266
I am able to connect to the database in question now using this string
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;User ID=myserver\alavna;Initial Catalog=mycms;Data Source=localhost\SQLEXPRESS;

Just need an example of how to create more records or query others. thanks
0
 
LVL 1

Accepted Solution

by:
Praveen_WS earned 500 total points
ID: 22701300
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question