| View previous topic :: View next topic |
| Author |
Message |
Tony
Guest
|
 Posted: Fri Dec 22, 2006 7:38 pm Post subject: Help: MSSQL 2005 Express & Delphi 2006 |
 |
|
Hello, I installed MSSQL Express 2005 and it seem to be running okay when
entered thru the Management Studio. However, I do not see an instance of it
when trying to connect to it thru Delphi 2006. Can someone help me here.
Thanks! |
|
| Back to top |
|
 |
Kevin Frevert
Guest
|
| Posted: Fri Dec 22, 2006 9:08 pm Post subject: Re: MSSQL 2005 Express & Delphi 2006 |
|
|
Tony,
How are you trying to connect thru Delphi 2006? BDE? ADO?
krf
"Tony" <tonysmith (AT) gemshopping (DOT) com> wrote in message
news:458bdfbe$1 (AT) newsgroups (DOT) borland.com...
| Quote: | Hello, I installed MSSQL Express 2005 and it seem to be running okay when
entered thru the Management Studio. However, I do not see an instance of
it when trying to connect to it thru Delphi 2006. Can someone help me
here.
Thanks!
|
|
|
| Back to top |
|
|
Oliver Townshend
Guest
|
| Posted: Sat Dec 23, 2006 4:48 am Post subject: Re: MSSQL 2005 Express & Delphi 2006 |
|
|
| Quote: | Hello, I installed MSSQL Express 2005 and it seem to be running okay when
entered thru the Management Studio. However, I do not see an instance of
it when trying to connect to it thru Delphi 2006. Can someone help me
here.
|
My database instance was called MACHINENAME\SQLExpress. Try something like
that.
Oliver Townshend |
|
| Back to top |
|
|
Tony
Guest
|
| Posted: Mon Dec 25, 2006 11:53 pm Post subject: Re: MSSQL 2005 Express & Delphi 2006 |
|
|
I've tried using MACHINENAME\SQLEXPRESS. However, I am getting the following
error: Test connection failed because of an error in initializing provider.
[DBNETLIB] ConnectionOpen (Connect()).]SQL Server does not exist or access
denied.
Is it possible for someone to walk me thru the installation steps? Here's
what I have done so far:
1. I've installed Delphi - This is working fine - I can connect to Access
Databases using ADO and to Firebird/Interbase with no problem.
2. I've installed SQL 2005 Express - This is working fine thru the
Management Studio. However, I cannot connect to any database thru Delphi
IDE or Borland's Database Explorer.
What am I missing? |
|
| Back to top |
|
|
Oliver Townshend
Guest
|
| Posted: Tue Dec 26, 2006 6:46 am Post subject: Re: MSSQL 2005 Express & Delphi 2006 |
|
|
| Quote: | What am I missing?
|
What is your connection string? Mine is:
Provider=SQLOLEDB.1;Data Source=codelegal;Initial Catalog=sashwin;Integrated
Security=SSPI
and that works (codelegal is my machine name, sashwin is my database).
Oliver Townshend |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
