Solved

Basics of connecting to a local MSSQL server with Delphi

Posted on 2008-10-13
4
1,071 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

707 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