Data source name not found and no default driver specified!

[marcusleemitchell]

Got a error, and really need some help.
i'm relativly new to asp and mssql, have come from coldfusion a mysql.

i have a site and a datasource that both work fine on my local machine, however with all the setting seemingly correct, when using the 'live' web server i get the following message:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

/hushpuppies/Default.asp, line 8

(line 8 being:

Application("

http://WWWProduct_ConnectionString")

= "Provider=MSDataShape.1;Extended Properties=""Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=;Use Encryption for Data=False;Tag with column collation when possible=False"";Persist Security Info=False;Data Source=;User ID=;Initial Catalog=

http://WWWProduct;Data

Provider=SQLOLEDB.1;User Id=;PASSWORD=;&quot

what could be causing the error?
i've checked the server connection and all all seems to be working fine. big disappointment!

many thanks to anyone who may be able to shed any light on this!

Marcus Lee Mitchell

 

[SQLBill]

What version of MDAC do you have installed? It should be at least 2.7.

-SQLBill

 

[Corran007]

did you remove the datasource from that line because right now its set too blank.

 

[marcusleemitchell]

sorted it - thanks for your help

 

[SQLBill]

What was the solution? You should always state what solved your issue so it can help others.

-SQLBill

 

[marcusleemitchell]

very sorry, got in a rush to leave work!

all it needed was for the application to be created in IIS (right click on the folder/properties, create application) just an oversight on my part.

thanks for the reply tho.

Marcus