SQL Server Developer Client Database

[goodmanrAy]

Hello

I've recreated an SQLServer database on my home pc using SQL Server Developer.

I'm now trying to connect to this database using delphi.

Does anyone have an idea of what my connection string should look like? As there is no server as such?

Any help greatly appreciated.

Thanks

Andrew

 

[whosrdaddy]

Do you mean you are using MSDE?

the connectionstring should be the same as connection to a normal sql server. something like this :

'Provider=SQLOLEDB.1;Data Source=localhost;Initial Catalog=YourDbName;Persist Security Info=False;User ID=YourUser;Password=YourPassword'

make sure you have latest MDAC on your pc.

-----------------------------------------------------
What You See Is What You Get
Never underestimate tha powah of tha google!

 

[goodmanrAy]

Hello whosrdaddy

Thanks for the reply.

Yes I managed to get it to connect. Was being and idiot and misspelling the server!

Cheers