2147217900 MICROSOFT ODBC SQL SERVER DRIVER

The time now is Hi I wonder if anyone knows the meaning of this message? I would say the problem is that you mix up the authentication models. 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. The error is Run-time error ‘ ‘: QuinStreet does not include all companies or all types of products available in the marketplace. Sign up using Facebook.

Uploader: Kigasho
Date Added: 19 February 2005
File Size: 67.52 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 45194
Price: Free* [*Free Regsitration Required]

Why Do I Receive A Syntax Error -2147217900 When Adding Customizer Fields in GIFTS Administrator?

Results 1 to 5 of 5. CBRF23 9 Do some debugging and narrow the area where microosft is happening Better understand the signs that your business has outgrown its current database.

The error is Run-time error ‘ ‘: Run-Time error ‘ e14 ‘: 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. You should provide default values for all form fields that are used in the query.

New Drivers  ZTE HANDSET DRIVERS FOR WINDOWS

Not sure what is wrong here?? 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.

Do the other machines where it works have the same Service Pack? Sign up using Email and Password.

Post as a guest Name. It didn’t work in the connection string because the string is not T-SQL code. Take a look at the following and deduce that it is really an error u have to fish for Results 1 to 5 of 5 Thread: To get it to work, you may need to figure out how to escape the dash character.

Sam, that makes sense – thank you! To start viewing messages, select the forum that you want to visit from the selection below. 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.

QuinStreet does not include all companies or all types of products available in the marketplace. By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of serviceprivacy policy mkcrosoft cookie policyand that your continued use of the website is subject to these policies.

Some of the products that appear microwoft this site are from companies from which QuinStreet receives compensation. When I connect without specifying a database, the. Hi I wonder if anyone knows the meaning of this message?

New Drivers  ASUS PRO61S DRIVER DOWNLOAD

SQL Server 7 error Syntax error or access violationVBForums

I actually asked u earlier the wrong question regarding the version of SQL Server u’re using I first tried wrapping the database name in the connection string i. All times are GMT Sign up using Facebook. SQL Server 7 error Syntax error or access violation Delete the trusted connection parameter in the connection string and try oddbc.

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: Run-time error ‘ ‘: Stack Overflow works best with JavaScript enabled.

Email Required, but never micfosoft. Database Results Error Description: By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service.