|
It is of course possible in VB.NET but extremely difficult!
The best solution would be to use Managed DirectX, there is an SDK for download on the MS site somewhere, (it's big, ~300MB I seem to remember) and this has samples in C# and VB.NET.
You'll need a powerful computer to run it though, I tried some of the samples and it ran quite slowly.
Another alternative is OpenGL but I don't know how this fares up, I havn't tried it.
Ed
|
|
|
|
|
I looked into downloading that DirectX thing and according to April's SDK, it's only in C++ and C#? Am I missing something?
Mike
Gaming at the GuildofBlades.com is the only way to really experiece the level 99 Soul-Sucking Sword!
|
|
|
|
|
Those are the languages which MS provide examples in I'm guessing but of course anything that C# can do VB.NET can do as well. It shouldn't be too difficult to understand what the C# code does since they will be using exactly the same classes.
An important fact to bear in mind is that the only major difference between C# and VB.NET is the syntax.
I know that this is a VB forum but I'd strongly recommend certainly understanding C# enough to translate it to VB.NET.
So in summary it will work with VB but probably none of the examples are provided in VB.
Something that might be helpful is #Develop which has a built in C# to VB, VB to C# (and some others like Boo) translators.
You know you're a Land Rover owner when the best route from point A to point B is through the mud.
Ed
|
|
|
|
|
Hey guys, I've got a problem:
I'm using vb.net 2005 and to make sure that my program only runs one instance and retrieves the arguments specified when it has been run a second time, I used this[^] code. I converted it to vb.net 2005 and after disabling the application framework, it finally worked out. But now I've got 2 problems, when the application framework is turned off:
1. The icons in my program are ugly
2. My datagridview doesn't work properly anymore
I need to have the application framework turned off because the code I mentioned above needs a sub to start up which is only possible when the application framework has been turned off.
I can't find a solution... Anyone able to help?
|
|
|
|
|
Well guys, I found the solution to my problem and it's so easy!
First of all, turn on the application framework and check the single instance checkbox underneath in the settings. Then, add this little chuck of code to your project:
<br />
Namespace My<br />
Partial Friend Class MyApplication<br />
<br />
Private Sub MyApplication_Startup(ByVal sender As Object, ByVal e As Microsoft.VisualBasic.ApplicationServices.StartupEventArgs) Handles Me.Startup<br />
Try<br />
msgbox(e.CommandLine(0))<br />
Catch<br />
<br />
End Try<br />
End Sub<br />
<br />
Private Sub MyApplication_StartupNextInstance(ByVal sender As Object, ByVal e As Microsoft.VisualBasic.ApplicationServices.StartupNextInstanceEventArgs) Handles Me.StartupNextInstance<br />
e.BringToForeground = True<br />
Try<br />
msgbox(e.CommandLine(0))<br />
Catch<br />
<br />
End Try<br />
<br />
End Sub<br />
<br />
End Class<br />
End Namespace<br />
The sub MyApplication_Startup starts when the first instance get's run, you can insert your own chunk of code there. The other sub starts when a user tries to start a second instance of the same application. Easy, isn't it?
|
|
|
|
|
Hello All,
We are developing applications based on a off-the-shelf PCI card using the PCI 9030 controller. The PCI9030 comes with the SDK to communicate to it, which has device drivers that compile as a DLL (PLXAPI.DLL) in VC++.
However in .NET, they fail on the 'Handle' data type. The Handle datatype is declared as: typedef void *HANDLE in VC++.
However, in .NET, the closest I can find is IntPtr or Integer. Both fail. The function always considers the handle as NULL if it is an integer and causes a System.NullReference.Exception if it is an intptr. Since we have VC++ that creates the DLL, I was able to go thru the function (PLXPCIDeviceOpen) and internally the handle does not match any datatype. Where are things going wrong?
I have pasted below both the .NET function prototype and the actual code of the function from the VC++
.NET
Public Declare Function DeviceOpen Lib "PLXAPI.DLL" Alias "PlxPciDeviceOpen" (ByRef Device As PCIDevice, ByRef PCIDevHandle As IntPtr) As Integer
VC++
RETURN_CODE
PlxPciDeviceOpen(
DEVICE_LOCATION *pDevice, //Device location is bus/slot/vendorid etc
HANDLE *pHandle // verified - can find the device.
)
{
U8 VerMajor;
U8 VerMinor;
U8 VerRevision;
U32 i;
char DriverName[25];
IOCTLDATA IoBuffer;
RETURN_CODE rc;
if ((pDevice == NULL) || (pHandle == NULL))
//if ( (pDevice == NULL))
return ApiNullParam;
// Get the Serial number of the device, if not provided
if (pDevice->SerialNumber[0] == '\0')
{
i = 0;
// Search for the device matching the criteria
rc =
PlxPciDeviceFind(
pDevice,
&i
);
if (rc != ApiSuccess)
{
*pHandle = NULL;
return rc;
}
}
// If provided, the SerialNumber is sufficient to open a device
sprintf(
DriverName,
DRIVER_PATH "%s",
pDevice->SerialNumber
);
// Open the device
*pHandle =
CreateFile(
DriverName,
GENERIC_READ | GENERIC_WRITE,
FILE_SHARE_READ | FILE_SHARE_WRITE,
NULL,
OPEN_EXISTING,
FILE_FLAG_DELETE_ON_CLOSE,
NULL
);
if (*pHandle == INVALID_HANDLE_VALUE)
{
*pHandle = NULL;
return ApiInvalidDeviceInfo;
}
// Add the handle to the device list.
if (DeviceListAdd(
*pHandle,
pDevice
) == NULL)
{
CloseHandle(
*pHandle
);
*pHandle = NULL;
return ApiInsufficientResources;
}
// Verify the driver version
PlxDriverVersion(
*pHandle,
&VerMajor,
&VerMinor,
&VerRevision
);
// Make sure the driver matches the DLL
if ((VerMajor != PLX_SDK_VERSION_MAJOR) ||
(VerMinor != PLX_SDK_VERSION_MINOR) ||
(VerRevision != PLX_SDK_VERSION_REVISION))
// Get device data from driver
IoMessage(
*pHandle,
PLX_IOCTL_DEVICE_INIT,
&IoBuffer
);
// Copy device information
*pDevice = IoBuffer.u.MgmtData.u.Device;
// msgbox put here indicates that function gets here.
return ApiSuccess;
}
|
|
|
|
|
Try passing the parameter ByVal instead of ByRef. For handles, the correct datatype should be IntPtr:
Public Declare Function DeviceOpen Lib "PLXAPI.DLL" _
Alias "PlxPciDeviceOpen" ( _
ByRef Device As PCIDevice, _
ByVal PCIDevHandle As IntPtr) As Integer
If not done correctly, you might also have a problem with the PCIDevice type, whatever that is.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Thank you very much. Even with Byval, the System.nullexcepton occurs and infact I do not get a handle value at all. (With ByRef, I do get the correct handle back as an integer along with the system.nullexception.
--this is how the handle type is defined in the PLXAPI.DLL
typedef void *HANDLE; (in winnt.h)
typedef HANDLE PLX_DRIVER_HANDLE;
typedef int PLX_DRIVER_HANDLE;
--
So, I think that Handle is an integer in VB.NET?? However the structure type, as you suggested, has a problem:
The structure is defined as:
(in DLL)
typedef struct _DEVICE_LOCATION
{
U8 BusNumber;
U8 SlotNumber;
U16 DeviceId;
U16 VendorId;
U8 SerialNumber[12];
} DEVICE_LOCATION;
----------------
VB.NET Structure - my equivalent
Structure PCIDevice
Dim BusNumber As Byte
Dim SlotNumber As Byte
Dim DeviceId As Short
Dim VendorId As Short
Dim SerialNumber() As Byte
End Structure
---------
Values sent to DLL (which modifies these values and I think thats where it is crashing!!!!)
dim device as pcidevice
Dim serialno As String = "PCI9030-0"
Device.BusNumber = System.Convert.ToByte(1)
Device.SlotNumber = System.Convert.ToByte(0)
Device.VendorId = System.Convert.ToUInt16(&H10B5)
Device.DeviceId = System.Convert.ToUInt16(&H9030)
ReDim Device.SerialNumber(11)
Device.SerialNumber = serialno.ToCharArray
---------
DLL DEBUG LOG SAYS:
Dev->BusNumber = 01
Dev->SlotNumber = 00
Dev->DeviceId = 9030
Dev->VendorId = 10B5
Dev->SerialNumber =
-------
serial number field goes in blank. so it is nto translated correctly. All the rest of the values are correct. On return, the DLL tries to write to the serial number "PCI-9030-0" back to the structure in the serial number field and I that is where I think it is failing. the serial number is assinged by teh dll in this generic fashion and since there i sonly one PCI-9030 device in our setup, that number never changes.
So, somehow I have to translate the serialNumber field to teh DLL correctly and make it a datatype that the C dll can write to.
|
|
|
|
|
Thanks all,
the serial number field needed to be 'Long'. and handle works as intptr, integer either.
this problem has been resolved!
|
|
|
|
|
Hey,
I'm having a little problem.
In my applicaton I have a combobox that is bound to a dataset. The dataset retrieves "Users" from my database. My combobox is bound as follows:
cboIncidentHandler.DataSource = busAllUsersDS.Tables("tbl_IMS_Users")<br />
cboIncidentHandler.DisplayMember = "UserFullName"<br />
cboIncidentHandler.ValueMember = "UserId"
Now, I have some textfields I want to be filled up with other data from the dataset (like UserEmail, UserPhone, etc.).
Is there someone who can help me out with this? What is the best way to do this?
Thanks in advance!!!
G72360
|
|
|
|
|
Depending on the functionality you want, this is easy enough.
On the SelectedIndexChanged (? from memory) event, get the ValueMember and do another lookup on the database that returns the fields you want based on that UserId number. You can either directly change the Text properties of your TextBox's from the record that is returned or bind the TextBox's Text properties to each field.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
I am working within a VB.NET [windows forms application] /SQL Server 2000 db. When a user changes the recordset I want to be able to notify the others that reload this recordset that this record has been modified.
A colleague of mine recommended that I add a Hash value to the changed recordset. This way I can compare the hash values to see if the recordset has been modified.
Having never worked with the Hash Algorithm but after reading about it, sounds like the right plan to follow.
However, I cannot find a tutorial on working with hash values with a recordset and wondered if someone had some advice on this subject.
Any help would be greatly appreciated,
Thanks in advice & Happy Easter,
~Brad
-- modified at 14:15 Friday 14th April, 2006
|
|
|
|
|
There's a problem with this. Your clients would have to have a central server to accept change notifications and relay them to the other clients.
You might want to look at SQL Server's Notification Services[^] first.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Dave,
Currently this Application is running on a server. It has 10 or more client machines that all use the same log in to the Application using the same Username found within Active Directory / roles.
Scenerio:
Inside my App. I have a datagrid that I populate using an SQL StoredProc to display records to the user. The problem is because the Application has only 1 log in, I cannot verify which user has changed the recordset. When 1 or more users opens a record to modify it, I allow the first user to have control over the record and display a message to the other users that try to open it. I perform this by setting a different value to the tables record being modified. The problem arise when the user that has modified the recordset and saves the record to the Db. The other users are now seeing the old recordsets in their datagrid because I have no way to automatically REFRESH their screens with the new datagrid recordset information.
A colleague of mine suggested that I add a Hash value to the record uponLOAD of the datagrid then when the user changes the state of the record I can see if the value has been changed. If I know it has been changed then I can notify the users to REFRESH their screens for their datagrid.
I do not have an Audit trail table that I can access to see if a particular user is working on a particualr table. In addition, I think that b/c I am using Active directory with only 1 Log In Username, I really cannot follow what each Client machine is doing to the records in my DB.
Any advice would be greatly appreciated as I am stumped as to how I can fix this issue within my Application.
Thanks in advance,
~Brad
|
|
|
|
|
None of this has any bearing on the problem if you use Notification Services. Clients register for notifications of changes to the underlying database. If a record is changed and there are clients registered for notifications, then each client will get a change event they can handle to refresh their datasets.
You really don't need a hash table for anything. The only other way to do this is to write a server component that manages access to the database for the clients. The clients communicate with the server component and "check out" blocks of records in the database. Frankly, you'd be writing an alternative to Notification Services.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Dave,
SQL Notification is something very cool and something I will definitlly look into it in order to increase my arsenal of design techniques. However for this particular functionanlity it is quite innapropriate (over kill to say the least). From what i read/understand, the notification makes sense when you have data driven behavior, this is not the case with the functionality of my Application.
For my App. I simply want to check if a row has changed or not. Not act when a row has changed. I am not sure if you see the nuance.
All this to say, SQL Notification is nice, however, not for my application. With the research I now know from your help/advice I may apply it when it fits the model or a behaviour that lends itself to it, keyword is "data driven behaviour" and this is not my Application, though I thank you for your advice.
I found an approach that I will implement for my particular situation, called the hash signature <a href="http://en.wikipedia.org/wiki/Hash_function" rel="nofollow">http://en.wikipedia.org/wiki/Hash_function</a>[<a href="http://en.wikipedia.org/wiki/Hash_function" target="_blank" rel="nofollow" title="New Window">^</a>]
Thanks again,
~Brad
|
|
|
|
|
Brad6ft4 wrote: quite innapropriate (over kill to say the least).
Yeah? Wait till you get done implementing this in your own code. You'll sit back, look at this code, and think, "Hey, maybe it wasn't overkill after all..."
Brad6ft4 wrote: I simply want to check if a row has changed or not.
Precisely when do you want to do this? Theres a couple of ways of doing this, but what works depends on your requirements. You have a concurrency problem.
You can lock the records so that only one client gets a Read/Write copy of the data, but if all your clients on working on the same set of records, this won't work. The first client to lock the records is the ONLY client that gets to ever attempt to write any changes back.
If that doesn't work for you, you'll have to implement some kind of "checkout" scheme in your SQL. Since each client has to check to see if the record they have is different from the one it has already, you have to read the values from the database BEFORE you can write the changed data back. The record can change between the time any one client reads it to check for a change and when that same client attempts to write the change back out to the database. You'll have to implement some kind of locking mechanism so that when you read a record to check for a change, you're actually "checking it out" like a book from the library. This part MUST be done in a stored procedure in the database.
From a logic point of view, the stored proc has to attempt to check the record out before it checks to see if the record changed, THEN read and pass it to the client. You'll have to implement a "check out" scheme in SQL. pass some kind of ReadOnly flag in the dataset to go with it. The database has to tell any client that attempts to check to see if it can write data back to the database that the record is already checked out.
Now, using Notification Services, if a record changes, it can automatically notify each client to do something very simple. Re-query the database for this one record.
It's your call...
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Dave,
I found an easier solution [Quick & Dirty] but works well to resolve my issue. Instead of using the Hash function and /or your suggestion of using SQL Server Notification which for this particular case would have been over kill.
I simply used a check on the tables field name DateModified datetime.
Once the user selects a particular record, upon retrieval of that record, I set a field within my table, to the status of EDIT_MODE [EDIT_MODE = 1]. After which I take the datetime inside the recordset and use it as a marker for later use. If that record is changed, upon the Save() of that record, I set the DateModified date = datetime.Now().
With this approach, I can notify the user making he/she aware that the record they are trying to view has been changed by another user and that they should REFRESH their initial Search criteria to obtain the new recordset of that particular record.
Thanks for all your help,
~Brad
|
|
|
|
|
Hi,
I used the example from http://blog.binaryocean.com/PermaLink,guid,a1ff6cab-dc2d-441c-8557-7dce920d4075.aspx
to create an insertable gridview, My code is identical, apart from the language being C# in the example and VB.NET in my project.
Everything works, except the inserting, when I insert data and press the save button I get an InvalidOperationException in the method
Protected Sub gvAgendaPunten_RowCommand(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewCommandEventArgs) ' Handles gvAgendaPunten.RowCommand
If e.CommandName = "Save" Then
Dim agendaPunt As String = CType(gvAgendaPunten.FooterRow.FindControl("txtAgendaPunt"), TextBox).Text
Dim vergaderingId As Integer = ddlVergaderingen.SelectedValue
odsAgendaPunten.InsertParameters.Add("agendaPunt", agendaPunt)
odsAgendaPunten.InsertParameters.Add("vergaderingId", vergaderingId)
odsAgendaPunten.Insert()
End If
End Sub
saying that the ObjectDataSource 'odsAgendaPunten' has no values to insert. Check that the 'values' dictionary contains values.
But the funny thing is dat my odsAgendaPunten.insertparameters has count 2 and items 0 and 1 have the values from agendaPunt and vergaderingId.
I also tried with setting the parameters before, in the source code and via the objectdatasource properties window, nothing seems to work.
If anyone could help me out here, or tell me in what direction to look. I'd appreciate it very much.
I don't think it's necessary to post the rest of the code, since the error must be located in this method (I think), but If it would clear things up, just let me know, and I'll post the rest of it too.
thx
davy.
|
|
|
|
|
I have not used this before, but looking at the code, the author of the sample has separated out the Inserting() event and it is here that the calls to InsertParameters are made.
I think you'll find that the call to Insert() in the RowCommand event raises the Inserting() event on the object which you have not provided hence the error.
...Steve
1. quod erat demonstrandum
2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once
|
|
|
|
|
Imports System.data
Partial Class VergaderingWijzigen
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Not Page.IsPostBack() Then
fillDropDownList()
Dim key() As String = {"agendaPuntId"}
gvAgendaPunten.DataKeyNames = key
gvAgendaPunten.Visible = False
Else
gvLeden.DataBind()
End If
End Sub
Private Property loadDataEmpty()
Get
Return CType(ViewState("loadDataEmpty"), Boolean)
End Get
Set(ByVal value)
ViewState("loadDataEmpty") = value
End Set
End Property
Protected Sub fillDropDownList()
Dim collectionVergaderingen As IDataReader = DatabaseAgent.selectUsersVergaderingen("ST")
ddlVergaderingen.DataSource = collectionVergaderingen
ddlVergaderingen.DataTextField = "titel"
ddlVergaderingen.DataValueField = "vergaderingid"
ddlVergaderingen.DataBind()
collectionVergaderingen.Close()
If ddlVergaderingen.Items.Count = 0 Then
ddlVergaderingen.Visible = False
lblError.Visible = True
lblError.Text = "Er zijn geen vergaderingen gepland die u kunt wijzigen"
Else
lblError.Visible = True
ddlVergaderingen.Visible = True
ddlVergaderingen.Items.Add(New ListItem("Selecteer vergadering", -1))
ddlVergaderingen.SelectedValue = -1
End If
End Sub
Protected Sub DropDownList1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles ddlVergaderingen.SelectedIndexChanged
gvAgendaPunten.Visible = True
End Sub
Protected Sub odsAgendaPunten_Inserting(ByVal sender As Object, ByVal e As ObjectDataSourceMethodEventArgs) Handles odsAgendaPunten.Inserting
e.InputParameters("agendaPunt") = CType(gvAgendaPunten.FooterRow.FindControl("txtAgendaPunt"), TextBox).Text
e.InputParameters("vergaderingId") = ddlVergaderingen.SelectedValue
End Sub
Protected Sub odsAgendaPunten_Selected(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.ObjectDataSourceStatusEventArgs) Handles odsAgendaPunten.Selected
If Not e.Exception Is Nothing Then
Throw e.Exception
End If
Dim d As DataTable = CType(e.ReturnValue, DataSet).Tables.Item(0)
If d.Rows.Count = 0 Then
d.Rows.Add(d.NewRow())
loadDataEmpty = True
Else
loadDataEmpty = False
End If
End Sub
Protected Sub odsAgendaPunten_Selecting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.ObjectDataSourceSelectingEventArgs) Handles odsAgendaPunten.Selecting
Console.Write("hallo")
End Sub
Protected Sub gvAgendaPunten_RowCommand(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewCommandEventArgs) Handles gvAgendaPunten.RowCommand
If e.CommandName = "Save" Then
odsAgendaPunten.Insert()
End If
End Sub
Protected Sub gvAgendaPunten_RowCreated(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles gvAgendaPunten.RowCreated
If (loadDataEmpty) And e.Row.RowType = DataControlRowType.DataRow Then
e.Row.Visible = False
e.Row.Controls.Clear()
End If
End Sub
Protected Sub gvAgendaPunten_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles gvAgendaPunten.SelectedIndexChanged
End Sub
Protected Sub btnAddAgendaPunt_Click1(ByVal sender As Object, ByVal e As System.EventArgs)
DatabaseAgent.insertAgendaPunt(New DAgendaPunt(ddlVergaderingen.SelectedValue, CType(gvAgendaPunten.FindControl("txtAgendaPunt"), TextBox).Text))
End Sub
End Class
This is the complete codebehind. (the way it looked before I started to try out several things to get it to work.)
I do have code for the inserting event, offcourse I forgot to mention that in my first post
Or do I have to raise that event somewhere manually?
|
|
|
|
|
Hi!
I have developed an application using visual basic 6. I have used access 2000 database and crystal report( for reporting). Now, i want the database to stay in one machine of the workgroup so that other machines can connect (can insert/update and view reports), simply i want it to be a client server application. My questions are :
1.How to configure the machine ( where the database will stay) so that others can use the databse?
2.I have used file dsn for crystal report as i want other machines to use the reports, so is it necesary for the reports to stay with each client application and also how do i find the file dsn of the machine where the database stays?
3.what will be the ado conect string for the clients to connect to the database in the lan?
Regads
Arunendra
|
|
|
|
|
arunendra wrote: 1.How to configure the machine
Access is NOT a good shareable database. It was meant to be a Desktop database. It'll work, but you have to maintain (compact and repair) that database religously! Also, maintenance on the database will take it offline until the maintenance is complete. This means that your application cannot run until your done!
This depends on your machine environment. I highly recommend reading up on Windows networking and security first. But, the basic thing is to setup a Share on the server and put your database files on that share. Then, each workstation has to map a drive to that Share. Excatly how this is done depends on if your machines are in a workgroup or domain. How you setup the Share and NTFS security also depends on this configuration.
arunendra wrote: 2.I have used file dsn for crystal report
I don't use Crystal Reports, so I couldn't tell you...
arunendra wrote: 3.what will be the ado conect string for the clients to connect to the database in the lan?
The same as what your using now. Only you'll have to specify the network drive letter you mapped setting up Windows networking, and specify the full path to the .MDB file.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Thanks Dave for your reply.
I know Access is not for sharing but the requirement is such that i have to use access. I have a code , therefore, in my application which will automatically run the compact database service everyday at a specific time.
I actually need the code to perform what I need. for eg, if the folder in which the database resides is called "x', and the name of the mdb file is "data.mdb", then, how do I make sure that users can open from other locations,
i have set read & execute,list folder contents,read, write permission for everyone and also have set the same permission for the mdb file. have i done something wrong?
also i have tried the following code for connecting from the client :
Connect_String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\machine_name\x\data.mdb;Persist Security Info=False;Jet OLEDB:Database Password=bill1234"
con.open connect_string
but when run from another machine i get the following error msg :
( not exact!!) "the \\machine_name\x\data.mdb can not be opened as this may be not permitted or exclusively locked"
Regarding the crystal report problem, i think i need to know only one thing, i.e. how to share the file dsn that i have used for the crystal report. to be specific, how should i configure the file dsn that i already have in the machine where i have the database, i think that will make the reports available in the client machines. so, can you help me for sharing the file dsn in proper manner.
Regadrs
Arunendra
N.B. I will soon want to learn how to connect to a sql server database in a workgroup and also in a domain, i think you can help me out in that also, but currently please get me out of this.
-- modified at 11:16 Friday 14th April, 2006
|
|
|
|
|
arunendra wrote: if the folder in which the database resides is called "x', and the name of the mdb file is "data.mdb", then, how do I make sure that users can open from other locations,
Have you setup a share on folder X?? A UNC path takes the format \\machineName\shareName\folder\filename. In your case, if you create a Share on folder X and called that share "Data", then the UNC path would be \\machine_name\Data\mydata.mdb.
As for the FileDSN, the default location for the file is C:\Program Files\Common Files\ODBC\Data Sources. I would suggest copying the FileDSN to that folder on each client machine.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|