troubleshooting Question

-2147467259 DBNMPNTW ConnectionOpen CreateFile error in SQL Server with ECSQ machine on network.

Avatar of stephenlecomptejr
stephenlecomptejrFlag for United States of America asked on
Programming Languages-OtherVisual Basic Classic
5 Comments1 Solution2483 ViewsLast Modified:
Set rsSQLData = CreateObject("ADODB.Recordset")
Set cnSQLData = CreateObject("ADODB.Connection")
cnSQLData.Open "Provider=sqloledb;" & _
             "Data Source=ECSQ; Password=smiley" & _
             "Initial Catalog=Access;" & _
             "User Id=Access;" & _

Right where after I have cnSQLData.Open - I get all of the coding highlighted and the following error:
-2147467259 # [DBNMPNTW]ConnectionOpen (CreateFile()).

I do have my SQL Server installed on a computer with its Full computer name:  ecsq.
For me to get on ECSQ machine I have to type a UserName and Password:
My UserName is eqcollab and my password is simon.
So I am aware that I do not have any of this information in the cnSQLData.Open string- could this be causing my problem?

Please also note that I can run this on any machine that I have already mapped to the ECSQ machine without any errors.  I notice that this problem only occurs on machines that are not mapped to the ECSQ.   If the only way I can use the above coding works with having the client's machine mapped to ECSQ then I am in trouble - I would still have to figure a way to map this through coding still because some users on a Novell network are unable to go into their Tools - Map Network Drive.
What code or syntax I could write that would open the SQL Server connection between the client and user with the above?

Thanks for any input.

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 5 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros