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.
|Date Added:||19 February 2005|
|File Size:||67.52 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|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.
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.
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?
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.