DSN-less linked tables.

[Guest]

Using an example for DSN-less connections found on the support site
(http://support.microsoft.com/default.aspx/kb/892490) I modified it slightly
to use an Oracle ODBC driver. The connect string now looks like this:

stConnect = "ODBC;DRIVER=Oracle in v8176;DBQ=" & stConn & ";UID=" &
stUsername & ";PWD=" & stPassword

The code runs correctly, but after the Append finishes and you look at the
table properties (Tables -> Design View -> Properties) the end of the string
has about 8 or 10 garbage characters that won't display. Also notable is
that the connect string after the Append has a "SERVER=blah_blah" in it and
no "PWD=your_password_here" embedded in it.

Is this a weird bug? I've searched MSDN for hours trying to find ANYTHING
remotely related to this.

Thanks in advance.

 

[Guest]

Just as a weird side note.. Starting from a freshly opened database - If you
"refresh linked tables" and select the table that gets created, you can open
it and see data. If you don't, it crashes Access completely.

 

[Tony Toews [MVP]]

Using an example for DSN-less connections found on the support site
(http://support.microsoft.com/default.aspx/kb/892490) I modified it slightly
to use an Oracle ODBC driver.

Try the connect strings from
http://www.carlprothman.net/Default.aspx?tabid=87#OLEDBProviderForOracleFromMicrosoft
or the immediately following " OLE DB Provider for Oracle (from
Oracle) " strings.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Guest]

Try the connect strings from
http://www.carlprothman.net/Default.aspx?tabid=87#OLEDBProviderForOracleFromMicrosoft
or the immediately following " OLE DB Provider for Oracle (from
Oracle) " strings.

I'm not using OLE DB, but I did get the format for the DSN-less ODBC driver
from the same site:
http://www.carlprothman.net/Default.aspx?tabid=90#ODBCDriverForOracleFromOracle

Just another tidbit, too. If I create the table without the
"dbAttachSavePWD" option, it creates it just fine and it's not corrupted,
however, opening it requires a password, obviously, which is not the effect
I'm looking for. Just adding the save password option back causes the
connect string to have the garbage characters and crashes Access when you try
to open it.