Have you tried to wrap the database name in [ ] All times are GMT Take a look at the following and deduce that it is really an error u have to fish for QuinStreet does not include all companies or all types of products available in the marketplace. The time now is Database Results Error Description:
|Date Added:||17 March 2005|
|File Size:||35.70 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|Price:||Free* [*Free Regsitration Required]|
Run-Time error ‘ e14 ‘: You should provide default values for all form fields that are used in the query. To start viewing messages, select the forum that you want to visit from the selection below. You may have to register before you can post: All times are GMT To get it to work, you may need to figure out how to escape the dash character.
Hi cboden, I commented on Dee’s comment above regarding 2147217090 – I noticed it shortly after posting and corrected the TrustedConnection parameter. Run-time error ‘ ‘: When I connect without specifying a database, the.
Have you tried to wrap the database name in [ ] Database Results Error Description: OK, credit for this answer should go to Dee and Sam who commented on the original question, however I can’t mark a comment as the answer, so here it is:.
But, since I can now access the database and the tables I need, which was the original question, I wanted to mark it as answered. I’ve tried single and double quotes, backslash, square brackets, parentheses and curly brackets and nothing seems to work to escape the hyphen in the database name within the connection string. Do the other machines where it works have the same Service Pack?
Sign up using Email and Password.
Why Do I Receive A Syntax Error -2147217900 When Adding Customizer Fields in GIFTS Administrator?
Needed to wrap the database name in square brackets [ ] DefaultDatabase property of the ADO connection object returns “” which I don’t even see as an available database on that server??
Post as a guest Name.
Having trouble connecting to SQL Server database from VBA using ADO connection – Stack Overflow
Sam, that makes sense – thank you! I would say the problem is that you mix up the authentication models. I actually asked u earlier the wrong question regarding the version of SQL Server u’re using QuinStreet does not include all companies serer all types of products available in the marketplace. Some of the products that appear on this site are from companies from which QuinStreet receives compensation.