Datasource name not found message

[zebrastripes]

Hi,

I'm having a problem that is really driving me up the wall. I recently created a web project on a windows 98 pc with Personal Web Server 4.0 and Front Page 2000 Server Extensions. I'm just trying to run a simple stored procedure from an ASP page (for a SQL 7.0 database) and I keep getting this message, "Data source name not found and no default driver specified." On the microsoft knowledge base there's an article about this message. It basically suggests going into the Personal Web Server Manager and checking to make sure that a virtual directory for the web project has been created and that the execute permission is checked. I did both of these things and still no luck.

Any ideas? Has anybody run into this before?

Thanks for any help.

zebrastripes

 

[Stretchy]

Are you Using ODBC connectivity and stated that your SQL 7.0 database is the datasource and its location?

Otherwise maybe posting the head of your code in the forum might help.

Not sure else
_______________
Stretchy [Pipe]

 

[MerlinB]

A Data Source Name is an ODBC connection name created via Control Panel. You may have created the Data Source Name under the 'User' tab, rather than the 'System' tab, in the ODBC administrator. A User DSN is only visible to your Login - but the web uses the IUSR_xxx login. So you need to delete the existing ODBC DSN, and re-create it as a System DSN - so ALL users of the computer can use it.

Does this help?

http://www.websitedesign.co.uk

http://www.zentext.com

(Content Management)

 

[zebrastripes]

Hi everyone, thanks for the feedback. MerlinB, no, I wasn't using a dsn. I was actually just using a straight ODBC connection string in my asp page. In my initial
connection string, I had "Provider = SQL-OLEDB." I changed this to "Driver={SQL Server}" and it worked. Honestly, I'm not sure why one worked and not the other.

Zebrastripes