>>Have you set the SQL server to allow remote connections, use TCP/IP, and allow port 1433 so you can connect remotely?
>I can get in using sql manager no problem and remote connections allowed. I've managed to login using
>constring = "Driver=SQL Server;Server=SERVER-ACC\SQLEXPRESS; Initial Catalog=acctrax; User Id=user1; Password=password1"
>
>but now this code fails
>
lcsqlSelect = "SELECT * from isinvoices"
>IF SQLEXEC(lnSqlHandler,lcSqlselect,"Cur1") <0
>
>
>~M
What is the error this time? Do you have IsInvoices table and does this user has access rights to the tables?
If it's not broken, fix it until it is.
My Blog