Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: robodad669
- Order by date
-
Run-time error '1004' when running SQL stored procedure (VB in Excel)
Steve thanks for sending towards connection strings. This one worked for me in Excel accessing stored procedures with temp tables. Const stCon As String = "OLEDB;Provider=MSDASQL.1;DRIVER=SQL Server;SERVER=KS01;Database=NOISE;Initial Catalog=NOISE;Trusted_Connection=Yes"- robodad669
- Post #17
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Run-time error '1004' when running SQL stored procedure (VB in Excel)
This is the connection string that does not work for temp tables. Const stCon As String = "OLEDB;Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=True;Initial Catalog=NOISE;Data Source=KSLPQQ03" Also heard that "I need to be connecting with an account that has db_ddladmin...- robodad669
- Post #15
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Run-time error '1004' when running SQL stored procedure (VB in Excel)
StevenK I have the exact same problem with temp table access via excel. Can you explicitly write the connection string detail that made the difference. Many thanks for the pointers with this. Robodad669- robodad669
- Post #11
- Forum: VBA Visual Basic for Applications (Microsoft)
