Microsoft SQL Server
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community ForumsDatabasesMicrosoft SQL Server

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old May 2nd, 2005, 09:03 AM
ShadowCoder ShadowCoder is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: May 2005
Location: Ottawa
Posts: 20 ShadowCoder User rank is Just a Lowly Private (1 - 20 Reputation Level) 
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

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsDatabasesMicrosoft SQL Server > Database path rules


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 6 hosted by Hostway