Do the other machines where it works have the same Service Pack? Email Required, but never shown. CBRF23 9 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. I first tried wrapping the database name in the connection string i.
|Date Added:||3 October 2007|
|File Size:||46.42 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|Price:||Free* [*Free Regsitration Required]|
Sam, that makes sense – thank you!
Run-time error ‘-2147217900 (80040e14)
It didn’t work in the connection string because the string is not T-SQL code. When I connect without srver a database, the. Needed to wrap the database name in square brackets [ ] Have you tried to wrap the xql name in [ ] I first tried wrapping the database name in the connection string i.
Results 1 to 5 of 5. Hi I wonder if anyone knows the meaning of this message?
You may have to register before you can post: Sign up using Email and Password. Hi cboden, I commented on Dee’s microeoft above regarding this – I noticed it shortly after posting and corrected the TrustedConnection parameter.
OK, credit for this 2142717900 should go to Dee and Sam who commented on the original question, however I can’t mark eql comment as the answer, so here it is: Delete the trusted connection parameter in the connection string and try again. Take a look at the following and deduce that it is really an error u have to fish for SQL Server 7 error Syntax error or access violation Better understand the signs that your business has outgrown its current database.
Having trouble connecting to SQL Server database from VBA using ADO connection – Stack Overflow
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:. Not sure what is wrong here?? You should provide default values for all form fields that are used in the query. 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’m not sure how ADO works in that case but I would assume that it doesn’t use the configured user and connects with the windows account. Email Required, but never shown. Database Results Error Description: CBRF23 9 Run-Time error ‘ e14 ‘: Run-time error ‘ ‘: Sign up or log in Sign up using Google.
The error is Run-time error ‘ ‘: QuinStreet does not include all companies or all types of products available in the marketplace. This compensation may impact how and where products appear on this site including, for example, the order in which they appear.
Results 1 to 5 of 5 Thread: