SQL Server 2008 USE database with [] Delphi ADO

Question

In SQL server 2008 Management studio I can do this

Use [C:\test\somedb...]

When I use Delphi 2009 with the same command, using ADO, the [] seems to be interpreted as a parameter and the command fails with parameter improperly defined error. There is no parameter - I just need to use the [] because of the \ in the file name. Double quotes don't work either in Delphi / ADO or Management Studio.

Thanks in advance...

Delphi sees : and thinks it's a parameter, have you tried turning ParamCheck off? — jasonpenny
– jasonpenny, Commented Jul 7, 2011 at 15:41
I believe I did but as Ken White said the USE is not necessary so I removed it. — RBrowning99
– RBrowning99, Commented Jul 8, 2011 at 13:17
If I remove [] it fails because \ and : are not valid in an identifier. — RBrowning99
– RBrowning99, Commented Jul 8, 2011 at 13:17

Ken White · Accepted Answer · 2011-07-08 01:52:22Z

1

With ADO, you don't typically USE in the SQL. You specify the database and the other information (driver, etc.) in the ConnectionString. It works in SSMS because that's not using ADO; SSMS uses the SQL Server client directly (which has different requirements than ADO).

You can find connection string information for your specific SQL Server version here.

edited Jul 8, 2011 at 1:52

answered Jul 8, 2011 at 1:28

Ken White

126k15 gold badges237 silver badges476 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

RBrowning99 Over a year ago

Hello - yes I know that. Some code I didn't write has this though and it caused a problem when the use statement was applied to a file based database where the file path contains a \ and was thus wrapped in [].

Collectives™ on Stack Overflow

SQL Server 2008 USE database with [] Delphi ADO

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related