
May 2nd, 2005, 09:03 AM
|
|
Registered User
|
|
Join Date: May 2005
Location: Ottawa
Posts: 20
Time spent in forums: 1 h 54 m 12 sec
Reputation Power: 0
|
|
|
Database path rules
I am using ODBC SQL Server Driver to read data into an app from a database on an MS SQL Server. The user is responsible for providing the full path and filename by selecting it themselves. For testing purposes I have been using "C:\TestTest\database.mdf". If I use that path everything works correctly, however, if I use
"C:\Test Test\database.mdf" I receive the following error: 80004005
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database requested in login '<databasename>.mdf'. Login fails
Unspecified error
Microsoft OLE DB Provider for ODBC Drivers
This is all being done in C++ and COM. The user has the Microsoft SQL Server Desktop Engine 2000A on their system and we use it, along with the ODBC driver, to read information in from the provided database. In attempting to track down if the whitespace in the path is indeed the problem, or if it's something else, I have been trying to find information on what the naming convention is for database names and their full paths but have not been able to find any resources on this issue. If anyone has any URLs on such information, or any thoughts, could you please post them. thanks
|