Help: Access 2002 dsn-less to Oracle 10g memiller[ at ]cnasurety.com 21.02.2006 22:05:59 I've been racking my brain and searching newsgroups for answers and its just not coming to me. I'm trying to set up DSN-less connections from an Access db to Oracle. I've got a working DSN connection, but I'd rather not use it for deployment. This is the DSN connection: ODBC;DSN=workflow;UID=wrid;PWD=wrpwd;DBQ=IRD;DBA=W;APA=T;EXC=F;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;BTD=F;BAM=IfAllSuccessful;NUM=NLS;DPM=F;MTS=T;MDI=F;CSR=F;FWC=F;FBS=64000;TLO=O; I've tried using the following connect strings with no success: ODBC;DRIVER={Microsoft ODBC for Oracle};UID=wrid;PWD=wrpwd;SERVER=IRD; ODBC;DRIVER={Oracle in OraClient10_2};UID=wrid;PWD=wrpwd;DBQ=IRD; IRD is defined in my Tsnames file. What am I missing that I can't get these to work? Any insight would be GREATLY appreciated. - Mark

Re: Access 2002 dsn-less to Oracle 10g "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> 21.02.2006 23:37:45 The only real difference I can see between what you have and what Carl Prothman has at http://www.carlprothman.net/Default.aspx?tabid=90#ODBCDriverForOracleFromMicrosoft is that you've got semi-colons at the end of the string, but I can't see that causing the problem. How are you using the connect string? What error (if any) are you getting? -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) <memiller[ at ]cnasurety.com> wrote in message news:1140559559.116456.106000[ at ]g44g2000cwa.googlegroups.com... [Quoted Text] > I've been racking my brain and searching newsgroups for answers and its > just not coming to me. I'm trying to set up DSN-less connections from > an Access db to Oracle. I've got a working DSN connection, but I'd > rather not use it for deployment. This is the DSN connection: > > ODBC;DSN=workflow;UID=wrid;PWD=wrpwd;DBQ=IRD;DBA=W;APA=T;EXC=F;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;BTD=F;BAM=IfAllSuccessful;NUM=NLS;DPM=F;MTS=T;MDI=F;CSR=F;FWC=F;FBS=64000;TLO=O; > > I've tried using the following connect strings with no success: > > ODBC;DRIVER={Microsoft ODBC for Oracle};UID=wrid;PWD=wrpwd;SERVER=IRD; > > ODBC;DRIVER={Oracle in OraClient10_2};UID=wrid;PWD=wrpwd;DBQ=IRD; > > IRD is defined in my Tsnames file. What am I missing that I can't get > these to work? Any insight would be GREATLY appreciated. > > - Mark >

Re: Help: Access 2002 dsn-less to Oracle 10g Stefan Hoffmann <stefan.hoffmann[ at ]explido.de> 22.02.2006 09:37:45 hi, memiller[ at ]cnasurety.com wrote: [Quoted Text] > I've tried using the following connect strings with no success: > ODBC;DRIVER={Microsoft ODBC for Oracle};UID=wrid;PWD=wrpwd;SERVER=IRD; > IRD is defined in my Tsnames file. What am I missing that I can't get > these to work? Any insight would be GREATLY appreciated. It is the USR and the PWD, which causes the 7771 error. Without these parameters, the driver prompts for the credentials and it will work correctly. mfG --> stefan <--

Re: Help: Access 2002 dsn-less to Oracle 10g "Paul" <test[ at ]tester.com> 06.03.2006 12:43:35 Heres the string I use, Hope it works for you. I've replaced MYPASSWORD, MYUSERNAME and MYDATASOURCE. Regards Paul Provider=OraOLEDB.Oracle.1;Password=MYPASSWORD;Persist Security Info=True;User ID=MYUSERNAME;Data Source=MYDATASOURCE;DistribTX=0;Extended Properties= Paul "Stefan Hoffmann" <stefan.hoffmann[ at ]explido.de> wrote in message news:u93w0N5NGHA.1288[ at ]TK2MSFTNGP09.phx.gbl... [Quoted Text] > hi, > > memiller[ at ]cnasurety.com wrote: >> I've tried using the following connect strings with no success: >> ODBC;DRIVER={Microsoft ODBC for Oracle};UID=wrid;PWD=wrpwd;SERVER=IRD; >> IRD is defined in my Tsnames file. What am I missing that I can't get >> these to work? Any insight would be GREATLY appreciated. > It is the USR and the PWD, which causes the 7771 error. Without these > parameters, the driver prompts for the credentials and it will work > correctly. > > > > mfG > --> stefan <--

RE: Help: Access 2002 dsn-less to Oracle 10g sjs30101 19.04.2006 13:56:02 I use OleDB; sConn = "Provider=MSDAORA.1;Data Source=Database Name;User ID=userID;Password=Pwd;" Steve "memiller[ at ]cnasurety.com" wrote: [Quoted Text] > I've been racking my brain and searching newsgroups for answers and its > just not coming to me. I'm trying to set up DSN-less connections from > an Access db to Oracle. I've got a working DSN connection, but I'd > rather not use it for deployment. This is the DSN connection: > > ODBC;DSN=workflow;UID=wrid;PWD=wrpwd;DBQ=IRD;DBA=W;APA=T;EXC=F;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;BTD=F;BAM=IfAllSuccessful;NUM=NLS;DPM=F;MTS=T;MDI=F;CSR=F;FWC=F;FBS=64000;TLO=O; > > I've tried using the following connect strings with no success: > > ODBC;DRIVER={Microsoft ODBC for Oracle};UID=wrid;PWD=wrpwd;SERVER=IRD; > > ODBC;DRIVER={Oracle in OraClient10_2};UID=wrid;PWD=wrpwd;DBQ=IRD; > > IRD is defined in my Tsnames file. What am I missing that I can't get > these to work? Any insight would be GREATLY appreciated. > > - Mark > >

Re: Help: Access 2002 dsn-less to Oracle 10g "david epsom dot com dot au" <david[ at ]epsomdotcomdotau> 20.04.2006 10:14:16 Create a file dsn. Open the file dsn in a text editor. What are the values you see? (david) "sjs30101" <sjs30101[ at ]discussions.microsoft.com> wrote in message news:540EF342-9728-4135-A5DF-2D92A971EF73[ at ]microsoft.com... [Quoted Text] >I use OleDB; > > sConn = "Provider=MSDAORA.1;Data Source=Database Name;User > ID=userID;Password=Pwd;" > > Steve > > "memiller[ at ]cnasurety.com" wrote: > >> I've been racking my brain and searching newsgroups for answers and its >> just not coming to me. I'm trying to set up DSN-less connections from >> an Access db to Oracle. I've got a working DSN connection, but I'd >> rather not use it for deployment. This is the DSN connection: >> >> ODBC;DSN=workflow;UID=wrid;PWD=wrpwd;DBQ=IRD;DBA=W;APA=T;EXC=F;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;BTD=F;BAM=IfAllSuccessful;NUM=NLS;DPM=F;MTS=T;MDI=F;CSR=F;FWC=F;FBS=64000;TLO=O; >> >> I've tried using the following connect strings with no success: >> >> ODBC;DRIVER={Microsoft ODBC for Oracle};UID=wrid;PWD=wrpwd;SERVER=IRD; >> >> ODBC;DRIVER={Oracle in OraClient10_2};UID=wrid;PWD=wrpwd;DBQ=IRD; >> >> IRD is defined in my Tsnames file. What am I missing that I can't get >> these to work? Any insight would be GREATLY appreciated. >> >> - Mark >> >>