REPOST - Please help.

Nick Poulis

Hi to all

I face the following problem,

the following code (very simple) is contained in
a referenced class method
Dim cn As New OdbcConnection( "DSN=BOC;UID=Ad min;PWD=;")
cn.Open()

When aspx page reaches the method containing those lines
I get the following server error:
ERROR [IM002] [Microsoft][ODBC Driver Manager]
Data source name not found and no default driver specified
Of course I have checked most possible reasons like DSN name and
it's existence in System DSN and User DSN.

Also checked that this DSN works for example with Access 2000 and
it does retrieve data from the source it points (Liant Relativity). Again I
checked if the IIS 6.0 application working process is running as a user that
has
has access to this DSN but I always get the same error.

It's strange cause there is no problem with IIS 5 and this came up when
the web app was transferred to an Win Server 2003 with IIS 6.

What is the difference between IIS 5 and IIS 6 on this matter?

Please any ideas on that error will save my day ;-).
Nick
np*****@hol.gr

Nov 19 '05 #1

Subscribe Reply

1566

Alvin Bruney [MVP - ASP.NET]

the error indicates that your dsn isn't configured correctly. i would start
there from scratch by removing and setting up the dsn again to see if that
helps

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc, Amazon.com etc
"Nick Poulis" <Ni********@dis cussions.micros oft.com> wrote in message
news:51******** *************** ***********@mic rosoft.com...

Hi to all

I face the following problem,

the following code (very simple) is contained in
a referenced class method
Dim cn As New OdbcConnection( "DSN=BOC;UID=Ad min;PWD=;")
cn.Open()

When aspx page reaches the method containing those lines
I get the following server error:
ERROR [IM002] [Microsoft][ODBC Driver Manager]
Data source name not found and no default driver specified
Of course I have checked most possible reasons like DSN name and
it's existence in System DSN and User DSN.

Also checked that this DSN works for example with Access 2000 and
it does retrieve data from the source it points (Liant Relativity). Again
I
checked if the IIS 6.0 application working process is running as a user
that
has
has access to this DSN but I always get the same error.

It's strange cause there is no problem with IIS 5 and this came up when
the web app was transferred to an Win Server 2003 with IIS 6.

What is the difference between IIS 5 and IIS 6 on this matter?

Please any ideas on that error will save my day ;-).
Nick
np*****@hol.gr

Nov 19 '05 #2

Nick Poulis

Hi Alvin and thanks for your answer,

Haven't tried that ;) since it returned data using it from access....

Anyway I will try that too (sometimes simplest things do the job right?)

But please stay tuned to the thread cause I'm not so optimistic LOL!

-------------------
Nick Poulis
np*****@hol.gr
-------------------

"Alvin Bruney [MVP - ASP.NET]" wrote:

the error indicates that your dsn isn't configured correctly. i would start
there from scratch by removing and setting up the dsn again to see if that
helps

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc, Amazon.com etc
"Nick Poulis" <Ni********@dis cussions.micros oft.com> wrote in message
news:51******** *************** ***********@mic rosoft.com...
Hi to all

I face the following problem,

the following code (very simple) is contained in
a referenced class method
Dim cn As New OdbcConnection( "DSN=BOC;UID=Ad min;PWD=;")
cn.Open()

When aspx page reaches the method containing those lines
I get the following server error:
ERROR [IM002] [Microsoft][ODBC Driver Manager]
Data source name not found and no default driver specified
Of course I have checked most possible reasons like DSN name and
it's existence in System DSN and User DSN.

Also checked that this DSN works for example with Access 2000 and
it does retrieve data from the source it points (Liant Relativity). Again
I
checked if the IIS 6.0 application working process is running as a user
that
has
has access to this DSN but I always get the same error.

It's strange cause there is no problem with IIS 5 and this came up when
the web app was transferred to an Win Server 2003 with IIS 6.

What is the difference between IIS 5 and IIS 6 on this matter?

Please any ideas on that error will save my day ;-).
Nick
np*****@hol.gr

Nov 19 '05 #3

Similar topics

1759

Please repost answer

by: Joe | last post by:

Please repost answer message did not make it last time Hello, Joe here, wanted to get the 411 on this article. I posted in the FrontPage forum but there is never an answer. So I have come here, where all my IIS problems have been solved (Thank YOU!!) I want to create a small utility web site with a logon page and a form connected to an Access database. The article below explains exactly how but when

ASP / Active Server Pages

1868

Repost: messages in compact.net

by: Adam | last post by:

I've posted about this previously, but failed to receive a satisfactory response, so have included a code sample: I am trying to receive messages from an HTML viewer control in compact.net (c#), but cannot use message window as the control's parent window, as this is invisible and so the html is not viewable! I have a code sample showing the problem at www.tenwisevirgins.com/Example.zip

C# / C Sharp

2837

REPOST: extremely long link times

by: Steve McLellan | last post by:

Hi, Sorry to repost, but this is becoming aggravating, and causing me a lot of wasted time. I've got a reasonably large mixed C++ project, and after a number of builds (but not a constant number) linking (and sometimes compiling) becomes immensely slow, and task manager shows that link.exe (or cl.exe) is barely using any processor time, but an awful lot of RAM (around 150-200MB). I'm going to keep an eye on page faults since I can't...

.NET Framework

1233

REPOST - Please can someone help me with a simple cookie question

by: Alan Silver | last post by:

Hello, I am having a problem setting and resetting cookies. I'm sure I just doing something really stupid as this is such a basic issue, but I can find any answer. Please can someone help me? The following code is a complete page that demonstrates my problem. If you save this as an .aspx and load it in a browser, it tells you it is creating the cookie. If you reload the page, it tells you it is changing the value. If you reload it...

ASP.NET

2448

SqlCacheDependency - repost in hopes of a reply

by: Adrian Parker | last post by:

I've got the standard SqlCacheDependency working just fine , ie. I've defined (and encrypted) the connectionStrings section in the web.config, and I've also defined an an sqlCacheDependency in the caching section. So, in my code I add an item to the cache with an sqlCacheDependency, referencing the named sqlCacheDependency in the web.config and the database table it is to be based on (have enabled notificiations for that table). Fine. ...

ASP.NET

1068

Repost â€“ Getting IP address of a Remote machine

by: Al | last post by:

Hi, Please forgive me for the repost. I need to get the IP address of a remote machine which has dynamic IP so I cannot set it in a configuration file. I have the name of the computer and based on that I want to be able to get the IP address. The following code works fine on the Server (the machine I want to connect too but it gives wrong IP address from other computers) Can anyone help.

Visual Basic .NET

3007

Repost, please help, my composite control's oninit won't fire

by: Beavis | last post by:

I hate to repost a message, but I am still at the same point where I was when I originally posted, and hopefully someone else will see this one... Ok, so I have gone off and documented the lifecycle of a page with a custom composite control on it. You can find that document here: http://www.ats-engineers.com/lifecycle.htm

ASP.NET

1290

Serialization Problem - REPOST - PLEASE PLEASE HELP!

by: Johnny J. | last post by:

I posted this last week, but didn't get any reply. I'm trying again now, because I'm getting desperate - I've tried everything I can think of myself. PLEASE help somebody. I've made an inherited ListView control with a customized ColumnHeader Type. I've overwritten the Columns property with a collection of my custom ColumnHeader items. Now I would like to implement serialization so that columns are persisted from designtime to runtime....

C# / C Sharp

960

Help Please.. Repost..

by: JovieUrbano | last post by:

Hi ALL! Guys this is a repost because nobody provided an answer on my question. I have a table with the following records. column1 column2 50 HR 50 SE 50 MGR

Microsoft SQL Server

17281

How to specifiy default values in WCF web services (repost)

by: Dave Burns | last post by:

Hello, I am trying to specify a logical default value for a in a WCF Web Service using basicHttpBinding. I realize that the language defaults are: int - 0 string - null bool - false

.NET Framework

9474

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10306

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10139

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

10075

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9931

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

8961

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

5504

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3632

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2869

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General