all groups > sql server odbc > december 2003 >
You're in the

sql server odbc

group:

ODBC


ODBC Ricardo
12/27/2003 5:08:01 AM
sql server odbc:
When trying to open a link from the main Web Page of
TimberHunt I get the following information:

Microsoft OLE DB Provider for ODBC Drivers
error '80040e07'
[Microsoft][ODBC SQL Server Driver][SQL Server]Error
converting data type varchar to numeric.
/timber_trade/comp_trade_board.asp, line 60

Anyone available to help solve the problem?

Will appreciate your support.
Re: ODBC Ayaz Ahmed
3/19/2004 10:38:44 PM
Hello,

<%
set conn1=server.CreateObject("adodb.connection")
conn1.cursorlocation=3
conn1.Open "Provider=sqloledb;" & _
"Data Source=ayaz;" & _
"Initial Catalog=ayaz;" & _
"User Id=ayaz;" & _
"Password=ayaz"
%>

try this.


Warm Regards,

Ayaz Ahmed
Software Engineer & Web Developer
Creative Chaos (Pvt.) Ltd.
"Managing Your Digital Risk"
http://www.csquareonline.com
Karachi, Pakistan
Mobile +92 300 2280950
Office +92 21 455 2414

*** Sent via Developersdex http://www.developersdex.com ***
AddThis Social Bookmark Button