I have one application on vb 6.0 and backhand is sql server 2000, now we are planning it to migrate to sql server 2005.
My application and sql server is in different location. Now problem is we are not able to connect sql server 2005. We are getting 'Server has not yet open'.
In code we are using
app.LogOnServer "p2ssql.dll", GBserver, sDatabaseName, gsReportUser, gsReportPwd
Please help me
IP Logged