DataDirectory problems

  • Thread starter Thread starter John Bailo
  • Start date Start date
J

John Bailo

I'm having tons of trouble with the "DataDirectory" attribute in a
connection string.

I am using a remote SQL2005 server. DataDirectory seems to refer to
local directory on the web server...right?

Does DataDirectory apply for both SQL2005 and SQLExpress?

Did even need that attribute? Why can't I just set InitialCatalog?
 
John Bailo said:
I'm having tons of trouble with the "DataDirectory" attribute in a
connection string.

I am using a remote SQL2005 server. DataDirectory seems to refer to
local directory on the web server...right?

Does DataDirectory apply for both SQL2005 and SQLExpress?

Did even need that attribute? Why can't I just set InitialCatalog?

AFAIK DataDirectory is used when you use AttachDbFileName. It allows the
database to be automatically attached as part of the connection. I have
never used it in production only as part of a demo installation.

PS
 
Back
Top