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.