473,385 Members | 1,730 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

ASP Connection String for Oracle 10g

5
Recently we upgraded to Oracle 10g and added encryption on the server.

I used to access the database tables via Active Server Pages with the following connection string: MyConnection.open "DSN=eisreport;Uid=eiu_sung;Pwd=xxxxx"

After upgrading to 10g it stop working with the following error message.

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC driver for Oracle][Oracle]ORA-12154: TNS:could not resolve the connect identifier specified
/reports/reports.asp, line 47 (the line indicates the above connection string)


The following three lines were added to 'sqlnet.ora' when upgrading the oracle client.

SQLNET.ENCRYPTION_TYPES_CLIENT= RC4_256
SQLNET.ENCRYPTION_CLIENT= required
SQLNET.CRYPTO_SEED=LDFKANTEJTE8232AFDFDEDFD

So I think the problem may related to the encryption feature.
I have no idean where to fix. Can I still use ASP? or Do something in IIS???
Any assistance would be greatly appreciated.

I guess this has to do with migration to the 10g.
Feb 28 '08 #1
4 5410
markrawlingson
346 Expert 100+
I personally have 0 experience working with oracle. Here's a couple resources for you though.

http://ora-12154.ora-code.com/
http://download-uk.oracle.com/docs/c...g.htm#BABBBGGG
http://download-uk.oracle.com/docs/c....htm#ORA-12154
http://download-uk.oracle.com/docs/c....htm#sthref484

I also have a tiny inclination that it could be your System DNS configuration. Maybe a driver problem? Try updating the oracle driver, creating a new System DNS configuration, rebooting the server, and then trying it out.

Hope that helps, if not - I'll move this thread to the oracle forum where you'll likely get more help.

Sincerely,
Mark
Feb 28 '08 #2
nsung
5
Thank you Mark!

I am able to link tables from within MS-Access at the same machine where the ASPs are, which indicates DSN and the Driver had been installed correctly.

I already posted the same message to the ORACLE forum. Thank you!
Feb 28 '08 #3
markrawlingson
346 Expert 100+
Thank you Mark!

I am able to link tables from within MS-Access at the same machine where the ASPs are, which indicates DSN and the Driver had been installed correctly.

I already posted the same message to the ORACLE forum. Thank you!
No problem. In the future please don't double post questions though.

I'll move this thread.

Sincerely,
Mark
Feb 28 '08 #4
jhardman
3,406 Expert 2GB
Thank you Mark!

I am able to link tables from within MS-Access at the same machine where the ASPs are, which indicates DSN and the Driver had been installed correctly.

I already posted the same message to the ORACLE forum. Thank you!
I also think it's a dsn problem. Did you update the dsn entry after updating?
Feb 29 '08 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: JWM | last post by:
I am trying to implement Oracle connection pooling for the following code, which was written by someone else. Here is my main question -- this java file creates code that is executed every hour,...
1
by: Cliff Cooley | last post by:
Can anybody suggest what may be causing the following problem ? I have an ASP script that opens a connection to an Oracle database using a DSN connection string, such as : Set dbConn=...
9
by: mcbill20 | last post by:
Hello all. I just installed Oracle 10g developer tools on a machine running XP Pro and Office XP. Before this I had just the Oracle 9 client installed. I the previous configuration, I was able to...
2
by: Steve Foo | last post by:
I have been posting this question in google group, EE, and Oracle OTN forum and still no cannot find a suitable solution for it. I have contacted Singapore Microsoft support regarding the problem...
6
by: Bala Nagarajan | last post by:
Hello, I am using Oracle 9i in my application and facing a problem with the connection string. In the datasource attribute of the connection string i had to specify an entry in "tnsnames.ora"...
2
by: Ben | last post by:
Hi, I have a problem connecting to Oracle using and ODBC connection in a ASP.Net web page. The TNS Names works fine because when I create a DSN it works, and it works in SQL Plus. Here are...
8
by: Greg Strong | last post by:
Hello All, The short questions are 1 Do you know how to make DSN connection close in Access to Oracle 10g Express Edition? &/or 2 Do you know how to make a DSN-less pass-through query...
1
by: Subangini | last post by:
"Hi, I am trying to migration Oracle database to mysql database using visual coding. I am having problem in the Do until loop, can u tell me what is the mistake. Oracle Database - Oracle...
1
by: Brad | last post by:
With Oracle 9.2 drivers, this worked connection string worked in a DSN-less connection ODBC;DRIVER={Microsoft ODBC For Oracle};Server=MyServerName;UID=MyName;PWD=MyPwd; However, after upgrading...
0
by: | last post by:
Hi All, I have a client connection problem with Oracle. The exe which i did with C# (vs.net 2005) and Oracle XE , works well on my developer machine but i am getting a connection string error on...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
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,...
0
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...
0
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...

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.