Hi,
This code is working fine on my os.
Exe is not working on other os.
Can you please see the code?
Project details:
There is a db with emails.
Need to place in seperate files with fix number in each file.
that I have specified in the text box
now
loop begin untils it reach end of records and in meantime it will put fixed number of records(emails) in one file and then proceed with ther file.
Please see why it is not working in other os where visual studio is not installed.
I did installed ado and jet db driver but still error and os was 98.
Message
From: Naveed Ahmed
To: ^Stuart Little^
Sent: Tuesday, September 19, 2006 5:52 PM
Subject: Re: [Visual Basic 6 programming] ado
To Start with check references ado and add this code to a basic module. Pass a sql statement and get the required recordset:
Quote
Private Const Provider = "Provider=Microsoft.JLEDB.4.0"
Private DataSource As String
Private Database As String
Public Function GetTableAsPerThisSql(StrSql As String) As Recordset
Dim cn As Connection
Dim rs As Recordset
Database = "databasename.mdb"
DataSource = "Data Source=//Database path//" & Database
Set cn = New Connection
Set rs = New Recordset
rs.CursorType = Dynamic
Provider & ";" & DataSource
DoEvents
StrSql, cn, Dynamic, adL
DoEvents
Set GetTableAsPerThisSql = rs
Set cn = Nothing
Set rs = Nothing
End Function
UnQuote
The datasource property should be set to the path of the database
^Stuart Little^ <coolpond (AT) gmail (DOT) comwrote:
Hello Naveed,
I need code to initiate the connection and the recordset by using references method.
What software will be required to run the program on system not having vb?
Thanks.
Message
From: Naveed Ahmed
To: coolpond (AT) gmail (DOT) com
Sent: Tuesday, September 19, 2006 5:31 PM
Subject: Re: [Visual Basic 6 programming] ado
hi Stuart little (sniff,sniff,lol),
using ado reference gives you much more control over ado. to know more mail me
Naveed
^Stuart Little^ <coolpond (AT) gmail (DOT) comwrote:
Hello Members,
What is the difference between using ado control and ado from project-references?
what extra software will be needed for running the program with either of the 2 method on the system not having vb?
Can you send connection statements along with few recordset basic statements when using project-references-method?
Please cc the reply.
TIA :)
[Non-text portions of this message have been removed]
Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates starting at 1/min.
How low will we go? Check out Yahoo! Messenger's low PC-to-Phone call rates.
[Non-text portions of this message have been removed]
Yahoo! Groups Links
<*To visit your group on the web, go to:
<*Your email settings:
Individual Email | Traditional
<*To change settings online go to:
(Yahoo! ID required)
<*To change settings via email:
@yahoogroups.com
@yahoogroups.com
<*To unsubscribe from this group, send an email to:
@yahoogroups.com
<*Your use of Yahoo! Groups is subject to: