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 [ ]
|Date Added:||14 November 2017|
|File Size:||43.2 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|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?
SQL Server 7 error Syntax error or access violationVBForums
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 [ ]