Re: Connection syntax not right

From: Bernie Yaeger (berniey_at_cherwellinc.com)
Date: 02/28/04


Date: Fri, 27 Feb 2004 21:01:42 -0500

Hi Kim,

First of all, you don't have an opening quote before otr.mdb" (s/b
"otr.mdb"). Also, debug or messagebox.show to get the actual string
represented by application.startup - do you have to append "\" to it?

HTH,

Bernie Yaeger

"Kimberley Wiggins" <kimwiggins@greenwaymedical.com> wrote in message
news:eycU3vZ$DHA.1956@TK2MSFTNGP10.phx.gbl...
> Can someone please tell me what is wrong with this syntax? I am just
> really frustrated. I am trying to use the application startup path for
> this but it does not like this syntax for some reason. Does something
> look out of place here?
>
> Dim strOTRConnection As String = "Provider=Microsoft.Jet.OLEDB.4.0;
> Data Source= Application.Startup & otr.mdb"
>
> I know this is the problem because if I move my database to my C drive
> it works fine.
> Thanks
>
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!



Relevant Pages

  • Re: inconsistent behavior of >FLOAT
    ... If the string represents a valid floating-point number in the syntax ... if the string does not match the syntax given then false ... ">FLOAT enables programs to read floating-point data in legible ASCII format. ...
    (comp.lang.forth)
  • Re: Just a bit of silliness
    ... Is that the syntax and grammar resemble the stammer ... Can't guess how to copy a string. ... Is the very last} "close curly bracket" ... format strings. ...
    (comp.lang.c)
  • Re: FTS Weighted Values Implementation Problem
    ... You have to convert your numeric value to string with ToStringfunction. ... a number into a textbox which assigns the weight value for each ... I don't want the user to have to work with decimals directly, ... I adjusted my SELECT statement using the syntax you provided for the ...
    (microsoft.public.sqlserver.fulltext)
  • SetText Method Confusion
    ... what is the correct syntax for the SetText Method? ... and neither will complile when I use them in my macro. ... before pasting the changed string to the new document. ... into the clipboard, from the clipboard into a DataObject, ...
    (microsoft.public.word.vba.beginners)
  • Need some help...
    ... I've got a snag in my syntax somewhere. ... The custom files are going to become a serious storage issue as our customer ... string through a stream. ... Dim stmStreamIn As IO.StreamWriter = CompressProcess.StandardInput ...
    (microsoft.public.dotnet.languages.vb)