Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
KB article - 06125: [dbnetlib][connectionopen] error
OS: Win2K
Excel version: 2000 SQL Server Version: 7.0 I'm attempting to test this code exactly as describe in this article: Microsoft Knowledge Base Article - 306125: HOW TO: Import Data from Microsoft SQL Server into Microsoft Excel I followed the steps here exactly. I selected "Microsoft ActiveX Data Objects 2.6 Library" at the step of referencing the ADO Object Library. Upon executing the macro, I receive the following error at the line of code where it attempts to open the connection: cnPubs.Open strConn <--- line where error occurrs The error message is, "[DBNETLIB][ConnectionOpen (Connect ()).]SQL Server does not exist or access denied." The SQL Server is running for a fact. Anyone else ever encountered this or know how I can resolve this error? I have full permissions to the SQL server to which I'm attempting to connect to. Please help. Sib |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
KB article - 06125: [dbnetlib][connectionopen] error
No sooner did I post this message than I realized the
problem. I didn't change "(local)" in the "DATA SOURCE=" reference to be the machine name with SQL server. Sorry, I'm a halfwit sometimes :( cnPubs.Open strConn <--- line where error occurrs The error message is, "[DBNETLIB][ConnectionOpen (Connect ()).]SQL Server does not exist or access denied." |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
11.04 forex article | Excel Worksheet Functions | |||
some forex article | Excel Worksheet Functions | |||
Good article on Microsoft | Excel Discussion (Misc queries) | |||
Good article on Microsoft | Excel Worksheet Functions |