c**t
发帖数: 2744 | 1 in XP, created system DSN with Microsoft ODBC for Oracle driver. In VBA, def
ined:
adostring = "Provider=MSDAORA.1;Password=myPassword;User ID=dbUser;Data Sour
ce=myDataSource;Persist Security Info=True"
but it always failed at: cn.Open adostring! any clue why? |
y********o
发帖数: 2565 | 2 It seems your connection string is for OleDb instead of ODBC, judging from
the info at the following URL.
http://www.connectionstrings.com/?carrier=oracle
What if you try this connection string as shown from the same URL for ODBC?
Driver={Microsoft ODBC for Oracle};Server=myServerAddress;Uid=myUsername;Pwd
=myPassword;
def
Sour
【在 c**t 的大作中提到】
: in XP, created system DSN with Microsoft ODBC for Oracle driver. In VBA, def
: ined:
: adostring = "Provider=MSDAORA.1;Password=myPassword;User ID=dbUser;Data Sour
: ce=myDataSource;Persist Security Info=True"
: but it always failed at: cn.Open adostring! any clue why?
|
c**t
发帖数: 2744 | 3 didn't work.
Pwd
【在 y********o 的大作中提到】
: It seems your connection string is for OleDb instead of ODBC, judging from
: the info at the following URL.
: http://www.connectionstrings.com/?carrier=oracle
: What if you try this connection string as shown from the same URL for ODBC?
: Driver={Microsoft ODBC for Oracle};Server=myServerAddress;Uid=myUsername;Pwd
: =myPassword;
:
: def
: Sour
|
y********o
发帖数: 2565 | 4 This is what I use for my .Net applications:
connectionString="DSN=MyDSN4Oracle;UID=johndoe;PWD=wassup; DRIVER={Microsoft ODBC for Oracle}; SERVER=110.119.114.120;" providerName="System.Data.Odbc"
Try it out and see if it works.
【在 c**t 的大作中提到】
: didn't work.
:
: Pwd
|
y********o
发帖数: 2565 | 5 Did you dry Tis out? I'm goncerned abou dju. :-)
Microsoft ODBC for Oracle}; SERVER=110.119.114.120;" providerName="System.
Data.Odbc"
【在 y********o 的大作中提到】
: This is what I use for my .Net applications:
: connectionString="DSN=MyDSN4Oracle;UID=johndoe;PWD=wassup; DRIVER={Microsoft ODBC for Oracle}; SERVER=110.119.114.120;" providerName="System.Data.Odbc"
: Try it out and see if it works.
|
c**t
发帖数: 2744 | 6 It worked; including previous. Have to reboot to make the DSN work..
【在 y********o 的大作中提到】
: Did you dry Tis out? I'm goncerned abou dju. :-)
:
: Microsoft ODBC for Oracle}; SERVER=110.119.114.120;" providerName="System.
: Data.Odbc"
|
y********o
发帖数: 2565 | 7 Even the one you initially used worked after you reboot your system?
The one you had in your first post:
adostring = "Provider=MSDAORA.1;Password=myPassword;User ID=dbUser;Data Sour
ce=myDataSource;Persist Security Info=True"
【在 c**t 的大作中提到】
: It worked; including previous. Have to reboot to make the DSN work..
|
c**t
发帖数: 2744 | 8
Sour
yes. The trick is to reboot. I don't know what's wrong. It seems the ultimat
e solution for windows is to reboot.
【在 y********o 的大作中提到】
: Even the one you initially used worked after you reboot your system?
: The one you had in your first post:
: adostring = "Provider=MSDAORA.1;Password=myPassword;User ID=dbUser;Data Sour
: ce=myDataSource;Persist Security Info=True"
|
y********o
发帖数: 2565 | 9
ultimat
I have the same feeling towards Windows. I once in a while have IIS Worker
Process Error, and this prevents the web application from connecting to our
Oracle 10g. This error is usually resolved through reboot. Or maybe
restarting IIS should work, too.
【在 c**t 的大作中提到】
:
: Sour
: yes. The trick is to reboot. I don't know what's wrong. It seems the ultimat
: e solution for windows is to reboot.
|
