Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
humsuplau
Starting Member
1 Post |
 Posted - 2003-12-19 : 02:19:06
|
| Hi,I am having trouble connecting to a sql DB using cocoon because the admin person who created the DB gave it a two word name (e.g. "Soccer Scores") and I don't know how this is handled.I have tried using an escape character, an underline character, quotation marks but to no avail. The relevent (and currently incorrect) line of code is: <dburl>jdbc:microsoft:sqlserver://blah:1433/Soccer Scores</dburl>A query i am trying to run is:Select * from Soccer Scores.todays_results;But it is evident that such a query will not run. Any ideas on how we can run queries on the Soccer Scores database?Thanks. |
|
|
cDc
Starting Member
30 Posts |
Posted - 2003-12-19 : 02:53:49
|
| try it like this Select * from [Soccer Scores].todays_results; |
 |
|
|
|
|
|
two word database name