Find Jobs
Hire Freelancers

SQL StoredProc as a DLL callable from VB6 on Vista

$30-250 USD

Completed
Posted over 12 years ago

$30-250 USD

Paid on delivery
I have an SQL database that has some stored procedures that I want to call from other computers on the network using DLL's. Some of these computers are older computers running Vista and Windows XP. I will pass 4 parameters to the DLL and I need to receive 5 parameters back from the DLL so that makes 9 parameters all together. I will give you what the stored procedure call looks like and you need to give me back the DLL and the source code so that I can modify it to change the parameter names. I can help you test it if that will make things easier for you. My goal is to use your code to learn how to do. I am not that concerned about what this DLL looks like. So I don't really care what the variable names and stored procedure code looks like, I just want a working example that receives multiple parameters and returns multiple parameters to the caller of the DLL. What I need from you: - The complied DLL - A Visual studio project with source code written in C# or C++ so that I can clone and modify for other stored procedures - An example of how to call the DLL Here is some example code that you can use to create the DLL. static public long SQL_GetResults(string connStr, long resID, long mapID, long operID, string mapName,ref long streetNum, ref double areaScore, ref long buildingID, ref int obstacles) { SqlConnection conn = new SqlConnection(connStr); SqlCommand cmd = new SqlCommand("GetResults", conn); [login to view URL](); [login to view URL] = [login to view URL]; [login to view URL]("@connStr", [login to view URL], 50).Value = connStr; [login to view URL]("@id", [login to view URL]).Value = resID; [login to view URL]("@mapID", [login to view URL]).Value = mapID; [login to view URL]("@operID", [login to view URL]).Value = operID; [login to view URL]("@map", [login to view URL], 30).Value = mapName; [login to view URL]("@streetNum", [login to view URL]).Value = streetNum; [login to view URL]("@areaScore", [login to view URL]).Value = areaScore; [login to view URL]("@buildingID", [login to view URL]).Value = buildingID; [login to view URL]("@obstacles", [login to view URL]).Value = obstacles; [login to view URL][5].Direction = [login to view URL]; [login to view URL][6].Direction = [login to view URL]; [login to view URL][7].Direction = [login to view URL]; [login to view URL][8].Direction = [login to view URL]; [login to view URL](); [login to view URL](); }
Project ID: 1204581

About the project

3 proposals
Remote project
Active 13 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
I am ready to help you. Contact me ASAP
$50 USD in 1 day
5.0 (30 reviews)
4.7
4.7
3 freelancers are bidding on average $87 USD for this job
User Avatar
let's start
$60 USD in 2 days
4.9 (22 reviews)
4.2
4.2

About the client

Flag of UNITED STATES
homer, United States
5.0
10
Payment method verified
Member since Feb 16, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.