AspWebSolution Forums » Products » ASP Report Wizard v2 » Error #:-2147467259 Invalid connection

index | search | no replies | posting guidelines | help

login | register

» »

:: Error #:-2147467259 Invalid connection :: (6)

Post a New Message | Post a Reply

Feb 13 2007, 11:42 AM

Error #:-2147467259 Invalid connection

alfher

since: Feb 13, 2007
from: mexico Hello, i need who would explain to me like doing sig. coneccion for the ASP Report Wizard, treatment to connect me to a server SQL in a direction IP, for example:
<%

Dim objWiz
Set objWiz = Server.CreateObject("AspWebSolution.ReportWizard2")

'Make sure you initialize before adding any HTML text
objWiz.Init("Provider=MSDASQL;Driver={SQL Server};" & _

"Server=111.222.33.4:1494\SQL3\SQL3;Database=My_DataBase;" &

_
"User ID=user01;Password=client01;")
%>

but the following error appears to me:

Errors Occured!
Error #:-2147467259
[Microsoft][ODBC SQL Server Driver][DBNETLIB]Invalid connection.

I need help please...

Thanks.

Feb 14 2007, 6:47 AM

Re: Error #:-2147467259 Invalid connection

ghost

from: Washington, DC Are you using SQL Server 2000 or SQL Server 2005?

-------------------------
Ghost

Feb 14 2007, 11:13 AM

Re: Error #:-2147467259 Invalid connection

alfher

since: Feb 13, 2007
from: mexico SQL Server 2000

Feb 14 2007, 1:27 PM

Re: Error #:-2147467259 Invalid connection

ghost

from: Washington, DC It seems the connection string is not recognized by ADO. Try using this:

strConnectionString = "Provider=MSDASQL;Driver={SQL Server};" & _
"Server=111.222.33.4:1494;Database=My_DataBase;" & _
"User ID=user01;Password=client01;"

For more information, check the Connection String Samples section of the Users' Manual.

-------------------------
Ghost

Feb 14 2007, 3:34 PM

Re: Error #:-2147467259 Invalid connection

alfher

since: Feb 13, 2007
from: mexico same error...

Error #:-2147467259
[Microsoft][ODBC SQL Server Driver][DBNETLIB]Invalid connection.

Mar 28 2007, 3:51 PM

Re: Error #:-2147467259 Invalid connection

Eric97386

since: Mar 28, 2007
from: Corvallis, OR Dim objWiz
Set objWiz = Server.CreateObject("AspWebSolution.ReportWizard2")
With objWiz
.LincenseKey = "xxxx-xxxx-xxxx-xxxx-xxxx"
.StyleSheet = "styles.css"
.Init("Driver={SQL Server};
Server=yourserver;
Database=yourdatabase;
UID=youruser;
PWD=yourpassword;
CommandTimeout=600")
.Title = "WINDOW TITLE"
.CommandTimeout = 600
.DisplayReports
End With
Set objWiz = Nothing

Pages: (1) [1]