Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: arniec
  • Order by date
  1. arniec

    Use stored procedure to convert num/text to date?

    Thank you thank you thank you!!!! That worked, and your explanation has allowed me to modify it to fit another scenario as well. THANK YOU!
  2. arniec

    Use stored procedure to convert num/text to date?

    I am running SQL Server 2000. I have a field which comes in as a string of numbers representing a date. For example: 122506 is christmas of this year. 70406 is the 4th of July. I need to get this information stored in a DateTime field in the database. I was hoping to write a stored...
  3. arniec

    SQL Server -> MS Access ODBC Question

    Works wonderfully, THANK YOU!
  4. arniec

    SQL Server -> MS Access ODBC Question

    That code is very interesting. I have some other cases where it will come in quite handy, but it appears to be using code to do this. Can these connections be used to create linked tables in Access? Thank you!!!!!!!!!! I appreciate you taking the time to help me.
  5. arniec

    SQL Server -> MS Access ODBC Question

    I have a SQL server set up and want to create an Access Database which will reside on a network share and hit the SQL Server. It is pointing to the SQL server through an ODBC connection. This database will be used by dozens of people; is there any way to get it set up where I do not have to...
  6. arniec

    VB . NET EXE running over network utilizing ADO

    Yeah, even with the Integrated Security I get an error from the network, and it workes fine from the desktop. I'm looking more into the "copy the file" solution. It may be the best/only way (packaging is not really an option) One question: if I have A.EXE on someone's C drive and they launch...
  7. arniec

    VB . NET EXE running over network utilizing ADO

    Dim conn As New SqlClient.SqlConnection("Data Source = D3HTT321; Initial Catalog = d_alt_lending") conn.Open() msgbox "It opened." conn.Close() msgbox "It closed."
  8. arniec

    VB . NET EXE running over network utilizing ADO

    Rick, I tried the SQL Server option and still hit the same security issue, and it's not trying to pop an LDB file. I made a quick app which connects to our SQL Server (the code is above) and it bombed.
  9. arniec

    VB . NET EXE running over network utilizing ADO

    Rick, Thanks for the suggestion. I tried it and a mapped network drive didn't fix the solution; the .NET framework still treated it as a network location.
  10. arniec

    VB . NET EXE running over network utilizing ADO

    Given this, mwardle, is there any way to rewrite the code to do the same thing in a way that would not alert the .NET security? Any other connection object or such that will fly "under the radar" so to speak?
  11. arniec

    VB . NET EXE running over network utilizing ADO

    I tried the "quickie application" route. I tried connecting to one of our existing SQL Servers and received the exact same security exception. I had this code: Dim conn As New SqlClient.SqlConnection("Data Source = D3HTT321; Initial Catalog = d_alt_lending") conn.Open() and...
  12. arniec

    VB . NET EXE running over network utilizing ADO

    One other thing: are we SURE that moving to SQL Server will fix the problem? Can I get verification that at the default level of security for the .Net 1.1 Framework allows this? I'd hate to spend a day rewriting this (it would be less for a more experienced .Net programmer I'm sure but I'm...
  13. arniec

    VB . NET EXE running over network utilizing ADO

    Macleod, In its own class? No. But still not that hard to change. The problem here lies in the fact that the domain accounts are managed by another group who doesn't like to talk to us much; all our current SQL users must be added manually by us. This could still possibly work, but in all...
  14. arniec

    VB . NET EXE running over network utilizing ADO

    The more I think about it, this option probably won't be as easy as I'd hoped as then I'd have to grant these users access to the SQL server, and the user base changes on a daily basis; there's no way to know the domain logins of all the users who will need this access. also, the systems are...
  15. arniec

    VB . NET EXE running over network utilizing ADO

    Bob, I can move the database out of Access and into SQL easily enough, but will the same code then function? I have Dim conn As New OleDb.OleDbConnection( _ "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=" & _ "\\networkshare\somefile.mdb") If I...
  16. arniec

    VB . NET EXE running over network utilizing ADO

    Thanks for the reply, jebenson, but our security policies really won't allow me to change this programatically on our users machines; if there's a change it needs to be at the application level, not the enterprise or OS level. Any suggestions on that? Can it be done? Thanks,
  17. arniec

    trying to read fields from DataTable -- ???

    I was able to do something like this in my current application. I set up the ADO connection as such: (note that my code goes to an Access database but can be modified to go to any data source I believe) 'connect to database Dim conn As New OleDb.OleDbConnection( _...
  18. arniec

    VB . NET EXE running over network utilizing ADO

    I have a Visual Basic .Net front-end to a Microsoft Access back-end. The Back-end is stored on a network share and during development, all of which took place on my desktop system, things went fine. The program uses an ADO connection to the database with the line Dim conn As New...
  19. arniec

    Easytrieve Beginner Question

    I am a programmer at a company where we are about to implement Easytrieve. I am the most experienced programmer in the group, with knowlege of C++, Assembler, Java, Perl, VB, etc. Most of our programmers are VBA proficient with a little Java experience as well. We are trying to take a 3 day...
  20. arniec

    Cannot make Active X component work, please help :(

    Please disregard, I had my code in a class module and not in a module; moving it fixed my problem. Thanks anyways!

Part and Inventory Search

Back
Top