ODBC vs. OLEDB 2

[FoxAmateur]

I am taking my first step into the remote data world and would rather use ODBC over OLEDB and have to deal with record sets. I have to take an ascii file and insert those records into an Oracle table. Do you have to create a DSN on each computer that runs this code?


Chris

 

[craigber]

No. You can either use a File DSN, which is simply a file that distributed to each computer or you can create the connection string in code and use that.

Craig Berntson
MCSD, Visual FoxPro MVP,

http://www.craigberntson.com

Author, CrysDev: A Developer's Guide to Integrating Crystal Reports"

 

[FoxAmateur]

Craig,

>>you can create the connection string in code and use that. <<

Is there a a thread that I can see an example of a connection string in code? I will check my Hentzenwerke books for this but it might be quicker if you could point me in the right direction.

Thanks,
Chris

 

[rgbean]

HOWTO: Creating a Connection to SQL Server Without a Datasource" -

http://support.microsoft.com/default.aspx?scid=kb;en-us;155392.

You can get other sample connection strings from

http://www.connectionstrings.com/

and

http://www.able-consulting.com/ADO_Conn.htm.

Rick

 

[FoxAmateur]

Rick,

Thanks I will check them out!

Chris

 

[wgcs]

Take a look at:

http://fox.wikis.com/wc.dll?Wiki~DSNLessConnections

http://fox.wikis.com/wc.dll?Wiki~FileDSN

http://fox.wikis.com/wc.dll?Wiki~ProgrammaticallyCreatingDSNs

http://fox.wikis.com/wc.dll?Wiki~DSN

 

[FoxAmateur]

The Fox Wiki links are excellent thanks!