Search results for query: *

just wanted to say thank you jmcilhinney. just needed to increase the timeout. apparently takes a little longer across the network. :P

yes, i know, and thank you. :) will have to come back to it later. bigger fish to fry right now. :P

the timing on my local box is much quicker, as I'm only working with a subset (~250K vs ~130M). It times out after about 30-35 seconds against the server. i'm still new at this, and I'm not familiar with the items you've listed.

I've put together the following script, and it runs great on my local machine (w/ SQL Express), but when I change the SQL login information to our company server (SQL Server 2008), it kicks back a timeout error at the second .ExecuteNonQuery() line, which i've colered red. The user credentials...

i found that my SQL install was misconfigured. problem resolved. I used SQL import/export tool once install was corrected.

I have Visual Studio 2010, with SQL EXPRESS which came with VS2010 from what I understand. I built a database in my VB.NET project, and am trying to copy data from the corporate SQL SERVER to my VB.NET created database (SQL EXPRESS). Below I've included my script, with both connection strings...

havent totally fixed it, but I think I'm getting closer. I'm getting a "Record is deleted" error now on cmdB.ExecuteNonQuery. It creates & populates the tmp table, but nothing gets deleted from the main table. Private Sub cmdDelete_Click(sender As System.Object, e As System.EventArgs)...

ok, I have what I hope is an easy problem to fix. i'm try to query a db, store to a temp table, and then query the same db, inner joined with first query. please help. I'm currently getting "access cant find table/query" error. I've tried putting quotes around tmp, and that doesnt work either...