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]();
}