Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

ASP.NET Forum


You are currently viewing our ASP.NET Forum as a guest. Please register to participate.
Login



Reply
Strange DNS problem with Win 64 and asp 1.1
Old 06-12-2006, 05:01 AM Strange DNS problem with Win 64 and asp 1.1
Junior Talker

Posts: 2
Trades: 0
Hello,

I recently upgraded to Windows 64. I installed asp 1.1 and followed the Microsoft patch to run it under 32 bit mode. I'm also using IIS.

I have a site running on asp using ms sql server 2000 as the db. I've set up the server added the ODBC entries for the datasource that I use (although interesting I only had the sql server connector not the whole list of connectors (access etc ) that I had under win 2000). I then run the asp site using my IIS localhost. The static site pages work fine but and dynamic page throws the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified



Now I have checked all of the DNS entries for spelling mistakes etc and they are fine. So I'm stuck as to why I can't connect to the db! By the way after I set up the ODBC entries if I test the connection it connects correctly.



Any help? Anyone else had similar probs?



Many thanks

Sonic.

P.S I am running the following connection sub:

Sub OpenWebSiteDSN()
Set websiteConn = Server.CreateObject("ADODB.Connection")
websiteConnection="DSN=MydatabaseConn;Database=Myd atabase;UID=webuser;PW=;"
websiteConn.Open websiteConnection
End Sub
Sonic123 is offline
Reply With Quote
View Public Profile
 
 
Register now for full access!
Old 06-12-2006, 05:37 AM Re: Strange DNS problem with Win 64 and asp 1.1
chrishirst's Avatar
Missing! presumed drunk.

Posts: 41,517
Name: Chris Hirst
Location: Blackpool. UK
Trades: 0
does the IUSR_ account have permissions to SQL server?
__________________
Chris. ->> Links are advertising NOT optimising!! <<-
A foolish consistency is the hobgoblin of little minds
Thought for today:- I SEO the only industry where all the cowboys are Indians?

Last edited by chrishirst; 06-12-2006 at 05:42 AM.. Reason: hit enter too soon
chrishirst is online now
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 06-12-2006, 05:56 AM Re: Strange DNS problem with Win 64 and asp 1.1
Junior Talker

Posts: 2
Trades: 0
Hi Chris,

Thanks for the reply. I've checked the IUSR_ account settings in IIS, how do I enable permissions to the SQL server?

Sonic
Sonic123 is offline
Reply With Quote
View Public Profile
 
Old 06-12-2006, 06:42 AM Re: Strange DNS problem with Win 64 and asp 1.1
chrishirst's Avatar
Missing! presumed drunk.

Posts: 41,517
Name: Chris Hirst
Location: Blackpool. UK
Trades: 0
is SQL server is running on the same box ?

You can add the user account to;
a usergroup that has permissions to SQL (though not a group that has admin permission to the server)
the SQL login list in Enterprise Manager

have you tested the connection with a DSNLess connection string ?
__________________
Chris. ->> Links are advertising NOT optimising!! <<-
A foolish consistency is the hobgoblin of little minds
Thought for today:- I SEO the only industry where all the cowboys are Indians?
chrishirst is online now
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 10-30-2006, 03:32 PM Re: Strange DNS problem with Win 64 and asp 1.1
Junior Talker

Posts: 1
Name: Ingmar Groppe
Trades: 0
We have the same problem. Have you found a solution to it?

Ingmar
igroppe is offline
Reply With Quote
View Public Profile
 
Old 10-30-2006, 05:03 PM Re: Strange DNS problem with Win 64 and asp 1.1
Junior Talker

Posts: 1
Name: Edwyn
Trades: 0
Hello all,

I am having the same problem as mentioned above, but will provide a few more details. I am migrating an ASP web app to a machine runnning Windows 2003 64 bit (IIS6). The application is accessing a MS SQL Server on a different machine. The app worked fine on the Windows 2003 32 bit (IIS6) machine, but will not work on the new machine. I have tested the ODBC for connectivity and it works fine. I also tried changing the connection in the app to a DSN-less connection string rather than a DSN connection and it worked fine.

I would like to use the DSN connection method so I am trying to figure out how to make it work.

Any help is greatly appreciated.

Thanks
orangeforest is offline
Reply With Quote
View Public Profile
 
Old 11-04-2006, 12:16 PM Re: Strange DNS problem with Win 64 and asp 1.1
Average Talker

Posts: 23
Trades: 0
Try this connection method

Set conn = Server.CreateObject("ADODB.Connection")
Set rs_conn = Server.CreateObject("ADODB.recordset")
conn.CursorLocation = 3
conn.IsolationLevel = 4096
conn.CommandTimeout = 60
conn.ConnectionTimeout = 30
call conn.Open("Provider=SQLOLEDB;SERVER=SERVERNAME;DAT ABASE=YOURDATABASENAME;UID=USERNAME;PWD=PASSWORD;N etwork=DBMSSOCN.DLL","USERNAME","PASSWORD")

You can replace servername with
Local IP Address
Remote IP Address
or the server name.

In your connect string I don't see how you are defining what server to connect to.
__________________
Free Gaming Websites

Please login or register to view this content. Registration is FREE

News - Forums - Features
jayr1021 is offline
Reply With Quote
View Public Profile
 
Old 11-04-2006, 12:54 PM Re: Strange DNS problem with Win 64 and asp 1.1
ADAM Web Design's Avatar
Canadastaninianite

Posts: 5,938
Name: Adam for web page design, not program
Location: Toronto, Ontario, Canada
Trades: 0
Actually, you'll have this problem no matter what you do.

I also have Windows XP 64-bit edition and the problem is that there are no native 64-bit Jet ODBC drivers for it.

Your solution is to flip IIS into 32-bit mode. See this support article:

http://support.microsoft.com/?id=894435
__________________

Please login or register to view this content. Registration is FREE
|
Please login or register to view this content. Registration is FREE
(my blog)


Please login or register to view this content. Registration is FREE
(with proof)
ADAM Web Design is offline
Reply With Quote
View Public Profile Visit ADAM Web Design's homepage!
 
Old 11-16-2006, 04:26 PM Re: Strange DNS problem with Win 64 and asp 1.1
Junior Talker

Posts: 1
Trades: 0
An additional item to look for is make sure you are using the 32 bit version of the ODBC Data Source Administrator located in:
\windows\syswow64\odbcad32.exe

For further information view the following link:
http://www.64advantage.com/blog/blog...64-bit+Windows
blegger is offline
Reply With Quote
View Public Profile
 
Reply     « Reply to Strange DNS problem with Win 64 and asp 1.1
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.30331 seconds with 12 queries