Results 1 to 4 of 4

Thread: Passing Variables !? *Resolved*

Threaded View

  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
« 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