Results 1 to 4 of 4

Thread: Passing Variables !? *Resolved*

  1. Mar 26th, 2003, 02:17 PM #1
    vbNeo
    vbNeo is offline

    Thread Starter
    Frenzied Member vbNeo's Avatar
    Join Date
    May 2002
    Location
    Jutland, Denmark
    Posts
    1,994

    Exclamation Passing Variables !? *Resolved*

    Hi !!
    I wan't to connect to an online database...
    What i'm doing now is:
    VB Code:
    1. strCn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _

    2.             "Data Source=http://www.Ziptron.dk/main.mdb;" & _

    3.             "Persist Security Info=False"

    4.     strSQL = "SELECT * FROM Main WHERE Brugernavn='" & txtUser.Text & "' AND Password='" & txtPassword.Text & "'"

    5.     Set rsEmployees = New ADODB.Recordset

    6.     rsEmployees.Open strSQL, strCn, adOpenDynamic, adLockReadOnly

    but that won't work! It just gives me an error saying Invalid File...
    how do i connect to an online DB ? do i have to have some special rights or something ??

    Cheers !
    Last edited by vbNeo; Mar 26th, 2003 at 03:31 PM.
    "Lies, sanctions, and cruise missiles have never created a free and just society. Only everyday people can do that."
    - Zack de la Rocha

    Hear me roar.
    Reply With Quote Reply With Quote
  2. Mar 26th, 2003, 02:35 PM #2
    vbNeo
    vbNeo is offline

    Thread Starter
    Frenzied Member vbNeo's Avatar
    Join Date
    May 2002
    Location
    Jutland, Denmark
    Posts
    1,994
    *bump*
    "Lies, sanctions, and cruise missiles have never created a free and just society. Only everyday people can do that."
    - Zack de la Rocha

    Hear me roar.
    Reply With Quote Reply With Quote
  3. Mar 26th, 2003, 02:37 PM #3
    seaweed
    seaweed is offline
    Frenzied Member
    Join Date
    Jan 2000
    Location
    Bellevue, WA, USA
    Posts
    1,357
    Bumping after only 18 minutes? Are we a little impatient today??

    I tried this, but I'm on the corporate network, and the only way I can access the database through our security firewall is to copy it locally. Sorry!
    ~seaweed
    Reply With Quote Reply With Quote
  4. Mar 26th, 2003, 02:52 PM #4
    vbNeo
    vbNeo is offline

    Thread Starter
    Frenzied Member vbNeo's Avatar
    Join Date
    May 2002
    Location
    Jutland, Denmark
    Posts
    1,994

    Hmmm.. Thanks anyways =)

    I got a new idea...
    Can anyone tell me how to pass variables through ASP to ones application ??

    Cheers !
    "Lies, sanctions, and cruise missiles have never created a free and just society. Only everyday people can do that."
    - Zack de la Rocha

    Hear me roar.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width