By admin on October 21, 2019 0 Comments

I actually asked u earlier the wrong question regarding the version of SQL Server u’re using The time now is Hi cboden, I commented on Dee’s comment above regarding this – I noticed it shortly after posting and corrected the TrustedConnection parameter. I’m receiving an error when trying to connect to said database. Needed to wrap the database name in square brackets [ ]

Uploader: Gasida
Date Added: 14 November 2017
File Size: 43.2 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 34326
Price: Free* [*Free Regsitration Required]

It didn’t work in the connection string because the string is not T-SQL code.

When I connect without specifying a database, the. Sign up or log in Sign up using Google. CBRF23 9 You may have to register before you can post: I first tried wrapping the database name in the connection string swrver.

Having trouble connecting to SQL Server database from VBA using ADO connection – Stack Overflow

Some of the products that appear on this site are from companies from which QuinStreet receives compensation. Sign up using Facebook.

Results 1 to 5 of 5. DefaultDatabase property of the ADO connection object returns “” which I don’t even see as an available database on that server?? All times are GMT 2142717900 Server 7 error Syntax error or access violation Hi I wonder if anyone knows the meaning of this message?


Run-Time error ‘ e14 ‘: To start viewing messages, select the forum that you want to visit from the selection below. This compensation may impact how and where products appear on this site including, for example, the order in which they appear.

Run-time error ‘-2147217900 (80040e14)

QuinStreet does not include all companies or all types of products available in the marketplace. Do the other machines where it works have the same Service Pack?

By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service. You should provide default values for microspft form fields that are used in the query. Do some debugging and narrow the area where it is happening Database Results Error Description: However the problem is that the some of the classes work as they should but I get errors when trying servef use others?. Have you tried to wrap the database name in [ ] Run-time error ‘ ‘: 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.


SQL Server 7 error Syntax error or access violationVBForums

I would say sqql problem is that you mix up the authentication models. By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of serviceprivacy policy and derver policyand that your continued use of the website is subject to these policies. The time now is 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:. Take a look at the following and deduce that it is really an error u have to fish for I just did, and got partial success.

I’m receiving an error when trying to connect to said database. Sign up using Email and Password. Delete the trusted connection parameter in the connection string and try again. Needed to wrap the database name in square brackets [ ]