?
Solved

Basics of connecting to a local MSSQL server with Delphi

Posted on 2008-10-13
4
Medium Priority
?
1,074 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 2000 total points
ID: 22701300
0

Featured Post

Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

Question has a verified solution.

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

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
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 …
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Suggested Courses

777 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