| View previous topic :: View next topic |
| Author |
Message |
Bob
Guest
|
 Posted: Wed Mar 03, 2004 4:56 am Post subject: Delphi 5 refuses to connect to SQL 7 in Win2k via ADO |
 |
|
Can anyone help?
I'm using ADO to connect to a SQL 7 database in Win2k. I just get the error
"Prperty value is invalid. Make sure the value is typed correctly"
This is pretty much regardless of what's actually in the connection string (although it does react to a wrong user name). I've tried it all ways I can think of. Currently using MDAC 2.8, after no success with 2.6
Does anyone have a conn string they know works for D5 - SQL Server 7 via ADO? Provider is SQLOLEDB.1
Any help greatly appreciated.
|
|
| Back to top |
|
 |
Rolf Hesterberg
Guest
|
| Posted: Wed Mar 03, 2004 9:27 am Post subject: Re: Delphi 5 refuses to connect to SQL 7 in Win2k via ADO |
|
|
Hi Bob
I know, that Delphi 5.0 had problems with the ADO componentes. Did you
upgrade to Delphi 5.2?
| Quote: | I'm using ADO to connect to a SQL 7 database in Win2k. I just get the
error
"Prperty value is invalid. Make sure the value is typed correctly"
|
Rolf Hesterberg
|
|
| Back to top |
|
|
Del Murray
Guest
|
| Posted: Wed Mar 03, 2004 2:29 pm Post subject: Re: Delphi 5 refuses to connect to SQL 7 in Win2k via ADO |
|
|
I didn't have any problem at all after installing the update to the ado
drivers from the delphi site. Do you have the network client utility for sql
server installed on your machine ? is it possible that you have an alias in
there that is the same name as the server you are trying to connect to ?
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
