473,573 Members | 3,117 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Helps Needed FOr ODBC in ASP

hi all, i am currently doing a website in ASP which is using ODBC to
connect the ERP Database in another server . when i run the system in
Winodws9 , it works perfectly, no errors and it may get the data from
the database . But when ic hange to winodws XP , here the problem
comes.

My windowsXP pro is using iis5.1 with sp2. The MDAC version 2.8 . i
cannot get any solution until now ( already 2 weks time ) , even though
i try to searched many forum, websites.

Below is my souce code. i have tried to close the connection fro RS and
Conn, but it still appear the same error.i already give all the
permission by sharing the whole database using simple file sharing .But
it still not working.

Set conn = Server.CreateOb ject("ADODB.Con nection")
conn.open "FILEDSN=C:\Pro gram Files\Common Files\ODBC\Data
Sources\Syspro Local - Co. A.dsn"
set rs=server.creat eobject("adodb. recordset")
sql="SELECT * from INVMASTER "
rs.open sql,conn11, 1, 2

--------------------------------------------------------------------------------------------------------------------------------------
Error appears

Error Type:
Provider (0x8000FFFF)
Catastrophic failure
/try.asp, line 5

this is 1 of the error. some time it will appear An exception occur (
"rs" ) or error in conn.open
any experts pls help me to solve the problems.

Feb 27 '06 #1
1 1737

mi*****@hotmail .com wrote:
hi all, i am currently doing a website in ASP which is using ODBC to
connect the ERP Database in another server . when i run the system in
Winodws9 , it works perfectly, no errors and it may get the data from
the database . But when ic hange to winodws XP , here the problem
comes.

My windowsXP pro is using iis5.1 with sp2. The MDAC version 2.8 . i
cannot get any solution until now ( already 2 weks time ) , even though
i try to searched many forum, websites.

Below is my souce code. i have tried to close the connection fro RS and
Conn, but it still appear the same error.i already give all the
permission by sharing the whole database using simple file sharing .But
it still not working.

Set conn = Server.CreateOb ject("ADODB.Con nection")
conn.open "FILEDSN=C:\Pro gram Files\Common Files\ODBC\Data
Sources\Syspro Local - Co. A.dsn"
set rs=server.creat eobject("adodb. recordset")
sql="SELECT * from INVMASTER "
rs.open sql,conn11, 1, 2

--------------------------------------------------------------------------------------------------------------------------------------
Error appears

Error Type:
Provider (0x8000FFFF)
Catastrophic failure
/try.asp, line 5

this is 1 of the error. some time it will appear An exception occur (
"rs" ) or error in conn.open
any experts pls help me to solve the problems.


http://www.aspfaq.com/show.asp?id=2323

You've also changed the name of your connection object from conn to
conn11

/P.

Feb 27 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1520
by: A.P. Madura | last post by:
Need help in debugging this problem. I have an access database which I use to demonstrate Java - ODBC connectivity and it works perfectly fine. This allows me to assume that the Data Source name definition is OK. I tried to access the same DSN (system DSN) thro' PHP and the following error is displayed. Warning: odbc_connect() : SQL...
1
8203
by: Eirik Tryggeseth | last post by:
During deployment of an application using distributed transactions managed under COM+ on an Oracle 9i RAC database, we encounter situations where the load balancing mechanisms in the RAC result in that the component context in the distributed transaction (in our case two different COM components) cannot hold onto the same ODBC connection. Or...
6
6758
by: Andreas Lauffer | last post by:
I changed from Access97 to AccessXP and I have immense performance problems. Details: - Access XP MDB with Jet 4.0 ( no ADP-Project ) - Linked Tables to SQL-Server 2000 over ODBC I used the SQL Profile to watch the T-SQL-Command which Access ( who creates the commands?) creates and noticed:
2
3716
by: Andrew | last post by:
Hi all! Sorry guys but I am totally ignorant on oracle matters. I need some guidance in how and what is needed to connect directly to an oracle 7.3.2.3.2 database on a OpenVMS operating system with a database application developed on a Windows XP PC using DB2K. Network/Database Server Details: Server: Compaq AlphaServer DS10 O/S: ...
8
1570
by: revathi | last post by:
Hi, I have created servlet program using Netbeans.I have also written the JDBC connectivity.But FileNotFoundException is arising.Can someone help me?
4
6523
by: MLH | last post by:
I apologize in advance to forum readers noticing this somewhat redundant post. I fear that my Subject Heading was ill-chosen in earlier post I made on this topic. Am hoping that a clearer Subject heading will attract the knowledgeable forum contributors I'm seeking. Thank-you... I'm being academically challenged trying to build a...
8
1317
by: Johan Goris | last post by:
I've made a small test program. I connect with oleDb (in fact sqlConnection ....etc) to a SQL-server. It works fine at home. But it did not work at another place, altough other simple C-sharp programs work (CLR is installed). But I tested overthere already with ODBC a connection (ms-access) to the sql-server and that worked also.Is my...
4
1588
by: Me | last post by:
I am writing a C#.NET application that is primarily intended to be used with SQL server. One of my concerns is that in the future I will have users who do not have or want to run SQL Server. That led me to think that perhaps I should be using ODBC from the start. What are your thoughts and suggestions on this? Will I still be able to...
1
1696
by: tommydkat | last post by:
Hi! We've switched from Developer Studio 6.0 to Visual Studio .net 2003. Our application compiles fine with Visual Studio .net 2003 but when it runs, it uses the Microsoft ODBC driver as is shown in this function sequence error we're getting when we issue an UPDATE SQL query to our DB2 database: State:S1010,Native:0,Origin: The IBM...
0
7778
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7687
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...
0
8201
jinu1996
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...
1
7777
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...
0
8063
tracyyun
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...
0
6413
agi2029
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...
0
3731
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
1
1300
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1039
bsmnconsultancy
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.